OraFAQ Forum: Server Administration » Change Database monitor timeout value ORA-01013

Home » RDBMS Server » Server Administration » Change Database monitor timeout value ORA-01013

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

Change Database monitor timeout value ORA-01013 [message #51878]

Wed, 19 June 2002 07:06

Michael Finney
Messages: 2
Registered: June 2002

Junior Member

Database monitor -

[[Oracle]][[ODBC]][[Ora]]ORA-01013: user requested cancel of current operation

This seems to happen when my computer is busy doing something when my oracle ASP application is running.

http://www.freshwater.com/support/notes/noteTN10389.htm says:

"This is an error seen for a Database monitor running against an Oracle database. Change the value of the timeout for the monitor. Either increase the value or set the value to 0. If you choose to set the value to 0, be careful it may cause monitors to skip."

That sounds right on the money. So How do I change the value of the timeout for the monitor? Are they talking about my Oracle/ODBC driver?

Michael

Report message to a moderator

Re: Change Database monitor timeout value ORA-01013 [message #51881 is a reply to message #51878]

Wed, 19 June 2002 10:36

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I dont think so.
With freshwater sitescope/siteseer, there are options to chagne frequency of monitoring call and timeout.
I think you need to change them.
sitescope needs just the oracle thin driver to be available @ its viscinity to connect to databases.

Report message to a moderator

Re: Change Database monitor timeout value ORA-01013 [message #51883 is a reply to message #51878]

Wed, 19 June 2002 13:37

Michael Finney
Messages: 2
Registered: June 2002

Junior Member

http://saloon.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=55&t=000177 has the answer

disable the "Enable Query Timeout" flag in the ODBC Driver Configuration of the driver

change the CPTIMEOUT in the registry under:
HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIOracle in OraHome8I to 0

JavaRanch Oracle area

Report message to a moderator

Re: Change Database monitor timeout value ORA-01013 [message #52714 is a reply to message #51878]

Wed, 07 August 2002 21:28

Vikram
Messages: 16
Registered: March 2000

Junior Member

We are not using Database moniters..

Still this error is encountered

Please advice

Report message to a moderator

Previous Topic:	Drop Database in Oracle 7.3
Next Topic:	year only date format

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 08:58:15 CST 2024