Friday, March 21, 2008

RMAN incremental backup

RMAN> connect target *
run
{
allocate channel t1 type disk format
'/u01/OraApps/oracle/product/11.5.10.2/rman_backup/%d_%s_%t.bak';
allocate channel t2 type disk format
'/u01/OraApps/oracle/product/11.5.10.2/rman_backup/%d_%s_%t.bak';
allocate channel t3 type disk format
'/u01/OraApps/oracle/product/11.5.10.2/rman_backup/%d_%s_%t.bak';
backup incremental level 1 skip inaccessible
TAG='INCREMENTAL_LEVEL_1' database include current controlfile;
release channel t1;
release channel t2;
release channel t3;
allocate channel t1 type disk format
'/u01/OraApps/oracle/product/11.5.10.2/rman_backup/al_%d_%p_%u_%t';
sql 'alter system archive log current';
change archivelog all crosscheck;
backup skip inaccessible archivelog all delete input;
crosscheck backup;
delete obsolete;
delete expired backup;
delete expired archivelog all;
release channel t1;
}

Saturday, March 15, 2008

Script to Archive Automation

#!/usr/bin/ksh
# Functions
#A function to format the date

function formatDate {
date +%Y%m%d"."%H%M%S
}

#A function to generate a time stamp
function getTimestamp {
echo `formatDate` -- "${*}"
}

#A function to exit after an error condition
function exitError {
getTimestamp ${exitCodeArr[${1}]}

exit ${1}
}

#Function to set the environmental varriable from oratab.

function ToSetEnvVariables ()
{
if [ -f /etc/oratab ]; then
OraTab=/etc/oratab
elif [ -f /var/opt/oracle/oratab ]; then
OraTab=/var/opt/oracle/oratab
fi
unset ORACLE_HOME
OH=`cat /etc/oratab |grep -v "#"|grep -v "*."|grep "$1"|cut -d ":" -f2`
ORACLE_SID=$1;export ORACLE_SID
ORACLE_HOME=$OH;export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH:.;export PATH
}
#Function to backup the archive log file aftre reaching to threshold of archive log file system

function cleararchivelog ()
{
ToSetEnvVariables $1
$ORACLE_HOME/bin/rman target / cmdfile /u01/Scripts/backup_arch_rman.cmd msglog /u01/Scripts/backup_arch_rman.log
}
sqlplus -s "/as sysdba" < /dev/null
set feed off echo off head off trimspool on timing off set pagesize 1000 verify off
spool CheckarchDest.lst
select round(PERCENT_SPACE_USED) from v\$FLASH_RECOVERY_AREA_USAGE where FILE_TYPE='ARCHIVED LOG';
spool off
set feed on
eof
cat CheckarchDest.lst|grep -v "rows selected"|grep -v "SQL" |grep -v ^$ > check_percent_arch_full
while read line
do
Percent=`echo $line |awk '{print $1}'`
if [ ${Percent} -gt $2 ]; then
cleararchivelog $1
else
echo "Looks Okay"
fi
done < check_percent_arch_full

Thursday, March 6, 2008

ISSUE: 115102 upgrade Workflow Mailer Service

ISSUE:

After 115102 upgrade Workflow Mailer Service | Workflow Agent Listener Service | Workflow Document Web Services Service DO NOT STARTUP

Steps to reproduce:

1. configure WF mailer as per Note:268085.1
2. Activate WF Concurrent processing

Concurrent : Manager -> Administer
Workflow Agent Listener Service
Workflow Mailer Service
Workflow Document Web Services Service
Activate all of them


##
## Verify that workflow mailer and agent listener services running successfully
## without exceptions in the log files. [they are not]
##

