can not start the isqlplus

#11

On May 11, 10:09*am, happy <ehabaziz2... (AT) gmail (DOT) com> wrote:

Quote:

On May 9, 2:08*am, Mladen Gogala <gogala.mla... (AT) gmail (DOT) 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 @ Homer /export/home/oracle/database>ps -ef | grep pmon
* oracle *1188 * 995 * 0 18:59:15 pts/3 * * * 0:00 grep pmon
oracle @ 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)(P ORT=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 @ 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
--
@home.com is bogus.
http://www.viatology.info/

#12

happy:

....If you do a "ps -ef | grep smon" what does it show you?

oracle @ Homer /export/home/oracle/database>ps -ef | grep pmon
oracle *1188 * 995 * 0 18:59:15 pts/3 * * * 0:00 grep pmon
oracle @ Homer /export/home/oracle/database>

....

This shows you that you do not have a pmon process going ... you have
no database instance running ... only the "grep" command was returned
as output.

#13

Sybrand:

# Can you also explain why you simultaneously post this on this forum
*and* on OTN?

Because he felt like it apparently? happy fingers?

#14

Comments embedded.

On May 11, 10:09*am, happy <ehabaziz2... (AT) gmail (DOT) com> wrote:

Quote:

On May 9, 2:08*am, Mladen Gogala <gogala.mla... (AT) gmail (DOT) 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.

Quote:

oracle @ Homer /export/home/oracle/database>ps -ef | grep pmon
* oracle *1188 * 995 * 0 18:59:15 pts/3 * * * 0:00 grep pmon
oracle @ 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)(P ORT=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.
..

Quote:

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 @ 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

can not start the isqlplus

comp.databases.oracle.server comp.databases.oracle.server

Re: can not start the isqlplus - 05-11-2011 , 04:38 PM

Re: can not start the isqlplus - 05-11-2011 , 08:28 PM

Re: can not start the isqlplus - 05-11-2011 , 08:30 PM

Re: can not start the isqlplus - 05-12-2011 , 10:26 AM