Re: can not start the isqlplus

From: happy <>
Date: Wed, 11 May 2011 10:09:20 -0700 (PDT)
Message-ID: <>

On May 9, 2:08 am, Mladen Gogala <> wrote:
> On Sun, 08 May 2011 12:41:25 -0700, happy wrote:
> > But I got that error :
> > ERROR - ORA-01034: ORACLE not available ORA-27101: shared memory realm
> > does not exist Intel SVR4 UNIX Error: 2: No such file or directory
> Is your ORACLE_SID defined and exported in the environment?
> --

I can see that the db is up But when I start the listener I can see the port 1521 but when I have the login screen of oracle I open the web page using : http://homer:5560/isqlplus/login.uix

oracle _at_ Homer /export/home/oracle/database>ps -ef | grep pmon
  oracle  1188   995   0 18:59:15 pts/3       0:00 grep pmon
oracle _at_ Homer /export/home/oracle/database>$ORACLE_HOME/bin/lsnrctl

LSNRCTL for Solaris: Version - Production on 11-MAY-2011 18:57:36

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /opt/oracle/102/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version - Production System parameter file is /opt/oracle/102/network/admin/listener.ora Log messages written to /opt/oracle/102/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Homer) (PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version -
Start Date                11-MAY-2011 18:57:42
Uptime                    0 days 0 hr. 0 min. 2 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/102/network/admin/listener.ora
Listener Log File         /opt/oracle/102/network/log/listener.log
Listening Endpoints Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

oracle _at_ Homer /export/home/oracle/database>$ORACLE_HOME/bin/ isqlplusctl start

Copyright (c) 2003, 2005, Oracle. All Rights Reserved. Starting iSQL*Plus ...
iSQL*Plus started. Received on Wed May 11 2011 - 12:09:20 CDT

Original text of this message