dbtier.applmgr->ls -l $APPLCSF/$APPLLOG/FNDCPGSC*.txt
-rw-r--r-- 1 applmgr oaa 359 Mar 8 17:08 /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199414.txt
-rw-r--r-- 1 applmgr oaa 1270 Mar 8 17:08 /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199415.txt
-rw-r--r-- 1 applmgr oaa 1270 Mar 8 17:08 /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199416.txt
-rw-r--r-- 1 applmgr oaa 1270 Mar 8 17:08 /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199417.txt
-rw-r--r-- 1 applmgr oaa 1270 Mar 8 17:08 /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199418.txt
-rw-r--r-- 1 applmgr oaa 1270 Mar 8 17:08 /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199419.txt
-rw-r--r-- 1 applmgr oaa 1270 Mar 8 17:08 /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199420.txt
-rw-r--r-- 1 applmgr oaa 1270 Mar 8 17:09 /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199421.txt
-rw-r--r-- 1 applmgr oaa 1270 Mar 8 17:09 /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199422.txt
-rw-r--r-- 1 applmgr oaa 1270 Mar 8 17:11 /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199423.txt
-rw-r--r-- 1 applmgr oaa 1270 Mar 8 17:11 /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199424.txt
-rw-r--r-- 1 applmgr oaa 1270 Mar 8 17:13 /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199425.txt
-rw-r--r-- 1 applmgr oaa 1270 Mar 8 17:13 /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199426.txt
-rw-r--r-- 1 applmgr oaa 1270 Mar 8 17:15 /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199427.txt

##
## Here's the error that was reported in one of the log files
## after I Activated WF% cm queues
##
dbtier.applmgr->more /u02/app/applmgr/common_cm/log/BHUP_dbtier/FNDCPGSC199415.txt
LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.Logger.Logger(String, int) : Logging to System.out until necessary parameters are retrieved for Logger to be properly started.
LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer.initializeStateMachine() : BEGIN
LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.SvcComponentContainer.getNewWorkflowContext() : BEGIN
LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.SvcComponentContainer.getNewWorkflowContext() : BEGIN
Could not start Service Component Container because an unexpected RuntimeException or other Throwable occurred -> java.lang.No
ClassDefFoundError: oracle/apps/pass/profiles/Profiles
java.lang.NoClassDefFoundError: oracle/apps/pass/profiles/Profiles
at oracle.apps.fnd.profiles.ExtendedProfileStore.clear(Compiled Code)
at oracle.apps.fnd.security.SessionManager.setUser(Compiled Code)
at oracle.apps.fnd.security.SessionManager.setUser(Compiled Code)
at oracle.apps.fnd.wf.apps.ContextFactory.makeContext(Compiled Code)
at oracle.apps.fnd.wf.common.WorkflowContext.(Compiled Code)
at oracle.apps.fnd.cp.gsc.SvcComponentContainer.getNewWorkflowContext(Compiled Code)
at oracle.apps.fnd.cp.gsc.SvcComponentContainer.start(Compiled Code)
at oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer.main(Compiled Code)

dbtier.applmgr->echo $AF_CLASSPATH
/u02/app/applmgr/common/util/jre/1.1.8/lib/rt.jar:/u02/app/applmgr/common/util/jre/1.1.8/lib/i18n.jar:/u02/app/applmgr/common/java/appsborg.zip:/u02/app/applmgr/common/java/apps.zip:/u02/app/applmgr/product/8.0.6_115102/forms60/java:/u02/app/applmgr/common/java


dbtier.applmgr->grep jar $APPL_TOP/admin/adjborg2.txt
/u02/app/applmgr/product/iAS_115102/jlib/jssl-1_1.jar
/u02/app/applmgr/product/iAS_115102/jlib/javax-ssl-1_1.jar
/u02/app/applmgr/product/iAS_115102/rdbms/jlib/aqapi.jar
/u02/app/applmgr/product/iAS_115102/rdbms/jlib/jmscommon.jar
/u02/app/applmgr/product/iAS_115102/Apache/xsu/xsu12.jar
/u02/app/applmgr/product/iAS_115102/Apache/xsu/oraclexmlsql.jar
/u02/app/applmgr/product/iAS_115102/rdbms/jlib/xsu12.jar
/u02/app/applmgr/product/iAS_115102/lib/http_client.jar
/u02/app/applmgr/product/iAS_115102/dm/lib/odmapi.jar
/u02/app/applmgr/product/iAS_115102/soap/webapps/soap/WEB-INF/lib/soap.jar


