How to Upgrade Oracle Application server 10g (10.1.3) in R12 (12i/EBS)

Currently we are having OEL 5.0,Realese R12.0.4 and application server version as 10.1.3.0 we followed all the steps in the metalink doc-:454811.1 and while applying the patch no. 7272722.
The runinstaller in its intials step threw a error
“There are no patches that need to be applied from the patchset 10.1.3.4.0”
so could you please help us???…

Pinaki,
Did you check version of OAS in R12 via runInstaller and opatch (Paste output here) ?

Did you change ORACLE_HOME to 10.1.3 instead of 10.1.2 before running runInstaller ?

Update runInstaller (7272722 patcgh) log here

Atul,

Thanks for your quick reply.

As mentioned above we have found the OAS VERSION using OPATCH in the application tier with some error tagged.However, an error of command not found was reflected when we used the same in the database tier.

1)SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
——————————————–
12.0.4

Kindly check the output

2)appsuser@xxx scripts]$ opatch lsinventory -detail

Oracle Interim Patch Installer version 1.0.0.0.55
Copyright (c) 2006 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com

Oracle Home = /home/appsuser/VIS/apps/tech_st/10.1.3
Location of Oracle Universal Installer components = /home/appsuser/VIS/apps/tech_st/10.1.3/oui
Location of OraInstaller.jar = “/home/appsuser/VIS/apps/tech_st/10.1.3/oui/jlib”
Oracle Universal Installer shared library = /home/appsuser/VIS/apps/tech_st/10.1.3/oui/lib/linux/liboraInstaller.so
Location of Oracle Inventory Pointer = /etc/oraInst.loc
Location of Oracle Inventory = /home/appsuser/VIS/apps/tech_st/10.1.3/inventory
Path to Java = /home/appsuser/VIS/apps/tech_st/10.1.3/jre/1.4.2/bin/java
Log file = /home/appsuser/VIS/apps/tech_st/10.1.3/.patch_storage//*.log

Creating log file “/home/appsuser/VIS/apps/tech_st/10.1.3/.patch_storage/LsInventory__03-20-2009_10-31-50.log”

Result:

LsInventory: OPatch Exception while accessing O2O

OPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred:
OPatch Exception:
OUI found no such ORACLE_HOME set in the environment
Can not get details for given Oracle Home
An exception occurs
null

PRODUCT NAME appsuser@xxx scripts]$ opatch lsinventory -detail

Oracle Interim Patch Installer version 1.0.0.0.55
Copyright (c) 2006 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com

Oracle Home = /home/appsuser/VIS/apps/tech_st/10.1.3
Location of Oracle Universal Installer components = /home/appsuser/VIS/apps/tech_st/10.1.3/oui
Location of OraInstaller.jar = “/home/appsuser/VIS/apps/tech_st/10.1.3/oui/jlib”
Oracle Universal Installer shared library = /home/appsuser/VIS/apps/tech_st/10.1.3/oui/lib/linux/liboraInstaller.so
Location of Oracle Inventory Pointer = /etc/oraInst.loc
Location of Oracle Inventory = /home/appsuser/VIS/apps/tech_st/10.1.3/inventory
Path to Java = /home/appsuser/VIS/apps/tech_st/10.1.3/jre/1.4.2/bin/java
Log file = /home/appsuser/VIS/apps/tech_st/10.1.3/.patch_storage//*.log

Creating log file “/home/appsuser/VIS/apps/tech_st/10.1.3/.patch_storage/LsInventory__03-20-2009_10-31-50.log”

Result:

LsInventory: OPatch Exception while accessing O2O

OPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred:
OPatch Exception:
OUI found no such ORACLE_HOME set in the environment
Can not get details for given Oracle Home
An exception occurs
null

PRODUCT NAME VERSION

============
There is no Interim Patch

OPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred:
Can not get a list of inventory on this home.

ERROR: OPatch failed because of Inventory problem.

VERSION

==================

There is no Interim Patch

OPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred:
Can not get a list of inventory on this home.

ERROR: OPatch failed because of Inventory problem.

3)[dbuser@xxxxlsinv]$ opatch lsinventory -detail
bash: opatch: command not found

Atul,

Thanks for your quick reply.

As mentioned above we have found the OAS VERSION using OPATCH in the application tier with some error tagged.However, an error of command not found was reflected when we used the same in the database tier.

