Mar 25, 2016

Tnsping takes long time oracle 11g After configuring 3 SCAN ip in DNS

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.

Register Remote listener:

If you have not register your remote listener, then follow the below steps. 

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
------------------------------------ ----------- ------------------------------
remote_listener                      string      hrdbprdscan.oracle.com:1521
SQL>

SQL>

Thanks .

No comments:

Post a Comment

Translate >>