Home » RDBMS Server » Networking and Gateways » Newbie: register instance with the listener?
Newbie: register instance with the listener? [message #285712] Wed, 05 December 2007 06:46 Go to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

I have started up a SR at Metalink. But we ran in to another problem while trying to solve my SR.
It seems that the instance are not registered with the listener. Below is a part from lsnrctl services command:

**********************************************************
Service "DB906" has 3 instance(s).
Instance "DB906", status READY, has 2 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=SESTOWS47)(PORT=1521))
"DEDICATED" established:7395 refused:0 state:ready
LOCAL SERVER
Instance "DB906", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:3079 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=SESTOWS48)(PORT=1521))
Instance "DB906", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:4186 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=SESTOWS49)(PORT=1521))
************************************************************
Getting an ORA-12521 when trying this:

sqlplus dnmps@DB9061

So, my question is, how do I register the instance with the listener? (is not this done automatically?)

Regards
H
Re: Newbie: register instance with the listener? [message #285715 is a reply to message #285712] Wed, 05 December 2007 06:50 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Try below command.
alter system register;



Also edit listener.ora file and add sid name.

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor



One reason is default listener registration is DYNAMIC you have to change DYNAMIC to STATIC.
edit your listener.ora file like below
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC = 
(SID_NAME = orcl)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1) )
)

C:\>LSNRCTL stop
C:\>REM WAIT FEW SECONDS
C:\>LSNRCTL start

[Updated on: Wed, 05 December 2007 06:51]

Report message to a moderator

Re: Newbie: register instance with the listener? [message #285741 is a reply to message #285715] Wed, 05 December 2007 07:25 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

We are using RAC with three nodes and ASM and have a lot of databases. Shall I manually change the listener.ora?

Our listener.ora is almost empty. I guess this is populated automatically in some way?

The lsnrctl services command I showed you above seems wrong to me. Should there be three different instances? They are all listed as "DB906" but should read "DB9061,DB9062, DB9063".

I tried "alter system register" but how should I proceed in doing that? Should I log in to every instance (inst 1 from node 1) and alter system?

Thanks for helping!

Regards
H
Re: Newbie: register instance with the listener? [message #292984 is a reply to message #285712] Thu, 10 January 2008 07:12 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
As this question have something to do with this topic I post here instead of creating a new thread.

As you can se below the listener.ora are located here:
E:\oracle\product\10.2.0\asm\network\admin\listener.ora

But when looking in the file its almost empty. Where does the listener.ora gets it information? Is it from the tnsnames.ora?
We are using RAC with three nodes.


LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SESTOWS47
Version                   TNSLSNR for 64-bit Windows: Version 10.2.0.3.0 - Production
Start Date                14-NOV-2007 10:31:06
Uptime                    57 days 3 hr. 37 min. 55 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   E:\oracle\product\10.2.0\asm\network\admin\listener.ora
Listener Log File         E:\oracle\product\10.2.0\asm\network\log\listener_sestows47.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=2.17.14.131)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=2.17.14.121)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+asm1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+asm1", status BLOCKED, has 1 handler(s) for this service...
Service "DB01" has 3 instance(s).
  Instance "DB01", status READY, has 1 handler(s) for this service...

Re: Newbie: register instance with the listener? [message #293045 is a reply to message #292984] Thu, 10 January 2008 13:15 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Can you post your listener.ora file?
Re: Newbie: register instance with the listener? [message #293056 is a reply to message #285712] Thu, 10 January 2008 14:07 Go to previous messageGo to next message
BlackSwan
Messages: 22790
Registered: January 2009
Senior Member
With V10+ Oracle no listener.ora is required/needed.
The Listener & DBs "autoregister"; kind of like ET phoning home.
Re: Newbie: register instance with the listener? [message #293196 is a reply to message #293056] Fri, 11 January 2008 03:19 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
anacedent wrote on Thu, 10 January 2008 14:07

With V10+ Oracle no listener.ora is required/needed.
The Listener & DBs "autoregister"; kind of like ET phoning home.


Yes, that what was I thougth. But still, the listener.ora must get the values from somewhere?
We are using ASM.
This is our listener.ora:


# listener.ora.sestows47 Network Configuration File: E:\oracle\product\10.2.0\asm\network\admin\listener.ora.sestows47
# Generated by Oracle configuration tools.

SID_LIST_LISTENER_SESTOWS47 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\product\10.2.0\asm)
      (PROGRAM = extproc)
    )
  )

