OraFAQ Forum: Precompilers, OCI & OCCI » Lock problem without explanation

Home » Developer & Programmer » Precompilers, OCI & OCCI » Lock problem without explanation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Lock problem without explanation [message #120610]

Fri, 20 May 2005 15:28

vmax
Messages: 4
Registered: March 2005

Junior Member

Hi, I have a problem with proc, I have a HP tru64 Unix System (version V5.1 2650) with oracle 9i (version 9.2.0.3.0).

I have a program with proc, this is a migration from oracle 7, and without explanation this program stay lock just before the insert in one table, but in the database there isn't locks, and in the view v$open_cursor the last sentence is just the sentence before of this insert in the program.

In the program I control the signal USR1 (send it by kill utility) with a routine, and if I send a kill -USR1 signal to the program, this program unlock and continue normally and to execute the insert and many others sentence later include a commit sentence.

Someone have any suggestions to try and to solution this problem.

Thanks everyone.

[Updated on: Fri, 20 May 2005 15:33]

Report message to a moderator

Re: Lock problem without explanation [message #120652 is a reply to message #120610]

Sat, 21 May 2005 16:09

Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...

Senior Member

Hi,

If the ProC database session doesn't have a lock and the session is idle, I would suggest you problem is unlikely to be ProC.

Have you tried debuging the application using Truss or equiv operating system tracing tool? I've seen a similar problem to yours before and it turned out to be a OS library call locking, which was fixed with a current OS patch release.

Is your operating system fully patched for Oracle 9.2.0.3? If not, then get patched.

Kind regards,
Michael Hartley, http://www.openfieldsolutions.co.uk

Report message to a moderator

Re: Lock problem without explanation [message #120733 is a reply to message #120652]

Mon, 23 May 2005 07:28

vmax
Messages: 4
Registered: March 2005

Junior Member

I don't know the Truss tool, I'm beginner proc programmer, but I try with this in the next test.

I think the same with about a bug problem with the OS platform, now update the OS.

Thanks

Report message to a moderator

Previous Topic:	Using OCI with ProC
Next Topic:	OCIHandleAlloc fails

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 15:25:26 CST 2024