Re: sqlplus broken not using env var ORACLE_SID

If you are chaning your database, do not just change your SID, this is a bad habit and it will mess you up when you are running with multiple ORACLE_HOMEs. use
(k-shell) $. oraenv (that is dot-space-o-r-a-e-n-v) or (c-shell) % source coraenv
make sure that the env variable ORAENV_ASK = YES This will set your ORACLE_HOME to whatever it is set to in the oratab file.
If you do have multiple versions of oracle running on your machine, this may be your problem.
--glen

Sybrand Bakker wrote:
>
> Usually this is a protection problem
> on $ORACLE_HOME/dbs/sgadeftest.dbf
> The protection should be 477
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> interlog <carlod_at_interlog.com> wrote in message
> news:7l88i7$40c$1_at_news.interlog.com...
> > 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.
> >
> >
> >
> >
> >
> >
> >

--
|-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-| Glen Upreti
Senior Oracle DBA
Northern Arizona University
Phone (520)523-8393 Fax(520)523-7407 Glen.Upreti_at_NOSPAMnau.edu

Received on Tue Jun 29 1999 - 09:06:10 CDT