connection to database slow down using OAS 10.1.2.3
338570Sep 23 2009 — edited Sep 23 2009We have custom Oracle Forms Application; Current production version is 10g (9.0.4.3).
We are trying to upgrade to 10.1.2.3.
I install on the same server in separate oracle home “forms and reports” 10.1.2.0.2 + patch 10.1.2.3;
We are using exactly the sqlnet.ora and tnsnames.ora file in production version and in new version. When I running sqlpus using production version oracle home it takes 3 sec connect to database and when I running sqlplus using new oracle home connection to same database takes 30sec.
What is the problem?
my sqlnet.ora file is
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DEFAULT_DOMAIN = WORLD
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, ONAMES, HOSTNAME)
DEFAULT_SDU_SIZE = 8761
my tnsnames.ora file is
test.WORLD=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=TCP.WORLD)(PROTOCOL=TCP)(HOST=TEST)(PORT=1521)))(CONNECT_DATA=(SID=TEST)(GLOBAL_NAME=TEST.WORLD)))
Thanks Mary