Excellent Deal To Developer or Functional Consultant Install setup of Orace EBS 11i or R12 or OFA

PLEASE NOTE:

All software's listed on this site are only IDES or Vision versions. This software's will only enable you to train as a Oracle professional and also practice as if you are in real time production environment. These are meant strictly for educational/informational use only; these are not suitable to run any commercial applications. Full commercial license can be purchased only from Oracle Corporation .

Dear Sir,
I am a Oracle Consultant,

We deal with All Oracle Software's, Installations

Call Javeed :+91-9160903479
Our services Are :

a.We Do Oracle Installations @ UR Door Step.

b.We provide Pre-Installed Oracle, USB 3.0 External Hard disks.

c.We will do the Remote Installations with Online Support(We do Oracle Installation in all over INDIA, US, UK, GULF, ASIA and all over the World)

We provide Pre-Installed Oracle External Hard disks are Compatible with Windows Xp,Windows7 & Windows 8 Laptops also.

1. Oracle Application 11i Installation
2. Oracle Application R12.1.1 Installation
3. Oracle Application R12.1.3 Installation
4. Oracle Application EBS R12.2 Installation
5. Oracle Fusion Application 11.1.8 Installation
6. Oracle Database (9i,10g,11g,12c) Installation
7. Oracle Rac (10g,11g,12c) Installation
8  Oracle External Hard disk with (9i,10g,11g,11i,R12,12c)
9. Others Oracle Issues

Thanks,

Javeed

Oracle Apps (E-Business Suite) 12.2 installation steps

Oracle Apps (E-Business Suite) 12.2 installation steps
1. Download software from eDelivery .


1.1 Download following zip files for Linux
V29764-01.zip V35231-01_4of5.zip V35806-01_1of3.zip V37515-01_1of6.zip V29856-01.zip V35231-01_5of5.zip V35806-01_2of3.zip V37515-01_2of6.zip V35215-01_1of3.zip V35802-01.zip V35806-01_3of3.zip V37515-01_3of6.zip V35215-01_2of3.zip V35803-01_1of3.zip V35807-01.zip V37515-01_4of6.zip V35215-01_3of3.zip V35803-01_2of3.zip V35808-01.zip V37515-01_5of6.zip V35230-01_1of2.zip V35803-01_3of3.zip V35809-01.zip V37515-01_6of6.zip V35230-01_2of2.zip V35804-01_1of2.zip V35810-01.zip V39615-01.zip V35231-01_1of5.zip V35804-01_2of2.zip V35811-01.zip V35231-01_2of5.zip V35805-01_1of2.zip V35812-01.zip V35231-01_3of5.zip V35805-01_2of2.zip V35813-01.zip

2. Setup staging area (You can either unzip all files downloaded earlier or follow below process)
2.1 unzip StratHere DVD (for Linux)
unzip V35215-01_1of3.zip
2.2 Start buildStage script
[R12.2_SOFTWARE]/startCD/Disk1/rapidwiz/bin
./buildStage.sh
2.3 select option 1 i.e. Create New Stage
2.3 Select Option 2 Linux x86-64
2.4 Please enter the directory containing the zipped installation media: [Enter directory location where all the zip files are downloaded]
/stage/oracle/r12/12.2/
You should see output like
__________
Unzipping V35810-01.zip
Unzipping V35803-01_3of3.zip
Unzipping V35231-01_5of5.zip
.
.
.
Verifying stage area…
Directory /stage/oracle/r12/12.2/TechInstallMedia is valid
Directory /stage/oracle/r12/12.2/TechPatches/DB is valid
Directory /stage/oracle/r12/12.2/TechPatches/MiddleTier is valid
Directory /stage/oracle/r12/12.2/EBSInstallMedia/AppDB is valid
Directory /stage/oracle/r12/12.2/EBSInstallMedia/Apps is valid
Directory /stage/oracle/r12/12.2/EBSInstallMedia/AS10.1.2 is valid
Directory /stage/oracle/r12/12.2/TechInstallMedia/database is valid
Directory /stage/oracle/r12/12.2/TechInstallMedia/ohs11116 is valid
Directory /stage/oracle/r12/12.2/TechInstallMedia/wls1036_generic is valid
__________

2.5 Staging Area should look like below


3. Create Operating System User depending on Single User or Multi UserInstallation :
You can do
a) Single -User  Installation : oracle where both Application Tier and Database Tier are owned by single user
b) Multi-User Installation : oracle & applmgr where Application Tier is owned by one user (applmgr) and Database Tier by another (oracle)
Note: I am doing multi-user installation and using applmgr & oracle both member of group dba
groupadd dba
useradd -g dba applmgr
useradd -g dba oracle

4. Start Installer from root user
cd $R12.2_SOFTWARE/startCD/Disk1/rapidwiz/
./rapidwiz
5. In Wizard Operation screen select : Install Oracle E-Business Suite Release 12.2.0

 1. Start EBS 12.2.x Installer from root user as
cd $R12.2_SOFTWARE/startCD/Disk1/rapidwiz/
./rapidwiz



2. Select Port Pool : Select port pool for services as you used to do in previous versions 12.1.x or 11i
Note: Oracle Apps 12.2 uses dual file system . more on dual file system in 12.2 later.


3. Select Database Type
a) Fresh Database : Use this for production or where you don’t need vision environment.
b) Vision Database : Use this option if you need vision data in R12.



Note: Base directory (/d01/oracle/prod) mentioned above should already be created and owned by Database user (oracle:dba) defined above.

4. License Additional Products : If you need any additional products you can license it now .
Note: You can license addtional products after installation as well.





5. If you are planning to use multi-language (language other than american english) then recommendation is to select Databse character set as AL32UTF8


6. Provide Application Tier details
Note: Apps OS user (applmgr:dba) should be able to create directory under Base directory (/d01/oracle/prod) .
Note: I created application tier user applmgr and database tier user oracle using same group i.e. dba



More on dual file system i.e. File System 1 & File System 2 later.
7. Provide Application Tier & database user password .
Note: WLS Admin User is WebLogic Server Administrator user used to login to WebLogic Console . WebLogic Server is newly introduced in Oracle Apps 12.2



8. If you plan to deploy application tier on multiple nodes then click on Add Server button at bottom.
Note: I am doing single node installation i.e. Application Tier and Database Tier on single host/machine.

9. Installer will validate system configuration and if any check fails then click on ! next to check .
Note: In my case Port Availablity and File Space checks failed. After fixing failed check click on Retry button

a) Port Availaibity check : In my case port 8899 was in use
To Identify which process is using port 8899 in linux run “netstat -tulpn | grep [Port_no]“
[atul@innowave21 ~]$ netstat -tulpn | grep 8899
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 :::8899 :::* LISTEN 4536/java
In my case Process ID 4536 was using port 8899, stop the process using 8899 or use different port pool in previous screen.




10. Click Next and then Install when all checks complete successfully.



11. After installation , access Application as http://host:port where port number is 8000+ port pool, as I use port pool 10 URL should be http://host:8010
 12.2 comes with the dual file system. One for PROD purpose and one for patching purpose.So there is not need to bring down EBS services for patching.

Overcoming Oracle Apps R12 FRM-92101 Error On Redhat Linux 5.6

Have you ever got the error, FRM-92101 on with Oracle Applications R12 on 64 bit Redhat Linux 5.5? Here is how to overcome it.

Oracle Forms Runtime Error FRM92101

