Home » Server Options » Replication » Job Failing Several Times (merged) (Oracle 10g)
Job Failing Several Times (merged) [message #490590] Tue, 25 January 2011 23:05 Go to next message
oraQ
Messages: 57
Registered: January 2011
Member
In TOAD,I see one of my jobs is failing several times. However, I could refresh it manually.I found the following error. Can anybody guide me regarding the cause of error and the way to rectify this.

ORA-23404: refresh group "ORA-23404: refresh group "schema_name"."job_name" does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REFRESH", line 23
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
"."" does not exist.

Thanks in advance.

[Updated on: Tue, 25 January 2011 23:06]

Report message to a moderator

Refresh Group For The Job [message #490804 is a reply to message #490590] Thu, 27 January 2011 07:46 Go to previous messageGo to next message
oraQ
Messages: 57
Registered: January 2011
Member
I found the following error as one of my jobs failed. I am seeing this problem for the past few days but still now unable to trace out the cause.What is that 'refresh group' and how can it be created if the same is linked to a job? Can anyone guide me in this regard?

Thanks in advance.

ORA-23404: refresh group "ORA-23404: refresh group "schema_name"."job_name" does not exist.
ORA-06512: at "SYS.DBMS_SYS_ERROR".

Re: Refresh Group For The Job [message #492372 is a reply to message #490804] Sun, 30 January 2011 09:15 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Are you sure refresh group exist?

- Babu

ORA-23404:refresh group "string"."string" does not exist
Cause:	 A refresh group name was given that is not in sys.rgroup$.
Action:	 Provide a refresh group name that is in sys.rgroup$ or dbs_rgroup.
Re: Job Failing Several Times [message #492512 is a reply to message #490590] Mon, 31 January 2011 18:24 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
From what I recall, all of these errors will be in alert.log. Have you looked there for a full picture?
Re: Job Failing Several Times [message #492533 is a reply to message #492512] Tue, 01 February 2011 01:06 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is useless to repeat the same question in another forum.
It just creates work for moderators that will move your topic and merge it with the previous one.
You don't get more answer (it is even the opposite).

On the other hand, you could feedback to answers we give you as in your topic that is still pending: http://www.orafaq.com/forum/m/490434/102589/#msg_490434

Regards
Michel

[Updated on: Tue, 01 February 2011 01:10]

Report message to a moderator

Previous Topic: Golden Gate: Tuning
Next Topic: Data Transfer From Oracle 10 g to Oracle 9i
Goto Forum:
  


Current Time: Thu Mar 28 12:58:02 CDT 2024