DBMS_ALERT on HP-UX

[Rajiv AV]

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)

[Indira Aramandla]

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

[Yogeeraj_1]

hi,

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

regards
yogeeraj