Here is my environment:
Server: Redhat Linux 5.5
lsb_release -a
LSB Version: :core-3.1-amd64:core-3.1-ia32:core-3.1-noarch:graphics-3.1-amd64:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: EnterpriseEnterpriseServer
Description: Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)
Release: 5.5
Codename: Carthage
uname -a
Linux black.testrac.com 2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
select
APPLICATIONS_SYSTEM_NAME
, ARU_RELEASE_NAME
, release_name
from apps.fnd_product_groups
APPLICATIONS_SYSTEM_NAME ARU_RELEASE_NAME
—————————— ——————-
RELEASE_NAME
————————————————–
VIS R12
12.1.1
———–
Prerequisites:
The java is working in your browser. To test whether Java is working in the web browser, run this in the URL.
http://java.com/en/download/testjava.jsp
You have overcome the error concerning: NPX_PLUGIN_PATH, and oaj2se.exe.  See my previous post.
http://rodgersnotes.wordpress.com/2012/01/20/firefox-oracle-apps-java-plugins-on-64-bit-redhat-5-5/
———–
Symptom:
Start the database, listener, and all the Oracle Apps processes. Open a browser. Test an Oracle Apps Form with the forms test webpage. In my case:
file:///oapps/applmgr/VIS/apps/tech_st/10.1.2/tools/web/html/runform.htm
You get a java window open. But you get the error: FRM-92101 There was a failure in the Forms server during startup. This could happen due to an invalid configuration. Please look into the web server log for the details.
Click on Details:
Java exception:
oracle.forms.net.ConnectionException: forms session <1> failed during startup: no response from runtime process
at oracle.forms.net.ConnectionException.createConnectionException(Unknown source)
at oracle.forms.net.HTTPStream.getResponse(Unknown source)
at oracle.forms.net.HTTPStream.doFlush(Unknown source)
at oracle.forms.net.HTTPStream.Flush(Unknown source)
at java.io.DataOutputStream.flush (DataOutputStream.java:106)
at oracle.forms.net.HTTPConnection.connect(Unknown source)
at oracle.forms.engine.FormsDispatcher.initConnection(Unknown source)
at oracle.forms.engine.FormsDispatcher.init(Unknown source)
at oracle.forms.engine.Runform.initConnection(Unknown source)
at oracle.forms.engine.Runform.startRunform(Unknown source)
at oracle.forms.engine.Main.createRunform(Unknown source)
at oracle.forms.engine.Main.start(Unknown source)
at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Plugin2Manager.java:1698)
at Java.lang.Thread.run(Thread.java:662)
————
Check the Oracle Forms Log:
$LOG_HOME/ora/10.1.3/opmn/forms_default_group_1/formsstd.out
In my case:
/oapps/applmgr/VIS/inst/apps/VIS_black/logs/ora/10.1.3/opmn/forms_default_group_1/formsstd.out
tail -100 /oapps/applmgr/VIS/inst/apps/VIS_black/logs/ora/10.1.3/opmn/forms_default_group_1/formsstd.out
…
12/01/21 12:32:08 FormsServlet init():
configFileName: /oapps/applmgr/VIS/inst/apps/VIS_black/ora/10.1.2/forms/server/appsweb.cfg
testMode: false
12/01/21 12:32:08 Oracle Containers for J2EE 10g (10.1.3.4.0) initialized
12/01/21 13:04:27 ListenerServlet init()
12/01/21 13:04:28 Forms session <1> aborted: runtime process failed during startup with errors /oapps/applmgr/VIS/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory
12/01/21 13:19:53 Forms session <2> aborted: runtime process failed during startup with errors /oapps/applmgr/VIS/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory
————–
And Check The File, application.log:
tail -100 /oapps/applmgr/VIS/inst/apps/VIS_black/logs/ora/10.1.3/j2ee/forms/forms_default_group_1/application.log
12/01/21 13:04:27.314 formsweb: ListenerServlet init()
12/01/21 13:04:28.455 formsweb: Forms session <1> aborted: runtime process failed during startup with errors /oapps/applmgr/VIS/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory
12/01/21 13:04:28.455 formsweb: Forms session <1> exception stack trace:
oracle.forms.engine.RunformException: Forms session <1> failed during startup: no response from runtime process
at oracle.forms.servlet.RunformProcess.connect(Unknown Source)
at oracle.forms.servlet.RunformProcess.dataToRunform(Unknown Source)
at oracle.forms.servlet.RunformSession.dataToRunform(Unknown Source)
at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
————–
Cause:
The cause is not unusual with Linux, or Oracle, or Oracle Apps. It’s that Oracle Forms is looking for a library file. But the file doesn’t exist in the expected place. Nor does a link. Not again.
In this case, libXm.so.2 can’t be found.
———-
Analysis:
Find the files. As root, do lots of linear searches all over the hard drive looking for library files.
find / -type f -ls 2> /dev/null | grep -i “libXm.so”
…
214067513 2692 -rwxr-xr-x 1 root root 2747528 Jun 6 2007 /usr/lib64/libXm.so.3.0.2
214054985 2776 -rwxr-xr-x 1 root root 2836528 Mar 4 2010 /usr/lib64/libXm.so.4.0.1
214067522 2492 -rwxr-xr-x 1 root root 2542828 Jun 6 2007 /usr/lib/libXm.so.3.0.2
1802278 2584 -rwxr-xr-x 1 root root 2637260 Mar 4 2010 /usr/lib/libXm.so.4.0.1
…
I did have more occurences of this file. But they were under different subdirectories.
/oapps/oracle/VIS/db/tech_st/11.1.0/lib32/stubs
/middleware/Oracle_BI1/lib32/stubs
The directories under /usr are the critical ones.
You can find any existing links with:
find / -type l -ls 2> /dev/null | grep -i “libXm.so”
—————
File Types:
file /usr/lib64/libXm.so.4.0.1
/usr/lib64/libXm.so.4.0.1: ELF 64-bit LSB shared object, AMD x86-64, version 1 (SYSV), stripped
file /usr/lib/libXm.so.3.0.2
/usr/lib/libXm.so.3.0.2: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), stripped
—————
Find or Verify the Packages Needed For The Library Files:
Reading other webpages (below), these library files are provided by the package: openmotif22-2.2.3-18.
I had installed everything, every last package, when I installed Redhat. It’s to avoid nonsense like this. So, I already the package installed. If you don’t have the package installed, download it, and install it. rpmfind.net is a good place to start.
Another time, I’d stuggled with a similar installation. In my notes, I was concerned with three library files: libMrm.so, libUil.so, and libXm.so. So, I leveraged my notes, and looked for all three. Turns out they are all owned by the same package: openmotif.
—–
rpm -q -f /usr/lib64/libXm.so.4.0.1
openmotif-2.3.1-2.el5_4.1
—–
rpm -q -f /usr/lib/libXm.so.3.0.2
openmotif22-2.2.3-18
—–
What Are All The Files Associated With That Package?
rpm -q openmotif22 -l | sort | more
/usr/lib64/libMrm.so.3
/usr/lib64/libMrm.so.3.0.2
/usr/lib64/libUil.so.3
/usr/lib64/libUil.so.3.0.2
/usr/lib64/libXm.so.3
/usr/lib64/libXm.so.3.0.2
….
/usr/lib/libMrm.so.3
/usr/lib/libMrm.so.3.0.2
/usr/lib/libUil.so.3
/usr/lib/libUil.so.3.0.2
/usr/lib/libXm.so.3
/usr/lib/libXm.so.3.0.2
/usr/share/doc/openmotif22-2.2.3
…
This query obviously finds both the 32 and 64 bit files.
—————–
—————–
Analysis For Links:
cd /usr/X11R6/lib
Original files:
/usr/lib/libMrm.so.3.0.2
/usr/lib/libMrm.so.4.0.1
/usr/lib/libUil.so.3.0.2
/usr/lib/libUil.so.4.0.1
/usr/lib/libXm.so.3.0.2
/usr/lib/libXm.so.4.0.1
—–
The application, is looking for files in the directory: /usr/X11R6/lib
But it does not exist. Create it.
As root:
mkdir -p /usr/X11R6/lib
—–
Make Links To The Original Files:
cd /usr/X11R6/lib
ln -s /usr/lib/libMrm.so.3.0.2 .
ln -s /usr/lib/libMrm.so.4.0.1 .
ln -s /usr/lib/libUil.so.3.0.2 .
ln -s /usr/lib/libUil.so.4.0.1 .
ln -s /usr/lib/libXm.so.3.0.2 .
ln -s /usr/lib/libXm.so.4.0.1 .
The above ^ will have a link, the same name as the original file.
—–
Make Links With An Abbreviated Name:
ln -s /usr/lib/libXm.so.3.0.2 libXm.so.3
ln -s /usr/lib/libXm.so.4.0.1 libXm.so.4
ln -s /usr/lib/libXm.so.4.0.1 libXm.so
ln -s /usr/lib/libUil.so.4.0.1 libUil.so.4
ln -s /usr/lib/libUil.so.3.0.2 libUil.so.3
ln -s /usr/lib/libUil.so.4.0.1 libUil.so
ln -s /usr/lib/libMrm.so.4.0.1 libMrm.so.4
ln -s /usr/lib/libMrm.so.3.0.2 libMrm.so.3
ln -s /usr/lib/libMrm.so.4.0.1 libMrm.so
—–
At this point,I still got the error: FRM-92101
Of course, the software is still looking for libXm.so.2, but I had not yet created the link it.
As root:
cd /usr/X11R6/lib
ln -s /usr/lib/libMrm.so.3.0.2 libMrm.so.2
ln -s /usr/lib/libUil.so.3.0.2 libUil.so.2
ln -s /usr/lib/libXm.so.3.0.2 libXm.so.2
———–
Try again. It works. In the sense that I can get a login form.

