Re: Error ORA-27101

"Adnan Jamil" <adnanjamil59_at_hotmail.com> wrote in message news:<ts9Da.10559$HG5.371911_at_news20.bellglobal.com>...
> Hello Friends,
>
> I have installed Oracle 9.0.0 on Windows 2000. But when I run SQL Plus
> option and enter system/manager username & password, I am getting following
> error:-
>
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
>
> Does anyone knows, how can I fix this error.
>
> Thanks in Advance
>
> Adnan

Make sure that instance you are trying to connect to is started.

To do: On command prompt,

  C:\> set oracle_sid=<SID>
  C:\> sqlplus /nolog
  SQL> connect sys/<password> as sysdba
  SQL> startup

Regards
/Rauf Sarwar Received on Wed Jun 04 2003 - 06:10:08 CEST