OraFAQ Forum: Server Utilities » how to execute the CATPROC.SQL

Home » RDBMS Server » Server Utilities » how to execute the CATPROC.SQL

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

how to execute the CATPROC.SQL [message #614949]

Thu, 29 May 2014 01:29

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi,

I needed to execute the CATPROC.SQL
SQL >@ $ORACLE_HOME/rdbms/admin/CATPROC.SQL

Thanks

Report message to a moderator

Re: how to execute the CATPROC.SQL [message #614950 is a reply to message #614949]

Thu, 29 May 2014 01:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How to do it? The same way you run any other SQL script.

Report message to a moderator

Re: how to execute the CATPROC.SQL [message #614951 is a reply to message #614950]

Thu, 29 May 2014 01:44

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi Littlefoot,

We are getting the below error's while update my database with data from a dmp file.

I have to update my database with data from a dmp file, but when performing import the following error message appears:
UDI - 31626: OPERATION GENERATEX ORALCE ERROR 361626
ORA - 31626: job does not exist
ORA - 06512: AT "SYS.DBMS_SYS_ERROR", line 79
ORA - 06512: AT "SYS.DBMS_SYS_DATAPUMP", line 1137
ORA - 06512: AT "SYS.DBMS_SYS_DATAPUMP", line 3414
ORA - 06512: AT "SYS.DBMS_SYS_DATAPUMP", line 4593
ORA - 06512: AT line 1

Thanks

Report message to a moderator

Re: how to execute the CATPROC.SQL [message #614952 is a reply to message #614951]

Thu, 29 May 2014 01:53

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

Senior Member
Account Moderator

You can ignore that and manually recreate the jobs as per your needs.

Report message to a moderator

Re: how to execute the CATPROC.SQL [message #614953 is a reply to message #614951]

Thu, 29 May 2014 01:54

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

ORALCE?!?
Quote:

UDI - 31626: OPERATION GENERATEX ORALCE ERROR 361626

Are you sure that this is exact copy/paste?

What does your last message have to do with the original question? You asked "how to execute catproc.sql". So, did you finally do it or not?

Report message to a moderator

Re: how to execute the CATPROC.SQL [message #614954 is a reply to message #614952]

Thu, 29 May 2014 01:54

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Quote:

You can ignore that and manually recreate the jobs as per your needs.

Hi sir, i am new of this topics and could you please what are steps to required?

Thanks

Report message to a moderator

Re: how to execute the CATPROC.SQL [message #614955 is a reply to message #614952]

Thu, 29 May 2014 01:56

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

Senior Member
Account Moderator

Also what is the relation with this and the title?
And why is it in Unix forum?

Report message to a moderator

Re: how to execute the CATPROC.SQL [message #614956 is a reply to message #614953]

Thu, 29 May 2014 01:57

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Quote:

Are you sure that this is exact copy/paste?

not copy/paste ...just written
Quote:

What does your last message have to do with the original question? You asked "how to execute catproc.sql". So, did you finally do it or not?

No,not did..

Report message to a moderator

Re: how to execute the CATPROC.SQL [message #614957 is a reply to message #614954]

Thu, 29 May 2014 01:57

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

Senior Member
Account Moderator

Do you need the jobs?

Report message to a moderator

Re: how to execute the CATPROC.SQL [message #614958 is a reply to message #614954]

Thu, 29 May 2014 02:02

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

This topic is confused, because it is only half the story. I'll try to explain.
The story began here,
https://community.oracle.com/thread/3565459
It would seem that the problem is that a Data Pump job was not tidied up properly after completion. One way (a rather drastic way) to fix this is supposed to be running catproc.sql. mist598 tried to do that, but failed because he spelt CATPROC in upper case, which is the beginning of this topic.

I do not know of catproc will fix the issue, but it must be worth trying. So, mist598, you need to connect AS SYSDBA, and then

@$ORACLE_HOME/rdbms/admin/catproc

Report message to a moderator

Previous Topic:	Bug in Loading XmlType column with VARCHARC
Next Topic:	ORA-01653: unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 13:22:36 CST 2025