Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

OPS connections hang for 8 to 10 minutes

Ryan Kogelheide
Frequent Advisor

OPS connections hang for 8 to 10 minutes

Using Oracle 8.1.7.3 on HP-UX 11 I'm experiencing regular connection hanging problems. The Oracle user process is created and I can see it in V$SESSION, but it sometimes takes 10 minutes to connect (and do a simple select from dual).

Using oradebug lkdebug, I see that the process has one lock in the pending queue. If I look at this lock, the owner of the process is the same process and its status is "OPENING".

This problem does not occur when the db is idle, but only when it starts to get several users.

I suspect that there is an HP-UX configuration problem and that a timeout is finally allowing the connection to proceed. In particular, I suspect it is a LAN+IPC configuration problem.

Any ideas would be appreciated.
2 REPLIES
harry d brown jr
Honored Contributor

Re: OPS connections hang for 8 to 10 minutes

Probably a DNS issue. Can you provide some more info on how your system resolves host names?

live free or die
harry
Live Free or Die
Ryan Kogelheide
Frequent Advisor

Re: OPS connections hang for 8 to 10 minutes

# /etc/nsswitch.conf

hosts: files [NOTFOUND=continue TRYAGAIN=continue] nis [NOTFOUND=continue TRYAGAIN=continue] dns

services: nis files
protocols: nis files
networks: nis files
rpc: nis files
netgroup: nis files
aliases: nis files

# /etc/hosts

127.0.0.1 localhost loopback
172.12.23.34 c7ora1 c7ora1.loc.dom.com
10.0.0.1 c7ora1 c7ora1hb

172.12.23.35 c7ora2
10.0.0.2 c7ora2hb

# /etc/cmcluster/cmclconfig.ascii

NODE_NAME c7ora1
NETWORK_INTERFACE lan1
HEARTBEAT_IP 172.12.23.34
NETWORK_INTERFACE lan2
NETWORK_INTERFACE lan3
HEARTBEAT_IP 10.0.0.1

NODE_NAME c7ora2
NETWORK_INTERFACE lan1
HEARTBEAT_IP 172.12.23.35
NETWORK_INTERFACE lan2
NETWORK_INTERFACE lan3
HEARTBEAT_IP 10.0.0.2