Quote:
Originally Posted by thiyagusham
Hi All;
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.
PHP Code:
export ORACLE_BASE=/u01/app/oracle; export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME export ORACLE_SID=orcl; export PATH=/usr/sbin:$PATH; export PATH=$ORACLE_HOME/bin:$PATH; export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export EDITOR=vi sqlplus / as sysdba sqlplus startup
$ . ./ora10.env
PHP Code:
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:
http://docs.oracle.com/cd/B19306_01/...b14357/toc.htm
http://docs.oracle.com/cd/B19306_01/...4231/start.htm