adcfgclone.pl failed while running autoconfig with the error "ORA-04063: package body "APPS.AD_ZD_ADOP" has errors"

This document describes about the error while running autoconfig as part of adcfgclone.pl

Autoconfig failed with below error while running autoconfig as part of adcfgclone.

Error details:

[APPLY PHASE]

  AutoConfig could not successfully execute the following scripts:

    Directory: /u01/oracle/ERPGOLD/fs1/FMW_Home/webtier/perl/bin/perl -I /u01/oracle/ERPGOLD/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I /u01/oracle/ERPGOLD/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /u01/oracle/ERPGOLD/fs1/EBSapps/appl/au/12.0.0/perl -I /u01/oracle/ERPGOLD/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/oracle/ERPGOLD/fs1/inst/apps/ERPGOLD_erpgoldapp/admin/install

      txkGenADOPWrapper.pl    INSTE8_APPLY      

Found below error in autoconfig log file and package body "APPS.AD_ZD_ADOP" is invalid.

SQL> SELECT ad_zd_adop.get_node_type('erpgoldapp') FROM DUAL

ERROR at line 1:

ORA-04063: package body "APPS.AD_ZD_ADOP" has errors

Solution:

SQL> alter package apps.AD_ZD_ADOP compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY APPS.AD_ZD_ADOP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2682/3   PL/SQL: Statement ignored
2682/7   PLS-00201: id

SQL> grant execute on DBMS_METADATA_UTIL to apps;

Grant succeeded.

SQL> alter package apps.AD_ZD_ADOP compile body;

Package body altered.

SQL>

Reran the autoconfig. It should complete.

Thanks for going through the post.

How to find unusable indexes in oracle database and how to rebuild the unusable indexes

This document describes how to find unusable indexes in oracle database and how to rebuild unusable indexes to make it use.

In some scenarios we get unusable indexes in the database. We have to find which indexes are unusable and we have to rebuild them to make it use.

Use below command to find unusable indexes in the database.

col owner for a15
col index_name for a35
col table_name for a40 
select owner,index_name,status,table_name from dba_indexes where status='UNUSABLE';

Use below command to rebuild indexes.

alter index <owner>.<index name> rebuild online;

SQL> alter index XXEMPLOYEES_EMPNO_T1 rebuild online;

Thanks for going through the post......................

How to kill all unix processes (PIDs) with single command in Linux

This document describes how to kill all unix processes related to one user with single command.

Some times we have to kill all the processes related to one unix user. It is a time consuming process if  we find the PID of each process to kill it. Instead of each unix process to kill, we can kill all the unix processes of a particular user with single command. It saves our time.

Please use below command to find PIDs and kill the processes.

ps auxww | grep applprod | awk '{print $2}' | xargs kill

Thanks for going through the post......................

How to find pending concurrent requests in 11i/R12

This document describes how to find total pending concurrent requests in the system. 

Some times our concurrent requests queue fill up. We find lot of requests in pending status. In that scenarios we need to find the total number of pending requests. 

Please use below query to find pending concurrent requests details.

SELECT  DECODE(phase_Code,'P','Pending','R','Running')
                 phase
        , meaning status
        , count(*) numreqs
  FROM apps.fnd_concurrent_requests, apps.fnd_lookups
 WHERE LOOKUP_TYPE = 'CP_STATUS_CODE' AND lookup_code = status_code AND phase_code in ( 'P','R') and status_code!='D'
and requested_Start_Date < sysdate
group by   DECODE(phase_Code,'P','Pending','R','Running') , meaning
/

Thanks for going through the post.................

Top 10 space consuming files in Linux

 

This document describes how to find top 10 space consuming files in Linux. 

Some times we have to purge files to cleanup file system in the server.  We can utilize below command to find top 10 space consuming files in a given directory. We can purge the files if the files are older and are not required.

Top 10 space consuming files in linux server.

$ du -a * | sort -n -r | head -n 10

Thanks for going through the post.....................

How to prepare script to compile all invalid objects in oracle database

This document describes how to prepare script to compile all invalid objects in the database.

Some times we may get hundreds of invalid objects in the database. We need to compile to fix those objects. We can manually compile one by one if the invalid objects are less. But incase if we have hundreds of invalids, we have to prepare a script and compile all invalids by executing the prepared script.

Use below steps to prepare script of all invalid objects and compile.

Step 1:

connect to database as sysdba and execute below query. 

SQL>col owner  for a15
SQL>col object_name for a35
SQL>col object_type for a25
SQL>col status for a15

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

SQL>spool compile_invalids.sql
SQL>select 'alter '||object_type|| ' ' || owner ||'.'||object_name || ' compile;' from dba_objects where status='INVALID';

SQL>spool off;

Step 2:

execute above prepared script as sysdba to compile all invalid objects.

SQL>compile_invalids.log
SQL>@compile_invalids.sql
SQL>spool off;

Verify compile_invalids.log file if any errors occurred and check the invalid objects count in the database.

Thanks for going through the post......

Query to find the session details of running concurrent request using request ID

 

Use below query to find the session details of running concurrent request using concurrent request ID.

SELECT a.request_id, d.sid, d.serial# , c.SPID
 FROM apps.fnd_concurrent_requests a,
 apps.fnd_concurrent_processes b,
 gv$process c,
 gv$session d
 WHERE a.controlling_manager = b.concurrent_process_id
 AND c.pid = b.oracle_process_id
 AND b.session_id=d.audsid
 AND a.request_id = &Request_ID
 AND a.phase_code = 'R';

Pass the concurrent request ID when it prompts.

Thanks for going through the post................