I am a beginner and can not open the http://homer:5560/isqlplus page
under Solaris10-x86? Any solutions ? I could open it when I installed
Oracle 10 on Solaris 10 - x86 system for the first time.
Thanks

"happy" <ehabaziz2001 (AT) gmail (DOT) com> a écrit dans le message de news:
60bdcbfc-ef80-4d90-ab90-b0b0fb909f58...oglegroups.com...
isqlplus is obsolete, start with something that exists in the current versions.

Regards
Michel

On Sun, 08 May 2011 19:50:12 +0200, Michel Cadot wrote:


Something like rpt/rpf of SQL*Calc.



--
http://mgogala.byethost5.com

On May 8, 8:52*pm, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:
issued the two commands :
$ORACLE_HOME/bin/lsnrctl start
$ORACLE_HOME/bin/isqlplusctl start

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

happy:

.... 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 database instance running?

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

On Sun, 08 May 2011 12:41:25 -0700, happy wrote:


Is your ORACLE_SID defined and exported in the environment?



--
http://mgogala.byethost5.com

On May 9, 1:13*am, John Hurley <hurleyjo... (AT) yahoo (DOT) com> wrote:
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>

On May 9, 2:08*am, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:
oracle @ Homer /export/home/oracle/database>echo $ORACLE_SID
ORA10GR2

On May 9, 2:08*am, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:

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.

On Wed, 11 May 2011 10:09:20 -0700 (PDT), happy
<ehabaziz2001 (AT) gmail (DOT) com> wrote:

The database is *not* up.

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

--
Sybrand Bakker
Senior Oracle DBA