How to drop and recreate a Corrupt Index

1. Verify the error.

2. Try to rebuild the index as below.

alter index <index name> rebuild;

If the still the issue exists.

3. Query for the Index script from dbms_metadata.get_ddl as below.

select dbms_metadata.get_ddl('INDEX','<INDEX_NAME>','OWNER') from dual;

DBMS_METADATA.GET_DDL('INDEX','PO_VENDORS_F1','PO')

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

  CREATE INDEX "OWNER"."<INDEX_NAME>" ON "OWNER"."<INDEX_NAME>" (NVL("END_DATE_ACTI

VE",TO_DATE(' 9999-12-31 00:00:00', 'syyyy-mm-dd hh24:mi:ss')))

  PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS

  STORAGE(INITIAL 16384 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645

  PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4

  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

  TABLESPACE "APPS_TS_TX_IDX"

4. Use the above script to recreate the index.

Script to find the Usage of the Responisibilities and the Porduct License details in Oracle Apps R12 or 11i

Script to check the last login to the Reponsibilities by the users
==============================================

select max(flr.start_time), flr.responsibility_id ,fu.user_name, 
flt.responsibility_name 
from fnd_logins fl, fnd_login_Responsibilities flr, fnd_user fu , 
fnd_responsibility_tl flt 
where flr.login_id = fl.login_id 
and flt.responsibility_id = flr.responsibility_id 
and fu.user_id = fl.user_id 
group by fl.user_id, flr.RESPONSIBILITY_ID ,fu.user_name, 
flt.responsibility_name 
order by fl.user_id

Script to check the Products Installed and Shared in Oracle Apps
================================================

select a.application_short_name,a.APPLICATION_NAME,decode(fpi.status,'I', 'INSTALLED','S', 'SHARED','N', 'Inactive', 'N/A') status from apps.fnd_application_vl a, apps.fnd_product_installations fpi where fpi.application_id = a.application_id and fpi.status in ('I','S') order by 3,1;

SELECT a.application_name,DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status,patch_level FROM apps.fnd_application_vl a, apps.fnd_product_installations b WHERE a.application_id = b.application_id and PATCH_LEVEL like '%&1%';

Script to Delete Applied archive logs on the Physical Standby Database

###################### START ########################

#!/bin/bash
drhost=`GFCDROBIEEDB1`
tstamp=`date +"%c"`
email="ravi@ecsme.ae"
myLog="/home/oracle/rmanDelStandbyArclogs.log"

if [ "$1" == "" ]; then
    echo "Error: Improper arguments"
    echo ""
    echo "Correct format"
    echo "$0 ORACLE_SID"
    exit -1
fi

export ORACLE_SID="$1"
export ORACLE_HOME="/swapphome/oracle/app/product/11.2.0/db_2"
export PATH="$ORACLE_HOME/bin:$PATH"

sequence=`sqlplus -s '/as sysdba' << EOF
set head off
set feed off
set echo off
select max(sequence#) from v\\\$archived_log where applied='YES' group by applied;

exit;
EOF`

 if [ `echo $sequence | grep ORA- | wc -l` -ge "1" ]; then
     echo "Error: [$sequence]"
     echo $sequence | mailx -s "[$tstamp] Error: Removing applied standby archived logs from standby database [$1] on host [$drhost]" $email
     exit -1
 fi

sequence=`echo "$sequence" |  tr -dc '[:alnum:]'`

rmanCmd="delete noprompt archivelog until sequence $sequence"

rmanDel=$(rman target / append log ${myLog} 2>&1 << END_OF_RMAN
$rmanCmd;
exit;
END_OF_RMAN
)

if [ `echo $rmanDel | grep RMAN- | wc -l` -ge "1" ]; then
     echo "Error: [$rmanDel]"
     echo $rmanDel | mailx -s "[$tstamp] Error: RMAN error while deleting applied archive logs from standby database [$1] on host [$drhost]" $email
     exit -1
 fi

exit 0
############################### END #############################

ORA-600[2619] During Physical Standby Recovery

Issue:
Managed Standby Recovery not using Real Time Apply
Parallel Media Recovery started with 4 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.

Media Recovery Log /swapphome/oracle/app/oradata/obieeproddb/archives/1_7011_876410455.dbf

Errors in file /swapphome/oracle/app/diag/rdbms/obieestbydb/obieestbydb/trace/obieestbydb_pr00_27961.trc:

ORA-00600: internal error code, arguments: [2619], [7011], [], [], [], [], [], [], [], [], [], []
Slave exiting with ORA-600 exception
Errors in file /swapphome/oracle/app/diag/rdbms/obieestbydb/obieestbydb/trace/obieestbydb_pr00_27961.trc:
ORA-00600: internal error code, arguments: [2619], [7011], [], [], [], [], [], [], [], [], [], []
Sun Aug 09 17:11:31 2015
Dumping diagnostic data in directory=[cdmp_20150809171131], requested by (instance=1, osid=27961 (PR00)), summary=[incident=6283].
Errors in file /swapphome/oracle/app/diag/rdbms/obieestbydb/obieestbydb/trace/obieestbydb_mrp0_27959.trc  (incident=6274):
ORA-00600: internal error code, arguments: [2619], [7011], [], [], [], [], [], [], [], [], [], []
ORA-10877: error signaled in parallel recovery slave
ORA-10877: error signaled in parallel recovery slave
ORA-10877: error signaled in parallel recovery slave
ORA-10877: error signaled in parallel recovery slave

Cause while applying the above log the mount point got 100% occupied no space left in the mount point.

RFS[11]: Opened log for thread 1 sequence 7009 dbid 912770197 branch 876410455

Non critical error ORA-48181 caught while writing to trace file "/swapphome/oracle/app/diag/rdbms/obieestbydb/obieestbydb/trace/obieestbydb_rfs_32359.trc"

Error message: Linux-x86_64 Error: 28: No space left on device

Additional information: 1

Writing to the above trace file is disabled for now on...

RFS[10]: Possible network disconnect with primary database

RFS[11]: Possible network disconnect with primary database

Solution:

1. Clear the disk space where archive log stored on standby site

2. Copy the problem archive log (eg: 1_7011_876410455.dbf) from the primary site and replace the one on the standby, then restart Managed Recovery.

Archive log should be applied properly now.

DBCA fails with ORA-27102

Issue: ORA-27102 Out of Memory messages 

Below errors found in the trace files. 

Fatal Error: ORA-01092 
Fatal Error: ORA-01034 
Fatal Error: ORA-03114 
Fatal Error: ORA-12560 

ORA-27102 Out of Memory messages 

After installing the 11.2.0.1 software binaries, dbca was throwing the ORA-27102.

Resources:

RAM - 128:
AMM - enabled

Observation: 

1. Installations of 11.2.0.1 binaries was successful on windows 2008 64bit.

2. While running the DBCA it hangs at 2% and then we see in the task manager the process which is running dbca consumes 100% memory and once it reaches 100% we get the below error

3. The process hangs at the RMAN Clone process in the installation.

ORA-27102 Out of Memory messages 

Cause: This is due to the bug in 11.2.0.1 version.


Solution:

1. Deinstall the 11.2.0.1 software binaries.

2. Install the 11.2.0.4 binaries.

3. Rerun the DBCA it should complete successfully.

EBS R12 Migration from Linux 32 bit OS to 64 bit

Below are the Metalink documents to refer for Migration.

Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit [ID 471566.1]
Adconfig.Sh appsTier error: afcpnode.sh INSTE8_SETUP 1 [ID 1271670.1]
What Are The Requirements For E-Business Suite When Upgrading Operating Systems? [ID 1061303.1]
R12: "error while loadingSHARED libraries: libc.so.6" Error When Migrating From Linux 32bit To Linux 64bit [ID 1473917.1]

Working on detailed steps.................

CVU report PRVG-1533 while upgrade from 11.2.0.3 to 11.2.0.4

Issue:

While running runcluvfy (from 11.2.0.4 Binary location) to check upgrade readiness from 11.2.0.2 to 11.2.0.4, gives below PRVG-1533 error

runcluvfy.sh stage -pre crsinst -upgrade -n racnode1,racnode2,racnode3 -rolling -src_crshome /oragrid/product/11.2.0.3 -dest_crshome /oragrid/product/11.2.0.4/gi_1 -dest_version 11.2.0.4.0 -fixup -fixupdir /tmp -verbose

ERROR:
PRVG-1533 : The IPMP interfaces "bxge0,nxge0" classified as public network do not belong to the subnet "10.20.31.1" on node "racnode1"

Cause:

This was due to bug Bug 17333157

Solution:

Verify If IPMP group configuration shows consistent when runcluvfy is executed from 11.2.0.3 GI home.

Then you can  ignore the error and proceed with upgrade.