Belum bisa juga pak ? apakah ada maximum user connection ...
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Yoel Susanto Sent: 17 June 2008 16:56 To: [email protected] Subject: Re: [indo-oracle] TNS Closed coba reload listenernya... lsnrctl reload On 17/06/2008, Wahyu Candra Utama <[EMAIL PROTECTED] <mailto:wahyu.candra%40globaltv.co.id> > wrote: > > 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] > > > -- Cheers, Yoel Susanto www.indo-oracletech.com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]