Oracle Applications Login

However, when I try logging in as sysadmin, OPERATIONS, or APPS, I now get another error:
APP-FND-01542:  The applications servers is not authorized to access this database.
Are these not the right users to login with? If so, when do the errors ever stop? If not, what are the right users to login with?  Please leave a comment.
—————
Useful Links:
Test whether Java is working in the web browser.
http://java.com/en/download/testjava.jsp
Installing Oracle E-Business 12.1.1 on Oracle Enterprise Linux 5.4 64-bit
http://www.oracle-developer.com/installing_oracle_r12_rhel5_64bit.html
Installing Oracle E-Business 12.1.1 on Oracle Enterprise Linux 5.4 64-bit
http://www.pythian.com/news/1265/installing-oracle-r12-ebs-in-my-living-room/
Oracle® Fusion Middleware Release Notes 11g Release 1 (11.1.1) for Linux x86 E10133-25  44 Oracle Forms
http://docs.oracle.com/cd/E23549_01/relnotes.1111/e10133/forms.htm

Patchset Uitlity to check installed patchsets and Family Packs

Hello Everyone!!!

Here you have a good tool to know.

patchset.sh is quite a good tool to evaluate the currently installed Oracle Applications' patchsets and Family Packs.

Note 139684.1 provides in depth details about this utility.

Here is the simple example, when you need to use this tool.

1) You want to know what is the current AD level of your system.
2) whether your system is at ATG RUP4 or RUP5 or RUP6(yet to be released!!)

Note: Its advised to download the latest version of this tool from
ftp://ftp.oracle.com/support/outgoing/PATCHSET_COMPARE_TOOL/patchsets.sh

If the ftp link is not working, try manual ftp as follows:
NOTE: Put the full path in for the get.

ftp ftp.oracle.com
login as an anonymous user, and then:
get support/outgoing/PATCHSET_COMPARE_TOOL/patchsets.sh

and finally this script works perfectly for 10.7, 11.0.x, 11.5.x, and 12.0.x !!!

Hope this helps you better in many ways!!

Utility TO CHECK TECHSTACK COMPONENTS-APPS-Database

There is a good utility for checking all the techstack components and there versions present in e-business application. This is applicable to both 11i and R12 environments.

There is a script $FND_TOP/patch/115/bin/txkInventory.pl on apps side which is going to fetch the versions of all components on apps side. This script can be run by giving input to $FND_TOP/patch/115/bin/TXKScript.pl script. TXKScript.pl script takes 2 mandatory arguments, one is the script to run and another is the directory for storing log file and out file. Other then these arguments you must give context file name and location and apps password as well. Also you need to give outfile where it will create report of techstack components.

Login to apps side of your application and source the environment. Run the below command

(appmgr06) appmgr - -bash $ perl $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=apps -outfile=$OA_HTML/techstack_info.html
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** STDOUT = /slot06/appmgr/scmc2mq0comn/rgf/scmc2mq0/TXK/txkInventory_Fri_May_16_04_01_03_2008_stdout.log
Reportfile /slot06/appmgr/scmc2mq0comn/html/techstack_info.html generated successfully.

You can access the above report file using http://(hostname.domain):(port)/OA_HTML/techstack_info.html

The report will look like this.

The report will have following information.

* Summary of environment details
* Inventory of HTTP Server Node
* Inventory of Forms Server Node
* Inventory of Concurrent Processing Server Node
* Inventory of Administration Server Node

Similarly you can check on DB side as well

(oracle06) scmc2mq0 - -bash $ perl $ORACLE_HOME/appsutil/bin/TXKScript.pl -script=$ORACLE_HOME/appsutil/bin/txkInventory.pl -txktop=$ORACLE_HOME/appsutil/temp -contextfile=$CONTEXT_FILE -appspass=apps -outfile=$ORACLE_HOME/appsutil/temp/master_db.html

Developer 6i Patch Set 19 upgrade with EBS 11i

It has been more than two years since the last Developer 6i patchset 18 was certified with Oracle E-Business Suite Release 11i, and now, Developer 6i patchset 19 (6.0.8.28) is certified with Oracle Apps 11i.

Actually, since we migrated from Jinitiator to Java JRE 1.6, we've encountered some frustrating mouse focus issues, I really hope they were fixed with this patch and won't appear after upgrade.

Like with the last patch set, I'll bring you "step-by-step" upgrade instructions for linux deployments.
Other Operation Systems's need another patches - see Note 125767.1 - Upgrading Developer 6i with Oracle Applications 11i.

*** All patches must be installed on all Application tier nodes

1. Stop all application processes by adstpall.sh
    
   
2. Apply the latest certified Developer 6i patch set 19 (6194129) 
   - Source applications environment (e.g source .../testappl/APPSORA.env) 
   - Verify that $ORACLE_HOME is the 806_ORACLE_HOME
   - Execute with applmgr user
   

   $ unzip p6194129_60828_LINUX.zip $ cd developer6i_patch19 $ ./patch_install.sh 2>&1 | tee patch_install_p19.log

   
   - Check patch_install_p19.log for any errors
   - Execute the following to relink Procedure Builder, Forms, Graphics and Reports
   

   $ cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install $ cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install $ cd $ORACLE_HOME/graphics60/lib; make -f ins_graphics60w.mk install $ cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install

   
   

3. Apply patch 9863561- Unzip patch file
   

   %cd $ORACLE_HOME %unzip p9863561_60828_GENERIC.zip

   
   - Backup old files
   

   %mkdir $ORACLE_HOME/forms60/java/oracle/forms/backup %cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine $ORACLE_HOME/forms60/java/oracle/forms/backup %cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler $ORACLE_HOME/forms60/java/oracle/forms/backup %cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui $ORACLE_HOME/forms60/java/oracle/forms/backup

4.  Special Instruction

$cd $ORACLE_HOME/forms60/java jar -xvf f60all.jar oracle/forms/ui/VBean.class

Copy patch to appropriate directories

$ cd $ORACLE_HOME/9863561/oracle/forms/engine $ cp * $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class $cd $ORACLE_HOME/9863561/oracle/forms/handler $cp * $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class $cd $ORACLE_HOME/9863561/oracle/forms/ui $cp * $ORACLE_HOME/forms60/java/oracle/forms/ui/VImage.class

Backup the Forms java subtree and extract the changed files

