OraFAQ Forum: Networking and Gateways » Listener support no services

Home » RDBMS Server » Networking and Gateways » Listener support no services (oracle 11.2.0.1 RAC of two nodes,solaris10)

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

Listener support no services [message #540596]

Tue, 24 January 2012 12:58

janakors
Messages: 232
Registered: September 2009

Senior Member

hi,
i have created a listener for my db and register the service to it some 2 years back now i have checked it and it display as follows

LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 24-JAN-2012 13:49:44

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.x.x.x)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date                24-JAN-2012 13:45:44
Uptime                    0 days 0 hr. 3 min. 59 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/product/11.2.0/dbhome_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.x.x.x)(PORT=1521)))
The listener supports no services
The command completed successfully

now i have stop and then restart but same status? so how can i manually register it again or anyother solution as i cant run netmgr

kindly guide

Regards
janakors

Report message to a moderator

Re: Listener support no services [message #540597 is a reply to message #540596]

Tue, 24 January 2012 13:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when no DB is available, then listener has nothing to do.

Report message to a moderator

Re: Listener support no services [message #540600 is a reply to message #540597]

Tue, 24 January 2012 13:06

janakors
Messages: 232
Registered: September 2009

Senior Member

BlackSwan wrote on Tue, 24 January 2012 13:02

when no DB is available, then listener has nothing to do.

well db is there ? but why it is showing this and how can i re register it

Regards

Report message to a moderator

Re: Listener support no services [message #540601 is a reply to message #540597]

Tue, 24 January 2012 13:08

janakors
Messages: 232
Registered: September 2009

Senior Member

BlackSwan wrote on Tue, 24 January 2012 13:02

when no DB is available, then listener has nothing to do.

well db is there,in fact i have stop it and restart it that is why it is showing little up time ? but why it is showing this and how can i re register it

Regards

Report message to a moderator

Re: Listener support no services [message #540603 is a reply to message #540601]

Tue, 24 January 2012 13:14

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

Senior Member

You can just wait a couple of minutes and the PMON process will register with the listener automatically. Or if you can't wait:
ALTER SYSTEM REGISTER;
It's nothing to do with netmgr.

Report message to a moderator

Re: Listener support no services [message #540604 is a reply to message #540603]

Tue, 24 January 2012 13:16

janakors
Messages: 232
Registered: September 2009

Senior Member

thanks john.let me then try it at DC..

Regards

Report message to a moderator

Re: Listener support no services [message #540606 is a reply to message #540603]

Tue, 24 January 2012 13:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Oracle RDBMS (tries to) register itself to listener once every 60 seconds.
DB will succeed to register itself when no OS/Networking mis-configuration exists

Report message to a moderator

Re: Listener support no services [message #540669 is a reply to message #540606]

Wed, 25 January 2012 05:00

janakors
Messages: 232
Registered: September 2009

Senior Member

hi,
Quote:

ALTER SYSTEM REGISTER;

well i checked it but again same issue, i have checked the alert log and it have these messages

dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 45)
Wed Jan 25 11:42:11 2012
dispatcher 'D000' encountered error getting listening address
Wed Jan 25 11:42:14 2012
found dead dispatcher 'D000', pid = (28, 46)
Wed Jan 25 11:42:15 2012
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 47)
Wed Jan 25 11:42:18 2012
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 48)
Wed Jan 25 11:42:21 2012
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 49)
Wed Jan 25 11:42:24 2012
dispatcher 'D000' encountered error getting listening address
Wed Jan 25 11:42:27 2012
found dead dispatcher 'D000', pid = (28, 50)
Wed Jan 25 11:42:27 2012
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 51)
Wed Jan 25 11:42:30 2012
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 52)
Wed Jan 25 11:42:33 2012
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 53)
Wed Jan 25 11:42:36 2012
dispatcher 'D000' encountered error getting listening address
Wed Jan 25 11:42:39 2012
found dead dispatcher 'D000', pid = (28, 54)
Wed Jan 25 11:42:39 2012
dispatcher 'D000' encountered error getting listening address
found dead dispatcher 'D000', pid = (28, 55)
Wed Jan 25 11:42:42 2012
dispatcher 'D000' encountered error getting listening address

also listener parameter

SQL> show parameter listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
listener_networks                    string
local_listener                       string
remote_listener                      string
SQL>

and these messages are continuously coming.

@BlackSwan, what kind of OS issues can be there as i doubt it?

Kindly Guide

Regards
janakors

Report message to a moderator

Re: Listener support no services [message #540671 is a reply to message #540669]

Wed, 25 January 2012 05:07

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

Senior Member

Your listener is not listening on the default addess, so you have to tell the instance where it is:

alter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=10.x.x.x)(PORT=1521))';
alter system register;

(I don't know what the correct address is, because in your post you replaced part of it with x.x.x for some reason)

Report message to a moderator

Re: Listener support no services [message #540673 is a reply to message #540671]

Wed, 25 January 2012 05:13

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

Senior Member

I've just noticed that you say this is an 11.2 two node RAC. That changes everything. Your node listeners and scan listeners should be running off your grid infrastructure home, and you should not be attempting to run a listener off the database home at all. I think you had better start again!
Have you looked at the scan listeners and node listeners? Are your instances and services correctly registered with them?

Report message to a moderator

Re: Listener support no services [message #540781 is a reply to message #540673]

Wed, 25 January 2012 12:51

janakors
Messages: 232
Registered: September 2009

Senior Member

hi john,
No the listener is on single instance DB server which is only built to have RMAN and this is our backup server.
i have created a service at production which connect RMAN catalog so when it try to connect so it give this error about listener.

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jan 25 09:36:09 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN>
connected to target database: GRID112 (DBID=307973015)

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04004: error from recovery catalog database: 
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

and also the listener parameters

SQL> show parameter listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
listener_networks                    string
local_listener                       string
remote_listener                      string
SQL>

i will implement your suggestion sir.

Regards

janakors

[Updated on: Wed, 25 January 2012 12:56] by Moderator

Report message to a moderator

Re: Listener support no services [message #540783 is a reply to message #540781]

Wed, 25 January 2012 12:58

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

Senior Member
Account Moderator

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a SID for an instance (usually a database instance) that either
 has not yet dynamically registered with the listener or has not been
 statically configured for the listener. This may be a temporary condition
 such as after the listener has started, but before the database instance
 has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which instances are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SID parameter in the connect descriptor specifies
    an instance known by the listener.
  - Check for an event in the listener.log file.

Regards
Michel

Report message to a moderator

Re: Listener support no services [message #540786 is a reply to message #540783]

Wed, 25 January 2012 13:14

janakors
Messages: 232
Registered: September 2009

Senior Member

Quote:

Check for an event in the listener.log file.

i hope you are talking about xml file .if yes so how to read that.
ouput of "lsnrctl services listener" is

 
LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 25-JAN-2012 10:26:26

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.x.x.x)(PORT=1521)))
The listener supports no services
The command completed successfully.

Report message to a moderator