topic Re: sqlplus - It hangs up during exit in Operating System - HP-UX

sqlplus - It hangs up during exit

Mahima Kaushik_2 — Mon, 22 Mar 2004 08:57:34 GMT

Hi,
Has any one seen this? Login to sqlplus is slow (2 - 3 minutes) but OK. But once enter exit, it hangs for at least 10 minutes. We are noticing this issue since few months now. It is causing several problems since some users have scripts running where after exit they are waiting to get to next step. We have HP-UX 10.20 and 11i.
Need help.
THX

Re: sqlplus - It hangs up during exit

Steve Steel — Mon, 22 Mar 2004 09:56:37 GMT

Hi

Without a lot more info on revisions . difficult

Try

http://www.oracletuning.com/

Steve Steel

Re: sqlplus - It hangs up during exit

Julio Yamawaki — Mon, 22 Mar 2004 10:04:42 GMT

Hi,

need more information:
1. Where is the database running
2. Where is sqlplus running
3. What kind of sqls are you running is this session

Re: sqlplus - It hangs up during exit

Mahima Kaushik_2 — Mon, 22 Mar 2004 11:28:41 GMT

Here is what user sees when logging in:

PL/SQL Release 2.3.2.3.0 - Production
HP10.20hostname:/path/home/userid 3 sqlplus usrid/passwd@databasename

SQL*Plus: Release 3.3.2.0.0 - Production on Mon Mar 22 10:35:41 2004

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

Connected to:
Oracle7 Server Release 7.3.2.3.0 - Production Release
With the distributed, replication and parallel query options
PL/SQL Release 2.3.2.3.0 - Production

SQL>
SQL> exit
Disconnected from Oracle7 Server Release 7.3.2.3.0 - Production Release
With the distributed, replication and parallel query options
PL/SQL Release 2.3.2.3.0 - Production

It used to work fine before.

Re: sqlplus - It hangs up during exit

Mahima Kaushik_2 — Mon, 22 Mar 2004 11:32:31 GMT

Database is running in a HP-UX 10.20 box. SQLPLUS is in the same box as well.

Re: sqlplus - It hangs up during exit

Julio Yamawaki — Mon, 22 Mar 2004 11:47:10 GMT

Hi,

Let's try to isolate the problem.
Can you make the same connection in a SQL for Windows to see if the same occurs?

Re: sqlplus - It hangs up during exit

Mahima Kaushik_2 — Mon, 22 Mar 2004 11:51:25 GMT

Unfortunately this can not be run on Windows.
It's unix mounted only.

Re: sqlplus - It hangs up during exit

Julio Yamawaki — Mon, 22 Mar 2004 12:01:15 GMT

Don't you have another UNIX box?
This is for testing purpose only.
I need to know if you have problem with your UNIX or if it's in your database.
Also, verify if you have some difference in calling sqlplus user/password (without using databasename).

Re: sqlplus - It hangs up during exit

Hein van den Heuvel — Mon, 22 Mar 2004 13:16:30 GMT

> Login to sqlplus is slow (2 - 3 minutes) but OK

Whoah. That is NOT ok. That is totally unacceptable. sub-second it good, 2-3 seconds is annoying but acceptable, anything over 5 seconds means there is a serious problem on the box! Ivestigate! Isolate! What is it doing all that time? Paging its brains outs? Figure out, like tan other reply suggest, whether it is the client, the server or the combo. What is the path taken? Local connectt? tcp? ipc? Oracle MTS making you wait for a slot? Lot's more details needed for answers, but don't bother with the exit prolem untill you understand the entry problem, because there is a serious problem there.

fwiw,
Hein.

Re: sqlplus - It hangs up during exit

James A. Donovan — Mon, 22 Mar 2004 13:37:17 GMT

Since SQL*Plus and your database are located on the same box, please try the following:

set ORACLE_SID=

$ sqlplus userid/passwd

Leave off the "@databasename". This should determine if the problem is with the listener/network or with the database.

BTW....have you considered upgrading your version of Oracle? The version you're on has been desupported for a few years now.

Re: sqlplus - It hangs up during exit

Jean-Luc Oudart — Mon, 22 Mar 2004 13:39:02 GMT

Well, both database and user on same box.
Why not try
export ORACLE_SID=
sqlplus user/passwword

what the response time for tnsping ?

Regards,
Jean-Luc

Re: sqlplus - It hangs up during exit

Mahima Kaushik_2 — Mon, 22 Mar 2004 13:43:05 GMT

On Oracle server itself, login and logout is fast. It's clients that we are experiencing the problem with.
Also we had made some changes to our /etc/inetd.conf file, arround the time since we are having this problem, to accomodate the security scan requirements. I am not sure if any of these changes might have caused this.
Following services have been commented out from inetd.conf:

bootpd
chargen
daytime
discard
echo
finger
echo
finger
ident
kerberose services (including klogin and kshell)
ntalk
portmapper
rpc.cmsd
rusers
time
tftp
walld
who

THX

Re: sqlplus - It hangs up during exit

Jean-Luc Oudart — Mon, 22 Mar 2004 13:54:56 GMT

How do you resolve IP@ ?

if you change hostname with IP@in tnsnames.ora , what is the response time ?

Regards,
Jean-Luc

Re: sqlplus - It hangs up during exit

Mahima Kaushik_2 — Tue, 23 Mar 2004 11:43:42 GMT

Tried

sqlplus userid/passwd

This did not make any difference.

Also we use DNS server to resolve our hostname and IP. That doesn't seem any issue. Pinging and nslookup are positive for the server and clients both.
THX for the responses.

Re: sqlplus - It hangs up during exit

Julio Yamawaki — Tue, 23 Mar 2004 12:02:08 GMT

Hi,

let's try one more time.
What about your UNIX box, is it performing "normally"?
Do you know when this performance issue started? Do you have other applications running in this database? Are these applications running with a "normal" performance?
Did you check the database to see if it has some contention?

Re: sqlplus - It hangs up during exit

Sanjay Kumar Suri — Tue, 23 Mar 2004 12:14:27 GMT

Can you post your init.ora?

Are you using shared server connection or dedicated connection?

sks

Re: sqlplus - It hangs up during exit

Jean-Luc Oudart — Tue, 23 Mar 2004 12:48:38 GMT

Mahima,

in a previous post you wrote :
"On Oracle server itself, login and logout is fast"

and now : "Tried
sqlplus userid/passwd
This did not make any difference.
"

Did I miss anything ?

Also, Are you using dedicated server (as opposed to MTS), Have you tried to create another listener , different port number, new entry in tnsnames and see the results.

What about tnsping (you haven't said anything about it) ?

Jean-Luc

Re: sqlplus - It hangs up during exit

Mahima Kaushik_2 — Tue, 23 Mar 2004 14:21:16 GMT

Unix box is performing good other then some space issue like some database File system 100% full. Itâ s a 9000/829/K400 Box.

Jean,
I tried â sqlplus userid/passwdâ on client.

Also what do you mean by tnsping, I am not sure. Can you explain it to me little more

Re: sqlplus - It hangs up during exit

Michael Schulte zur Sur — Tue, 23 Mar 2004 14:36:12 GMT

Hi,

can you see any errors in errorlog?
If this is a network problem, you could activate tracing.

greetings,

Michael

Re: sqlplus - It hangs up during exit

Michael Schulte zur Sur — Tue, 23 Mar 2004 14:37:10 GMT

Hi,

I meant alertlog and you could modify sqlnet.ora for tracing.

Michael