Sometimes You can get “ORA-12529: TNS:connect request rejected based on current filtering rules ” error.
Details of error are as follows.
ORA-12529: TNS:connect request rejected based on current filtering rules
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.
alter system set LOCAL_LISTENER="(address=(host=hostname.domain.com)(port=1521)(protocol=tcp))" scope=both sid='*';
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
Or Restart database and listener.
LSNRCTL> stop LSNRCTL> start SQL> shutdown immediate SQL> startup
1. Unset or Remove the TNS_ADMIN parameter at OS Level.
Set the TNS_ADMIN value to the location where Client Credentials file (.zip) is located.
Do you want to learn more details about RMAN, then read the following articles.
476 views last month, 24 views today