I login sqlplus slowly?

[Wangbin_1]

Hi,
I login sqlplus slowly After I input passward. The sqlplus version is shown very fast. but the "SQL>" prompt is display slowly(about 10 seconds). I want to find the reason. Can you help me?

[harry d brown jr]

Probably DNS related.

please provide a lot more info if that answer doesn't cut it.

live free or die
harry

[Wangbin_1]

Hi,
the server is K380. and there are 2GB memory. the NIS is used to manage the username,password,hostname. and It work correctly. the sever don't use dns. the oracle version is 8.0.6.

[T G Manikandan · Accepted solution]

Do you have hostname in the listener.ora and the tnsnames.ora file(both server and the client).Change them to ip-address.
If the delay is due to the dns the above method will prove whether the delay is due to dns.

There could also be connections being very slow due to lack of resource.What is the usage of memory and swap on the machine.

I just got some info from oracle site which I have attached.Should be useful


Thanks

[Tom Geudens]

Hi,
How does
tnsping
react ? Is it slow as well ? If so you're indeed having a resolving problem.

Regards,
Tom

[Wangbin_1]

Thank you! Now I settle the problem!