I have using 24x7 2.3.7 on a NT server to run all the replication process from AS400 to oracle 8.0.5.2.0 often i use the oracle 7.3 driver and in others the oracle 8.0 driver, it happend that in the nigth some process start but in oracle aren't running in that way they "never end" really they are not running. what can i do, i need that the process run in the nigth.

i want to make a correction , the other driver is not oracle 8.0 IS ORACLE 8.0.4 - 8i.

Thanks

Can you clarify what you can call a "process".

Does the 24x7 job starts?

Does it succeed in making the connection?

Can you see a corresponding Oracle process in Oracle? If you don't have good tools for monitoring Oracle, you may want to try our DB Tools http://www.softtreetech/monitor/ package.

If you see the Oracle process in the Oracle monitor, check whether that process is locked by some other processes.

Do you have a 24x7x365 operational database or it is restarted every night?

If the job starts and makes the connection, enable "Database Tracing" in the 24x7 Scheduler options. Then you can check which particular operation is hanging the job.

: I have using 24x7 2.3.7 on a NT server to run all the replication process
: from AS400 to oracle 8.0.5.2.0 often i use the oracle 7.3 driver and in
: others the oracle 8.0 driver, it happend that in the nigth some process
: start but in oracle aren't running in that way they "never end"
: really they are not running. what can i do, i need that the process run in
: the nigth.

with process i mean , jobs that make the conection to the database(JAL,SQL) and execute the oracle store procedures.

the 24x7 log says that the jobs are started

I already have a good oracle process monitor and i can't see them running (in fact are not running)

I have 24x7x365 operational database. I think so.

i haven't enabled the database tracing( i will try with it)

but while, do you have an idea that what is happened.

1. Check database locks
2. Check the trace file to find out where the process stops, and maybe some additional error messages.

: with process i mean , jobs that make the conection to the database(JAL,SQL)
: and execute the oracle store procedures.

: the 24x7 log says that the jobs are started

: I already have a good oracle process monitor and i can't see them running (in
: fact are not running)

: I have 24x7x365 operational database. I think so.

: i haven't enabled the database tracing( i will try with it)

: but while, do you have an idea that what is happened.

I enabled the database trace, but every time that run a job appear a window advising that the database trace is enabled and i must to clic on ok to continue.

I want to keep running the database trace all the nigth to collect the logs. but whitout the alert window

Sorry, the message is not removable.

: I enabled the database trace, but every time that run a job appear a window
: advising that the database trace is enabled and i must to clic on ok to
: continue.

: I want to keep running the database trace all the nigth to collect the logs.
: but whitout the alert window

What can i do now!!!?

If the process runs fine during day time but stops at night, there is something different in your database at night. Use your monitoring tool to record database activity overnight, especially check database locks.

Try to run your procedure at night by scheduling SQL*Plus with a script and connection parameters specified in the command line.

: What can i do now!!!?