Home » Server Options » Replication » Oracle Snapshot/ Job
Oracle Snapshot/ Job [message #62537] Tue, 27 July 2004 13:10 Go to next message
Henning
Messages: 6
Registered: October 2001
Junior Member
I have the following problem:

I work on a Oracle 8i database. I have created a snapshot. This repeats only 16 times and then it is marked as broken. I also tried to create a job, which repeats every hour. When I look into the USER_JOBS it counts the field FAILURES up to 16 and after that it marks the field BROKEN to 'Y'. I tried to chang the init.ora but nothing change.

I hope somebody can help me.

Best regards
Henning
Re: Oracle Snapshot/ Job [message #62538 is a reply to message #62537] Tue, 27 July 2004 14:19 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Look at the trace files in .../bdump they'll show the errors.

select value from v$parameter where name = 'background_dump_dest';
Re: Oracle Snapshot/ Job [message #62592 is a reply to message #62538] Mon, 02 August 2004 04:00 Go to previous message
Henning
Messages: 6
Registered: October 2001
Junior Member
But when I look at the trace file I found a little bit stupid message:

Mon Aug 1 12:03:08 2004
Errors in file D:oracleadminorawsp8bdumporawsp8.NSP0.TRC:
ORA-12012: error on auto execute of job 121
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 3

Mon Aug 1 12:05:10 2004
Errors in file D:oracleadminorawsp8bdumporawsp8.NSP0.TRC:
ORA-12012: error on auto execute of job 121
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 3

Mon Aug 1 12:07:12 2004
Errors in file D:oracleadminorawsp8bdumporawsp8.NSP0.TRC:
ORA-12012: error on auto execute of job 121
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 3

Mon Aug 1 12:09:14 2004
Errors in file D:oracleadminorawsp8bdumporawsp8.NSP0.TRC:
ORA-12012: error on auto execute of job 121
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 3

... and so on and so on

But it is a simple query which returns ony one row!

Henning
Previous Topic: why I use sqlplus internal, but the system ask me the passwd?
Next Topic: ORA-12008: error in materialized view refresh path
Goto Forum:
  


Current Time: Thu Mar 28 09:15:43 CDT 2024