Sometimes You can get “ORA-12564: TNS:connection refused ” error.
Details of error are as follows.
ORA-12564: TNS:connection refused
This error may be related with the listener, so Make sure that The listener is up and running properly.
The other case is The listener received a request to establish a connection to a database or other service, so create a new static listener.
To solve this error, 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 ) ) )
[[email protected] ~]$ lsnrctl start LISTENER
Or Restart database and listener.
LSNRCTL> stop LSNRCTL> start SQL> shutdown immediate SQL> startup
Or check your database server if it is up and running in open mode.
Do you want to learn more details about RMAN, then read the following articles.
1,927 views last month, 1 views today