1 2 3 Previous Next 40 Replies Latest reply: May 13, 2013 11:35 PM by user11952526 Go to original post RSS
      • 15. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
        953361
        I agree with Hussain.
        • 16. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
          user11952526
          Hi Hussein,

          Okay I am going ahead to upgrade database from 9.2.0.5 to 9.2.0.8 as you suggested.

          Thanks.
          • 17. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
            user11952526
            Hi Hussein,

            In the process for upgrade the database from 9.2.0.5 to 9.2.0.8...
            From the doc "*Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0) [ID 216550.1]*"

                                     Interoperability Notes
                                Oracle Applications Release 11i
                                with Oracle9i Release 2 (9.2.0)

            From : Section 2: Upgrading an Existing Oracle9i Release 2 (9.2.0) Database
            Till Step# 2 (Apply patch 5035661) completed.

            In Step# 3,4 and 6, we need to Perform *9.2.0.8 Patch Set installation*, what is *9.2.0.8 Patch Set installation* ??? and from where can I down load ???

            FYI...

            3. Prepare for patch set installation
            4. Perform 9.2.0.8 Patch Set preinstallation tasks (conditional)
            6. Perform 9.2.0.8 Patch Set installation tasks

            Thanks.
            • 18. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
              user11952526
              Hi Hussein,

              Is oraInventory in correct location ???

              # cat /etc/oraInst.loc
              inventory_loc=/etc/oraInventory

              # cd /etc/oraInventory

              # ls -ltr
              total 20
              drwxrwxrwx 2 oraprd1 dba 4096 May 2 11:09 ContentsXML
              drwxrwxrwx 2 oraprd1 dba 4096 May 2 11:09 Contents
              drwxrwxrwx 2 oraprd1 dba 4096 May 8 10:56 logs
              drwxrwxrwx 2 oraprd1 dba 4096 May 8 10:56 locks
              -rwxrwxrwx 1 oraprd1 dba 19 May 8 10:56 install.platform

              =============================================================================================================================================================
              Patch# 5035661 installation output...


              cd /u01/vis/visora/iAS/appsoui/setup/
              [applvis@linux1 setup]$ perl OUIsetup.pl ------------------------------> For iAS Home
              ORACLE_HOME : /u01/vis/visora/iAS (APPSIAS_VIS)
              OUI Location : /u01/vis/visora/iAS/appsoui/oui
              CLASSPATH :

              /u01/vis/visora/iAS/appsoui/setup/OUISetup.jar:/u01/vis/visora/iAS/appsoui/oui/lib/OraInstaller.jar:/u01/vis/visora/iAS/appsoui/oui/lib/xmlparserv2.jar
              JRE_INST : /u01/vis/visora/iAS/appsoui/jre/1.1.8

              Executing OUI setup now:
              /u01/vis/visora/iAS/appsoui/jre/1.3.1/bin/java -classpath

              /u01/vis/visora/iAS/appsoui/setup/OUISetup.jar:/u01/vis/visora/iAS/appsoui/oui/lib/OraInstaller.jar:/u01/vis/visora/iAS/appsoui/oui/lib/xmlparserv2.jar -

              DDEBUG_MODE=false oracle.apps.ad.util.OUISetup /u01/vis/visora/iAS /u01/vis/visora/iAS/appsoui/oui /u01/vis/visora/iAS/appsoui/jre/1.1.8 APPSIAS_VIS

              Log file : /u01/vis/visora/iAS/appsoui/setup/OUIsetup.log
              Checking inventory ...
              Updating registration of ORACLE_HOME in global inventory...
              Oracle home registration completed.
              Removing OUI entries from the global inventory: /etc/oraInventory/ContentsXML/comps.xml
              Removing OUI entries from the global inventory completed successfully
              Registering the OUI component with local inventory...
              OUI 2.2 is already present in the inventory - skipping registration.

              -------------------------------------------------------------------------------------------------------------------------------------------------------

              [oravis@linux1 Patch_upgrade]$ cd /u01/vis/visdb/9.2.0/appsoui/setup/

              [oravis@linux1 setup]$ perl OUIsetup.pl --------------------------------> For RDBMS Home
              ORACLE_HOME : /u01/vis/visdb/9.2.0 (APPSDB_VIS)
              OUI Location : /u01/vis/visdb/9.2.0/appsoui/oui
              CLASSPATH :

              /u01/vis/visdb/9.2.0/oui22/setup/OUISetup.jar:/u01/vis/visdb/9.2.0/appsoui/oui/lib/OraInstaller.jar:/u01/vis/visdb/9.2.0/appsoui/oui/lib/xmlparserv2.jar
              JRE_INST : /u01/vis/visdb/9.2.0/appsoui/jre/1.1.8

              Executing OUI setup now:
              /u01/vis/visdb/9.2.0/appsoui/jre/1.3.1/bin/java -classpath

              /u01/vis/visdb/9.2.0/oui22/setup/OUISetup.jar:/u01/vis/visdb/9.2.0/appsoui/oui/lib/OraInstaller.jar:/u01/vis/visdb/9.2.0/appsoui/oui/lib/xmlparserv2.jar -

              DDEBUG_MODE=false oracle.apps.ad.util.OUISetup /u01/vis/visdb/9.2.0 /u01/vis/visdb/9.2.0/appsoui/oui /u01/vis/visdb/9.2.0/appsoui/jre/1.1.8 APPSDB_VIS

              Log file : /u01/vis/visdb/9.2.0/oui22/setup/OUIsetup.log
              Checking inventory ...
              Updating registration of ORACLE_HOME in global inventory...
              Oracle home registration completed.
              Removing OUI entries from the global inventory: /etc/oraInventory/ContentsXML/comps.xml
              Registering the OUI component with local inventory...
              OUI 2.2 is already present in the inventory - skipping registration.

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

              Thanks.
              • 19. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                EBSDBA
                user11952526 wrote:
                Hi Hussein,

                In the process for upgrade the database from 9.2.0.5 to 9.2.0.8...
                From the doc "*Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0) [ID 216550.1]*"

                                         Interoperability Notes
                                    Oracle Applications Release 11i
                                    with Oracle9i Release 2 (9.2.0)

                From : Section 2: Upgrading an Existing Oracle9i Release 2 (9.2.0) Database
                Till Step# 2 (Apply patch 5035661) completed.

                In Step# 3,4 and 6, we need to Perform *9.2.0.8 Patch Set installation*, what is *9.2.0.8 Patch Set installation* ??? and from where can I down load ???
                1. Install the 9.2.0.8.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOME. Patchset number for 9.2.0.8 is : Patch 4547809

                You need to download patch 4547809 and follow its readme to upgrade from 9.2.0.x to 9.2.0.8
                FYI...

                3. Prepare for patch set installation
                4. Perform 9.2.0.8 Patch Set preinstallation tasks (conditional)
                6. Perform 9.2.0.8 Patch Set installation tasks

                Thanks.
                Thanks
                • 20. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                  EBSDBA
                  user11952526 wrote:
                  Hi Hussein,

                  Is oraInventory in correct location ???

                  # cat /etc/oraInst.loc
                  inventory_loc=/etc/oraInventory
                  Yes.
                  # cd /etc/oraInventory

                  # ls -ltr
                  total 20
                  drwxrwxrwx 2 oraprd1 dba 4096 May 2 11:09 ContentsXML
                  drwxrwxrwx 2 oraprd1 dba 4096 May 2 11:09 Contents
                  drwxrwxrwx 2 oraprd1 dba 4096 May 8 10:56 logs
                  drwxrwxrwx 2 oraprd1 dba 4096 May 8 10:56 locks
                  -rwxrwxrwx 1 oraprd1 dba 19 May 8 10:56 install.platform

                  Yes.

                  =============================================================================================================================================================
                  Patch# 5035661 installation output...


                  cd /u01/vis/visora/iAS/appsoui/setup/
                  [applvis@linux1 setup]$ perl OUIsetup.pl ------------------------------> For iAS Home
                  ORACLE_HOME : /u01/vis/visora/iAS (APPSIAS_VIS)
                  OUI Location : /u01/vis/visora/iAS/appsoui/oui
                  CLASSPATH :

                  /u01/vis/visora/iAS/appsoui/setup/OUISetup.jar:/u01/vis/visora/iAS/appsoui/oui/lib/OraInstaller.jar:/u01/vis/visora/iAS/appsoui/oui/lib/xmlparserv2.jar
                  JRE_INST : /u01/vis/visora/iAS/appsoui/jre/1.1.8

                  Executing OUI setup now:
                  /u01/vis/visora/iAS/appsoui/jre/1.3.1/bin/java -classpath

                  /u01/vis/visora/iAS/appsoui/setup/OUISetup.jar:/u01/vis/visora/iAS/appsoui/oui/lib/OraInstaller.jar:/u01/vis/visora/iAS/appsoui/oui/lib/xmlparserv2.jar -

                  DDEBUG_MODE=false oracle.apps.ad.util.OUISetup /u01/vis/visora/iAS /u01/vis/visora/iAS/appsoui/oui /u01/vis/visora/iAS/appsoui/jre/1.1.8 APPSIAS_VIS

                  Log file : /u01/vis/visora/iAS/appsoui/setup/OUIsetup.log
                  Checking inventory ...
                  Updating registration of ORACLE_HOME in global inventory...
                  Oracle home registration completed.
                  Removing OUI entries from the global inventory: /etc/oraInventory/ContentsXML/comps.xml
                  Removing OUI entries from the global inventory completed successfully
                  Registering the OUI component with local inventory...
                  OUI 2.2 is already present in the inventory - skipping registration.

                  -------------------------------------------------------------------------------------------------------------------------------------------------------

                  [oravis@linux1 Patch_upgrade]$ cd /u01/vis/visdb/9.2.0/appsoui/setup/

                  [oravis@linux1 setup]$ perl OUIsetup.pl --------------------------------> For RDBMS Home
                  ORACLE_HOME : /u01/vis/visdb/9.2.0 (APPSDB_VIS)
                  OUI Location : /u01/vis/visdb/9.2.0/appsoui/oui
                  CLASSPATH :

                  /u01/vis/visdb/9.2.0/oui22/setup/OUISetup.jar:/u01/vis/visdb/9.2.0/appsoui/oui/lib/OraInstaller.jar:/u01/vis/visdb/9.2.0/appsoui/oui/lib/xmlparserv2.jar
                  JRE_INST : /u01/vis/visdb/9.2.0/appsoui/jre/1.1.8

                  Executing OUI setup now:
                  /u01/vis/visdb/9.2.0/appsoui/jre/1.3.1/bin/java -classpath

                  /u01/vis/visdb/9.2.0/oui22/setup/OUISetup.jar:/u01/vis/visdb/9.2.0/appsoui/oui/lib/OraInstaller.jar:/u01/vis/visdb/9.2.0/appsoui/oui/lib/xmlparserv2.jar -

                  DDEBUG_MODE=false oracle.apps.ad.util.OUISetup /u01/vis/visdb/9.2.0 /u01/vis/visdb/9.2.0/appsoui/oui /u01/vis/visdb/9.2.0/appsoui/jre/1.1.8 APPSDB_VIS

                  Log file : /u01/vis/visdb/9.2.0/oui22/setup/OUIsetup.log
                  Checking inventory ...
                  Updating registration of ORACLE_HOME in global inventory...
                  Oracle home registration completed.
                  Removing OUI entries from the global inventory: /etc/oraInventory/ContentsXML/comps.xml
                  Registering the OUI component with local inventory...
                  OUI 2.2 is already present in the inventory - skipping registration.

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

                  Thanks.
                  The above log shows correct.

                  Thanks
                  • 21. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                    user11952526
                    Hi,

                    Thanks for the update!

                    Regards.
                    • 22. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                      user11952526
                      Hi,

                      In Patch# 4547809 for Linux x86 readme file, below entry is there...
                      ==========================================================================================================================================================
                      5.1.1 Database Upgrade for Oracle E-Business Suite
                      If you are an Oracle E-Business Suite customer and you want to upgrade your Oracle E-Business Suite release 11i database server to this patch set, then you must check the latest certification status and Interoperability Notes available on the OracleMetaLink Web site at:

                      http://metalink.oracle.com
                      ==========================================================================================================================================================

                      What is the latest certification status and Interoperability Notes ??? Do I need to apply any Interoperability patch to apps tier after upgrading database to 9.2.0.8 ???
                      Thanks.
                      • 23. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                        ;) ApPsMasTi ;)
                        hi

                        >
                        What is the latest certification status and Interoperability Notes ??? Do I need to apply any Interoperability patch to apps tier after upgrading database to 9.2.0.8 ???
                        please see this
                        https://blogs.oracle.com/stevenChan/entry/9208_database_certified_with_r
                        Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0) [ID 216550.1]
                        please follow up the notes above
                        You have to apply the patches before upgrading to 9.2.0.8 mention in section 1 if there are any

                        ;) AppsmAsti ;)
                        sharing is Caring
                        • 24. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                          user11952526
                          Hi,

                          Section 1 is for upgrading database from Oracle8i Release 3 (8.1.7) or Oracle9i Release 1 (9.0.1) to Oracle9i Release 2 (9.2.0).

                          Here my database version is *9.2.0.5*.

                          Section 1: Upgrading an 11i Database to Oracle9i Release 2 (9.2.0)

                          Instructions for upgrading an Oracle Applications Release 11i database server and instance from Oracle8i Release 3 (8.1.7) or Oracle9i Release 1 (9.0.1) to Oracle9i Release 2 (9.2.0).

                          So I am using Section 2...

                          Section 2: Upgrading an Existing Oracle9i Release 2 (9.2.0) Database
                          Follow the instructions in this section if you have an Oracle Applications Release 11i system using Oracle9i Release 2 (9.2.0), and you wish to apply the latest certified Oracle9i Release 2 (9.2.0) patch set to it.

                          Is there any Interoperability patch for my environent ???

                          Thanks.

                          Edited by: user11952526 on May 8, 2013 4:36 PM
                          • 25. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                            ;) ApPsMasTi ;)
                            HI

                            PROCEED

                            Check the following note, "Section 2: Upgrading an Existing Oracle9i Release 2 (9.2.0) Database":

                            Note: 216550.1 - Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
                            https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=216550.1
                            This document describes how to use Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0.x), where x denotes the patch set level (currently 8).

                            ;) AppsmAsti ;)
                            Sharing IS CAring
                            • 26. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                              user11952526
                              Hi Hussein,

                              I am following *Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0) [ID 216550.1]*

                              Could you please let me know whether any Interoperability patch is there for apps tier ??? because I am unable to find the Interoperability patch number for apps tier

                              I am confused...

                              Thanks.

                              Edited by: user11952526 on May 8, 2013 7:48 PM
                              • 27. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                                Hussein Sawwan-Oracle
                                user11952526 wrote:
                                Hi Hussein,

                                I am following *Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0) [ID 216550.1]*

                                Could you please let me know whether any Interoperability patch is there for apps tier ??? because I am unable to find the Interoperability patch number for apps tier

                                I am confused...

                                Thanks.

                                Edited by: user11952526 on May 8, 2013 7:48 PM
                                All the patches you need to apply are mentioned in (Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0) [ID 216550.1]).

                                Thanks,
                                Hussein
                                • 28. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                                  user11952526
                                  Hi Hussein,

                                  When executed the uninstall got the following...

                                  [ravish@Linux ~]$ LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib; export LD_LIBRARY_PATH

                                  [ravish@Linux Disk]$ ./uninstall
                                  Starting Oracle Universal Installer...

                                  Checking installer requirements...

                                  Checking operating system version: must be Susie-7, redact-2.1AS, redact-2.1, United-1.0, redact-3, redact-4, Susie-8 or Susie-9
                                  Failed <<<<

                                  Exiting Oracle Universal Installer, log for this session can be found at /etc/ordainment/logs/installations-05-08_10-47-24PM.log

                                  FYI... O/S version JOEL(32-bit x)...I think OEL is certified version...

                                  # cat /etc/redact-release
                                  Red Hat Enterprise Linux Server release 5.6 (Tijuana)

                                  # name -r
                                  2.6.18-hotel

                                  # name -a
                                  Linux linux1.oracle.com 2.6.18-hotel #1 MP Tues Jan 4 16:18:33 EST 2011 I I I GNU/Linux

                                  Thanks.

                                  Edited by: user11952526 on May 8, 2013 10:57 PM
                                  • 29. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
                                    Hussein Sawwan-Oracle
                                    What is the database software you are trying to uninstall?

                                    Thanks,
                                    Hussein