This discussion is archived
1 2 3 Previous Next 40 Replies Latest reply: May 13, 2013 9: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 Newbie
    Currently Being Moderated
    I agree with Hussain.
  • 16. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
    user11952526 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Hi,

    Thanks for the update!

    Regards.
  • 22. Re: Upgrage from 11i(11.5.10) to R12(12.x.x) single node
    user11952526 Newbie
    Currently Being Moderated
    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 ;) Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 ;) Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    What is the database software you are trying to uninstall?

    Thanks,
    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points