% cd $ORACLE_HOME/forms60/java % cp -r oracle/ewt oracle/ewt.PREBUG9863561 % jar -xvf $ORACLE_HOME/9863561/ewt3.jar % rm META-INF/MANIFEST.MF % rmdir META-INF

Verify that the EWT version has been updated under the

           $ORACLE_HOME/forms60/java directory.
       For example:
       % ls -la oracle/ewt | grep 3_4_49

- Regenerate Jar files
- Execute adadmin
- Select the "Generate Applications Files menu" option
- Select "Generate product JAR files"
- Do you wish to force regeneration of all jar files? => Yes
- Spot check that the JAR files have been generated by verifying the timestamp

$ cd $OA_JAVA/oracle/apps/fnd/jar $ ll fndforms.jar fndewt.jar

3. Apply patch 6125732- Unzip patch file + Apply patch
   

   $ unzip p6125732_60828_LINUX.zip $ cd 6125732 $ sh patch.sh

          
   
4. Apply patch 6857221 - Unzip patch file + Apply patch
   

   $ unzip p6857221_60828_LINUX.zip $ cd 6857221 $ sh patch.sh

          
   - Relink f60webmx for Oracle Applications
   

   $ adrelink.sh force=y "fnd f60webmx"

          
   
5. Apply patch 5232832- Unzip patch file + Apply patch
   

   $ unzip p5232832 _60828_LINUX.zip $ cd 5232832 $ sh patch.sh

           - Relink f60webmx for Oracle Applications
   

   $ adrelink.sh force=y "fnd f60webmx"

6. Apply patch 8888184 - Unzip patch file + Apply patch
   

   $ unzip p8888184_60828_LINUX.zip $ cd 8888184 $ sh patch.sh

          
   - Relink f60webmx for Oracle Applications
   

   $ adrelink.sh force=y "fnd f60webmx"

   
   
7. Apply patch 7329300- Unzip patch file + Apply patch
   

   $ unzip p7329300_60828_LINUX.zip $ cd 7329300 $ sh patch.sh

          
   - Relink f60webmx for Oracle Applications
   

   $ adrelink.sh force=y "fnd f60webm

8. Apply patch 7552880- Unzip patch file + Apply patch
   

   $ unzip p7552880_60828_LINUX.zip $ cd 7552880 $ sh patch.sh

          
   - Relink f60webmx for Oracle Applications
   

$ adrelink.sh force=y "fnd f60webm

10. Relink applications executables - Run adadmin
    - Select (2) "Maintain Applications Files Menu"
    - Select (1) "Relink Applications programs"
    - List of product to link: fnd - Generate specific executables …: Yes - Relink with debug: No
    - Enter executables to relink: f60webmx ar60run ar60runb ar60rund
     
    
11. Apply patch 9935935 (Apps Interoperability) - Unzip patch file
    

    $ unzip p9935935_11i_GENERIC.zip

           
    - Enable maintenance mode: adadmin -> (5) Change Maintenance Mode -> (1) Enable Maintenance Mode
    - apply patch with adpatch
    - Disable maintenance mode: adadmin -> (5) Change Maintenance Mode -> (2) Disable Maintenance Mode
     
    
12. Verify your upgrade - Check the timestamp for the following files:
    

    $ cd $OA_JAVA/oracle/apps/fnd/jar $ ll fndforms.jar fndewt.jar

            
    If the timestamp is not current - run adadmin =>Generate Applications Files menu => Generate Product JAR Files. 
     
    
13. Start all applications processes (adstrtall.sh) - You can also verify your upgrade by login to forms responsibility -> Help -> About Oracle Applications
      You should see: Oracle Forms version : 6.0.8.28

Related - Note 125767.1 - Upgrading Developer 6i with Oracle Applications 11i.

Install Oracle Apps R12 on Linux

Part -1pre-installation-steps-for-oracle-r12
Part -2
The Oracle Applications Rapid Install Wizard, more commonly called RapidWiz, drives the EBS installation process. If you're accustomed to using the Oracle Universal Installer, you'll find that RapidWiz "feels" a bit different, but it still has that comforting grey, "It  Is a Java-based Oracle software installer!" look to it.

Step 1: Launching RapidWiz
Log in to your Linux server's desktop as root, not oracle. Open a terminal window and change to the startCD/Disk1/rapidwiz subdirectory of the software staging area

Run the rapidwiz utility in that directory:

[root@londo R12stage]# cd startCD/Disk1/rapidwiz/

[root@londo rapidwiz]# ./rapidwiz

You should see a few launch messages in your terminal window, and the welcome screen of the installer will appear. Click Next:

Step 2: Select installation type
In the Wizard Operations window, make sure that "Install Oracle Applications" is selected, but do not check the Express Install box. Click Next:

Step 3: OCM configuration
In the Oracle Configuration Manager window, leave all the fields and options blank, and click Next. OCM is not a complication we need right now.

Step 4: Configuration Choice
Since this is a new install, select the first option ("Create a new configuration") in the Configuration Options window and click Next.

Step 5: Port pool assignment
Select a number between 0 and 99 from the port pool list

 

Step 6: Database node configuration
Now we're finally getting to the fun bits! In the Database Node Configuration window, verify that the following fields have correct values:

• Database type is "Vision Demo Database"
• Hostname and domain name match the host and domain names on your Linux server. If you've configured this correctly in /etc/hosts and /etc/sysconfig/network, RapidWiz should pull the correct values.
• The Operating System value should match your server's platform (Linux x86 or Linux x86-64)

Change the following fields as necessary:

• Database SID: You can leave this at the default (VIS), or change it if you prefer.   
• Database OS user: The OS user you created in part 1 as the owner of the Oracle software (e.g. oravis)
• Database OS group: Change to oinstall
• Base Directory: This should be set to a directory in the Very Large Mount Point(tm) that you created in part 1. RapidWiz doesn't exactly conform to the OFA standard, but if you're picky about such things, you can click the "Edit Paths" button for finer control over where things go. I'm usually picky, but for the sake of saving you a few more screenshots, I'm letting RapidWiz decide where to file everything this time.

Note: If your specified base directory doesn't exist, you'll need to create it.

Make sure to change the ownership, and to grant write permissions to the oinstall group:

[root@londo rapidwiz]# cd /u01

[root@londo u01]# mkdir -m 775 -p ebs/R12VIS

[root@londo u01]# chown -R oravis:oinstall ebs

[root@londo u01]# ls -lR ebs

Click OK once you've created the base directory, make sure the installer has retained your other configuration settings, and click Next.

Step 7: Applications node configuration
The next window, "Primary Applications Node Configuration," takes most of its values from the database node configuration. You'll need to change the values of Apps OS user and Apps OS group to match the ones created in part 1 of this series. Everything else should be fine; you'll just need to verify. Again, if you want to tinker with specific locations in the installation, you can click the Edit Paths button, but that's beyond the scope of these instructions. Oh yeah, and click Next when you're done.

Step 8: Node information review
The Node Information window presents a review of the servers you've configured so far, and offers the option to add an additional server. Adding a server would be useful in the case of multi-node installations, but for now, just click (what else?) Next:

Step 9: Pre-install system checks
RapidWiz will pop up a window showing the system checks it is performing prior to installation. Basically, it's making sure that the necessary ports are open for the applications and database to run, that there's enough disk space to install, that it can write to all its directories, etc. After the checks are done, a Pre-Install Checks results window will appear. Hopefully you'll see all green checkmarks, as below. If you see red X's next to any of the test categories, click on the X to see a log from the test run, find and fix the errors, and click the Retry button to re-run the tests. Once all tests have been run successfully, click Next.

Step 10: The actual installation part
Click Next at the Install Review window, then Yes in the inevitable "are you sure you want to install?" box, and you're off to the races! Or maybe off to run some errands while blue bars crawl across the installer windows for a few hours, whichever. You'll notice that the terminal window from which you launched RapidWiz will display some information about where it's writing out log files. Hopefully we won't need those, because the installation will just go swimmingly, right?

