Home » RDBMS Server » Server Utilities » error ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors (11g)
error ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors [message #576029] Wed, 30 January 2013 20:56 Go to next message
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 Go to previous messageGo to next message
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/
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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;
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Connect as SYSDBA.

Regards
Michel
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 Go to previous messageGo to next message
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.
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 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your DBA to do it.

Regards
Michel
Previous Topic: Unable to import ( impdp )
Next Topic: System crashed
Goto Forum:
  


Current Time: Thu Mar 28 13:49:47 CDT 2024