Sujeet APPS DBA: February 2023

[applmgr@oracle ~]$ sqlplus apps/*****@DB

SQL > alter package AD_ZD_PREP compile body;

Warning: Package Body altered with compilation errors.

SQL> show error;

Errors for PACKAGE BODY AD_ZD_PREP:

LINE/COL ERROR

-------- -----------------------------------------------------------------

467/3 PL/SQL: SQL Statement ignored

467/19 PL/SQL: ORA-00942: table or view does not exist

471/5 PL/SQL: SQL Statement ignored

471/21 PL/SQL: ORA-00942: table or view does not exist

491/5 PL/SQL: Statement ignored

491/5 PLS-00201: identifier 'SYS.XDB_MIGRATESCHEMA' must be declared

505/5 PL/SQL: SQL Statement ignored

505/21 PL/SQL: ORA-00942: table or view does not exist

Solution:

SQL> select owner, object_name from dba_objects where lower(object_name) ='xdb_migrateschema';

no row select

# oracle@ora admin]$ sqlplus / as sysdba

SQL> grant READ on DIRECTORY FND_DIAG_DIR to APPS;

SQL> grant WRITE on DIRECTORY FND_DIAG_DIR to APPS;

SQL>@$ORACLE_HOME/rdbms/admin/dbmsxdbschmig.sql

SQL>@$ORACLE_HOME/rdbms/admin/prvtxdbschmig.plb

SQL> select owner, object_name from dba_objects where lower(object_name) ='xdb_migrateschema';

OWNER OBJECT_NAME

SYS XDB_MIGRATESCHEMA

2 rows selected.

# cd /u01/db/tech_st/12.1.0.2/appsutil/admin

adgrants.sql version > 120.67.12020000.69 2020/03/20 00:56:38

# sqlplus /nolog

# @/adgrants.sql apps

[applmgr@oracle ~]$ sqlplus apps/*****@DB

SQL> alter package AD_ZD_PREP compile body;

Package body altered.

SQL > select owner,object_name,object_type from dba_objects where status='INVALID' and object_name like 'AD_ZD%';

SQL > select object_type,status from dba_objects where object_name='AD_ZD_PREP';