cancel
Showing results for 
Search instead for 
Did you mean: 

DBMS_ALERT on HP-UX

Rajiv AV
Occasional Visitor

DBMS_ALERT on HP-UX

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)


2 REPLIES
Indira Aramandla
Honored Contributor

Re: DBMS_ALERT on HP-UX

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
Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

Re: DBMS_ALERT on HP-UX

hi,

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

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)