OraFAQ Forum: Networking and Gateways » Listener Utility error

Home » RDBMS Server » Networking and Gateways » Listener Utility error (Oracle 11G,Linux)

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

Listener Utility error [message #536637]

Thu, 22 December 2011 00:24

zutty
Messages: 45
Registered: December 2011

Member

I am new to oracle .
when i run lsnrctl status i got message like "
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 21-DEC-2011 11:32:25

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 21-DEC-2011 10:48:33
Uptime 0 days 0 hr. 43 min. 51 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/dbserver/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "AG.localhost" has 1 instance(s).
Instance "AG", status BLOCKED, has 1 handler(s) for this service...

"
The command completed successfully

Report message to a moderator

Re: Listener Utility error [message #536640 is a reply to message #536637]

Thu, 22 December 2011 00:30

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And the problem is?

Regards
Michel

Report message to a moderator

Listener Utility [message #536644 is a reply to message #536637]

Thu, 22 December 2011 00:46

zutty
Messages: 45
Registered: December 2011

Member

I am new to oracle .
when i run lsnrctl status i got message like "
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 21-DEC-2011 11:32:25

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 21-DEC-2011 10:48:33
Uptime 0 days 0 hr. 43 min. 51 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/dbserver/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "AG.localhost" has 1 instance(s).
Instance "AG", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully"

how to unblock AG instance

Report message to a moderator

Re: Listener Utility [message #536645 is a reply to message #536644]

Thu, 22 December 2011 00:56

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Whats your problem..
any error like "ORA-12528: TNS:listener: all appropriate instances are blocking new connections" ? Please post your error message.

[Updated on: Thu, 22 December 2011 00:56]

Report message to a moderator

Re: Listener Utility [message #536650 is a reply to message #536645]

Thu, 22 December 2011 01:08

zutty
Messages: 45
Registered: December 2011

Member

ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

Report message to a moderator

Re: Listener Utility [message #536651 is a reply to message #536650]

Thu, 22 December 2011 01:09

zutty
Messages: 45
Registered: December 2011

Member

when i try to,login with Database AG user
i got the error message like
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

Report message to a moderator

Re: Listener Utility [message #536655 is a reply to message #536651]

Thu, 22 December 2011 01:18

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

ORA-01033: ORACLE initialization or shutdown in progress.

Cause: An attempt was made to log on while Oracle is being started up or shutdown.

Action: Wait a few minutes. Then retry the operation

Report message to a moderator

Re: Listener Utility [message #536656 is a reply to message #536655]

Thu, 22 December 2011 01:18

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Check your alert log files

Report message to a moderator

Re: Listener Utility [message #536659 is a reply to message #536656]

Thu, 22 December 2011 01:32

zutty
Messages: 45
Registered: December 2011

Member

when i run dbstart i got error message

ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart ORACLE_HOME
Processing Database instance "orcl": log file /u01/app/oracle/product/11.2.0/dbhome_1/startup.log
how to solve this?

Report message to a moderator

Re: Listener Utility [message #536660 is a reply to message #536651]

Thu, 22 December 2011 01:33

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

zutty wrote on Thu, 22 December 2011 08:09

when i try to,login with Database AG user
i got the error message like
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

Either your instance is currently starting or shutting down, either your instance failed to start up.
You can find the reason in the alert.log file.

Regards
Michel

Report message to a moderator

Re: Listener Utility [message #536661 is a reply to message #536656]

Thu, 22 December 2011 01:35

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

ramoradba wrote on Thu, 22 December 2011 12:48

Check your alert log files

log file /u01/app/oracle/product/11.2.0/dbhome_1/startup.log

[Updated on: Thu, 22 December 2011 01:43]

Report message to a moderator

Re: Listener Utility [message #536670 is a reply to message #536661]

Thu, 22 December 2011 02:55

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

Also look at
/u01/app/oracle/diag/rdbms/AG/AG/trace/alert_AG.log
(I'm guessing at the case sensitivity for AG)

Report message to a moderator

Re: Listener Utility error [message #536786 is a reply to message #536640]

Fri, 23 December 2011 01:27

zutty
Messages: 45
Registered: December 2011

Member

How to change the instance status from blocked to ready?

Report message to a moderator

Re: Listener Utility error [message #536787 is a reply to message #536786]

Fri, 23 December 2011 01:29

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why don't you answer to our questions?
We already gave you what you have to FIRST do.
The second step depends on the answer of the frst one.

Regards
Michel

Report message to a moderator

Re: Listener Utility [message #536788 is a reply to message #536661]

Fri, 23 December 2011 01:41

zutty
Messages: 45
Registered: December 2011

Member

How can i solve this?

Errors in file /u01/app/oracle/diag/rdbms/ag/AG/trace/AG_ora_17206.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Errors in file /u01/app/oracle/diag/rdbms/ag/AG/trace/AG_ora_17206.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option

Report message to a moderator

Re: Listener Utility [message #536790 is a reply to message #536788]

Fri, 23 December 2011 01:50

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you upgrade your binaries during these last days?

Regards
Michel

Report message to a moderator

Re: Listener Utility [message #536794 is a reply to message #536790]

Fri, 23 December 2011 02:13

zutty
Messages: 45
Registered: December 2011

Member

No...

Report message to a moderator

Re: Listener Utility [message #536795 is a reply to message #536794]

Fri, 23 December 2011 02:21

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

But you did upgrade some day as Oracle seems to require you finish your upgrade.
Attch the complete alert.log.

Regards
Michel

Report message to a moderator

Re: Listener Utility [message #536796 is a reply to message #536795]

Fri, 23 December 2011 02:23

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option

Michel was right! Seems there was problem in your Post upgrade Steps On running scripts.

[Updated on: Fri, 23 December 2011 02:24]

Report message to a moderator

Re: Listener Utility [message #536797 is a reply to message #536795]

Fri, 23 December 2011 02:25

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

Another possibility: running catalog or catproc and not letting them run to completion? You can get the same issue when creating a database.
@OP, try this:
connect with SQL*Plus as sysdba, and issue these commands:

shu abort
startup upgrade
@?/rdbms/admin/catalog
@?/rdbms/admin/catproc
startup force

Report message to a moderator

Re: Listener Utility [message #536798 is a reply to message #536797]

Fri, 23 December 2011 02:28

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

And after that check for invalid objects...on Database.

Report message to a moderator

Re: Listener Utility [message #536799 is a reply to message #536795]

Fri, 23 December 2011 02:29

zutty
Messages: 45
Registered: December 2011

Member

Alert log is attached with this.

Attachment: alert_AG.log
(Size: 24.21KB, Downloaded 2580 times)

Report message to a moderator

Re: Listener Utility [message #536801 is a reply to message #536799]

Fri, 23 December 2011 02:37

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Try what John suggested.
More on the error might be found in /u01/app/oracle/diag/rdbms/ag/AG/trace/AG_ora_6142.trc

Regards
Michel

Report message to a moderator

Re: Listener Utility [message #536803 is a reply to message #536801]

Fri, 23 December 2011 02:41

zutty
Messages: 45
Registered: December 2011

Member

I am trying the suggestion from John.....

Report message to a moderator

Re: Listener Utility [message #536807 is a reply to message #536803]

Fri, 23 December 2011 03:01

zutty
Messages: 45
Registered: December 2011

Member

yes, John was right.At last it is solved....................

Thank you all......
Thank u very much.........

Report message to a moderator

Re: Listener Utility [message #536809 is a reply to message #536807]

Fri, 23 December 2011 03:10

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Thanks for the Feedback it will help others...
Have a Good Day.

Sriram

Report message to a moderator

Previous Topic:	Need help reading listener.log
Next Topic:	listener password

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 18:32:00 CST 2025