Re: can not start the isqlplus

From: ddf <oratune_at_msn.com>
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

Original text of this message