I'm stumped here and I don't know where to start. Whenever I log into oracle from sqlplus it takes over a minute. Into any schema, with or without the Net Service Name. i.e. scott/user@oracledb
I had modified the glogin file and I reverted to the original one but that hasn't fixed it.
This is Win2K, Oracle 8.1.7.
The are 20MB of free ram, which should be enough for sqlplus and oracle is already in memory 60 megs ram.
- Too big listener.log file ? remove and see.
- Setup one more port in the listener and connect on this port instead. Faster ?
- Name resulotion method on your client to reach the host specified in tnsnames.ora file ? dns,wins,local hostfile... is this correct ? tnsping shows a good result though.