Re: sqlplus broken not using env var ORACLE_SID

If I can assume that you are on a UNIX platform, make sure that you have set the sticky bit on the oracle executable in $ORACLE_HOME/bin by performing : chmod 6751 oracle. This should clear up you problem.

djuly_at_casema.net wrote:

> 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 Fri Jul 16 1999 - 14:41:31 CDT