OraFAQ Forum: Replication » Job Failing Several Times (merged)

Home » Server Options » Replication » Job Failing Several Times (merged) (Oracle 10g)

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

Job Failing Several Times (merged) [message #490590]

Tue, 25 January 2011 23:05

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

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".

Report message to a moderator

Re: Refresh Group For The Job [message #492372 is a reply to message #490804]

Sun, 30 January 2011 09:15

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.

Report message to a moderator

Re: Job Failing Several Times [message #492512 is a reply to message #490590]

Mon, 31 January 2011 18:24

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?

Report message to a moderator

Re: Job Failing Several Times [message #492533 is a reply to message #492512]

Tue, 01 February 2011 01:06

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 31 05:40:36 CDT 2025