Step 11: Post-install checks
After a while (probably a few hours, depending on how speedy your server is) the installation will complete, and post-install checks will begin. If some of the post-install checks are listed as failed initially, don't be too worried. The initial startup of E-Business Suite can pretty resource-intensive, and it's not unusual for some of the post-install checks to time out waiting for responses from web pages, or for application server components themselves to time out when starting up. Keep in mind that you're installing software intended to run on server-class hardware, and your server might be under spec somewhere (disk speed, CPU, memory).

Here's what my post-install checks looked like the first time around. Ouch.  As with the pre-install checks, you can click on the icons to see more about the failed checks. I'll spare you all 5 screenshots, but in this case, all the messages have the same theme: HTTP server taking too long to respond.

Step 12: A troubleshooting interlude
My poor 2-CPU "server" had a load average above 10 when the post-install checks first ran, and a ridiculous level of I/O wait (thanks, 5400RPM hard drive!), so the first thing I did was to wait until the system has settled down a bit, and then click the Retry button. Unfortunately, the outcome of the post-install checks didn't change, so I had to look into fixing the web server. What follows may not be applicable to your install situation, but it does provide a small taste of basic Oracle Applications troubleshooting, so please bear with me. If you get bored, or if your post-install checks were all successful, you can always skip ahead to step 14. ;-)

The first thing I did was to log in as the owner of the Oracle Applications software, applvis in this case. Then, I set up the OS environment to be able to better navigate the various sections of the Apps filesystem. You'll often hear this called "sourcing the Apps environment."

[root@londo ~]# su - applvis

[applvis@londo ~]$ . /u01/ebs/R12VIS/apps/apps_st/appl/R12VIS_londo.env

If you don't feel like digging through the documentation to find out where the Apps environment file should be for your system, you can find the value from the result of the "Environment File" post-install check. The output from that check lists a number of environment files; the one that's relevant here is the "APPL_TOP environment file." Using the newly-defined environment variables, I checked the status of the 10g Application Server components and tried to restart the web server:

[applvis@londo ~]$ $ADMIN_SCRIPTS_HOME/adopmnctl.sh status

You are running adopmnctl.sh version 120.6

Checking status of OPMN managed processes...

Processes in Instance: R12VIS_londo.londo.local



error while loading shared libraries: 

libdb.so.2: cannot open shared object file: No such file or directory

That missing shared object library file is the most likely culprit. This often, but not always, means that there's a required OS package missing. In this case, a review of the installed packages on my server didn't show anything missing, so I turned to Google and My Oracle Support. I quickly found a handful of references in OTN forums and Oracle's non-EBS documentation to a quirk of installing R12.1 on 64-bit Oracle Enterprise Linux 5. One symlink later, and I was on my way:

[root@londo ~]# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

[applvis@londo ~]$ $ADMIN_SCRIPTS_HOME/adapcctl.sh start

You are running adapcctl.sh version 120.7.12010000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance ...

opmnctl: opmn is already running.

opmnctl: starting opmn managed processes...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile 

/u01/ebs/R12VIS/inst/apps/R12VIS_londo/logs/appl/admin/log/adapcctl.txt for more information ...

[applvis@londo ~]$ $ADMIN_SCRIPTS_HOME/adopmnctl.sh status

You are running adopmnctl.sh version 120.6

Checking status of OPMN managed processes...Processes in Instance: R12VIS_londo.londo.local

---------------------------------+--------------------+---------+---------

ias-component                    | process-type       |     pid | status

---------------------------------+--------------------+---------+---------

OC4JGroup:default_group          | OC4J:oafm          |   10677 | Alive

OC4JGroup:default_group          | OC4J:forms         |   12390 | Alive

OC4JGroup:default_group          | OC4J:oacore        |   10505 | Alive

HTTP_Server                  | HTTP_Server     |  29299 | Alive  

