Re: can not start the isqlplus
Date: Thu, 12 May 2011 08:26:43 -0700 (PDT)
Message-ID: <c79ae26f-7321-4c63-86df-d38a93e680f2_at_p23g2000vbl.googlegroups.com>
Comments embedded.
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
>
As others have stated the database is not up and lsnrctl status is proving that.
> 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
>
The PLSExtProc service is 'hard-coded' into the listener.ora file as
evidenced by the UNKNOWN status reported. Hard-coded listener.ora
entries always show UNKNOWN as the status as the listener is 'forced'
to listen for them. You should have at least another service entry
that shows READY due to the autoregistration of a running instance
with the listener, but you don't. Thus the database is not running.
.
> 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.
Since there is nothing to connect to isqlplus fails to start.
As others in this thread have said you need to start your database before you can even hope to get isqlplus running. I'll repeat the instructions on how to start your database presuming you're logged into the database server:
Start sqlplus:
oracle _at_ Homer /export/home/oracle/database>sqlplus /nolog
...
SQL> connect / as sysdba
Connected.
SQL> startup
[you SHOULD see output here similar to this
Total System Global Area 1.0737E+10 bytes
Fixed Size 2090600 bytes Variable Size 1073744280 bytes Database Buffers 9646899200 bytes Redo Buffers 14684160 bytes
indicating that at least the instance startup was successful. You should then see
Database mounted.
and after a bit of a wait you should then see
Database opened.
indicating your database is now up and running.]
Once you get the SQL> prompt you should be ready to exit sqlplus and then attempt to run isqlplus; since the database is running it will probably connect (unless you have configuration issues for isqlplus).
David Fitzjarrell Received on Thu May 12 2011 - 10:26:43 CDT