Dear all, 

Saya punya kasus untuk sqlnet saya sudah batasi tetapi akan menambahkan
user yang ter connect kok tidak bisa ya ?

Mohon advice dari teman2 oracle 

 

SQLNET.ORA Network Configuration File:
C:\Oradata\network\admin\sqlnet.ora

# Generated by Oracle configuration tools.

TCP.VALIDNODE_CHECKING = Yes

TCP.INVITED_NODES= (172.16.17.126,

                    172.16.17.191,

                    172.16.14.25,

                    172.16.17.95,

                   172.16.17.93,

                   172.16.17.169,

                   172.16.15.94,

                   172.16.17.156,

                   172.16.16.121,

                   172.16.17.199) 

NAMES.DEFAULT_DOMAIN = GLB

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

#TCP.EXCLUDED_NODES= ()

 

Untuk 2  IP terakhir tidak dapat connect dengan message dibawah ini  :

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)

(HOST = global-mrtg)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE)

E_NAME = Oradata)))

TNS-12537: TNS:connection closed

 

Mohon pencerahan ???



[Non-text portions of this message have been removed]

Kirim email ke