Re: sqlplus broken not using env var ORACLE_SID

On Mon, 28 Jun 1999 12:41:19 -0400, "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.
>

the connect string after @ that is test is not the SID name. The SID is the system identifier. A wrong sid may point to a non existing memory stuctore.
Solution.
Search the SID in the tnsnames.ora. That is where the connect string test is defined.
If found try ORACLE_SID=<SID>; export ORACLE_sid

>
>
>
>
Received on Thu Jul 15 1999 - 23:19:50 CDT