This time I faced this scenario, One of my client called me and tell me that his application server faces difficulties to create the connection pool against the DB. first I have checked the DB server side and I saw everything is ok I tried to connect from my laptop - again OK from the application server things were getting weird.. once every few tnsping commands or sqlplus command using tnsnames.ora sqlnet.ora the command tooks more than 10 seconds to return to prompt... I did these changes to isolate the problem sqlnet.ora I've changed - SQLNET . AUTHENTICATION_SERVICES = ( NTS ) to: SQLNET . AUTHENTICATION_SERVICES = ( NONE ) and in the tnsnames.ora - I've used IP instead of the DB hostname. but still - same behavior as above. then I've started to drill down and found these amazing finding: * in the registry key called TNS_ADMIN under LOCAL MACHINE -> SOFTWARE -> ORACLE I found out that the value is pointing to a centralized Oracle client s...
this site will guide you how to overcome some problems you may face during your work and guide you how to perform simple technical operations to achieve your goals.