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