IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
Sometimes You can get “TNS-12224: TNS:no listener ” error.
Details of error are as follows.
TNS-12224: TNS:no listenerCause: The connection request could not be completed because the listener is not running.
Action: Ensure that the supplied destination address matches one of the addresses used by the listener
– compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection
is to go by way of an Interchange). Start the listener on the remote machine.
To solve this error, stop and start listener as follows.
You can stop and start the Listener as follows.
$ srvctl stop listener $ srvctl start listener
or
$ lsnrctl stop listener $ lsnrctl start listener
If listener is not running properly, you can create a static listener and start it as follows.
Add the following listener descriptions to the listener.ora file under $ORACLE_HOME/network/admin.
Check your Hostname, Port, DB Name and fill them correctly.
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.63.34)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = MSDB) (ORACLE_HOME = /u01/app/db_home_18c ) (SID_NAME = MSDB1 ) ) )
[oracle@msdbadm01 ~]$ lsnrctl start LISTENER
Check listener status as follows, it is listening the Database and its service as follows.
[oracle@msdbadm01 ~]$ lsnrctl status LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 28-APR-2020 15:44:29 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 18.0.0.0.0 - Production Start Date 25-MAR-2020 20:34:20 Uptime 33 days 19 hr. 10 min. 8 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/vfxidb01/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.63.34)(PORT=1521))) Services Summary... Service "+APX" has 1 instance(s). Instance "+APX1", status READY, has 1 handler(s) for this service... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_RECO" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "MSDB" has 1 instance(s). Instance "MSDB1", status READY, has 1 handler(s) for this service... Service "MSDBXDB" has 1 instance(s). Instance "MSDB1", status READY, has 1 handler(s) for this service... [oracle@msdbadm01 ~]$
Do you want to learn more details about RMAN, then read the following articles.
https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/
