Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

while getting error to oracle database upgradation 11.2.3.0 to 11.2.4.0

User_1ITVNOct 21 2016 — edited Oct 26 2016

@$ORACLE_HOME/rdbms/admin/utlrp.sql;

DECLARE * ERROR at line 1: 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.UTL_RECOMP", line 863 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 line 4

Message was edited by: 2678512

Comments

Yunus-Oracle

Check to see if that object is invalid or not. if it is then reload logical standby package.

1. Change directory to $ORACLE_HOME/rdbms/admin

2. Login as SYS
    SQL> connect sys/sys_password as sysdba

3. Re-load the Logical Standby package
    SQL> @@prvtlsby.plb

1 - 1