Re: can not start the sqlplus

From: joel garry <joel-garry_at_home.com>
Date: Mon, 10 Jan 2011 09:10:32 -0800 (PST)
Message-ID: <73eaa30f-da53-42c5-9f45-d1a3d001c6d3_at_r40g2000prh.googlegroups.com>

On Jan 9, 9:46 am, happy <ehabaziz2..._at_gmail.com> wrote:
> 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>

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

--
_at_home.com is bogus.
http://www.crn.com/news/applications-os/229000371/new-oracle-bi-tools-tap-into-data-from-rival-sap-applications.htm

Received on Mon Jan 10 2011 - 11:10:32 CST