Friday, October 19, 2012

How to Create OEL 5U5 Local Yum Repository from ISO

Please follow below steps to create Yum Local repository
 
1) Ftp Enterprise-R5-U5-Server-x86_64-dvd.iso to Newly created VM under /Oracle_Media/LINUX
2) Logon as root to the VM and navigate to /Oracle_Media/LINUX
3) mkdir -p /media/cdrom
4) mount -o loop ./Enterprise-R5-U5-Server-x86_64-dvd.iso /media/cdrom
5) cd /media/cdrom/Server/
6) rpm -Uvh createrepo-0.4.11-3.el5.noarch.rpm (IF createrepo is not Installed)
7) vi /etc/yum.repos.d/oel5u5_64bit_iso.repo (this is new file)
8) Add following to the oel5u5_64bit_iso.repo file
   
    [oel5u5_64bit_iso.repo]
    name=OEL 5u5 x86_64 Bit Repository
    baseurl=file:///media/cdrom/Server
    enabled=1

9) rpm --import /media/cdrom/RPM-GPG-KEY-oracle
10)rpm --import /media/cdrom/RPM-GPG-KEY

Check Now By Installing Oracle-Validated Package and see how it resolves all the dependencies

yum install oracle-validated


Enjoy!

Monday, October 1, 2012

EBS R12.1.3 Login Page Branding







Image Number
Image Name
Actual Image File Name
Directory
Actual Image Size
New Image Size/Type
1
Image (Oracle logo)
FNDSSCORP.gif
$OA_MEDIA
155 X 20  Pixels
Same
2
Image (people image)
people.jpg
$OA_MEDIA
417 X 54  Pixels
Same
3
Image (above globe)
topLines.gif
$OA_MEDIA
352 X 54  Pixels
Same
4
Image (globe)
globalTop.jpg
$OA_MEDIA
351 X 180 Pixels
Same
5
Image (below globe)
global.jpg
$OA_MEDIA
352 X 79  Pixels
Same

1)      Prepare the images of same format name and size. Below method is only valid when default and custom brand images have same names
2)      Logon to application tier and take backup of directory $OA_MEDIA as shown below
[applebs@whjed-apstest3 media]$ echo $OA_MEDIA
/u03/PROD/apps/apps_st/comn/java/classes/oracle/apps/media
3)      FTP the image with same name to $OA_MEDIA as shows in above tables’s (Actual Image Name column)
4)      Stop the application services
5)      Remove the following cache
[applebs@whjed-apstest3 u03]$ rm -Rf $OA_HTML/_pages/*
[applebs@whjed-apstest3 u03]$ rm -Rf $COMMON_TOP/_pages/*
[applebs@whjed-apstest3 u03]$ rm -Rf $IAS_ORACLE_HOME/Apache/modplsql/cache/*
6)      Disable Load Balancer Cache/Web acceleration if applicable 
7)      Compile all the JSPs 
Remove the following cache
[applebs@whjed-apstest3 u03]$ rm -Rf $OA_HTML/_pages/*
[applebs@whjed-apstest3 u03]$ rm -Rf $COMMON_TOP/_pages/*
[applebs@whjed-apstest3 u03]$ rm -Rf $IAS_ORACLE_HOME/Apache/modplsql/cache/*
[applebs@whjed-apstest3 u03]$ $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 2
logfile set: /u03/PROD/inst/apps/EBS1213C_whjed-apstest3/logs/appl/rgf/ojsp/ojspc_error.log
(*)  To compile a Single JSP use following command

$FND_TOP/patch/115/bin/ojspCompile.pl --compile -s 'RF.jsp,AppsLocalLogin.jsp' --flush -p 2

8)      Start the services
9)      Clean Local Desktop Internet Explorer Cache
10)   Login to EBS to see the Changes



11)   Helpful Notes are following
·         Note: 579917.1 - How to Personalize Login page in R12?
·         Note: 741459.1 - Tips For Personalizing The E-Business Suite r12 Login Page (MainLoginPG)
·         Note: 473539.1 - How to Replace the Globe and People Images of the Release 12 Login page
·         Note: 468971.1 - Tips For Personalizing The E-Business Suite 11i Login Page (AppsLocalLogin)