Re: Oracle died with SGA error messages!

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: 2000/03/20
Message-ID: <8b5aev$9qt$1@nereid.worldonline.nl>#1/1

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
Received on Mon Mar 20 2000 - 00:00:00 CST