I started the sqlplus through :
http://homer:5560/isqlplus/

but did not opened .
I tried :
oracle @ Homer /export/home/oracle/database>lsnrctl start

LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 09-JAN-2011
18:56:08

Copyright (c) 1991, 2005, Oracle. All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been
started
oracle @ Homer /export/home/oracle/database>
oracle @ Homer /export/home/oracle/database>dbstart $ORACLE_HOME
oracle @ Homer /export/home/oracle/database>


oracle @ Homer /export/home/oracle/database>sqlplus scott/tiger@orcl

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 9 18:56:59 2011

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested
in connect
descriptor


Enter user-name:

On Sun, 09 Jan 2011 08:57:29 -0800, happy wrote:

That is "iSQLplus", not sqlplus. This is sqlplus:

[mgogala@medo ~]$ sqlplus scott/tiger

SQL*Plus: Release 11.2.0.2.0 Production on Sun Jan 9 12:14:23 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options

SQL>

Furthermore, lsnrctl is used to start Oracle*Net listener. Listener is
not a web server as is "iSQLPlus" server. So called "iSQL*Plus" was a web
application, configured in the $ORACLE_HOME/Apache/Apache/conf directory.
Standard sqlplus is an awesome CLI tool. If you want a gooey client, try
SQL*Developer. I believe that iSQL*Plus is obsolete and abandoned.



--
http://mgogala.byethost5.com

On Jan 9, 8:57*am, happy <ehabaziz2... (AT) gmail (DOT) com> wrote:
Does lsnrctl status tell you anything has been started?

Normally what should happen is, starting the database registers the
database with the listener, but this can take a minute or two.

If simply waiting a minute doesn't make it work, you probably have a
connect descriptor that doesn't match the registration of the database
service.

Carefully check your tnsnames.ora, and see what tnsping orcl gives
you. Also try sqlplus without the @orcl - if that works, you likely
have orcl defined wrong.

See Ed's description of the various errors here:
http://forums.oracle.com/forums/mess...346244#4346244

"connect descriptor" means what the listener knows about.

jg
--
@home.com is bogus.
http://www.computerworld.com/s/artic... by_subsidiary

On Jan 9, 7:21*pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
oracle @ Homer /export/home/oracle>lsnrctl service

LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 09-JAN-2011
19:25:57

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1) ))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
oracle @ Homer /export/home/oracle>sqlplus scott/tiger

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 9 19:27:33 2011

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Intel SVR4 UNIX Error: 2: No such file or directory


Enter user-name:


oracle @ Homer /export/home/oracle>cat /opt/oracle/102/network/admin/
tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/oracle/102/network/
admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Homer)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

oracle @ Homer /export/home/oracle>

On Sun, 09 Jan 2011 09:46:21 -0800, happy wrote:

Look at the environment variables. Please, read the fine manuals
carefully.



--
http://mgogala.byethost5.com

On Jan 9, 9:46*am, happy <ehabaziz2... (AT) gmail (DOT) com> wrote:
You most likely have an ORACLE_SID defined wrong for sqlplus, perhaps
for dbstart, and perhaps a wrong ORACLE_HOME.

dbstart uses oratab, so find that file and see what it says about
orcl. Case may matter, see if it is ORCL.

Also, try running . oraenv before the sqlplus (that is dot space
oraenv), it may help properly condition your environment.

Also be sure you export environment variables.

Also, try ps -aux|grep dbw to see what dbstart started for your sid
(apologies if aux isn't what you need for solaris, it's been too long
since I've been on solaris).

Also, check the alert log to see if it is trying and dying, or not
trying at all. Try ls -l $ORACLE_BASE/admin/*/bdump/alert*log or if
you don't have ORACLE_BASE set right:
find / -name "alert*log" -exec ls -l {} \;

Also try lsnrctl status, it shows where the listener log is, so you
can look at that to see if anything is using it. When your db starts
up, there should be service update messages showing your sid.

jg
--
@home.com is bogus.
http://www.crn.com/news/applications...plications.htm