Re: can not start the isqlplus
From: joel garry <joel-garry_at_home.com>
Date: Wed, 11 May 2011 14:38:01 -0700 (PDT)
Message-ID: <849f05bd-cbac-4e89-a4fe-01086c11c189_at_d26g2000prn.googlegroups.com>
On May 11, 10:09 am, happy <ehabaziz2..._at_gmail.com> wrote:
> 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.
Date: Wed, 11 May 2011 14:38:01 -0700 (PDT)
Message-ID: <849f05bd-cbac-4e89-a4fe-01086c11c189_at_d26g2000prn.googlegroups.com>
On May 11, 10:09 am, happy <ehabaziz2..._at_gmail.com> wrote:
> 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.
What happens when you say:
sqlplus / as sysdba
startup
Then do the ps command John mentioned and the lsnrctl status (you might have to wait a minute for the db to register itself). Also, echoing an environment variable doesn't show that it has been exported - you need to go into a subshell and then echo it.
jg
-- _at_home.com is bogus. http://www.viatology.info/Received on Wed May 11 2011 - 16:38:01 CDT