Re: [9.2.0.1.0 on SuSE-Linux 8.2] No login in sqlplus possible

From: Peter van Rijn <pgm.van.rijnRM_at_THIShccnet.nl>
Date: Tue, 13 May 2003 18:15:49 +0200
Message-ID: <b9r5n4$655$1@news.hccnet.nl>

"Andreas Müller" <andreas_mueller_1981_at_gmx.de> schreef in bericht news:b9r4l2$6q3$02$1_at_news.t-online.com...
> Hi to all,
>
> After I start sqlplus (and login with system/manager) I see...
>
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> Linux Error: 2: No such file or directory
>
> What is the reason? Installation Errors?
>
> many thanks
>
> Andreas
>
>
>

Andreas,

Check your environment:

Are ORACLE_HOME and ORACLE_SID being set? If so, did you start the instance?
To check this you can do a "ps -ef|grep $ORACLE_SID", if several processes are shown, like pmon, smon, dbw0 etc, your instance appears running, but if not do the following:
start sqlplus
SQL> connect / as sysdba
Connected to an idle instance
SQL> startup

Did this help?

regards,
Peter Received on Tue May 13 2003 - 11:15:49 CDT