dbtier.applmgr->unzip -l $JAVA_TOP/appsborg2.zip | grep -i jms | wc -l
128

dbtier.applmgr->grep jar $APPL_TOP/admin/adjborg.txt
/u02/app/applmgr/product/8.0.6_115102/owm/jlib/jssl-1_1.jar
/u02/app/applmgr/product/8.0.6_115102/owm/jlib/javax-ssl-1_1.jar
/u02/app/applmgr/product/iAS_115102/dm/lib/odmapi.jar
dbtier.applmgr->

## this setting is coming from:
$APPL_TOP/admin/adovars.env

AF_CLASSPATH="/u02/app/applmgr/common/util/jre/1.1.8/lib/rt.jar:/u02/app/applmgr/common/util/jre/1.1.8/lib/i18n.jar:/u02/app/applmgr/common/java/appsborg.zip:/u02/app/applmgr/common/java/apps.zip:/u02/app/applmgr/product/8.0.6_115102/forms60/java:/u02/app/applmgr/common/java"
export AF_CLASSPATH

show be:

Example of AF_CLASSPATH setting:
/local/java/jdk1.3.1/lib/dt.jar:/local/java/jdk1.3.1/lib/tools.jar:/slot05/appmgr/atgwfqacomn/java/appsborg2.zip:/slot05/appmgr/atgwfqaora/8.0.6/forms60/java:/slot05/appmgr/atgwfqacomn/java


dbtier.applmgr->grep classpath $APPL_TOP/admin/BHUP_dbtier.xml
# wrapper.classpath =
# wrapper.classpath =


/u02/app/applmgr/common/util/jre/1.1.8/lib/rt.jar:/u02/app/applmgr/common/util/jre/1.1.8/lib/i18n.jar:/u02/app/applmgr/common/util/jre/1.1.8/lib/tools.jar:/u02/app/applmgr/common/java/appsborg.zip:/u02/app/applmgr/common/java/apps.zip:/u02/app/applmgr/product/8.0.6_115102/forms60/java:/u02/app/applmgr/common/java
/u02/app/applmgr/common/util/jre/1.1.8/lib/rt.jar:/u02/app/applmgr/common/util/jre/1.1.8/lib/i18n.jar:/u02/app/applmgr/common/java/appsborg.zip:/u02/app/applmgr/common/java/apps.zip:/u02/app/applmgr/product/8.0.6_115102/forms60/java:/u02/app/applmgr/common/java

.:/u02/app/applmgr/common/java/jdbc111.zip:/u02/app/applmgr/common/java/xmlparserv2.zip:/u02/app/applmgr/common/java:/u02/app/applmgr/common/java/apps.zip:/u02/app/applmgr/common/util/jre/1.1.8/classes:/u02/app/applmgr/common/util/jre/1.1.8/lib:/u02/app/applmgr/common/util/jre/1.1.8/lib/classes.zip:/u02/app/applmgr/common/util/jre/1.1.8/lib/classes.jar:/u02/app/applmgr/common/util/jre/1.1.8/lib/rt.jar:/u02/app/applmgr/common/util/jre/1.1.8/lib/i18n.jar:/u02/app/applmgr/common/java/3rdparty/RFJavaInt.zip:
/u02/app/applmgr/common/util/jre/1.1.8/bin/jre -mx128m -classpath .:/u02/app/applmgr/common/java/jdbc111.zip:/u02/app/applmgr/common/java/xmlparserv2.zip:/u02/app/applmgr/common/java:/u02/app/applmgr/common/java/apps.zip:/u02/app/applmgr/common/util/jre/1.1.8/classes:/u02/app/applmgr/common/util/jre/1.1.8/lib:/u02/app/applmgr/common/util/jre/1.1.8/lib/classes.zip:/u02/app/applmgr/common/util/jre/1.1.8/lib/classes.jar:/u02/app/applmgr/common/util/jre/1.1.8/lib/rt.jar:/u02/app/applmgr/common/util/jre/1.1.8/lib/i18n.jar:/u02/app/applmgr/common/java/3rdparty/RFJavaInt.zip: -Dengine.LogPath=/u02/app/applmgr/common/admin/log/BHUP_dbtier -Dengine.TempDir=/u02/app/applmgr/common_cm/temp -Dengine.CommandPort=9300 -Dengine.AOLJ.config=/u02/app/applmgr/11.5/fnd/11.5.0/secure/dbtier_xupg.dbc -Dengine.ServerID=5000 -Ddebug=full -Dengine.LogLevel=9 -Dlog.ShowWarnings=false -Dengine.FaxEnabler=oracle.apps.jtf.fm.engine.rightfax.RfFaxEnablerImpl -Dengine.PrintEnabler=oracle.apps.jtf.fm.engine.rightfax.RfPrintEnablerImpl -Dfax.TempDir=/u02/app/applmgr/common/admin/log/BHUP_dbtier -Dprint.TempDir=/u02/app/applmgr/common/admin/log/BHUP_dbtier oracle.apps.jtf.fm.FulfillmentServer >> /u02/app/applmgr/common/admin/log/BHUP_dbtier/jtffmctl.txt

