Re: Oracle died with SGA error messages!

An additional possibility, given NT is that the Oracle Service is started but the database isn't. In NT there are usually two services, ORACLESERVICE and ORACLESTART, with sid designations (at least in 8.0.x). I am guessing the primary service is up, but the specific database is not. It may be the environment as stated, but it may just be the service.

In article <8b5aev$9qt$1_at_nereid.worldonline.nl>, "R.Schierbeek" <bytelife_at_worldonline.nl> wrote:
> Hello Adrian,
> Obvious: The system can't find the environment: the instance.
>
> The SGA (Shared Global Area) is the started Oracle instance on your
 NT.
> If you're sure it's running, then you forgot to tell Sqlplus WHICH
> Oracle instance: you have to define the ORACLE_SID (Can be ORCL, PROD,
> TEST or whatever you have defined)
>
> Option1:
> - Start Sqlplus
> - Connect to Username/Passwd INSTANCE:ORCL
> (Your ORCL instance should be defined in TNSNAMES.ORA file)
>
> Option2, for NT session on the SERVER:
> - open Command-window
> - SET ORACLE_SID=ORCL
> (check by typing SET on command-line )
> Now you can start Sqlplus.
>
> Or better define it ORACLE_SID globally in the registry - if you have
 1
> instance.
> Cheers,
> Roelof
> ------------------------------
> Roelof Schierbeek, DBA
> Bytelife BV
> The Hague, Holland
> email: bytelife AT worldonline.nl
> check out : http://home.worldonline.nl/~bytelife
>
> Adrian Harrison heeft geschreven in bericht ...
> >I keep getting this set of error messages when running SQLPlus -
> >
> >ERROR: ORA-01034: ORACLE not available
> >ORA-09243: smsget: error attaching to SGA
> >OSD-04101: invalid SGA: SGA not initialized
> >O/S-Error: (OS 203) The system could not find the environment
> >
> >I haven't got a clue what they mean - any ideas?
> >
> >Oracle is definetly running but I can't login at all!
> >
> >Thanks
> >
> >Adrian Harrison
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com http://www.deja.com/
Before you buy.