OraFAQ Forum: Server Utilities » error ORA-04063: package body "SYS.DBMS_INTERNAL

Home » RDBMS Server » Server Utilities » error ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors (11g)

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

error ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors [message #576029]

Wed, 30 January 2013 20:56

mkumar.p
Messages: 4
Registered: January 2013
Location: india

Junior Member

Hi Friends,

I am getting the below error when i am trying to import the dmp file into my oracle 11g.

impdp system/password@orcl dumpfile=aaa.dmp directory=datapump remap_schema=dev:user

ORA-31626: job does not exist
ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_INTERNAL_
LOGSTDBY"
ORA-06512: at "SYS.KUPV$FT", line 949
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"

[Updated on: Wed, 30 January 2013 21:01]

Report message to a moderator

Re: error ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors [message #576030 is a reply to message #576029]

Wed, 30 January 2013 21:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://navaneethdba.blogspot.com/2009/07/ora-04063-package-body.html

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: error ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors [message #576129 is a reply to message #576030]

Thu, 31 January 2013 18:26

mkumar.p
Messages: 4
Registered: January 2013
Location: india

Junior Member

Hi BlackSwan,

thanks for replying.

I seen your guidelines and solutions.
But for me there is no other same db version.... so i could not run the scripts of the missing table.
Please let me know how to resolve
Regards
MK

Report message to a moderator

Re: error ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors [message #576130 is a reply to message #576129]

Thu, 31 January 2013 18:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

issue SQL below & post results back here

ALTER PROCEDURE SYS.DBMS_INTERNAL_LOGSTDBY COMPILE;
ALTER PROCEDURE SYS.DBMS_LOGREP_UTIL COMPILE;

Report message to a moderator

Re: error ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors [message #576131 is a reply to message #576130]

Thu, 31 January 2013 19:25

mkumar.p
Messages: 4
Registered: January 2013
Location: india

Junior Member

Hi BlackSwan,

thanks for quick reply...
i getting the below error

SQL> ALTER PROCEDURE SYS.DBMS_INTERNAL_LOGSTDBY COMPILE;
ALTER PROCEDURE SYS.DBMS_INTERNAL_LOGSTDBY COMPILE
*
ERROR at line 1:
ORA-01031: insufficient privileges

SQL> ALTER PROCEDURE SYS.DBMS_LOGREP_UTIL COMPILE;
ALTER PROCEDURE SYS.DBMS_LOGREP_UTIL COMPILE
*
ERROR at line 1:
ORA-01031: insufficient privileges

Regards
MK

Report message to a moderator

Re: error ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors [message #576152 is a reply to message #576131]

Fri, 01 February 2013 00:54

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

Senior Member
Account Moderator

Connect as SYSDBA.

Regards
Michel

Report message to a moderator

Re: error ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors [message #576197 is a reply to message #576152]

Fri, 01 February 2013 05:08

mkumar.p
Messages: 4
Registered: January 2013
Location: india

Junior Member

Hi Michel,

I tried to connect with user SYSDBA...
I could able to connect to this above user due to bad credentials
Really I dont know what is the password for this user.

Report message to a moderator

Re: error ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors [message #576214 is a reply to message #576197]

Fri, 01 February 2013 07:45

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

Senior Member
Account Moderator

Ask your DBA to do it.

Regards
Michel

Report message to a moderator

Previous Topic:	Unable to import ( impdp )
Next Topic:	System crashed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 00:44:51 CST 2025