we have recently insalled oracle817 on vms. when we connect to sqlplus it takes long time to establish the connection only to this server. connection to other servers are OK. I tried tnsping on 3 servers.
1. on UNIX.
tnsping server1 50 --- very fast.. immediate.
2. on VMS
tnsping server2 50 - Not as fast as in the first case..2-4 secs....But it's OK.
3. on VMS (newly installed oracle817)
tnsping server3 50 ---- very slow..it takes longt time (4-8 secs).
I have create prespawned procesess also. But still no appreciable improvement. listener.ora entries are ok. any solutions?
Did you check the network?
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width