1)SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
——————————————–
12.0.4

This reflects that you have a corrupted Oracle Inventory

401454.1 Opatch Lsinventory Raises An OPatchException While Accessing O2O
395187.1 OPatch_JAVA_ERROR=CheckConflict: Opatch Exception While Accessing O2O

To recreate inventory use

472854.1 How to Recreate the OraInventory on UNIX Systems

Important thing you need to take care here is that you need to create inventory for 10.1.3 oracle home so change oracle_home reference in this doc.

Take backup of your existing oraInventory .

Here are steps for your reference
=======

1. Create inventory pointer /etc/oraInst.loc (linux) or /var/opt/oracle/oraInst.loc (Unix)

entry like

/home/appsuser/oraInventory (This is location where you want to keep your inventory. Ensure that you have write permission on this directory)

2. Set your ORACLE_HOME (in this case 10.1.3 oracle home) by running env file under 10.1.3

3. Copy oraInst.loc (created above) to $ORACLE_HOME directory

4. Recreate inventory

cd $ORACLE_HOME/oui/bin
./runInstaller -silent -attachHome ORACLE_HOME=”/home/appsuser/VIS/apps/tech_st/10.1.3″ ORACLE_HOME_NAME=”Web1013Home”

Try

/home/appsuser/VIS/apps/tech_st/10.1.3/OPatch/opatch lsinventory detail (If this uis successful try installing 10.1.3.4 patch)

Dear atul,

what are the special features available
in latest version. what is the main usage to upgrade?

advance thanks
yaseen ar.

Dear Atul,

We are upgrading the 10.1.3 Oracle Home to latest certified patch set using the patch set 10g Release 3 (10.1.3) Patch Set 4 (10.1.3.4.0) .we have followed this DOC ID:-454811.1
and applied patch 7237313,7359933 already while applying the main installer patch 7272722 we are facing some issues so my doubt is we have not fullfill some of the prerequisites mentioned in the Readme do we need to follow the prerequsites mentioned. Actually the prerequisites are not clear such as

Section 4.2.1 :–
a)Connect to the Oracle database as the orabpel user.(what should be the deafault pwd)
b)Run the following script based on your database and operating system for your BPEL environment :-
For Linux x86: upgrade_10131_10134_oracle.sql (what would be the user name and password to run this script).
Section 5.1.2 :–(not clear)

we have followd this DOC ID:-454811.1
and applied patch 7237313,7359933 already

Below is the o/p of OAS version

SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
——————————————–
12.0.4

Hi Sonali,
Steps like running sql script as user orabpel as part of 7272722 does not apply to your environment (as this is OAS part of R12) with no BPEL component (under dba_users there is no orabpel account) so please ignore any steps related to running sql using database schema like ORABPEL, ORAWSM, ORAESB

Atul,
Thanks for ur reply.
we are still stucked with the prerequsites of the patch 7272722 in section 5.1.2 of the readme.

1)How to know the Enterprise Javabeans version?
2)How to login into Application Server Control Console?
3)How to know whether our environment uses OracleAS Cold Failover Cluster topology or not?

Thanks
Sonali

we are still stucked with the prerequsites of the patch 7272722 in section 5.1.2 of the readme.

1)How to know the Enterprise Javabeans version?

If this is for 10.1.3 upgrade with R12 then ignore point about undeploying ejb 3.0 application.

2)How to login into Application Server Control Console?
IAS console URL should be

http://hostname.domainname:web_port/em but this doesn’t work for OAS 10.1.3 shipped with R12, I am looking in to this.

3)How to know whether our environment uses OracleAS Cold Failover Cluster topology or not?

OracleAS Cold Failover Cluster is not applicable to OAS 10.1.3 shipped with R12 so you are not using OAS Cold Failover cluster

Dear,
Thanks for ur reply.We directly tried to run the patch 7272722 10.1.3 oracle home.But it failed with some error.
Below are the details of the error log

without silent option:
=========================

All installer requirements met.

Checking Temp space: must be greater than 400 MB. Actual 57968 MB Passed
Checking swap space: must be greater than 512 MB. Actual 8607MB Passed
Checking monitor: must be configured to display at least 256 colors Failed <<<>> Could not execute auto check for display colors using command /usr/X11R6/bin/xdpyinfo. Check if the DISPLAY variable is set.
Checking if CPU speed is above 300 MHz. Actual 2408 MHz Passed

