Home » RDBMS Server » Networking and Gateways » Listener Utility error (Oracle 11G,Linux)
Listener Utility error [message #536637] Thu, 22 December 2011 00:24 Go to next message
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
Re: Listener Utility error [message #536640 is a reply to message #536637] Thu, 22 December 2011 00:30 Go to previous messageGo to next message
Michel Cadot
Messages: 67888
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the problem is?

Regards
Michel
Listener Utility [message #536644 is a reply to message #536637] Thu, 22 December 2011 00:46 Go to previous messageGo to next message
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
Re: Listener Utility [message #536645 is a reply to message #536644] Thu, 22 December 2011 00:56 Go to previous messageGo to next message
ramoradba
Messages: 2456
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 Go to previous messageGo to next message
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
Re: Listener Utility [message #536651 is a reply to message #536650] Thu, 22 December 2011 01:09 Go to previous messageGo to next message
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
Re: Listener Utility [message #536655 is a reply to message #536651] Thu, 22 December 2011 01:18 Go to previous messageGo to next message
ramoradba
Messages: 2456
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
Re: Listener Utility [message #536656 is a reply to message #536655] Thu, 22 December 2011 01:18 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Check your alert log files
Re: Listener Utility [message #536659 is a reply to message #536656] Thu, 22 December 2011 01:32 Go to previous messageGo to next message
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?
Re: Listener Utility [message #536660 is a reply to message #536651] Thu, 22 December 2011 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 67888
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Listener Utility [message #536661 is a reply to message #536656] Thu, 22 December 2011 01:35 Go to previous messageGo to next message
ramoradba
Messages: 2456
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 Go to previous messageGo to next message
John Watson
Messages: 8561
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)

Re: Listener Utility error [message #536786 is a reply to message #536640] Fri, 23 December 2011 01:27 Go to previous messageGo to next message
zutty
Messages: 45
Registered: December 2011
Member
How to change the instance status from blocked to ready?




Re: Listener Utility error [message #536787 is a reply to message #536786] Fri, 23 December 2011 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 67888
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Listener Utility [message #536788 is a reply to message #536661] Fri, 23 December 2011 01:41 Go to previous messageGo to next message
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
Re: Listener Utility [message #536790 is a reply to message #536788] Fri, 23 December 2011 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 67888
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you upgrade your binaries during these last days?

Regards
Michel
Re: Listener Utility [message #536794 is a reply to message #536790] Fri, 23 December 2011 02:13 Go to previous messageGo to next message
zutty
Messages: 45
Registered: December 2011
Member
No...

Re: Listener Utility [message #536795 is a reply to message #536794] Fri, 23 December 2011 02:21 Go to previous messageGo to next message
Michel Cadot
Messages: 67888
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Listener Utility [message #536796 is a reply to message #536795] Fri, 23 December 2011 02:23 Go to previous messageGo to next message
ramoradba
Messages: 2456
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 Go to previous messageGo to next message
John Watson
Messages: 8561
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


Re: Listener Utility [message #536798 is a reply to message #536797] Fri, 23 December 2011 02:28 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
And after that check for invalid objects...on Database.

Re: Listener Utility [message #536799 is a reply to message #536795] Fri, 23 December 2011 02:29 Go to previous messageGo to next message
zutty
Messages: 45
Registered: December 2011
Member
Alert log is attached with this.
  • Attachment: alert_AG.log
    (Size: 24.21KB, Downloaded 824 times)
Re: Listener Utility [message #536801 is a reply to message #536799] Fri, 23 December 2011 02:37 Go to previous messageGo to next message
Michel Cadot
Messages: 67888
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Listener Utility [message #536803 is a reply to message #536801] Fri, 23 December 2011 02:41 Go to previous messageGo to next message
zutty
Messages: 45
Registered: December 2011
Member
I am trying the suggestion from John.....
Re: Listener Utility [message #536807 is a reply to message #536803] Fri, 23 December 2011 03:01 Go to previous messageGo to next message
zutty
Messages: 45
Registered: December 2011
Member
yes, John was right.At last it is solved....................

Thank you all......
Thank u very much.........
Re: Listener Utility [message #536809 is a reply to message #536807] Fri, 23 December 2011 03:10 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Thanks for the Feedback it will help others...
Have a Good Day.

Sriram
Previous Topic: Need help reading listener.log
Next Topic: listener password
Goto Forum:
  


Current Time: Wed Jun 23 16:34:28 CDT 2021