I have a job that connects to an Oracle 8.1.6 database using DatabaseConnect. It reads records from 2 tables successfully, then I use DatabaseDisconnect to disconnect from the database. This is successful the first time the job runs. However, 24X7 bombs at the DatabaseConnect statement with a Dr. Watson error about access violation if I run the same job a second time without stopping/restarting 24X7. How do I fix this?

This is known issue in versions 2.3.x and prior. Please upgrade to a more recent version

: I have a job that connects to an Oracle 8.1.6 database using DatabaseConnect.
: It reads records from 2 tables successfully, then I use DatabaseDisconnect
: to disconnect from the database. This is successful the first time the job
: runs. However, 24X7 bombs at the DatabaseConnect statement with a Dr.
: Watson error about access violation if I run the same job a second time
: without stopping/restarting 24X7. How do I fix this?

: This is known issue in versions 2.3.x and prior. Please upgrade to a more
: recent version

I was running 3.0.4b at the time of the error. Just upgraded this morning. Now what do I do?

Version 3.0.4b is the most recent!

Which database driver do you use for connection? "8.0.4 and later" or some other? Which version of Oracle client are you running?

By the way, there is one simple way to deal with such problems. Set the job to run "detached" and it will not impact other jobs or other subsequent runs

: I was running 3.0.4b at the time of the error. Just upgraded this morning.
: Now what do I do?

: Version 3.0.4b is the most recent!

: Which database driver do you use for connection? "8.0.4 and later"
: or some other? Which version of Oracle client are you running?

: By the way, there is one simple way to deal with such problems. Set the job
: to run "detached" and it will not impact other jobs or other
: subsequent runs

I am using the Oracle 8.0.4 - 8i Database profile. I am running Oracle 8.1.6.
The job uses MailSend and MailSendWithAttachment and is called from various other scripts with the JobRun command. I tried setting the job to run detached but I never received email and the job log doesn't show the job as having run. I tried setting the job to run asynchronous and detached and had the same results.

The email job is a script called SendMail and it is called from another script using the JobRun("SendMail") command.

Any other suggestions?

Please try creating Oracle 7.3 profile (for connnecting to your Oracle 8.1.6 database)

: I am using the Oracle 8.0.4 - 8i Database profile. I am running Oracle 8.1.6.
: The job uses MailSend and MailSendWithAttachment and is called from various
: other scripts with the JobRun command. I tried setting the job to run
: detached but I never received email and the job log doesn't show the job
: as having run. I tried setting the job to run asynchronous and detached
: and had the same results.

: The email job is a script called SendMail and it is called from another
: script using the JobRun("SendMail") command.

: Any other suggestions?

: Please try creating Oracle 7.3 profile (for connnecting to your Oracle 8.1.6
: database)

I can't connect with a 7.3 profile (Ora-01017 - invalid user profile) because the database was created as an 8i database.

I did try connecting to the same database through an ODBC connection rather than the Oracle connection and was able to run the same job several times. This will work as a temporary fix, but can you please check into the Oracle 8.0.4 - 8i connection and modify it to work correctly?

From what I know this is caused by a bug in the Oracle OCI (Oracle Call Interface) which is a part of the Oracle client. On disconnect, some versions of the OCI don't releases all allocated system resources and the next connect may lead to a crash. If you are interested, I can find out Oracle assigned bug number.

You should be able to use the Oracle 7.3 driver as long as you correctly specify the Connect String. The format of the string is different in different Oracle versions. Your Oracle client version and the selected driver don't have to match your server version. Ora-01017 is likely a result of the incorrect Connect string.

: I can't connect with a 7.3 profile (Ora-01017 - invalid user profile) because
: the database was created as an 8i database.

: I did try connecting to the same database through an ODBC connection rather
: than the Oracle connection and was able to run the same job several times.
: This will work as a temporary fix, but can you please check into the
: Oracle 8.0.4 - 8i connection and modify it to work correctly?