I can successfully connect to my database using sqlplus if I specify the SID on the command line; however, I get an error if I try connecting after using setora to set the SID. Any ideas on why this might be happening?
Oracle version is 10.2.4.0
OS is SunOS 5.9 Generic_122300-46 sun4u sparc SUNW,Sun-Fire-V490
MYDB resides on a host machine that is different from the one from which I'm running sqlplus. We'll call this machine REMOTEHOST.
I'm certain that MYDB is up and running on REMOTEHOST
MYUSER@MYHOST% setora MYDB
MYUSER@MYHOST% sqlplus MYUSER
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 8 09:38:58 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
Enter user-name: ^C^C
MYUSER@MYHOST% sqlplus MYUSER@MYDB
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 8 09:39:10 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Oracle environment variables:
MYUSER@MYHOST% env | grep -i ora
PATH=/u01/home/bin:/u01/app/oracle/product/10.2.0/OPatch:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/opt/lib/cobol/bin:/usr/ccs/bin:/opt/SUNWspro/bin:/banvol/uncg/bin:/etc:/usr/openwin/bin:/opt/hsqr/ora/bin:/opt/hsqr/jre/jre141/bin:/u01/app/oracle/product/10.2.0/bin
SQRDIR=/opt/hsqr/ora/bin
LD_LIBRARY_PATH=/usr/ccs/lib:/opt/lib/cobol/lib:/opt/SUNWspro/lib/v9:/opt/SUNWspro/lib/v9:/opt/SUNWspro/lib:/u01/app/oracle/product/10.2.0/lib:/opt/hsqr/ora/bin:/opt/hsqr/jre/jre141/lib/sparce/native_threads:/opt/hsqr/jre/jre141/lib/sparc/client:/opt/hsqr/jre/jre141/lib/sparc:/u01/app/oracle/product/10.2.0/lib32
ORACLE_BASE=/u01/app/oracle
ORABIN=/u01/home/bin
OWB_HOME=/u01/app/oracle/product/owb102
ORACLE_SID=MYDB
ORACLE_HOME=/u01/app/oracle/product/10.2.0
TNSNAMES entry:
MYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = REMOTEHOST)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYDB.MYDOMAIN.COM)
)
)