things that need to be changed:



SOLUTION
----------

##
## FIX AF_CLASSPATH
##

## EXISTING SETTING [WRONG] ##
dbtier.applmgr->grep s_adovar_afclasspath $APPL_TOP/admin/BHUP_dbtier.xml
/u02/app/applmgr/common/util/jre/1.1.8/lib/rt.jar:/u02/app/applmgr/common/util/jre/1.1.8/lib/i18n.jar:/u02/app/applmgr/common/java/appsborg.zip:/u02/app/applmgr/common/java/apps.zip:/u02/app/applmgr/product/8.0.6_115102/forms60/java:/u02/app/applmgr/common/java

## SHOULD BE ##
Example of AF_CLASSPATH setting:
/local/java/jdk1.3.1/lib/dt.jar:
/local/java/jdk1.3.1/lib/tools.jar:
/slot05/appmgr/atgwfqacomn/java/appsborg2.zip:
/slot05/appmgr/atgwfqaora/8.0.6/forms60/java:
/slot05/appmgr/atgwfqacomn/java

## OUR MAPPING BE ##
/usr/j2se/lib/dt.jar:
/usr/j2se/lib/tools.jar:
/u02/app/applmgr/common/java/appsborg2.zip:
/u02/app/applmgr/product/8.0.6_115102/forms60/java:
/u02/app/applmgr/common/java

## OUR MAPPING MT ##
/usr/j2se/lib/dt.jar:
/usr/j2se/lib/tools.jar:
/u01/app/applmgr/common/java/appsborg2.zip:
/u01/app/applmgr/product/8.0.6_115102/forms60/java:
/u01/app/applmgr/common/java


## FIXED SETTING ##
dbtier.applmgr->grep s_adovar_afclasspath $APPL_TOP/admin/BHUP_dbtier.xml
/usr/j2se/lib/dt.jar:/usr/j2se/lib/tools.jar:/u02/app/applmgr/common/java/appsborg2.zip:/u02/app/applmgr/product/8.0.6_115102/forms60/java:/u02/app/applmgr/common/java

midtier.applmgr->grep s_adovar_afclasspath $APPL_TOP/admin/BHUP_midtier.xml
/usr/j2se/lib/dt.jar:/usr/j2se/lib/tools.jar:/u01/app/applmgr/common/java/appsborg2.zip:/u01/app/applmgr/product/8.0.6_115102/forms60/java:/u01/app/applmgr/common/java


##
## FIX java exe definition
##

## EXISTING SETTING [WRONG] ##
dbtier.applmgr->grep -i AF_JRE_TOP $APPL_TOP/admin/BHUP_dbtier.xml
/u02/app/applmgr/common/util/jre/1.1.8

dbtier.applmgr->grep -i AFJVAPRG $APPL_TOP/admin/BHUP_dbtier.xml
/u02/app/applmgr/common/util/jre/1.1.8/bin/jre


