1 2 3 4 Previous Next 58 Replies Latest reply: Jan 11, 2013 3:42 PM by Hussein Sawwan-Oracle Go to original post RSS
      • 30. Re: Moving EBS database to different node
        970261
        Just curious do i have to apply the American English upgrade patch driver and NLS upgrade patch driver and then run rapidwiz to start the Upgrade to Oracle applications Release 12 ?
        • 31. Re: Moving EBS database to different node
          Hussein Sawwan-Oracle
          967258 wrote:
          Just curious do i have to apply the American English upgrade patch driver and NLS upgrade patch driver and then run rapidwiz to start the Upgrade to Oracle applications Release 12 ?
          You need to run Rapid Install to lay down R12 software, then run the US patch driver, followed by NLS (if you have any languages installed), then run Rapid Install again to configure the application tier.

          The above steps are clearly explained in the upgrade doc -- http://docs.oracle.com/cd/E18727_01/doc.121/e16342/toc.htm

          Thanks,
          Hussein
          • 32. Re: Moving EBS database to different node
            970261
            So basically i missed points from 8 to 16
            Once the above is completed then i should run rapidwiz to upgrade to Oracle Application release 12.1

            What should i do with existing rapidwiz that is running?
            Should i leave it like that and apply all the steps from 8 to 16 ?
            • 33. Re: Moving EBS database to different node
              Hussein Sawwan-Oracle
              967258 wrote:
              So basically i missed points from 8 to 16
              So, it is expected to get that error at this stage.
              Once the above is completed then i should run rapidwiz to upgrade to Oracle Application release 12.1
              The upgrade will be done by running the steps 10 and 11 and RapidWiz will not upgrade the application for you.
              What should i do with existing rapidwiz that is running?
              Should i leave it like that and apply all the steps from 8 to 16 ?
              Yes, then run Rapid Install again as mentioned in (Configure and start server processes (required)) step.

              Thanks,
              Hussein
              • 34. Re: Moving EBS database to different node
                970261
                What about the existing rapidwiz that is up and running ?
                Should i cancel and exit out ?

                Then complete step 8 to 16
                The run rapidwiz
                • 35. Re: Moving EBS database to different node
                  Hussein Sawwan-Oracle
                  967258 wrote:
                  What about the existing rapidwiz that is up and running ?
                  Should i cancel and exit out ?

                  Then complete step 8 to 16
                  The run rapidwiz
                  Just click on Next/Finish to close Rapid Install, then proceed with the other steps.

                  Thanks,
                  Hussein
                  • 36. Re: Moving EBS database to different node
                    970261
                    One thing i noticed is that most of the accounts are locked or expired and locked
                    Do i have to unlock these and if yes what should be their password ?

                    OLAPSYS EXPIRED & LOCKED
                    XDB EXPIRED & LOCKED
                    MDSYS EXPIRED & LOCKED
                    TSMSYS EXPIRED & LOCKED
                    DIP EXPIRED & LOCKED
                    ORACLE_OCM EXPIRED & LOCKED
                    ORDPLUGINS EXPIRED & LOCKED
                    ORDSYS EXPIRED & LOCKED
                    EXFSYS EXPIRED & LOCKED
                    SI_INFORMTN_SCHEMA EXPIRED & LOCKED
                    DBSNMP EXPIRED & LOCKED
                    OWAPUB EXPIRED & LOCKED
                    SSOSDK EXPIRED & LOCKED
                    PORTAL30_PUBLIC EXPIRED & LOCKED
                    PORTAL30_SSO_PUBLIC EXPIRED & LOCKED
                    PORTAL30 EXPIRED & LOCKED
                    JUNK_PS EXPIRED & LOCKED
                    PORTAL30_DEMO EXPIRED & LOCKED
                    PORTAL30_SSO EXPIRED & LOCKED
                    ORABKUP EXPIRED & LOCKED
                    PRP EXPIRED & LOCKED
                    JA EXPIRED & LOCKED
                    XNP EXPIRED & LOCKED
                    IES EXPIRED & LOCKED
                    IMC EXPIRED & LOCKED
                    CCT EXPIRED & LOCKED
                    IBU EXPIRED & LOCKED
                    AX EXPIRED & LOCKED
                    HXT EXPIRED & LOCKED
                    OSM EXPIRED & LOCKED
                    MSR EXPIRED & LOCKED
                    JTS EXPIRED & LOCKED
                    CSC EXPIRED & LOCKED
                    BIL EXPIRED & LOCKED
                    SSP EXPIRED & LOCKED
                    CUF EXPIRED & LOCKED
                    CUP EXPIRED & LOCKED
                    IGI EXPIRED & LOCKED
                    MRP EXPIRED & LOCKED
                    ENI EXPIRED & LOCKED
                    QRM EXPIRED & LOCKED
                    EAA EXPIRED & LOCKED
                    OKI EXPIRED & LOCKED
                    OKO EXPIRED & LOCKED
                    CUN EXPIRED & LOCKED
                    FEM EXPIRED & LOCKED
                    GMD EXPIRED & LOCKED
                    DOM EXPIRED & LOCKED
                    RLA EXPIRED & LOCKED
                    GMI EXPIRED & LOCKED
                    CSR EXPIRED & LOCKED
                    MSO EXPIRED & LOCKED
                    GML EXPIRED & LOCKED
                    ZFA EXPIRED & LOCKED
                    EVM EXPIRED & LOCKED
                    ASP EXPIRED & LOCKED
                    FII EXPIRED & LOCKED
                    OE EXPIRED & LOCKED
                    AK EXPIRED & LOCKED
                    QP EXPIRED & LOCKED
                    RG EXPIRED & LOCKED
                    IEM EXPIRED & LOCKED
                    IBA EXPIRED & LOCKED
                    XDP EXPIRED & LOCKED
                    MFG EXPIRED & LOCKED
                    RHX EXPIRED & LOCKED
                    OZP EXPIRED & LOCKED
                    RLM EXPIRED & LOCKED
                    ABM EXPIRED & LOCKED
                    VEA EXPIRED & LOCKED
                    EDR EXPIRED & LOCKED
                    EAM EXPIRED & LOCKED
                    BEN EXPIRED & LOCKED
                    GR EXPIRED & LOCKED
                    PMI EXPIRED & LOCKED
                    CS EXPIRED & LOCKED
                    XNC EXPIRED & LOCKED
                    POS EXPIRED & LOCKED
                    BNE EXPIRED & LOCKED
                    MSC EXPIRED & LOCKED
                    BIV EXPIRED & LOCKED
                    CRP EXPIRED & LOCKED
                    CLN EXPIRED & LOCKED
                    OTA EXPIRED & LOCKED
                    ZSA EXPIRED & LOCKED
                    OKX EXPIRED & LOCKED
                    CZ EXPIRED & LOCKED
                    IBC EXPIRED & LOCKED
                    BOM EXPIRED & LOCKED
                    GMS EXPIRED & LOCKED
                    HXC EXPIRED & LOCKED
                    INV EXPIRED & LOCKED
                    PSP EXPIRED & LOCKED
                    EGO EXPIRED & LOCKED
                    PSB EXPIRED & LOCKED
                    ISC EXPIRED & LOCKED
                    IPD EXPIRED & LOCKED
                    VEH EXPIRED & LOCKED
                    FV EXPIRED & LOCKED
                    GMA EXPIRED & LOCKED
                    PN EXPIRED & LOCKED
                    IEO EXPIRED & LOCKED
                    WMS EXPIRED & LOCKED
                    WSH EXPIRED & LOCKED
                    ME EXPIRED & LOCKED
                    BIC EXPIRED & LOCKED
                    IEC EXPIRED & LOCKED
                    CSF EXPIRED & LOCKED
                    BSC EXPIRED & LOCKED
                    ASL EXPIRED & LOCKED
                    IEX EXPIRED & LOCKED
                    ALR EXPIRED & LOCKED
                    BIX EXPIRED & LOCKED
                    CSS EXPIRED & LOCKED
                    XLA EXPIRED & LOCKED
                    CUA EXPIRED & LOCKED
                    AST EXPIRED & LOCKED
                    AHM EXPIRED & LOCKED
                    ITG EXPIRED & LOCKED
                    IBY EXPIRED & LOCKED
                    JTF EXPIRED & LOCKED
                    QOT EXPIRED & LOCKED
                    AMV EXPIRED & LOCKED
                    OKB EXPIRED & LOCKED
                    PSA EXPIRED & LOCKED
                    BIM EXPIRED & LOCKED
                    IGW EXPIRED & LOCKED
                    QA EXPIRED & LOCKED
                    GME EXPIRED & LOCKED
                    MWA EXPIRED & LOCKED
                    XNB EXPIRED & LOCKED
                    GMP EXPIRED & LOCKED
                    AHL EXPIRED & LOCKED
                    CSE EXPIRED & LOCKED
                    CSD EXPIRED & LOCKED
                    OKS EXPIRED & LOCKED
                    CSM EXPIRED & LOCKED
                    MSD EXPIRED & LOCKED
                    IGS EXPIRED & LOCKED
                    AMF EXPIRED & LOCKED
                    IBE EXPIRED & LOCKED
                    CE EXPIRED & LOCKED
                    CN EXPIRED & LOCKED
                    FPT EXPIRED & LOCKED
                    IGC EXPIRED & LOCKED
                    IEB EXPIRED & LOCKED
                    ASG EXPIRED & LOCKED
                    AR EXPIRED & LOCKED
                    ECX EXPIRED & LOCKED
                    ASF EXPIRED & LOCKED
                    CUI EXPIRED & LOCKED
                    POA EXPIRED & LOCKED
                    FRM EXPIRED & LOCKED
                    OPI EXPIRED & LOCKED
                    POM EXPIRED & LOCKED
                    FLM EXPIRED & LOCKED
                    WSM EXPIRED & LOCKED
                    PJM EXPIRED & LOCKED
                    OKR EXPIRED & LOCKED
                    JL EXPIRED & LOCKED
                    CSI EXPIRED & LOCKED
                    WPS EXPIRED & LOCKED
                    IMT EXPIRED & LOCKED
                    AMS EXPIRED & LOCKED
                    OZF EXPIRED & LOCKED
                    ASO EXPIRED & LOCKED
                    XNI EXPIRED & LOCKED
                    CUS EXPIRED & LOCKED
                    JG EXPIRED & LOCKED
                    EC EXPIRED & LOCKED
                    PV EXPIRED & LOCKED
                    OKE EXPIRED & LOCKED
                    JE EXPIRED & LOCKED
                    XTR EXPIRED & LOCKED
                    AZ EXPIRED & LOCKED
                    OZS EXPIRED & LOCKED
                    IPA EXPIRED & LOCKED
                    ENG EXPIRED & LOCKED
                    IEU EXPIRED & LOCKED
                    CUG EXPIRED & LOCKED
                    CSP EXPIRED & LOCKED
                    CUE EXPIRED & LOCKED
                    XNS EXPIRED & LOCKED
                    XNM EXPIRED & LOCKED
                    ONT EXPIRED & LOCKED
                    IGF EXPIRED & LOCKED
                    CSL EXPIRED & LOCKED
                    FTE EXPIRED & LOCKED
                    JTM EXPIRED & LOCKED
                    WIP EXPIRED & LOCKED
                    PJI EXPIRED & LOCKED
                    PON EXPIRED & LOCKED
                    IBP EXPIRED & LOCKED
                    OKL EXPIRED & LOCKED
                    HRI EXPIRED & LOCKED
                    GMF EXPIRED & LOCKED
                    OKC EXPIRED & LOCKED
                    DDD EXPIRED & LOCKED
                    AD_MONITOR EXPIRED & LOCKED
                    EM_MONITOR EXPIRED & LOCKED

                    Some of them are in locked status

                    MDDATA LOCKED
                    ANONYMOUS LOCKED
                    UDPM LOCKED
                    APPROVA LOCKED
                    INTELLIMON LOCKED
                    EADMIN LOCKED
                    LINKUSER LOCKED
                    IA LOCKED
                    BIS LOCKED
                    AMW LOCKED
                    ZX LOCKED
                    AP LOCKED
                    XDO LOCKED
                    GCS LOCKED
                    FUN LOCKED
                    ZPB LOCKED
                    PO LOCKED
                    HR LOCKED
                    LNS LOCKED
                    IZU LOCKED
                    GL LOCKED
                    ASN LOCKED
                    XLE LOCKED
                    PA LOCKED
                    • 37. Re: Moving EBS database to different node
                      Hussein Sawwan-Oracle
                      967258 wrote:
                      One thing i noticed is that most of the accounts are locked or expired and locked
                      Do i have to unlock these and if yes what should be their password ?
                      Those accounts should not be locked and their passwords should not be expired.

                      You can change the password for all schemas to one single password using FNDCPASS command (ALLORACLE) -- How to Change Applications Passwords using Applications Schema Password Change Utility (FNDCPASS or AFPASSWD) [ID 437260.1]

                      Thanks,
                      Hussein
                      • 38. Re: Moving EBS database to different node
                        970261
                        I have unlocked the accounts and applied the patch

                        Currently running the American English Driver patch. According to what i am reading might take long time

                        The next step is NLS upgrade patch driver. Since we only have English as language in our system we are going to skip this step.

                        Step 12 Apply latest product patches (required)
                        Determine the latest product-specific patches. Then, download the American English patches. Using AD Merge Patch, create a merged patch and apply it to your Release 12.1.1 APPL_TOP

                        Where do i get list of all the patches that i need to apply. Once i get the complete list i will merge them all.

                        Thanks
                        Chirag
                        • 39. Re: Moving EBS database to different node
                          Hussein Sawwan-Oracle
                          967258 wrote:
                          I have unlocked the accounts and applied the patch
                          Good.
                          Currently running the American English Driver patch. According to what i am reading might take long time
                          Yes, this is an expected behavior.
                          The next step is NLS upgrade patch driver. Since we only have English as language in our system we are going to skip this step.
                          Correct.
                          Step 12 Apply latest product patches (required)
                          Determine the latest product-specific patches. Then, download the American English patches. Using AD Merge Patch, create a merged patch and apply it to your Release 12.1.1 APPL_TOP

                          Where do i get list of all the patches that i need to apply. Once i get the complete list i will merge them all.
                          You can skip this step if you are planning to upgrade to 12.1.3 then apply this step. If you have no plans to upgrade to 12.1.3, then you can complete this step at the end of the upgrade (once you complete all the tasks).

                          To get the latest patches, please refer to:

                          Identifying the Latest Family Packs for Oracle E-Business Suite
                          https://blogs.oracle.com/stevenChan/entry/latest_available_packs_for_oracle

                          Identifying Recommended Patches for E-Business Suite Environments
                          https://blogs.oracle.com/stevenChan/entry/recommended_patches_for_oracle_e

                          Oracle Applications Current Patchset Comparison Utility - patchsets.sh [ID 139684.1

                          Thanks,
                          Hussein                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
                          • 40. Re: Moving EBS database to different node
                            970261
                            Yes the plan is to upgrade to R12.1.3

                            So basically once this English driver patch completes I should complete the remaining task in the document

                            a. Disable Maintenance Mode
                            b. Backup Oracle database
                            c. Reset Oracle schema password (ALLORACLE)
                            d. Configure and Start server process Create appsutil.zip, run autoconfig on db tier and app tier and then ( I believe here i have to run rapidwiz and choose Configure upgraded R12 instance)
                            e. Bring application services up and verify concurrent, invalids, all sanity checks.

                            Then upgrade to R12.1.3

                            Can you check whether my point "d" is correct.

                            Thanks
                            Chirag
                            • 41. Re: Moving EBS database to different node
                              Hussein Sawwan-Oracle
                              All the above steps are correct.

                              Thanks,
                              Hussein
                              • 42. Re: Moving EBS database to different node
                                970261
                                This American driver patch is taking long time
                                Doing adctrl for show worker status

                                Control
                                Worker Code Context Filename Status
                                ------ -------- ----------------- -------------------------- --------------
                                1 Run AutoPatch R120 pl Wait
                                2 Run AutoPatch R120 pl Wait
                                3 Run AutoPatch R120 pl Wait
                                4 Run AutoPatch R120 pl Wait
                                5 Run AutoPatch R120 pl ponAllocItemPG.xml Running
                                6 Run AutoPatch R120 pl Wait
                                7 Run AutoPatch R120 pl ponCancelOutPG.xml Running
                                8 Run AutoPatch R120 pl Wait
                                9 Run AutoPatch R120 pl Wait
                                10 Run AutoPatch R120 pl Wait
                                11 Run AutoPatch R120 pl Wait
                                12 Run AutoPatch R120 pl Wait
                                13 Run AutoPatch R120 pl Wait
                                14 Run AutoPatch R120 pl Wait
                                15 Run AutoPatch R120 pl ComponentListPG.xml Running
                                16 Run AutoPatch R120 pl ComponentStyleUpdatePG.xml Running
                                17 Run AutoPatch R120 pl Wait
                                18 Run AutoPatch R120 pl ponAllocatePG.xml Running
                                19 Run AutoPatch R120 pl Wait
                                20 Run AutoPatch R120 pl ponCreAttSearchPG.xml Running
                                21 Run AutoPatch R120 pl Wait
                                22 Run AutoPatch R120 pl Wait
                                23 Run AutoPatch R120 pl Wait
                                24 Run AutoPatch R120 pl Wait
                                25 Run AutoPatch R120 pl Wait
                                26 Run AutoPatch R120 pl Wait
                                27 Run AutoPatch R120 pl Wait
                                28 Run AutoPatch R120 pl Wait
                                29 Run AutoPatch R120 pl Wait
                                30 Run AutoPatch R120 pl Wait
                                31 Run AutoPatch R120 pl Wait
                                32 Run AutoPatch R120 pl Wait
                                33 Run AutoPatch R120 pl Wait
                                34 Run AutoPatch R120 pl Wait
                                35 Run AutoPatch R120 pl ponMngDraftNegPG.xml Running
                                36 Run AutoPatch R120 pl Wait
                                37 Run AutoPatch R120 pl Wait
                                38 Run AutoPatch R120 pl Wait
                                39 Run AutoPatch R120 pl Wait
                                40 Run AutoPatch R120 pl Wait
                                41 Run AutoPatch R120 pl Wait
                                42 Run AutoPatch R120 pl Wait
                                43 Run AutoPatch R120 pl ponViewInvListPG.xml Running
                                44 Run AutoPatch R120 pl Wait
                                45 Run AutoPatch R120 pl Wait
                                46 Run AutoPatch R120 pl Wait
                                47 Run AutoPatch R120 pl Wait
                                48 Run AutoPatch R120 pl Wait
                                49 Run AutoPatch R120 pl Wait
                                50 Run AutoPatch R120 pl Wait

                                It has been here for long time

                                The database show inactive sessions. Is there any way to find whether these connections are doing anything ?

                                Do i have to start again ?

                                Thanks
                                Chirag
                                • 43. Re: Moving EBS database to different node
                                  Hussein Sawwan-Oracle
                                  This American driver patch is taking long time
                                  How long this has been running?

                                  Can you find any errors in the database log file?

                                  Any high CPU utilization?

                                  Please also check the workers log files for any error messages.

                                  Thanks,
                                  Hussein
                                  • 44. Re: Moving EBS database to different node
                                    970261
                                    On the database log file i see

                                    WARNING: inbound connection timed out (ORA-3136)
                                    Thu Dec 20 03:55:00 EST 2012
                                    WARNING: inbound connection timed out (ORA-3136)
                                    Thu Dec 20 03:55:04 EST 2012
                                    WARNING: inbound connection timed out (ORA-3136)


                                    Most of the worker log file shows below at the end
                                    XDOLoader done successfully: Thu Dec 20 03:56:23 EST 2012

                                    Time when worker completed job: Thu Dec 20 2012 03:56:23
                                    AdjavaWorker has reached the maximum wait timeout specified( 36000000 ). So Exiting.

                                    Some of the workers log files are saying about high resource consumption. Add more resources
                                    I have started the job with 300 batch size and 32 parallel workers
                                    The server has 65 GB RAM and 8 CPUs

                                    Should i start all the workers again from adctrl ?