LISTENER_SESTOWS47 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sestons01.prg-dc.dhl.com)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 2.17.14.121)(PORT = 1521)(IP = FIRST))
    )
  )





Re: Newbie: register instance with the listener? [message #294524 is a reply to message #293056] Thu, 17 January 2008 22:34 Go to previous messageGo to next message
magicfinger
Messages: 2
Registered: January 2008
Junior Member
anacedent wrote on Thu, 10 January 2008 14:07
With V10+ Oracle no listener.ora is required/needed.
The Listener & DBs "autoregister"; kind of like ET phoning home.


With V10+ no listener.ora and tnsnames.ora ... required.

But when i connect to the db from client, the error appeared:

"ORA-12514: TNS:listener does not currently know of service "

And then i try to create listener.ora in $ORACLE_HOME and


restart the listener, the other error appeared:

"TNS-01189: The listener could not authenticate the user"

Here is my listener.ora file:


# listener.ora Network Configuration File: /u01/app/oracle/product/10.1.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10g)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = AIX_02)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

[Updated on: Thu, 17 January 2008 22:57]

Report message to a moderator

Re: Newbie: register instance with the listener? [message #294534 is a reply to message #285712] Thu, 17 January 2008 23:25 Go to previous messageGo to next message
BlackSwan
Messages: 22790
Registered: January 2009
Senior Member
magicfinger,
You never get a 2nd chance to make a FIRST impression.
>With V10+ no listener.ora and tnsnames.ora ... required.
Please provide thread number & time stamp where I stated that no tnsnames.ora file is required.
<dbx1-oracle@devdb02.example.com:/b/oracle/product/10.2.0.2/network/admin:> sqlplus dbadmin/ID10T@dbx1

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jan 17 21:11:49 2008

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Release 10.2.0.2.0 - Production

SQL> exit
Disconnected from Oracle Database 10g Release 10.2.0.2.0 - Production
<dbx1-oracle@devdb02.example.com:/b/oracle/product/10.2.0.2/network/admin:> cat tnsnames.ora
dbx1=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=devdb02.example.com)(PORT=1521))(CONNECT_DATA=(SID=dbx1)))
<dbx1-oracle@devdb02.example.com:/b/oracle/product/10.2.0.2/network/admin:> ls -l
total 20
-rw-r--r--    1 oracle   dba            27 Jan  4 17:25 afiedt.buf
drwxr-x---    2 oracle   dba          4096 Jan  4 16:16 samples
-rw-r-----    1 oracle   dba           172 Dec 26  2003 shrept.lst
-rw-r--r--    1 oracle   dba           668 Jan 17 21:10 sqlnet.log
-rw-r--r--    1 oracle   dba           105 Jan  4 17:24 tnsnames.ora


<dbx1-oracle@devdb02.example.com:/b/oracle/product/10.2.0.2/network/admin:>
lsnrctl status

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 17-JAN-2008 21:44:59

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.2.0 - Production
Start Date                17-JAN-2008 21:09:17
Uptime                    0 days 0 hr. 35 min. 41 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Log File         /b/oracle/product/10.2.0.2/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=devdb02.example.com)(PORT=1521)))
Services Summary...
Service "dbx1.dbx1.example.com" has 1 instance(s).
  Instance "dbx1", status READY, has 1 handler(s) for this service...
Service "dbx1XDB.dbx1.example.com" has 1 instance(s).
  Instance "dbx1", status READY, has 1 handler(s) for this service...
Service "dbx1_XPT.dbx1.example.com" has 1 instance(s).
  Instance "dbx1", status READY, has 1 handler(s) for this service...