After that, the post-install checks all came back green. Which is good, because I hadn't clicked Next in a while:
Step 14: Grand Finale
(what, you thought I'd risk the whole exercise by ending on step 13?)
And now, after hours of downloads and nigh-endless unzipping, the EBS install is done! That tempting "Connect to Oracle Applications Release 12.1.1" button may work, but if it doesn't, don't despair. Click Finish, open a web browser, and go the URL http://server.domain:80nn. The value for nn is the "port pool" value you selected in the early stages of the installation. Hopefully you know what "server" and "domain" are.  For example, when I browse to http://londo.local:8055, I am redirected to the main login page for EBS:

If you want to start looking around a little bit, the "superuser" for Oracle Applications is SYSADMIN, and the default password for the account is the same as the username. If you attempt to launch any of the Oracle Forms-based parts of the Apps interface from a browser on your Linux server, you may run into trouble. The EBS Forms interface is famously finicky on Linux-based browsers; I usually access EBS from browser on a Windows or OS X desktop, rather than from Linux, but the OTN forums are full of tips on how to get EBS Forms working on Linux.

PRE INSTALLATION STEPS FOR ORACLE R12

This series of posts will cover a Vision install of Oracle Applications 12.1.1 on Linux. In this installment, I'll discuss requirements and acquiring the software. Subsequent posts will cover the installation of the software and actually using your shiny new E-Business Suite system.

Requirements

1. A Linux machine (physical or virtual).
2. At least 2GB of memory. 3GB would be better. If your machine is on the low end of this list, don't expect to use it for anything else while EBS is running.
3. Lots of disk space. At least 290GB. set aside 400GB for other propose(like backup )

.

Recommendations

1. Install on a version of Linux that is supported/certified for use with EBS. I'm going to be using Redhat Enterprise linux 4 or Oracle Enterprise Linux 5, Update 4 (64-bit) or (32-bit) for this install, but there are other options, listed in My Oracle Support Doc ID 761566.1: Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 (32-bit Linux users can check out My Oracle Support Note 761564.1) It may be possible to install EBS on your favorite flavor of Linux, but that's not what this particular adventure is all about.
2. Consider installing EBS in a virtual machine, using VMware or Virtualbox. There are serious advantages to doing this, in my opinion, particularly if, like me, you'll be installing on your primary workstation.
3. Get familiar with some of the documentation while you're downloading the massive software distribution and building and/or patching your Linux environment to get up to spec. You'll find a reference list at the end of this post.

Preparing the OS
When laying out the disk space for your Linux server, allocate your preferred amount of space for swap and the operating system (I usually set aside about 10GB), 260-275GB for the /u01 partition (where we'll be installing the EBS software and database), and 50GB for the stage directory for the installer (I usually mount this to /mnt/R12stage). Needless to say, a production system's layout would be more refined/detailed, but if you're reading this guide as a roadmap to a production deployment, you need to stop immediately and have your head examined.

Install packages and set kernel parameters according to the appropriate section in the Release Notes referenced above. If you don't have access to My Oracle Support, you're in a bit of a tough spot, but here are some thoughts:

• Version R12.1 of EBS comprises Oracle RDBMS 11.1.0.7, Oracle Developer 10g, and two versions of Oracle Application Server 10g (ahem, excuse me, Fusion Middleware): 10.1.2.3 and 10.1.3.4. Presumably, combining the installation requirements for those products will get you most of the way to a full set of required packages and kernel parameters.
• Similarly, installing all the packages that come with your OS distribution should get you almost all of the installation requirements.
• The oracle-validated RPM seems to cover many, but not all, of the software and kernel parameter requirements for Oracle Enterprise Linux.
• One point that bears mentioning (and has been discussed pretty openly in the OTN forums, so it's not like I'm giving away any deep My Oracle Support secrets) is that an old version of openmotif libraries is required for this install. The name of the package varies by OS distribution, but the version number is what's important: it has to be version 2.1. If you go with the install-everything route, be sure to remove any competing openmotif packages.

Create two OS users, one to own the Oracle RDBMS software, and one to own the Apps software. Oracle recommends oraSID and applSID, respectively, where SID is all or part of the database SID that you designate during installation. For example, since we'll be doing a Vision install, it would be appropriate to create users oravis and applvis. It's a good idea to make sure that both users share the same primary group, usually the oinstall group. Also, create a dba group and assign it to the Oracle RDBMS software owner as an additional (not primary) group.

Acquiring and staging the software
E-Business Suite software can't be found on Oracle Technet (OTN). You can either purchase the media from the Oracle Store, or download it from Oracle's E-Delivery site. I'll assume you'll be downloading from E-Delivery. Two things worth noting here:

After logging in to E-Delivery, select "E-Business Suite" in the Product Pack dropdown, and select your desired installation platform (Linux x86 or Linux x86-64). Click Go to search, and click the "Oracle E-Business Suite Release 12.1.1 Media Pack" link to get to the downloads page. Don't pick the "Upgrade Media" link, unless you really intend to upgrade, in which case you really shouldn't be reading this.

You don't need to download all of the files listed on the page, but you're still going to be grabbing about 45GB. You might want to fix yourself a snack while you wait. The media is separated as if to be burned to DVD. For this exercise, however, we won't be burning DVDs. Be sure to grab all of the parts labelled:

• "Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Start Here"
• "Rapid Install RDBMS - Disk 1" "Rapid Install Databases - Disk 1" through "Rapid Install Databases - Disk 9," inclusive
• "Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Tools - Disk 1"
• "Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install APPL_TOP - Disk 1"
• "Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install APPL_TOP - Disk 2"

When I sent these instructions to Chet, he did the smart thing and created a spreadsheet to track his downloads. He's been kind enough to share it on Google Docs. Note that your part numbers may be different if you decide to go with 64-bit Linux instead of 32-bit.

Once you have all of the media, unzip the files into the stage directory on your Linux server. When the unzip utility asks if you want to replace dvd.label or component.label files, answer yes. If you get any other errors from unzip, you may have a corrupt download, and should re-download that zip file. Don't assume you can work around it. Once you've unpacked all of the files, your stage directory should look like this:

[root@londo R12stage]# ls

oraAppDB  oraApps  oraAS  oraDB  startCD

• At this point, you'll be ready to start the installation (finally!). Hopefully, by the time you're done building your Linux server and downloading and staging the EBS software, the next installment in this series will be up.

Installation of oracle apps 11.5.10.2

Installing Oracle Applications 11.5.10.2 on Oracle Enterprise Linux 5.3

Description :

This Documentations covers the details about the patches which we need to download and the process of applying patches and also step by step installation process for Oracle Apps 11.5.10.2 on OEL5.3d

• Install the following non-standard packages:
  
  The following packages are not part of the OEL 5 or RHEL 5 distribution media and must be installed manually:
  
  * compat-libstdc++-egcs-1.1.2-11
  * compat-libcwait-2.1-11
  * compat-oracle-el5-1.0-51
  * openmotif21-2.1.30-11.EL51
  * binutils-2.152
  
  The following packages must be installed from the OEL 5 or RHEL 5 distribution media:
  
  * libXp-1.0.0-8.1.el5
  * compat-libgcc-296-2.96-138
  * compat-libstdc++-33-3.2.3-61
  * compat-db-4.2.52-5.1
  
  → Comment out the /lib/libcwait.so line from /etc/ld.so.preload
  
  For Oracle Enterprise Linux 5, Red Hat Enterprise Linux 5 and SUSE Linux Enterprise Server 10 customers, the LD_ASSUME_KERNEL environment variable should be unset before starting the installation. The installation fails when the LD_ASSUME_KERNEL variable is set by the adgetlnxver.sh file during the course of the installation. Patch 6365595 contains the fix for adgetlnxver.sh file. The procedure below is a guideline for replacing the adgetlnxver.sh file in the Oracle Applications 11i shiphome.
• 1. Download the patch 6365595 from OracleMetalink.
  
  2. Follow the Oracle Applications Installation guide and set up the stage area.
  
  3. Set the STAGE_TOP environment variable to the top level directory of the stage area that contains the subdirectories startCD, oraApps, oraDB, oraiAS and oraAppDB. Make sure that the stage area is read writable.
  
  # export STAGE_TOP=/stage/software/stage11i10.2
  # export PATCH_TOP=/stage/software/stage11i10.2/oel5rpms/6365595
  
  4. Create the following directories in the stage area.
  # mkdir -p $STAGE_TOP/oraDB/Disk3/db/stage/appsutil/bin
  # mkdir -p $STAGE_TOP/oraApps/Disk5/appl/stage/bin
  5. Copy the adgetlnxver.sh file in the patch 6365595 to the following directories created in earlier step.
  # cp -p $PATCH_TOP/ad/bin/adgetlnxver.sh $STAGE_TOP/oraDB/Disk3/db/stage/appsutil/bin
  # cp -p $PATCH_TOP/ad/bin/adgetlnxver.sh $STAGE_TOP/oraApps/Disk5/appl/stage/bin
  
  6. Update the zip archive with the fix (adgetlnxver.sh file).
  # cd $STAGE_TOP/oraDB/Disk3/db/stage
  # zip -u dboh0_appsutil appsutil/bin/adgetlnxver.sh
  # cd $STAGE_TOP/oraApps/Disk5/appl/stage
  # zip -u ad_CORE bin/adgetlnxver.sh
• Download and apply the OS library patch 6078836 from OracleMetaLink and create the following symbolic link:
  # ln -s /usr/lib/libdb.so.2 /usr/lib/libdb.so.3
  
  # Verify that the host name setting is correct. The command should return a fully qualified host name. For example: <host_name>.<domain_name>.
  
  # hostname -f

• add the following to .bash_profile for oracle and applmgr users and execute in the root session doing the install:
  
  export LD_PRELOAD32=/lib/libcwait.so
  export KSH_VERSION='PD KSH'
  export LDEMULATION='elf_i386'
• For Oracle Enteprise Linux and Red Hat Enteprise Linux 5 Update 3 (5.3), users will see a failure when running Rapid Install. Users must edit the file $STAGE_TOP/startCD/Disk1/rapidwiz/bin/runWizard.sh and comment out lines 122-125, as in:
  
  # if test "$exit_code" == "0" ; then
  # LD_ASSUME_KERNEL=2.4.19
  # export LD_ASSUME_KERNEL
  # fi
• If we get the Error RW-50004: Error code received when running external process

Create Softlink for a library file shown as below

# cd /usr/lib

# ln -sf libstdc++-3-libc6.2-2-2.10.0.so libstdc++-libc6.1-1.so.2

• Reboot the system and start the rapid installation process
• Reference link
  Documentation for installing Oracle Applications 11.5.10.2 on Oracle Enterprise Linux 5.3
  
  
  Description :
  This Documentations covers the details about the patches which we need to download and the process of applying patches and also step by step installation process for Oracle Apps 11.5.10.2 on OEL5.3d
  
  
• Install the following non-standard packages:
  
  The following packages are not part of the OEL 5 or RHEL 5 distribution media and must be installed manually:
  
  * compat-libstdc++-egcs-1.1.2-11
  * compat-libcwait-2.1-11
  * compat-oracle-el5-1.0-51
  * openmotif21-2.1.30-11.EL51
  * binutils-2.152
  
  The following packages must be installed from the OEL 5 or RHEL 5 distribution media:
  
  * libXp-1.0.0-8.1.el5
  * compat-libgcc-296-2.96-138
  * compat-libstdc++-33-3.2.3-61
  * compat-db-4.2.52-5.1
  
  → Comment out the /lib/libcwait.so line from /etc/ld.so.preload
  
  For Oracle Enterprise Linux 5, Red Hat Enterprise Linux 5 and SUSE Linux Enterprise Server 10 customers, the LD_ASSUME_KERNEL environment variable should be unset before starting the installation. The installation fails when the LD_ASSUME_KERNEL variable is set by the adgetlnxver.sh file during the course of the installation. Patch 6365595 contains the fix for adgetlnxver.sh file. The procedure below is a guideline for replacing the adgetlnxver.sh file in the Oracle Applications 11i shiphome.
• 1. Download the patch 6365595 from OracleMetalink.
  
  2. Follow the Oracle Applications Installation guide and set up the stage area.
  
  3. Set the STAGE_TOP environment variable to the top level directory of the stage area that contains the subdirectories startCD, oraApps, oraDB, oraiAS and oraAppDB. Make sure that the stage area is read writable.
  
  # export STAGE_TOP=/stage/software/stage11i10.2
  # export PATCH_TOP=/stage/software/stage11i10.2/oel5rpms/6365595
  
  4. Create the following directories in the stage area.
  # mkdir -p $STAGE_TOP/oraDB/Disk3/db/stage/appsutil/bin
  # mkdir -p $STAGE_TOP/oraApps/Disk5/appl/stage/bin
  5. Copy the adgetlnxver.sh file in the patch 6365595 to the following directories created in earlier step.
  # cp -p $PATCH_TOP/ad/bin/adgetlnxver.sh $STAGE_TOP/oraDB/Disk3/db/stage/appsutil/bin
  # cp -p $PATCH_TOP/ad/bin/adgetlnxver.sh $STAGE_TOP/oraApps/Disk5/appl/stage/bin
  
  6. Update the zip archive with the fix (adgetlnxver.sh file).
  # cd $STAGE_TOP/oraDB/Disk3/db/stage
  # zip -u dboh0_appsutil appsutil/bin/adgetlnxver.sh
  # cd $STAGE_TOP/oraApps/Disk5/appl/stage
  # zip -u ad_CORE bin/adgetlnxver.sh
• Download and apply the OS library patch 6078836 from OracleMetaLink and create the following symbolic link:
  # ln -s /usr/lib/libdb.so.2 /usr/lib/libdb.so.3
  
  # Verify that the host name setting is correct. The command should return a fully qualified host name. For example: <host_name>.<domain_name>.
  
  # hostname -f

• add the following to .bash_profile for oracle and applmgr users and execute in the root session doing the install:
  
  export LD_PRELOAD32=/lib/libcwait.so
  export KSH_VERSION='PD KSH'
  export LDEMULATION='elf_i386'
• For Oracle Enteprise Linux and Red Hat Enteprise Linux 5 Update 3 (5.3), users will see a failure when running Rapid Install. Users must edit the file $STAGE_TOP/startCD/Disk1/rapidwiz/bin/runWizard.sh and comment out lines 122-125, as in:
  
  # if test "$exit_code" == "0" ; then
  # LD_ASSUME_KERNEL=2.4.19
  # export LD_ASSUME_KERNEL
  # fi
• If we get the Error RW-50004: Error code received when running external process

Create Softlink for a library file shown as below

# cd /usr/lib

# ln -sf libstdc++-3-libc6.2-2-2.10.0.so libstdc++-libc6.1-1.so.2

• Reboot the system and start the rapid installation process
• 
                                          
  
  
  

Upgrading 9i Database to 10g for Oracle Applications11i

For Oracle Applications 11i installation, the database version that comes is 9.2.0
This post is to give a brief and clear steps for upgrading your database to 10.2.0
Instance Details
Here are the details for the Oracle Application I am trying on
Oracle Application Version: 11.5.10 CU2
Oracle Database Version: 9.2.0
Since its a 11.5.10 CU2, its autoconfig enabled. So we have to make sure that we need to make new Oracle Home also autoconfig enabled. For more information on autoconfig, please refer to metalink note ID 165195.1
The below steps are summarized from metalink note ID 423056.1.
To begin with I will briefly explain the procedure in 3 major steps.
1) Pre-Upgrade
2) Upgrade
3) Post-Upgrade
Pre-Upgrade Step:
1) Check the current database version:
For upgrading the database, you need to check the exact version of the current database and based on that check the upgrade path.
Below is the brief compatibility matrix. Reference Metalink note ID 316889.1.
COMPATIBILITY MATRIX
====================
+ Minimum Version of the database that can be directly upgraded to Oracle 10g Release 2
8.1.7.4 -> 10.2.X.X.X
9.0.1.4 or 9.0.1.5 -> 10.2.X.X.X
9.2.0.4 or higher -> 10.2.X.X.X
10.1.0.2 or higher -> 10.2.X.X.X
+ The following database version will require an indirect upgrade path.
7.3.3 (or lower) -> 7.3.4 -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X
7.3.4 -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X
8.0.n -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X
8.1.n -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X
SQL> select banner from v$version;
BANNER
—————————————————————-
Oracle9i Enterprise Edition Release 9.2.0.5.0 – Production
PL/SQL Release 9.2.0.5.0 – Production
CORE 9.2.0.6.0 Production
TNS for Linux: Version 9.2.0.5.0 – Production
NLSRTL Version 9.2.0.5.0 – Production
Since in my case its 9.2.0.5, I can directly upgrade to 10.2.0
2) Check the application version:
Oracle Application version should be above 11.5.9 (11.5.10 CU2 in my case).
SQL> SELECT product_group_id GroupID, product_group_name GroupName,
release_name Release, product_group_type GroupType, argument1
FROM fnd_product_groups;
GROUPID GROUPNAME
———- ————————————————————
RELEASE
————————————————–
GROUPTYPE ARGUMENT1
—————————— ——————————
1 Default product group
11.5.10
Standard
Check the developer 6i Patch set.
refer metalink no:[ID 125767.1]
3) Check the latest autoconfig patch:
Check if the autoconfig latest patch is applied to your environment or not. Metalink note ID 165195.1
The latest patch mention in this note is 5985992. So if this patch is not applied then please apply this patch on application system.

