Newbie: register instance with the listener? [message #285712] |
Wed, 05 December 2007 06:46  |
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   |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |

|
|
Try below command.
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   |
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   |
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 #293196 is a reply to message #293056] |
Fri, 11 January 2008 03:19   |
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   |
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   |
 |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
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   |
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 #300365 is a reply to message #285712] |
Fri, 15 February 2008 04:00   |
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 
|
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 #300380 is a reply to message #300373] |
Fri, 15 February 2008 04:40  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
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
|
|
|