The command completed successfully
<dbx1-oracle@devdb02.example.com:/b/oracle/product/10.2.0.2/network/admin:>

The example above shows I was able to make a SQL*Net connection & that no listener.ora file exists on this system.

The fact that that you can not correctly configure your site, does not mean that others suffer from similar problems.

I know with 100% certainty that no listener.ora file is required on V10 Oracle or higher.
I do believe that if the listener.ora is NOT correctly constructed that problems will result.

The point I have tried to stress, is that when one is having problems with their listener.ora file, perhaps they should rename it out of the way & bounce the listener process itself.
It is like giving chicken soup to a dead man; it can't hurt & just might help.

[Updated on: Thu, 17 January 2008 23:46] by Moderator

Report message to a moderator

Re: Newbie: register instance with the listener? [message #294598 is a reply to message #294534] Fri, 18 January 2008 02:07 Go to previous messageGo to next message
magicfinger
Messages: 2
Registered: January 2008
Junior Member
anacedent,

I installed 10g on AIX system and i did not find listener.ora, tnsnames.ora, sqlnet.ora at the server's folders.

when i try to connect to database server the error

ORA-12514: TNS:listener does not currently know of service

So i'm confusing about the default listener at server side.

Does my problem cause by the listener not register with the dbs???

[Updated on: Fri, 18 January 2008 03:15]

Report message to a moderator

Re: Newbie: register instance with the listener? [message #294707 is a reply to message #294598] Fri, 18 January 2008 09:32 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Maybe you should try create the listener with NetCA?
Re: Newbie: register instance with the listener? [message #294939 is a reply to message #294707] Sun, 20 January 2008 23:26 Go to previous messageGo to next message
jkirankumar_307@yahoo.com
Messages: 12
Registered: April 2007
Junior Member
Hi,

Can U check the listener.ora files present at
1. $ORACLE_HOME/network/admin
2. ASM_HOME/network/admin

Let me know

Regards,
Kiran
Re: Newbie: register instance with the listener? [message #300365 is a reply to message #285712] Fri, 15 February 2008 04:00 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

The listener have been working fine for some time. But after some strange errors (listener dies, CRS-errors) some DBs are nnot registered with the listener. We are using dynamic registration.

Listenerlog:
Quote:

14-FEB-2008 15:38:27 * (CONNECT_DATA=(SID=DB012)(CID=(PROGRAM=E:\oracle\product\10.2.0\agent10g\perl\5.8.3\bin\MSWin32-X64-multi-thread\perl.exe)(HOST=SESTO WS48)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=2.17.14.122)(PORT=4707)) * establish * DB012 * 12505
TNS-12505: swedish rabble Smile



Its only 4 of 24 DBs that are affected. How to reregister the instances? Can I use ALTER SYSTEM register? But I must be connected to the instance, dont I?

Regards
H

[Updated on: Fri, 15 February 2008 04:02] by Moderator

Report message to a moderator

Re: Newbie: register instance with the listener? [message #300368 is a reply to message #300365] Fri, 15 February 2008 04:03 Go to previous messageGo to next message
Michel Cadot
Messages: 59143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TNS-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
Re: Newbie: register instance with the listener? [message #300373 is a reply to message #300368] Fri, 15 February 2008 04:13 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

I know what the ORA-error means. But how do I make the instance dynamicaly register with the listener?

Regards
H
Re: Newbie: register instance with the listener? [message #300380 is a reply to message #300373] Fri, 15 February 2008 04:40 Go to previous message
Michel Cadot
Messages: 59143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I know what the ORA-error means

Youo don't show anywhere you know what it means.

Quote:
But how do I make the instance dynamicaly register with the listener?

Use LOCAL_LISTENER parameter

Regards
Michel
Previous Topic: Oracle - MS SQL-Server Transparent Gateway not working
Next Topic: HELP Getting ORA - 12500 ERROZR
Goto Forum:
  


Current Time: Fri Sep 19 23:12:51 CDT 2014

Total time taken to generate the page: 0.05461 seconds