SQL> select count(*) from ad_bugs
2 where bug_number = ’5985992′;

COUNT(*)
———-
1
4) Apply either

• Oracle Applications Release 11.5.9 (without Oracle Demand Planning)¹
• 11.5.9 E-Business Suite Consolidated Update 2
• 10g Release 2 interoperability patch for 11.5.9 (4653217)
  

or

• 11.5.10 E-Business Suite Consolidated Update 2
• 10g Release 2 interoperability patch for 11.5.10 (4653225)
  

¹If you are using Oracle Demand Planning, your Applications version must be 11.5.10 in order to use Oracle Database 10g Release 2. The 11.5.9 version of Oracle Demand Planning is not certified against Oracle Database 10g Release 2.Upgrade Step:
1) Install Oracle Database 10g. (Software Only).
2) Since you are upgrading the 9i database to 10g database, you have to install 10g software to some different Oracle Home. So create a new Oracle Home 10.2.0 and install the software in that location.
Example if the currect 9i Oracle home location is
9i Oracle Home: /u01/app/oracle/apps11idb/9.2.0
10g Oracle Home: /u01/app/oracle/apps11idb/10.2.0
3) Create nls/data/9idata directory:
This can be done using $ORACLE_HOME/nls/data/old/cr9idata.pl script
Here ORACLE_HOME refers to 10g ORACLE_HOME.
[oracle@ocvmrh2064 old]$ export ORACLE_HOME=/u01/app/oracle/apps11idb/10.2.0
[oracle@ocvmrh2064 old]$ perl cr9idata.pl
Creating directory //u01/app/oracle/apps11idb/10.2.0/nls/data/9idata …
Copying files to //u01/app/oracle/apps11idb/10.2.0/nls/data/9idata…
Copy finished.
Please reset environment variable ORA_NLS10 to //u01/app/oracle/apps11idb/10.2.0/nls/data/9idata!
[oracle@ocvmrh2064 old]$ export ORA_NLS10=/u01/app/oracle/apps11idb/10.2.0/nls/data/9idata
4) Next Step is to perform database upgrade.
Reference used is the upgrade docs

