OraFAQ Forum: Networking and Gateways » Shutdown database & lsnrctl start

Home » RDBMS Server » Networking and Gateways » Shutdown database & lsnrctl start

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Shutdown database & lsnrctl start [message #201454]

Sat, 04 November 2006 07:25

rsubramani
Messages: 11
Registered: January 2006

Junior Member

Hi All,

I am trying to start my lsnrctl, but unable to do so. See the following error:

[oraklon@oradata 9.2.0]$ lsnrctl start prod

LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 04-NOV-2006 18:54:17

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting /u03/pcdb/testdb/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.6.0 - Production
System parameter file is /u03/pcdb/testdb/9.2.0/network/admin/prod_oradata/listener.ora
Log messages written to /u03/pcdb/testdb/9.2.0/network/admin/prod.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCprod)))
Error listening on: (ADDRESS=(PROTOCOL=TCP)(Host=oradata.dats.com)(Port=1521))
TNS-12532: TNS:invalid argument
TNS-12560: TNS:protocol adapter error
TNS-00502: Invalid argument
Linux Error: 515: Unknown error 515

Listener failed to start. See the error message(s) above...

-------------

When I tried to shut down the database:

I get the following

Database closed.
Database dismounted. and it hung there. I am not getting 'ORACLE instance shut down.'

----

Waiting for a solution.

Thanks

Regards
Subra

Report message to a moderator

Re: Shutdown database & lsnrctl start [message #201457 is a reply to message #201454]

Sat, 04 November 2006 07:44

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi.
what is ur listener names.
i think ur not using default listener.
if yes then "prob" is new listener.

let try this.
cmd>set oracle_sid=db_name
cmd>lsnrctl start

or
cmd>set oracle_sid=db_name
cmd>lsnrctl start prod

Hope this helps.
MOhammad Taj.

Report message to a moderator

Re: Shutdown database & lsnrctl start [message #201501 is a reply to message #201457]

Sun, 05 November 2006 02:38

orausern
Messages: 826
Registered: December 2005

Senior Member

To check what is the state of the database, you can see the alert log...does it record recent a shutdown of the db? also you can connect as sys with sysdha privilages and try 'shutdown immediate' command and post the output here.

Report message to a moderator

Re: Shutdown database & lsnrctl start [message #201502 is a reply to message #201454]

Sun, 05 November 2006 04:08

rsubramani
Messages: 11
Registered: January 2006

Junior Member

Hi,

shutdown inmmediate produced the following

Database closed.
Database dismounted. and it got hung there.
I suppose to get 'ORACLE instance shut down.'

Whereas

When I 'Startup Force', it start up the instatnce.

Thanks

Regards
Subramani

Report message to a moderator

Re: Shutdown database & lsnrctl start [message #201503 is a reply to message #201454]

Sun, 05 November 2006 04:11

orausern
Messages: 826
Registered: December 2005

Senior Member

Strange..can you post last 100 or 50 lines of your alert log?

Report message to a moderator

Previous Topic:	DB Connection Timeout
Next Topic:	dblink with a new server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 04 20:24:24 CDT 2024