Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus broken not using env var ORACLE_SID

Re: sqlplus broken not using env var ORACLE_SID

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Mon, 28 Jun 1999 12:51:38 -0400
Message-ID: <3777A81A.607D6C96@Unforgettable.com>


My guess is that you do not have an instance with the name of TEST but that your tnsnames.ora has a database alias of TEST that points to a valid instance on your system.

Ken

interlog 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 - 11:51:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US