OPS connections hang for 8 to 10 minutes

[Ryan Kogelheide]

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.

[harry d brown jr]

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

live free or die
harry

[Ryan Kogelheide]

# /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