Multiple FFP invalid objects after installing R12.1.3

We got 250+ invalid objects whose name started with FFP:

FFP55375_01011990 FFP50508_01011900 FFP50512_01011900 FFP52744_01071999 FFP50510_01011900 FFP52724_01071999 FFP55355_01011990 FFP55058_01011990 FFP60833_01012000 FFP60793_01012004 FFP60963_01012000 FFP60964_01012000 FFP60606_01011990 FFP60607_01011990

A quick search on My Oracle support revealed some articles with similar errors for 11i:

Applied Patch 9062727 (11i.Hr_pf.K.Delta.5) And Left With FFP<######> Invalid Packages [ID 1096417.1]

The above article pointed to this article:

How to compile fast formula from the server (via FFXBCP) (Doc ID 167689.1) and I executed this command:

$ FFXBCP apps/apps 0 Y %% %%

Log filename : L5826316.log

Report filename : O5826316.out

All the FFP invalids were resolved after executing the above command.

ORA-00904: "AD_PA_MISC"."GET_TOTAL_TIME": invalid identifier

I upgraded a freshly installed R12.1.1 Vision instance to 12.1.3 by applying patch 9239090. Howerver I got errors wherever adtimrpt.sql was executed after a patch similar to this:

sqlplus -s APPS/APPS @/jaer12/appl/ad/12.0.0/sql/adtimrpt.sql 550206 adt550206

The spooled file would give this error:

Product Information page

1

rpad(ad_pa_misc.get_total_time(inner.session_id,

*

ERROR at line 5:

ORA-00904: "AD_PA_MISC"."GET_TOTAL_TIME": invalid identifier

I checked the instance for availability of package AD_PA_MISC, and found that it was non existant.

So I checked what files created this package by

cd $AD_TOP/patch/115/sql

grep ad_pa_misc *

adpamisb.pls:REM | Body for ad_pa_misc package

adpamisb.pls:CREATE or REPLACE package body ad_pa_misc as

adpamisb.pls:END ad_pa_misc;

adpamiss.pls:REM | Specification for ad_pa_misc package

adpamiss.pls:CREATE OR REPLACE package ad_pa_misc as

adpamiss.pls:end ad_pa_misc;

So adpamiss.pls is the package specification and adpamisb.pls is the package body.

I connected as apps and executed adpamisb.pls and adpamiss.pls

This has created the missing ad_pa_misc package. I re-executed the failing sql again and it succeded this time:

sqlplus -s APPS/APPS @/jaer12/appl/ad/12.0.0/sql/adtimrpt.sql 550206 adt550206

Spooling to adt550206.lst

Spooling to adt550206.csv

List of all tables which are updated during ASCP Collections

I found this Article in My Oracle Support which has a list of all the tables which get populated during ASCP collections:Troubleshooting Missing Data Collection Entities [ID 558477.1]

How to start and stop telnet in Solaris 10

To check status of telnet

$ svcs telnet

STATE STIME FMRI

disabled Mar_18 svc:/network/telnet:default

To stop telnet

svcadm disable telnet

To start telnet

svcadm enable telnet

ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [1651], [1603]

Today Imdad pinged about this issue in Database:

ALTER DATABASE MOUNT

Wed Oct 27 09:22:13 2010

Setting recovery target incarnation to 2

Wed Oct 27 09:22:13 2010

Errors in file /jic1001/oracle/10.2.0/admin/jic1001_jic1001/bdump/jic1001_lgwr_28101.trc:

ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [1651], [1603], [0x000000000], [], [], [], []

Wed Oct 27 09:22:13 2010

Errors in file /jic1001/oracle/10.2.0/admin/jic1001_jic1001/bdump/jic1001_lgwr_28101.trc:

ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [1651], [1603], [0x000000000], [], [], [], []

Wed Oct 27 09:22:13 2010

LGWR: terminating instance due to error 470

Instance terminated by LGWR, pid = 28101

Solution was to recover the database by recreating controlfile.

ORA-39083: Object type ROLE_GRANT failed to create with error:

I got this error when I was trying to do a full import of a dump file.

$ impdp "'/ as sysdba'" full=y directory=data_pump_dir dumpfile=fullexport.dmp logfile=fullimport.log

Import: Release 11.2.0.1.0 - Production on Sat Aug 7 01:02:52 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": "/******** AS SYSDBA" full=y directory=data_pump_dir dumpfile=fullexport.dmp logfile=fullimport.log
Processing object type SCHEMA_EXPORT/ROLE_GRANT
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'QUALYS_ROLE' does not exist
Failing sql is:
GRANT "QUALYS_ROLE" TO "SYS" WITH ADMIN OPTION

Job "SYS"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 01:03:06


I checked the dump file and it was only 141 KB in size. Then I checked the export log file and realized that I had forgotten to put full=y while doing expdp. So it was just a schema export of SYS and did not have the full database.

Once I realized this and took an export with expdp full=y command, the import completed successfully.