## SHOULD BE ##

AF_JRE_TOP=/usr/j2se
export AF_JRE_TOP

AFJVAPRG=/usr/j2se/bin/java
export AFJVAPRG

## FIXED SETTING ##
dbtier.applmgr->grep -i AF_JRE_TOP $APPL_TOP/admin/BHUP_dbtier.xml
/usr/j2se

dbtier.applmgr->grep -i AFJVAPRG $APPL_TOP/admin/BHUP_dbtier.xml
/usr/j2se/bin/java

midtier.applmgr->grep -i AF_JRE_TOP $APPL_TOP/admin/BHUP_midtier.xml
/usr/j2se

midtier.applmgr->grep -i AFJVAPRG $APPL_TOP/admin/BHUP_midtier.xml
/usr/j2se/bin/java


##
## Re-run AutoConfig
##

## BE tier
$AD_TOP/bin/adconfig.sh contextfile=$APPL_TOP/admin/BHUP_dbtier.xml appspass=pass


## MT tier
$AD_TOP/bin/adconfig.sh contextfile=$APPL_TOP/admin/BHUP_midtier.xml appspass=pass



## MT tier
##
## comment out the following lines from jserv.properties and jserv.conf:
## refer to SR:780 11.5.10.2 AppsLocalLogin.jsp Internal Server Error
##

vi /u01/app/applmgr/product/iAS_115102/Apache/Jserv/etc/jserv.properties
#zones=mobile
#mobile.properties=/u01/app/applmgr/product/iAS_115102/Apache/Jserv/etc/mobile.properties

vi /u01/app/applmgr/product/iAS_115102/Apache/Jserv/etc/jserv.conf
#ApJServGroupMount /mobile balance://OACoreGroup/mobile



##
## Shutdown Services
##

## BE tier
/u02/app/applmgr/common/admin/scripts/BHUP_dbtier/adstpall.sh apps/pass

## MT tier
/u01/app/applmgr/common/admin/scripts/BHUP_midtier/adstpall.sh apps/pass



##
## Start Services
##

## BE tier
exit
su - applmgr
/u02/app/applmgr/common/admin/scripts/BHUP_dbtier/adstrtal.sh apps/pass


## MT tier
exit
su - applmgr
/u01/app/applmgr/common/admin/scripts/BHUP_midtier/adstrtal.sh apps/pass



##
## TEST call to external SMTP server
##
$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=smtp -Dserver=mailhub.company.com \
-Dport=25 -Daccount=oracle.dba@company.com -Dconnect_timeout=120 \
oracle.apps.fnd.wf.mailer.Mailer

dbtier.applmgr->$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=smtp -Dserver=mailhub.company.com \
-Dport=25 -Daccount=oracle.dba@company.com -Dconnect_timeout=120 \
oracle.apps.fnd.wf.mailer.Mailer
> -Dport=25 -Daccount=oracle.dba@company.com -Dconnect_timeout=120 \
> oracle.apps.fnd.wf.mailer.Mailer
Server mailhub.company.com at port 25 is reachable
Successfully connected to the SMTP account



REFERENCE:
Note:242941.1 How To Troubleshoot Java-based Workflow Notification Mailer In 11.5.9 and OWF.G
Note:278127.1 Workflow Notification Will Not Start After Cloning
Note:278163.1 Workflow Notification Mailer Will Not Start

Wednesday, March 5, 2008

Concurrent manager -- Doc

http://www.dbatoolz.com/scripts_desc.htm --- Concurrent manager/program scripts

Concurrent Processing (CP) / APPS Reporting Scripts
Doc ID: Note:213021.1