Some optional pre-requisite checks have failed (see above). Continue? (y/n) [n]

with silent option
===================
./runInstaller -silent -force -responseFile /home/appsuser/VIS/apps/a
pps_st/appl/patch/Disk1/stage/Response/oracle.
as.j2ee.patchset.Custom.rsp
LOG:-
silentInstall2009-03-25_05-29-26PM.log
Error:Values for the following variables could not be obtained from the command line or response file(s):
ORACLE_HOME(OracleHome),
ORACLE_HOME_NAME(OracleHomeName)
Silent install cannot continue.

Thanks
Sonali

Hi Sonali,

In non-silent mode runInstaller opens a new windows and it seems you are installing it remotely and DISPLAY is not set currectly.

Start X term like exceed (hummingbird) or any such tool on your local machine and set DISPLAY on server pointing to your IP and screen on which X tern is running usually 0:0

or start vncserver on your server and access server directly using vncviewer

Issue with silent install option is that your response file oracle.
as. j2ee.patchset .Custom. rsp
is not correct , check entry for ORACLE_HOME and ORACLE_HOME_NAME

Hi Atul and Sonali,
We have sucessfully upgraded the OAS 10.1.3.0.0 to 10.1.3.4.0.Your post and answers to the quries were simply short and sweet. Keep this good work going hats off to you and your team.

Pinaki

hi atul,
I have recently installed obiee in our environment which on oel 5 and 10.1.3.4 APPS
server.
But the main thing is that it was sucessfully installed with a warning
WARNING: could not delete locked file /tmp/ismp001/4979638
WARNING: could not delete locked file /tmp/ismp001

And then we had a problem that we couldnt login in the either way you suggested in this site like
http :// servername :9704/analytics

http :// servername :9704/xmlpserver

Administrator/Administrator

9704 is default port

Finally it was not opening so I have deleted the that file /tmp/ismp001/4979638 and simply restarted the services and tried logging but it didnt happen.I wish that your expertise could suggest me some way

Hello Atul,

As everyone is discussing ,we are also in process of upgrading OAS to 10.1.3.4 version.

I have applied the patches : 7237313 and 7359933 before applying the 7272722.

But the patch 7272722 fails at 83% saying that OPMN failing to start.

What could be the possible reason?
Is there any step which i’m missing.

We are following metalink document-id : 454811.1 and readme of 7272722 patch.

Thanks in advance.
Regards,
Avadhut

Avadhut,
To check why opmn failed to start in R12 while upgrading to 10.1.3.4 check logs at

$IAS_ORACLE_HOME/opmn/logs/

Hi Atul,
Thanks for the quick reply!!

I have checked the opmn.log file in the mentioned directory.

and here is the output::

========opmn.log===========================
09/02/15 17:59:51 [ons-internal] ONS server initiated
09/02/15 17:59:51 [pm-internal] PM state directory exists: /u03/prod/apps/tech_st/10.1.3/opmn/logs/states
09/02/15 17:59:51 [pm-internal] OPMN server ready. Request handling enabled.
09/02/15 17:59:52 [pm-requests] Request 3 Started. Command: /stop
09/02/15 17:59:52 [pm-requests] Request 3 Completed. Command: /stop
09/02/15 17:59:52 [pm-internal] OPMN server stopped. Request handling disabled.
09/02/15 17:59:52 [pm-requests] Request 4 Started. Command: /shutdown
09/02/15 17:59:52 [pm-requests] Request 4 Completed. Command: /shutdown
09/02/15 17:59:53 [internal] Logging disabled
09/05/09 09:11:35 [ons-internal] ONS server initiated
09/05/09 09:11:35 [pm-internal] PM state directory exists: /u02/PMS/app/apps/tech_st/10.1.3/opmn/logs/states
09/05/09 09:11:35 [pm-internal] OPMN server ready. Request handling enabled.
09/05/09 09:11:37 [pm-requests] Request 3 Started. Command: /stop
09/05/09 09:11:37 [pm-requests] Request 3 Completed. Command: /stop
09/05/09 09:11:37 [pm-internal] OPMN server stopped. Request handling disabled.
09/05/09 09:11:37 [pm-requests] Request 4 Started. Command: /shutdown
09/05/09 09:11:37 [pm-requests] Request 4 Completed. Command: /shutdown
09/05/09 09:11:38 [internal] Logging disabled
====================opmn.log================

