topic Re: I login sqlplus slowly? in Operating System - HP-UX

I login sqlplus slowly?

Wangbin_1 — Wed, 04 Dec 2002 01:40:23 GMT

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?

Re: I login sqlplus slowly?

harry d brown jr — Wed, 04 Dec 2002 01:51:52 GMT

Probably DNS related.

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

live free or die
harry

Re: I login sqlplus slowly?

Wangbin_1 — Wed, 04 Dec 2002 02:46:50 GMT

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.

Re: I login sqlplus slowly?

T G Manikandan — Wed, 04 Dec 2002 05:17:31 GMT

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

Re: I login sqlplus slowly?

Tom Geudens — Wed, 04 Dec 2002 06:42:23 GMT

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

Regards,
Tom

Re: I login sqlplus slowly?

Wangbin_1 — Wed, 04 Dec 2002 06:46:15 GMT

Thank you! Now I settle the problem!