Getting PLS-00801 on compiling invalid objects which are invalid after applied patch

After you applied a few OE patches,you have invalid objects like OE%.After you run utlrp.sql,these object aren't gone.When you want one of these objects manually you get PLS-00801 error.

But these invalid objects can effect this module.

Problem:

Getting PLS-00801 on compiling invalid objects which are invalid after applied patch

We applied patch 10338643,this patch solved problem,but it generate 5 invalid in apps schema.



Invalid objects:

OE_ORDER_GRP
OE_OE_FORM_LOT_SERIAL
OE_DEFAULT_LOT_SERIAL
OE_DEFAULT_LINE_PATTR
OE_OE_FORM_HEADER_PAYMENT

Error Codes
---------------------------------------------------
PLS-00801

Solution:

1) start database in UPGRADE mode
(using STARTUP UPGRADE or ALTER DATABASE OPEN UPGRADE)

2) Run script $ORACLE_HOME/rdbms/admin/utlirp.sql
You must be connected AS SYSDBA to run this script.

3) Shut down the database and restart in normal mode

4) Run script $ORACLE_HOME/rdbms/admin/utlrp.sql
You must be connected AS SYSDBA to run this script.
There should be no other DDL on the database while running the script.


Note:It is very important and took 4 hours on my database which have 315000 objects

sh: adchkutl.sh: command not found

Problem:

sh: adchkutl.sh: command not found
i got this error while cloning
I ran
perl adcfgclone.pl dbTier
I got this error

Solution:


Add the directory with the PERL executable to the path (added . to the path, so that #2 will not occur).
Instead of:
perl adcfgclone.pl dbTier

Use:

perl ./adcfgclone.pl dbTier


Note:./filename - You are referring to filename in current directory

Done relinking module XDPCTRLS in product xdp

Problem:

When applying patch

adrelink is exiting with status 1

Done relinking module XDPCTRLS in product xdp
Done with link of product 'xdp' on Fri Oct 25 22:42:07 EEST 2013


Solution:

Relink

adadmin----------->2------------->1

relink xdp manually

ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt

PROBLEM:

In GATHER_SCHEMA_STATS , schema_name= ALL percent= 10 degree = 8 internal_flag= NOBACKUP
stats on table FND_CP_GSM_IPC_AQTBL is locked
stats on table FND_SOA_JMS_IN is locked
stats on table FND_SOA_JMS_OUT is locked
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=GL.JE_BE_LINE_TYPE_MAP***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
Error #2: ERROR: While GATHER_TABLE_STATS:
object_name=GL.JE_BE_LOGS***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
Error #3: ERROR: While GATHER_TABLE_STATS:
object_name=GL.JE_BE_VAT_REP_RULES***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***


SOLUTION:

Run this query,you will see the locked table.


SQL> select owner, table_name, stattype_locked
from dba_tab_statistics
where stattype_locked is not null
and owner not in ('SYS');

OWNER TABLE_NAME STATTYPE_LOCKED
-----   ----------       ---------------
SYSTEM DEF$_AQCALL ALL
SYSTEM DEF$_AQERROR ALL
ODM DMS_QUEUE_TABLE ALL
SYSTEM TBLMIG_MSG_QTAB ALL
APPLSYS FND_SOA_JMS_IN ALL
APPLSYS FND_SOA_JMS_OUT ALL
APPLSYS FND_CP_GSM_IPC_AQTBL ALL

Then run dbms_stats.unlock_schema_stats api to unlock this table.


SQL > exec dbms_stats.unlock_schema_stats('APPLSYS');

Pray & Tray :)

Error connecting to Database Concurrent error(EBS)

Problem:

When we look the output of this request,see the below:

Error connecting to database necoklon

Solution:

If you try to login as sysdba in sqlplus(sqlplus / as sysdba) you get max processor error,so you can’t login

Max process,you have to kill some LOCAL=NOJ

mscmatlab.sh INSTALL_SETUP

Problem:

RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyApplTop
ERROR: AutoConfig completed with errors. Check logfile at /appdata/cloneap2/data
_appl/inst/apps/necoklon_testnecoapp/admin/log/ApplyAppsTier_09262304.log for de
tails.
ApplyApplTop Completed Successfully.

# Checking the status of AutoConfig run of ApplyApplTop
Warning : AutoConfig has completed with  errors .



 mscmatlab.sh            INSTALL_SETUP      127

Solution:

add unzip PATH in your PATH

like this:

bash-4.2$ which unzip
/appdata/data_appl/apps/tech_st/10.1.2/bin/unzip

RC-50004: Fatal: Error occurred in ApplyDatabase

Problem:

When you running adcfgclone.pl you may get this error.

CREATE CONTROLFILE REUSE SET DATABASE "necoklon"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/dbdata/clonedb2/archive/a_txn_ind08.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


    Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------

RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase


APPS Password : Log file located at /dbdata/clonedb2/db/appsutil/log/necoklon_tes                                                                                        tburladb/ApplyDBTier_09250234.log
  \     50% completed       RC-50004: Fatal: Error occurred in ApplyDatabase:
Control file creation failed

ERROR while running Apply...
Wed Sep 25 02:37:33 2013

 ERROR: Failed to execute /dbdata/clonedb2/db/appsutil/clone/bin/adclone.pl

 Please check logfile.

Solution:

Check your hosts.You have double IP

Please take a "snapshot" of this APPL-TOP using "AD Administration" first

Problem:

When running adpatch with "prereq" flag, we might get an error message like:
Analyzing prerequisite patch information...
AutoPatch error: This patch has some prerequisites specified, but a "snapshot" of this APPL-TOP's file-system has never been taken, thereby rendering it impossible to check for the prerequisites.
Please take a "snapshot" of this APPL-TOP using "AD Administration" first.

This error message will show up if a snapshot on current APPL_TOP doesn't exists.


Solution:

To create such snapshot on APPL_TOP:

1) run adadmin
2) Select "Maintain Applications Files menu"
3) Select "Update current view snapshot"
4) Rerun adpatch

File server could not verify its initialization parameters

Problem:

file-server-could-not-verify-its-initialization-parameters


Solution:


1. Apply Patch 4244610.

2. View request and output.


Temporary workaround:

1. Modify the 8.0.6 listener.ora file and remove the spaces in between them for the
APPLFSTT parameter.

Example:

Change

APPLFSTT=WFTST_806_BALANCE; WFTST; WFTST_FO; WFTST_BALANCE

to

APPLFSTT=WFTST_806_BALANCE;WFTST;WFTST_FO;WFTST_BALANCE



2. Restart the apps listener.
lsnrctl stop apps_listener
lsnrctl start apps_listener

Note: Make a copy of the listener.ora file before editing.  If you don't apply the patch this issue won't solved permanenly.