Re: can not start the sqlplus
Date: Sun, 9 Jan 2011 09:46:21 -0800 (PST)
Message-ID: <0b00044b-75a5-4100-b2ac-3447a49f87fe_at_a10g2000vby.googlegroups.com>
On Jan 9, 7:21 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Jan 9, 8:57 am, happy <ehabaziz2..._at_gmail.com> wrote:
>
>
>
> > I started the sqlplus through :http://homer:5560/isqlplus/
>
> > but did not opened .
> > I tried :
> > oracle _at_ 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 _at_ Homer /export/home/oracle/database>
> > oracle _at_ Homer /export/home/oracle/database>dbstart $ORACLE_HOME
> > oracle _at_ Homer /export/home/oracle/database>
>
> > oracle _at_ Homer /export/home/oracle/database>sqlplus scott/tiger_at_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:
>
> 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 _at_orcl - if that works, you likely
> have orcl defined wrong.
>
> See Ed's description of the various errors here:http://forums.oracle.com/forums/message.jspa?messageID=4346244#4346244
>
> "connect descriptor" means what the listener knows about.
>
> jg
> --
> _at_home.com is bogus.http://www.computerworld.com/s/article/9204021/Oracle_slapped_with_la...
oracle _at_ 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 _at_ 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 _at_ 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 _at_ Homer /export/home/oracle> Received on Sun Jan 09 2011 - 11:46:21 CST