Re: sqlplus broken not using env var ORACLE

From: XU <xux_at_informa.bio.caltech.edu>
Date: 28 Jun 1999 23:41:13 GMT
Message-ID: <7l916p$6qr@gap.cco.caltech.edu>

This is just a guess - I think maybe you did not set the env variable ORACLE_SID correctly, or forgot to "export" it (if you are using bash). In any case, you can check it with "echo $ORACLE_SID" and see if it really has been set to "TEST".

Robert Xu

interlog (carlod_at_interlog.com) wrote:
: Anyone have any ideas why this is occuring

: If I set the ORACLE_SID=TEST and do the following

: sqlplus user/password

: I get the following error
: ERROR: ORA-1034: ORACLE not available
: ORA-07429: smsgsg: shmget() failed to get segment
: SVR4: Error: 2: No such file or directory

: But, If I do sqlplus user/password_at_TEST no problem.

: System is Solaris 2.6 & Oracle 7.3.4.
Received on Mon Jun 28 1999 - 18:41:13 CDT

Re: sqlplus broken not using env var ORACLE_SID