a) copy the script utlu102i.sql provided in new Oracle Home 10g to some temporary location and run the same in your existing 9i database.

[oracle@ocvmrh2064 admin]$ pwd
/u01/app/oracle/apps11idb/10.2.0/rdbms/admin
[oracle@ocvmrh2064 admin]$ cp utlu102i.sql /tmp/

**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
WARNING: –> “streams_pool_size” is not currently defined and needs a value of
at least 50331648
WARNING: –> “large_pool_size” needs to be increased to at least 8388608
WARNING: –> “session_max_open_files” needs to be increased to at least 20

copy the init.ora parameter file from old ORACLE_HOME to new ORACLE_HOME

Set the above parameters in the new init.ora parameter file you copied to 10g ORACLE_HOME

**********************************************************************
SYSAUX Tablespace:
[Create tablespace in the Oracle Database 10.2 environment]
**********************************************************************
–> New “SYSAUX” tablespace
…. minimum required size for database upgrade: 500 MB
SQL> create tablespace sysaux datafile ‘/u01/app/oracle/apps11idata/sysaux01.dbf’ size 1000M
2 extent management local segment space management auto;

Tablespace created.

TIMESTAMP WITH TIMEZONE Datatype:

The time zone files that are supplied with Oracle Database 10g have been updated from version 1 to version 2 to reflect changes in transition rules for some time zone regions. The changes may affect existing data of TIMESTAMP WITH TIME ZONE datatype. To preserve this TIMESTAMP data for updating according to the new time zone transition rules, you must run the utltzuv2.sql script on the database before upgrading. This script is located in the new 10.2 ORACLE_HOME/rdbms/admin directory. This script analyzes your database for TIMESTAMP WITH TIME ZONE columns that are affected by the updated time zone transition rules.

If the utltzuv2.sql script identifies columns with time zone data affected by a database upgrade, then back up the data in character format before you upgrade the database. After the upgrade, you must update the tables to ensure that the data is stored based on the new rules. If you export the tables before upgrading and import them after the upgrade, the conversion will happen automatically during the import.

SQL> @?/../10.2.0/rdbms/admin/utltzuv2.sql
DROP TABLE sys.sys_tzuv2_temptab
*
ERROR at line 1:
ORA-00942: table or view does not exist

Table created.

Query sys.sys_tzuv2_temptab Table to see if any TIMEZONE data is affected by
version 2 transition rules

PL/SQL procedure successfully completed.

Commit complete.

SQL> select * from sys.sys_tzuv2_temptab;

no rows selected

b) Shutdown the database and start it again. Run the pre-upgrade utility again to check if every thing is alright before staring the upgrade.

c) Shutdown all the process on mid tier and database tier

d) Shutdown the listener process for 9i database.

e) connect to database using 10g Oracle Home.

[oracle@ocvmrh2064 9.2.0]$ export ORACLE_HOME=/u01/app/oracle/apps11idb/10.2.0
[oracle@ocvmrh2064 9.2.0]$ sqlplus “/as sysdba”

Message 133 not found; product=SQLPlus; facility=SP2
: Release 9.2.0.5.0 – Production on Sun Oct 14 04:30:52 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL>

You might face the issue mentioned above. This is becase the PATH variable is not having the new ORACLE_HOME/bin path.

[oracle@ocvmrh2064 9.2.0]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@ocvmrh2064 9.2.0]$ sqlplus “/as sysdba”

SQL*Plus: Release 10.2.0.1.0 – Production on Sun Oct 14 04:33:09 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL>

f) Start the upgrade process

SQL> startup upgrade
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 591396864 bytes
Fixed Size 1220700 bytes
Variable Size 415240100 bytes
Database Buffers 163577856 bytes
Redo Buffers 11358208 bytes
Database mounted.
Database opened.
SQL> SPOOL upgrade.log
SQL> @catupgrd.sql

Oracle Database 10.2 Upgrade Status Utility 10-14-2007 06:32:36
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.1.0 00:55:04
JServer JAVA Virtual Machine VALID 10.2.0.1.0 00:06:53
Oracle XDK VALID 10.2.0.1.0 00:08:38
Oracle Database Java Packages VALID 10.2.0.1.0 00:00:44
Oracle Text VALID 10.2.0.1.0 00:01:20
Oracle XML Database VALID 10.2.0.1.0 00:02:50
Oracle Real Application Clusters INVALID 10.2.0.1.0 00:00:01
Oracle Data Mining VALID 10.2.0.1.0 00:00:30
OLAP Analytic Workspace VALID 10.2.0.1.0 00:00:25
OLAP Catalog VALID 10.2.0.1.0 00:01:32
Oracle OLAP API VALID 10.2.0.1.0 00:01:01
Oracle interMedia INVALID 10.2.0.1.0 00:09:37
Spatial INVALID 10.2.0.1.0 00:09:24
.
Total Upgrade Time: 01:52:15

g) After the upgrade is over, there will be many invalid objects, which we have to compile. Please use utlrp.sql to compile the invalids.

Once the invalids are compiled, the next step is to make the database autoconfig enabled. This are brifly explaind in post upgrade section.
Post Upgrade Steps:
1) Copy the .env file present in 9i Oracle Home to 10g oracle home.
2) Change all the 9.2.0 reference to 10.2.0 reference.
Source the .env file.
3) Restart the database again.
4) On the application tier run the below command to generate appsutil.zip file.
perl <AD_TOP>/bin/admkappsutil.pl
5) Copy the appsutil.zip file generated on application tier to the database tier inside 10g Oracle Home.
unzip the appsutil.zip file.
6) Next step is to create a context file on database tier. Run the below commands with appropriate values. This will generate context file on database tier.
cd $ORACLE_HOME/appsutil
perl adbldxml.pl tier=db appsuser=<APPSuser> appspasswd=<APPSpwd>
Please note that above oracle home we are selecting is 10g Oracle home.
==========================================================
While running adbldxml.pl you might encounter following issue.
[oracle@ocvmrh2081 bin]$ perl adbldxml.pl tier=db appsuser=apps appspasswd=apps
Starting context file generation for db tier..
Using JVM from /u01/app/oracle/proddb/10.2.0/jdk/bin/java to execute java programs..
The log file for this adbldxml session is located at:
/u01/app/oracle/proddb/10.2.0/appsutil/log/adbldxml_02172131.log
UnsatisfiedLinkError exception loading native library: njni10
Could not Connect to the Database with the above parameters, Please answer the Questions below
Enter Hostname of Database server: OCVMRH2081.us.oracle.com
Enter Port of Database server: 1521
Enter SID of Database server: PROD
Could not Connect to the Database : ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
Could not Connect to the Database with the above parameters, Please answer the Questions below
Enter Hostname of Database server[OCVMRH2081.us.oracle.com]:
Enter Port of Database server[1521]:
and it will keep on asking the same questions.
The reason for such error is becasue adbldxml.pl is not able to make connection to your database. This is because of listener issue.
- If you do “echo $TNS_ADMIN”, it will point to your 9i ORACLE_HOME.
- Now what you have to do is to copy the <SID_hostname> directory present under 9i ORACLE_HOME/network/admin to new 10g ORACLE_HOME/netwrok/admin
- Make all the references to 9i ORACLE_HOME to 10g ORACLE_HOME in listener.ora
- make sure that listener started from 9i ORALCE_HOME is stopped from 9i ORACLE_HOME only
- Start the listner from 10g ORACLE_HOME. Then try running adbldxml.pl. This should work.
==========================================================
7) Once the context file is created on db tier, run autoconfig.
cd $ORACLE_HOME/appsutils/bin
adconfig.sh contextfile=<CONTEXT> appspass=<APPSpwd>
This completes the migeration to 10g database

plz refer weblink: