1 2 3 Previous Next 40 Replies Latest reply on May 14, 2013 4:35 AM by user11952526 Go to original post
      • 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