Can you please confirm whether i’m missing some patch (other than the patches mentioned above)?

Thanks !!

Regards,
Avadhut

I can’t see any request to start opmn as part of patch

—
09/05/09 09:11:37 [pm-requests] Request 4 Completed. Command: /shutdown
09/05/09 09:11:38 [internal] Logging disabled

—

Did you set your environment variable as mentioned in upgrade note 454811.1

/ora/10.1.3 and source the .env/.cmd file to set your 10.1.3 ORACLE_HOME.

I’m getting the same error:

OPMN is failing to start.

This error comes up at the 83% mark of the Universal Installer “Specify File Location” screen.

I verified that I am able to start the opmn processes manually without any errors, but for some reason, the OUI cannot do it or detect it that it is up.

any ideas?

I am seeing the same error upgrading 10.1.3.3 to 10.1.3.4 (12.0.6). Whether opmn is started or not, runInstaller fails at 83% indicating that it cannot detect if opmn is up or not. The installer log shows:

Calling Query textFileQueries2.1.0.4.0 getValuesFromTextFile

fileName = NonExistentFile

searchString = NonExistentString

Query Exception: FileNotFoundException
Query Exception Class: class oracle.sysman.oii.oiil.OiilQueryException

Running opmnctl status or adopmnctl.status errors with:

Bad string
Unable to connect to opmn.
Opmn may not be up.

Kathi,

If you didn’t get an answer yet, this might help.

I also got the same exact error when I tried to apply 7272722 and spent a few hours to figure it out why this is happening.

This is happening because R12 cloning is not changing all the required files for the IAS.

Check the following files in the system:

$IAS_ORACLE_HOME/inventory/Clone/clone.xml
$IAS_ORACLE_HOME/config/ias.properties
$IAS_ORACLE_HOME/opmn/bin/opmnctl

You will see that the above files still hold the source instance references such as production path and ias_instance_name.

You definitely need to change the opmnctl and start it manually before starting the installer. Other two files, I am not sure.

/oracle/uat/apps/tech_st/10.1.3/opmn/bin/opmnctl startall

This should start it normally

opmnctl: starting opmn and all managed processes…

Thanks,
Siva

Did someone get past the 83% mark ? My 10.1.3.4 Patchset Installer has stuck there and the error in the installation log is

#########
OPMN is failing to start. OPMN must be started in order to correctly install and configure the patchset. Please start OPMN manually in order to continue with the patchset installation.
#########

My opmn is running. However , installer is not able to detect it.
This is on Solaris SPARC and i am in the process of upgrading to R12.1 from 12.0.2

Any ideas?

Thanks,
Arun

Arun,

Please see my reply to Kathi.
Basically you need to fix the following files and start the opmn manually to get past 83%.

$IAS_ORACLE_HOME/inventory/Clone/clone.xml
$IAS_ORACLE_HOME/config/ias.properties
$IAS_ORACLE_HOME/opmn/bin/opmnctl

We upgraded from 12.0.6 to 12.1.1 on Linux.

Thanks,
Siva

If you are stuck on the tech stack upgrade(10.1.2) and you are trying to upgrade a cloned system you will have to check the source machine references in many files under 10.1.2 home.

I noticed that rapidclone is not replacing all the source references during the cloning process. For example, emctl. This is not happening in all the cases.

I had to write a script to find and replace the source machine references like production path in the 10.1.2 home files to get past the Invalid IAS admin password issue.

Here is workaround to get away this issue:

$IAS_ORACLE_HOME/opmn/bin/opmnctl is trying to read opmn.xml from path pointed by $ORACLE_CONFIG_HOME which points to 10.1.2 home instead opmnctl should need 10.1.3 home

Do below:
Point ORACLE_CONFIG_HOME to 10.1.3 home and test by running the below command before running the installer again.

$IAS_ORACLE_HOME/opmn/bin/opmnctl status (or) startall

Export the environment variable before invoking runinstaller and this should be able to bypass the issue.

Cheers!

Siva,

Thanks for your useful tips. I was also stuck at 83% and did notice that the the path is different in the cloned system for some of the files. Replaced the file paths as per your direction and the installation completed successfully.