Note:200358.1 Oracle Application Object Library Report Review Agent Setup Test
Note 74717.1: Troubleshooting Concurrent Manager Startup problems
Note 97798.1 ORA-904 when starting concurrent managers
Note 230121.1 Routine AFPEIM encountered an error while starting Concurrent Manager on Cloned instance
Note 1059201.6 Status pending with 'Inactive No Manager' cor Concurrent Requests
Note 113135.1 Conflict Resolution Manager FNDCRM Does Not Start; NoError Message.
Note 123607.1 CONCSUB SYSADMIN 'System Administrator' GIVES INVALID RESPONSIBILITY ERROR
Note 2055375.6 RESET PMON METHOD (CHOICES: LOCK, OS, RDBMS)
Note 2069781.6 Basic Troubleshooting of the Concurrent Managers
Note 2120154.6 Unable to start the ccm after install - core dump
Note 171855.1 CCM.sql Diagnostic Script for Concurrent Manager
Note 185036.1 Unable to Startup or Shutdown the Concurrent Managers in 11.5.5 by Using the Syntax adcmctl.sh apps/ Start or Stop

Saturday, March 1, 2008

1. 4898608 - Latest Opatch (10.2.0.3.4 )

1. 4898608 - Latest Opatch (10.2.0.3.4 )

cd /admin/orapatch/oracle/10.2.0.3/Patches/OPatch
mv $ORACLE_HOME/OPatch/ $ORACLE_HOME/OPatch_old
mkdir $ORACLE_HOME/OPatch
cp -rp * $ORACLE_HOME/OPatch/.


2. 5929784 - MLR FOR THE FIXES IN 4966417/5605370 AND 5631915 ON TOP OF 10.2.0.3

cd /admin/orapatch/oracle/10.2.0.3/Patches/5929784
opatch apply -local

3. 6358777 - MLR for 6121268 and 5998987

cd /admin/orapatch/oracle/10.2.0.3/Patches/6358777
opatch apply -local

ApplySession applying interim patch '6358777' to OH '/u01/app/oracle/product/10.2.0.3_Aug/DBEE_1'
Interim patch 6358777 is a superset of the patch(es) [ 5998987 ] in OH /u01/app/oracle/product/10.2.0.3_Aug/DBEE_1
OPatch will rollback the subset patches and apply the given patch.

The local system has been patched and can be restarted.


4. 6487758 - MLR for 6397940 and 4587572

cd /admin/orapatch/oracle/10.2.0.3/Patches/6487758
opatch apply -local

5. 6523687 - MLR for 6397948 and 5606847

cd /admin/orapatch/oracle/10.2.0.3/Patches/6523687
opatch apply -local

# After applying/rolling back the patch, you need to run following :
#

Connect sys as sysdba;
ALTER SESSION SET CURRENT_SCHEMA=MDSYS;
$ORACLE_HOME/md/admin/prvtcat.plb
$ORACLE_HOME/md/admin/prvtrtr.plb
$ORACLE_HOME/md/admin/prvtsam.plb
ALTER SESSION SET CURRENT_SCHEMA = SYS;



6. 6646853 - Jan 2008 CPU

cd /admin/orapatch/oracle/10.2.0.3/Patches/6646853
./apply_cpu_proderp_aug.sh


a> On one RAC node, start the instance and execute:

cd $ORACLE_HOME/cpu/CPUJan2008
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catcpu.sql
SQL> QUIT

b> If catcpu.sql reports any Invalid Objects, run the following commands:


cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @utlrp.sql


c> You must recompile views for all databases except the following:

To recompile the views in the database, follow these steps:

Run the pre-check script, which reports the maximum number of views and objects that may be recompiled:

cd $ORACLE_HOME/cpu/view_recompile
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @recompile_precheck_jan2008cpu.sql

Run the view recompilation script. Note that this script is run with the database in upgrade mode, which restricts connections as SYSDBA.

cd $ORACLE_HOME/cpu/view_recompile
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP UPGRADE
SQL> @view_recompile_jan2008cpu.sql

SQL> SHUTDOWN;
SQL> STARTUP;


Check the log file for any errors. The log file is in the current directory and is named: vcomp__.log

d> If any invalid objects were reported, run the utlrp.sql script as follows:

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @utlrp.sql

e> Verify that the view recompilation has been performed for the database, by executing the following statement:

SELECT * FROM registry$history where ID = '6452863';

If the view recompilation has been performed, this statement returns one row. If the view recompilation has not been performed, this statement returns no rows.