Originally Posted by thiyagusham
I tried to write shell scripts. It's for local use. whenever i execute my 10g database env file , automatically my db should be up.
$ . ./ora10.env
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Sun Apr 20 21:34:55 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to an idle instance.
but i cannot startup my instance . why ?
You've said previously that you're an Oracle DBA, with years of experience, and have been posting Oracle related questions for at least two years now. You've been told in that time:
- Oracle 10g is OLD
- You need to first do research on your own...like reading the Oracle documentation
- Contact Oracle support, since Oracle is a commercial, pay-for product.
Given these things, there are MANY hints that can help you. This problem can have one of several solutions, depending on the error code. As an 'experienced DBA', this should be obvious. Also, a DBA with several years of experience with Oracle, and someone who is also TRAINING OTHERS, should be able to see the 'error'.
Hint: you are CONNECTED to Oracle...but you have not yet bothered to open a database
. Please read the SQLPlus basics documents: