topic Re: DBMS_ALERT on HP-UX in Operating System - HP-UX

DBMS_ALERT on HP-UX

Rajiv AV — Tue, 15 Feb 2005 14:16:58 GMT

Hi, we are using HP-UX B.11.11 U 9000/800 (tb). We are using Oracle 9i. While using the DBMS_ALERT.WAITONE procedure manytimes we get the error. Any patches that would solve the problem?

java.sql.SQLException: ORA-20000: ORU-10023: error 2 on lock request.
ORA-06512: at "SYS.DBMS_ALERT", line 319
ORA-06512: at line 1

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:656)
at hp.comcat.apps.DaemonBase.waitForNextMessage(DaemonBase.java:315)

Re: DBMS_ALERT on HP-UX

Indira Aramandla — Tue, 15 Feb 2005 20:44:29 GMT

Hi Rajiv,

During what situation is the error occuring. Please provide more info on what steps were you following and this error occured.

May be your application has specified the TIMEOUT parameter to a small amount when calling DBMS_ALERT.WAITONE or DBMS_ALERT.WAITANY.

Or is your application using the default setting -- 86400000 seconds -- 1000 days!

How was the grant given. The 'grant' must be given to the user, not the role.
Grant execute on sys.dbms_alert to ;
Grant execute on sys.dbms_lock to ;

Indira A

Re: DBMS_ALERT on HP-UX

Yogeeraj_1 — Wed, 16 Feb 2005 05:42:50 GMT

hi,

consider using waitany so that it just collect the messages from whomever finishes first.

regards
yogeeraj