-Jay

saurabh00pc,

Thanks.It works.

Thanks,
Gangadhar

I had same issue “OPMN is failing to start. OPMN must be started in order to correctly…” when I was trying to upgrade AS from 10.1.3 to 10.1.3.4 in a cloned instance. It was resolved editing the 3 files refered by Siva. By the way…does anyone know what is the patch number that would fix/avoid these wrong references in a cloned instance?

Hi lookin out for a corporate trainer…….pls send your profile and contact to esha.argon@gmail.com

Hii,

Im upgrading from 12.0.4 to 12.1.1, for that i have Upgraded OracleAS 10g Release 3 (10.1.3) to Patchset 4 (10.1.3.4).
My Oracle Application Server version is 10.1.3.0.0, and after applying the patchset 4,I Tried to apply the additional patch 6702510 but it is showing the following error:

MISSING_COMPONENT : oracle.j2ee, 10.1.3.4.0
This Oracle Home does not have components/versions required by the patch.

ERROR: OPatch failed during prerequisite check.

Plz help me in resolviing the problem..what should i do..??

Im following this Document:
Oracle E-Business Suite Release 12.1.1 Maintenance Pack Installation Instructions [ID 752619.1]

Thanks in advance…waiting for your reply…

Hii,,

I have solved my issue, thanks for your blog, i got some important points from earlier comments of dis post, it helped me a lot in solving the issue.

Look forward to ur help in future.

Thank U.

Hii,

Im runnig adadmin and i got the following error

Copying Registry.dat from the Forms Java directory to /u02/oracle/PROD/apps/apps_st/comn/java/classes …

AD Administration error:
Error copying the Forms Registry file to /u02/oracle/PROD/apps/apps_st/comn/java/classes/oracle/forms/registry/Registry.dat.

adogjf() Unable to copy Registry.Dat.

Backing up restart files, if any……Done.

You should check the file
/u02/oracle/PROD/apps/apps_st/appl/admin/PROD/log/adadmin.log

for errors.

what should i do noww..??..waiting for ur replyy..

Hi Atul,

I am facing the autoconfig issue in Release 12 i am doing the SSL enabiling in Release 12, everything i have done but only the thing is i could not able to success the autoconfig. Error:-

##########################################################################
Generate Tns Names
##########################################################################
Logfile: /install/oracle/inst/apps/esp6855_sandebus02/admin/log/09291226/NetServiceHandler.log
Classpath : /install/oracle/goldsm_apps2/apps/apps_st/comn/java/lib/appsborg2.zip:/install/oracle/g
oldsm_apps2/apps/apps_st/comn/java/classes

Updating s_tnsmode to ‘generateTNS’
UpdateContext exited with status: 0

Result : FAILED
===============================================

[CVM Error Report]
The following report lists errors encountered during CVM Phase

/install/oracle/goldsm_apps2/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl -1

No of scripts failed in CVM phase: 1

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:

[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /install/oracle/goldsm_apps2/apps/tech_st/10.1.3/perl/bin/perl -I /install/oracle/goldsm_apps2/apps/tech_st/10
.1.3/perl/lib/5.8.3 -I /install/oracle/goldsm_apps2/apps/tech_st/10.1.3/perl/lib/site_perl/5.8.3 -I /install/oracle/goldsm_ap
ps2/apps/apps_st/appl/au/12.0.0/perl -I /install/oracle/goldsm_apps2/apps/tech_st/10.1.3/Apache/Apache/mod_perl/lib/site_perl
/5.8.3/sun4-solaris-thread-multi /install/oracle/inst/apps/esp6855_sandebus02/admin/scripts/adexecsql.pl sqlfile=/install/ora
cle/inst/apps/esp6855_sandebus02/admin/install
bisdblrp.sql INSTE8_PRF 1

Directory: /install/oracle/inst/apps/esp6855_sandebus02/admin/install
txkJavaMailerCfg.sh INSTE8_PRF 1

AutoConfig is exiting with status 2

Regards,
Sri…

how to run host command on oracle 10g application server .And any map drive is not working on oracle applciation server 10g …

please

Hi Atul,

please can you provide the path to upgrade Oracle 10g AS from 10.1.2.0.1 to 10.1.3.1.0.

Thanks
Pinaki