Platform: IBM AIX 6.1 / 7.1
Issue Describe:
Recently I configured three SCAN IPs in my DNS. After than I observed tnsping to same database service in same server of all nodes taking significant/ log time to resolve. I go through lots of documents but I did not find any solution. i.e., All solution was there except one OS level .conf file.
Change the below file and the line after commenting the same. This resolved the issue.
# vi /etc/netsvc.conf
...
hosts = local, bind4
...
Note: Don't change any other values.
If you have not register your remote listener, then follow the below steps.
Thanks .
Issue Describe:
Recently I configured three SCAN IPs in my DNS. After than I observed tnsping to same database service in same server of all nodes taking significant/ log time to resolve. I go through lots of documents but I did not find any solution. i.e., All solution was there except one OS level .conf file.
Change the below file and the line after commenting the same. This resolved the issue.
# vi /etc/netsvc.conf
...
hosts = local, bind4
...
Note: Don't change any other values.
Register Remote listener:
SQL> show parameter remote_listener;
NAME
TYPE VALUE
------------------------------------ -----------
------------------------------
remote_listener
string hrdbprdscan:1521
SQL>
SQL> alter system set
remote_listener='hrdbprdscan.oracle.com:1521' scope=both sid='*';
System altered.
SQL> SQL>
SQL>
SQL> show parameter remote_listener;
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
SQL>
SQL>
Thanks .
No comments:
Post a Comment