Re: can not start the sqlplus

From: joel garry <joel-garry_at_home.com>
Date: Sun, 9 Jan 2011 09:21:27 -0800 (PST)
Message-ID: <68fdc582-8286-4856-a821-f895d4082338_at_e16g2000pri.googlegroups.com>

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_lawsuit_over_alleged_IP_theft_by_subsidiary

Received on Sun Jan 09 2011 - 11:21:27 CST