| Oracle database not registering with listener [message #686497] |
Tue, 27 September 2022 23:53  |
 |
rcct
Messages: 36
Registered: May 2013
Location: Ottawa, ON
|
Member |
|
|
I recently recovered a database from backup onto a new Linux server to test DR, but I am not being able to register it with the listener, it shows status as "UNKNOWN" instead of "READY". Here is some more info:
===========================================================================
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string LISTENER_GBM12P
remote_listener string
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string GBM12P.ncc-ccn.ca
===========================================================================
[oracle@tmp-hq-ldora1 admin]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 28-SEP-2022 00:46:36
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TMP-HQ-LDORA1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 28-SEP-2022 00:25:03
Uptime 0 days 0 hr. 21 min. 32 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/product/12.2.0.1/db_1/network/admin/listener.ora
Listener Log File /oracle/app/diag/tnslsnr/tmp-hq-ldora1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tmp-hq-ldora1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=tmp-hq-ldora1)(PORT=5501))(Security=(my_wallet_directory=/oracle/app/admin/SDE11P/xdb_wall et))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "gbm12p" has 1 instance(s).
Instance "gbm12p", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
===========================================================================
[oracle@tmp-hq-ldora1 admin]$ cat listener.ora
- listener.ora Network Configuration File: /oracle/app/product/12.2.0.1/db_1/network/admin/listener.ora
- Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = gbm12p)
(ORACLE_HOME = /oracle/app/product/12.2.0.1/db_1)
(SID_NAME = gbm12p)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TMP-HQ-LDORA1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
===========================================================================
[oracle@tmp-hq-ldora1 admin]$ cat tnsnames.ora
GBM12P =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tmp-hq-ldora1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = GBM12P.ncc-ccn.ca)
)
)
LISTENER_GBM12P =
(ADDRESS = (PROTOCOL = TCP)(HOST = TMP-HQ-LDORA1)(PORT = 1521)
===========================================================================
[oracle@tmp-hq-ldora1 admin]$ tnsping gbm12p
TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 28-SEP-2022 00:50:39
Copyright (c) 1997, 2016, Oracle. All rights reserved.
Used parameter files:
/oracle/app/product/12.2.0.1/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = tmp-hq-ldora1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = GBM12P.ncc-ccn.ca)))
OK (0 msec)
===========================================================================
Thank you.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Oracle database not registering with listener [message #690542 is a reply to message #686509] |
Tue, 13 October 2026 07:43  |
 |
SwonnCarlos0405
Messages: 1
Registered: October 2026
|
Junior Member |
|
|
rcct wrote on Thu, 29 September 2022 19:42Sorry, that was a copy-paste error, I had missed the last bracket when copying. However, I bounced the database, and the listener now shows a "READY" instance for it.
I had done a few "alter system register", but that had not registered the instance. Weird.
Thank you very much for your advice.
Glad you got it working! That does sound like a registration timing issue. ALTER SYSTEM REGISTER forces the instance to register with the listener, but it won't help if the instance isn't fully available or the relevant configuration isn't right yet. Restarting the database may have allowed dynamic registration to complete properly. If it happens again, checking lsnrctl status and the database's LOCAL_LISTENER setting would be a good starting point. At least now you know the listener can see the instance as READY.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
