Thursday, June 26, 2008

Oracle Critical Patch Update Note for Oracle E-Business Suite

April 2006
360468.1 - Oracle Critical Patch Update April 2006 Pre-Installation Note for Oracle E-Business Suite
July 2006
372931.1 - E-Business Suite Critical Patch Update Note July 2006
October 2006
391564.1 - -Business Suite Critical Patch Update October 2006 Note
January 2007
402670.1 - Oracle E-Business Suite Critical Patch Update Note January 2007
April 2007
420072.1 - Oracle E-Business Suite Critical Patch Update Note April 2007
July 2007
432882.1 - Oracle E-Business Suite Critical Patch Update Note July 2007
October 2007
455294.1 - Oracle E-Business Suite Critical Patch Update Note October 2007
January 2008
467742.1 - Oracle E-Business Suite Critical Patch Update Note (January 2008)
April 2008
557157.1 - Oracle E-Business Suite Critical Patch Update Note April 2008
July 2008
605117.1 - Oracle E-Business Suite Critical Patch Update Note July 2008
October 2008
738921.1 - Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Note (October 2008)
January 2009
738923.1 - Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Note (January 2009)
April 2009
738923.1 - Oracle® E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (April 2009)

How to prevent Concurrent Requests executing post rapid clone

1. Edit the $COMMON_TOP/clone/bin/adcfgclone.pl

2. Go to the end of the file

3. Change the following lines:-

print "\n Starting application Services for $s_dbSid:\n";
print "Running:\n";
print(" $s_com/admin/scripts/$s_contextname/adstrtal.$ext $s_apps_user/\n");
system("$s_com/admin/scripts/$s_contextname/adstrtal.$ext $s_apps_user/$PWD");

TO:

print "\nNOT Starting application Services for $s_dbSid:\n";
#print "Running:\n";
#print(" $s_com/admin/scripts/$s_contextname/adstrtal.$ext $s_apps_user/\n");
#system("$s_com/admin/scripts/$s_contextname/adstrtal.$ext $s_apps_user/$PWD");

4. Run "perl adcfgclone.pl appsTier" as normal.

The services will not start Automatically when the clone completes allowing data to be changed safely.

How to Enable and Disable the archive log

To Disable the Archive Log:

change the following value to false in the init.ora file

log_archive_start=false

shutdown the database:
shutdown immediate

disable the archivelog:
startup mount
alter database noarchivelog;
alter database open;
archive log list;


To Enable the Archive Log:

change the following value to true in the init.ora file

log_archive_start=true

shutdown the database:
shutdown immediate

enable the archivelog:
startup mount
alter database archivelog;
alter database open;
archive log list;
archive log all;

How to find if the Oracle Client Software is 32-Bit or 64-Bit ?

You can find whether Oracle Client Software is 32-Bit or 64-Bit by using the following :

Check for the directories :

1) $ORACLE_HOME/lib32
2) $ORACLE_HOME/lib

% ls -l $ORACLE_HOME/lib32
% ls -l $ORACLE_HOME/lib


If the two directories $ORACLE_HOME/lib32 and $ORACLE_HOME/lib are existing then it is 64 bit client.
If there is only an ORACLE_HOME/lib directory then it is 32 bit client.

11i Product Info

To get the 11i Product Info you can execute the following Sql

sqlplus apps/apps @$AD_TOP/sql/adutconf.sql