sqlplus '/ as sysdba'" connects to idle instance
646430Mar 5 2009 — edited Mar 12 2009[root@xxxxx ~]# su oracle -c "ORACLE_SID=aitrap;export ORACLE_SID;TNS_ADMIN=/u01/app/oracle/product/10.1.0.5_aitrap/network/admin;export TNS_ADMIN;PATH=/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/local/bin:/usr/bin:/u01/app/oracle/product/10.1.0.5_aitrap/lib:/u01/app/oracle/product/10.1.0.5_aitrap/bin:/usr/dt/lib:/usr/openwin/lib;export PATH;ORACLE_HOME=/u01/app/oracle/product/10.1.0.5_aitrap;export ORACLE_HOME;LD_LIBRARY_PATH=/u01/app/oracle/product/10.1.0.5_aitrap/lib:/u01/app/oracle/product/10.1.0.5_aitrap/ctx/lib;export LD_LIBRARY_PATH; /u01/app/oracle/product/10.1.0.5_aitrap/bin/sqlplus '/ as sysdba'"
SQL*Plus: Release 10.1.0.5.0 - Production on Wed Mar 4 02:26:22 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> !echo $ORACLE_SID
aitrap
SQL> !echo $ORACLE_HOME
/u01/app/oracle/product/10.1.0.5_aitrap
SQL>
[root@xxxxx oracle]# cat oratab | grep aitrap
aitrap:/u01/app/oracle/product/10.1.0.5_aitrap:N:oracle:oracle:AITRAP database
I am on Linux 2.6.9-55.0.2.6.2.ELhugemem #1
But if i login as oracle and try it connects to active instance
xxxx:oracle> (aitrap:10.1.0.5_aitrap) /home/oracle
$ sqlplus '/ as sysdba'
SQL*Plus: Release 10.1.0.5.0 - Production on Wed Mar 4 22:56:25 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> !echo $ORACLE_SID
aitrap
SQL> !echo $ORACLE_HOME
/u01/app/oracle/product/10.1.0.5_aitrap
SQL> select name from v$database;
NAME
---------------------------
AITRAP