Re: can not start the isqlplus

From: happy <ehabaziz2001_at_gmail.com>
Date: Wed, 11 May 2011 10:09:20 -0700 (PDT)
Message-ID: <9e1145d9-da53-4110-9af6-6c5ea9c93639_at_w10g2000yqa.googlegroups.com>

On May 9, 2:08 am, Mladen Gogala <gogala.mla..._at_gmail.com> 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?
>
> --http://mgogala.byethost5.com

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

start

LSNRCTL for Solaris: Version 10.2.0.2.0 - 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 10.2.0.2.0 - 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 10.2.0.2.0 -
Production
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...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Homer)(PORT=1521))) Services 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

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