1 2 Previous Next 19 Replies Latest reply: Dec 15, 2012 10:24 AM by Hussein Sawwan-Oracle RSS

    upgrade r12.1.1 to r12.1.3

    i_do_me_you_do_you
      Hello,

      I have to upgrade my E-bs from 12.1.1 to 12.1.3, but I don't know which patches do I have to apply. I have searched in metalink, but I got lost in the information.

      I would be much grateful if somebody tell me where can I find info about that issue?

      Thanks in advance!
        • 1. Re: upgrade r12.1.1 to r12.1.3
          user9005190
          Hello,

          You have to read upgrade guide for 12.1.1 : No. E16342-04
          and install Patchset 12.1.3. : 1080973.1

          it's not easy.. ;)

          I'm working on it...
          • 2. Re: upgrade r12.1.1 to r12.1.3
            Hussein Sawwan-Oracle
            974556 wrote:
            Hello,

            I have to upgrade my E-bs from 12.1.1 to 12.1.3, but I don't know which patches do I have to apply. I have searched in metalink, but I got lost in the information.

            I would be much grateful if somebody tell me where can I find info about that issue?

            Thanks in advance!
            Oracle E-Business Suite Release 12.1.3 Release Update Pack (Patch 9239090)

            Oracle E-Business Suite Release 12.1.3 Now Available
            https://blogs.oracle.com/stevenChan/entry/ebs_1213_available

            Thanks,
            Hussein
            • 3. Re: upgrade r12.1.1 to r12.1.3
              i_do_me_you_do_you
              I'm in the middle of applying the patch.

              At certain point, it prompted that there was an error in relinking applications, I've checked in adrelink.log but I couldn't find the error. So when prompted Continue as if this didn't occur, i gave "Yes" instead of the default "No".

              We'll see at the end if it works, than the upgrade is successful. If not, .........

              There are going to be a lot of posts in this thread :)

              Many thanks to Hussein for his help.
              • 4. Re: upgrade r12.1.1 to r12.1.3
                Hussein Sawwan-Oracle
                At certain point, it prompted that there was an error in relinking applications, I've checked in adrelink.log but I couldn't find the error. So when prompted Continue as if this didn't occur, i gave "Yes" instead of the default "No".
                Can you post it here?
                We'll see at the end if it works, than the upgrade is successful. If not, .........

                There are going to be a lot of posts in this thread :)
                Will be waiting.
                Many thanks to Hussein for his help.
                You're welcome.

                Thanks,
                Hussein
                • 5. Re: upgrade r12.1.1 to r12.1.3
                  i_do_me_you_do_you
                  Ok, so I'm back,

                  I left the workers running during the night, and this morning the ssh session was broken.

                  I logged again and started autopatch to continue from where it left. Now, here I'm posting the output. There was an error again, and it asked again "Continue as if it was successful?" To which i replied Yes again like the previous time.

                  Luckily, this is just a test installation, so no big deal if it goes wrong.

                  so here's the output from this morning:


                  Copyright (c) 2002 Oracle Corporation
                  Redwood Shores, California, USA

                  Oracle Applications AutoPatch

                  Version 12.0.0

                  NOTE: You may not use this utility for custom development
                  unless you have written permission from Oracle Corporation.


                  Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
                  You must use OAM Patch Wizard for this feature. Alternatively, you can
                  review the README for pre-requisite information.


                  Your default directory is '/d01/oracle/VIS/apps/apps_st/appl'.
                  Is this the correct APPL_TOP [Yes] ?

                  AutoPatch records your AutoPatch session in a text file
                  you specify. Enter your AutoPatch log file name or press [Return]
                  to accept the default file name shown in brackets.

                  Filename [adpatch.log] :


                  Backing up restart files, if any......Done.


                  Your previous AutoPatch session did not run to completion.
                  Do you wish to continue with your previous AutoPatch session [Yes] ?



                  You are about to apply a patch to the installation of Oracle Applications
                  in your ORACLE database 'VIS'
                  using ORACLE executables in '/d01/oracle/VIS/apps/tech_st/10.1.2'.

                  Is this the correct database [Yes] ?

                  Already asked for the ORACLE username and password
                  of Application Object Library.
                  (The given username/password was: APPLSYS/*****)

                  The status of various features in this run of AutoPatch is:

                  <-Feature version in->
                  Feature Active? APPLTOP Data model Flags
                  ------------------------------ ------- -------- ----------- -----------
                  CHECKFILE Yes 1 1 Y N N Y N Y
                  PREREQ Yes 6 6 Y N N Y N Y
                  CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
                  PATCH_TIMING Yes 2 2 Y N N Y N Y
                  PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
                  SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
                  JAVA_WORKER Yes 1 1 Y N N Y N Y
                  CODELEVEL Yes 1 1 Y N N Y N Y



                  Reading product information from file...

                  Reading language and territory information from file...

                  Reading language information from applUS.txt ...

                  AutoPatch warning:
                  Product Data File
                  /d01/oracle/VIS/apps/apps_st/appl/admin/zfaprod.txt
                  does not exist for product "zfa".
                  This product is registered in the database but the
                  above file does not exist in APPL_TOP. The product
                  will be ignored without error.


                  AutoPatch warning:
                  Product Data File
                  /d01/oracle/VIS/apps/apps_st/appl/admin/zsaprod.txt
                  does not exist for product "zsa".
                  This product is registered in the database but the
                  above file does not exist in APPL_TOP. The product
                  will be ignored without error.


                  AutoPatch warning:
                  Product Data File
                  /d01/oracle/VIS/apps/apps_st/appl/admin/jtsprod.txt
                  does not exist for product "jts".
                  This product is registered in the database but the
                  above file does not exist in APPL_TOP. The product
                  will be ignored without error.


                  Currently, the following language is installed:

                  Code Language Status
                  ---- --------------------------------------- ---------
                  US American English Base

                  Your base language will be AMERICAN.

                  Setting up module information.
                  Reading database for information about the modules.
                  Saving module information.

                  AD code level : [B.3]



                  Trying to obtain a lock...


                  Attempting to instantiate the current-view snapshot...

                  Was already instantiated. So no instantiation done this time.


                  **************** S T A R T O F U P L O A D ****************

                  Start date: Fri Dec 07 2012 09:15:06



                  0 "left over" javaupdates.txt files uploaded to DB: Fri Dec 07 2012 09:15:06

                  0 patches uploaded from the ADPSV format patch history files: Fri Dec 07 2012 09:15:06


                  Uploading information about files copied during the previous runs ...


                  Uploading "/d01/oracle/VIS/apps/apps_st/appl/admin/VIS/out/filescopied_542208.txt" ...


                  Start Processing Snapshot Info
                  No of records processed =5012
                  Gathering statistics for table 'AD_CHECK_FILE_TEMP'...
                  Done.




                  Updating Snapshot Tables...Start time:Fri Dec 07 2012 09:15:08
                  Done Updating Snapshot Tables for the above rows...End Time:Fri Dec 07 2012 09:15:37
                  No of records processed =10110
                  Updating Snapshot Tables...Start time:Fri Dec 07 2012 09:15:38
                  Done Updating Snapshot Tables for the above rows...End Time:Fri Dec 07 2012 09:15:53
                  No of records processed =15110
                  Updating Snapshot Tables...Start time:Fri Dec 07 2012 09:15:54
                  Done Updating Snapshot Tables for the above rows...End Time:Fri Dec 07 2012 09:16:07
                  No of records processed =20130
                  Updating Snapshot Tables...Start time:Fri Dec 07 2012 09:16:08
                  Done Updating Snapshot Tables for the above rows...End Time:Fri Dec 07 2012 09:16:19
                  No of records processed =25130
                  Updating Snapshot Tables...Start time:Fri Dec 07 2012 09:16:20
                  Done Updating Snapshot Tables for the above rows...End Time:Fri Dec 07 2012 09:16:31
                  No of records processed =30844
                  Gathering statistics for table 'AD_CHECK_FILE_TEMP'...
                  Done.




                  Updating Snapshot Tables...Start time:Fri Dec 07 2012 09:16:32
                  Done Updating Snapshot Tables for the above rows...End Time:Fri Dec 07 2012 09:16:37


                  Completed Processing Snapshot Info


                  1 "left over" filescopied_<session_id>.txt files uploaded to DB: Fri Dec 07 2012 09:15:06

                  ****************** E N D O F U P L O A D ******************




                  End date: Fri Dec 07 2012 09:16:38




                  Already asked for the name of the patch directory.
                  (The answer was: /home/applmgr/patches/9239090)

                  Already asked for the name of the patch driver file.
                  (The answer was: /home/applmgr/patches/9239090/u9239090.drv)

                  Reading release list save file...

                  Done reading release list save file

                  Log and Info File sync point:
                  Fri Dec 07 2012 09:16:40

                  Turning off actions that reference unrecognized products.


                  Log and Info File sync point:
                  Fri Dec 07 2012 09:16:40

                  End of unrecognized products checking.


                  (The number of parallel workers is: " 16 ")


                  AutoPatch will run in parallel mode.


                  Did not need to apply new applterr.txt.

                  Skipping...
                  Determine directories to create for Specified driver
                  since no such action is present for this driver file

                  Skipping...
                  Determine if need to generate message files for Specified driver
                  since no such action is present for this driver file

                  Skipping...
                  Create Directories for Specified driver
                  since no such action is present for this driver file

                  Number of invalid objects: 339

                  Number of invalid objects: 339

                  Getting list of invalid objects in APPS schema.

                  Invalid object reports are recorded in
                  /d01/oracle/VIS/apps/apps_st/appl/admin/VIS/log/542208_postenv.*

                  Generating forms library files...



                  Creating the AD_UTIL_PARAMS table...
                  Table AD_UTIL_PARAMS already exists, so dropping the table and recreating it.

                  Creating FND_INSTALL_PROCESSES table...

                  Already created fnd_install_processes table

                  Already created FND_INSTALL_PROCESSES_U1 index.

                  Already created AD_DEFERRED_JOBS table

                  Already created AD_DEFERRED_JOBS_U1 index.

                  Writing dependencies of jobs to run to appldep.txt file...

                  There are now 23 jobs remaining (current phase=A1000):
                  0 running, 23 ready to run and 0 waiting.

                  Reading completed jobs from restart file (if any).
                  AutoPatch error:
                  Unable to find job when restarting.

                  At line number 12 in the main restart file, the job with:
                  product = au username = APPLSYS
                  filename = APCACHE.pll phase = 1000 ign = 0 arguments = formgen /d01/oracle/VIS/apps/apps_st/appl/admin/VIS/out/pchfsucf.txt /d01/oracle/VIS/apps/apps_st/appl/admin/VIS/out/pchferrf.txt
                  has to run after some jobs that are not listed earlier in the file,
                  or it is a duplicate of another line,
                  or the job is invalid in some other way.
                  AutoPatch error:
                  adfrjp(): Error running jobs in workers


                  An error occurred while generating Oracle Forms library files.
                  Continue as if it were successful [No] : Yes

                  AutoPatch error:
                  aiurcl(): Discrepancy detected in restart file:
                  /d01/oracle/VIS/apps/apps_st/appl/admin/VIS/restart/adpmain.rf9

                  Line 13 from file = 'Done job: prod= au un= APPLSYS file= APPAYSHD.pll phase= 1000 ign= 0 succ= Y args= /7782A9A28770543E1E5EAAF47843A5A94C00E0A37356A1FE1A5CF1A6016499F50347F3EF634EA7E34472B4A9710DBEF8141BB0EB7256A5B7326893F23F5FEABF1254A8BB2D5BB2E94D10ADE76643B5BE4E0EA9AF3D47B3ED597189CB620DBDEF1047F5FE201F82FC101FBAE02A52E2BB1A47FDE7787384894B42B5FC7148B4FD1F01B5E73617A6E643/'
                  Line to compare = 'Drop synonym for FND_INSTALL_PROCESSES table'


                  You should check the file
                  /d01/oracle/VIS/apps/apps_st/appl/admin/VIS/log/adpatch.log

                  for errors.


                  Any ideas?

                  I started the APPS tier, it exited with status 0 but there's nothing in the browser. In which log file can i troubleshoot what would be the problem?


                  Edit:
                  I am able to log into the gui as sysadmin, and it takes me to the worklist page where there are lots of warnings and errors. For each one there's retry, reassign and request information.

                  What should I do?

                  Or maybe the better question would be, "Were did i do wrong in the first place, so I can roll back to that point and fix things from the beginning"

                  Edited by: 974556 on Dec 6, 2012 11:55 PM
                  • 6. Re: upgrade r12.1.1 to r12.1.3
                    Hussein Sawwan-Oracle
                    Please see (Ad Worker Error:Aiurcl():Discrepancy Detected In Restart File:Adpinit.rf9 [ID 358943.1]).

                    Thanks,
                    Hussein
                    • 7. Re: upgrade r12.1.1 to r12.1.3
                      i_do_me_you_do_you
                      Thanks Hussein,

                      I did exactly as described in the document, and the patch went ok, with some errors which I ignored.

                      Did also the post-install steps. It did upgrade to 112.1.3, but was practically unusable any more due to the thousands of errors.

                      So I decided to drop this installation, and start a new one.

                      Now what I have, is a fresh install with only the 4377566 patch installed and nothing else.

                      I follow the steps in 1080973.1 document, but I'm doing something wrong, and I'm not sure what is it.

                      The patches that I apply are the following, in this order:

                      9239089
                      8919491
                      9239090
                      9239095
                      9817770
                      9966055

                      First errors I get on the 9239090 patch (the actual RUP) The default database release out of the installer is 11.1.0.7. I've read this document "Database Preparation Guidelines for an E-Business Suite Release 12.1.1 Upgrade [ID 761570.1]" but I couldn't get a clue what should I do to the database first prior to upgrade, so I gave up and left it as it is.

                      I would be much grateful if anybody takes the time to tell me what am I missing here. Meanwhile, I'll run the upgrade once more, record all the steps, and post the errors here.

                      Thanks
                      • 8. Re: upgrade r12.1.1 to r12.1.3
                        Srini Chavali-Oracle
                        Pl see my blog post (linked in my profile) on this topic. I upgraded a Vision instance from 12.1.1 to 12.1.3 and documented all of the steps.

                        HTH
                        Srini
                        • 9. Re: upgrade r12.1.1 to r12.1.3
                          i_do_me_you_do_you
                          Thank you so much Srini,

                          I just looked at your blog post. It doesn't seem an easy task, but it's very detailed. I'm down to it, when I finish, I'll post the result.

                          Thanks again for the info.
                          • 10. Re: upgrade r12.1.1 to r12.1.3
                            Hussein Sawwan-Oracle
                            I follow the steps in 1080973.1 document, but I'm doing something wrong, and I'm not sure what is it.
                            What is the error you get?
                            The patches that I apply are the following, in this order:

                            9239089
                            8919491
                            9239090
                            9239095
                            9817770
                            9966055

                            First errors I get on the 9239090 patch (the actual RUP) The default database release out of the installer is 11.1.0.7. I've read this document "Database Preparation Guidelines for an E-Business Suite Release 12.1.1 Upgrade [ID 761570.1]" but I couldn't get a clue what should I do to the database first prior to upgrade, so I gave up and left it as it is.
                            You need to apply all the patches in the same doc, under "Path E: Upgrade Path for Systems with 11.5.10.2 with a 11.1.0.6, 11.1.0.7, 11.2.0.1, 11.2.0.2, 11.2.0.3 Database -- B) For users on 11.1.0.7" section.
                            I would be much grateful if anybody takes the time to tell me what am I missing here. Meanwhile, I'll run the upgrade once more, record all the steps, and post the errors here.
                            Please elaborate more on the issue you have.

                            Thanks,
                            Hussein
                            • 11. Re: upgrade r12.1.1 to r12.1.3
                              i_do_me_you_do_you
                              Hello Hussein,

                              I patched the database as described in the Path E for my configuration.

                              Got some errors running sql scripts, first, in the README file of the 6460304 patch says the following:


                              (3)Postinstallation
                              ----------------------

                              After you install the patch, reload the packages into the Oracle Database.
                              cd rdbms/admin
                              sqlplus "/ as sysdba"
                              @@catnomtt.sql
                              @@dbmsmeta.sql
                              @@dbmsmeti.sql
                              @@dbmsmetu.sql
                              @@dbmsmetb.sql
                              @@dbmsmetd.sql
                              @@dbmsmet2.sql
                              @@catmeta.sql
                              @@prvtmeta.plb
                              @@prvtmeti.plb
                              @@prvtmetu.plb
                              @@prvtmetb.plb
                              @@prvtmetd.plb
                              @@prvtmet2.plb
                              @@catmet2.sql


                              but in /rdbms/admin directory there is only one file catmeta.sql
                              So I've run only that one. It completed somewhat successfully and ended with:

                              SP2-0310: unable to open file "catmetx.sql"

                              I moved on as if this was successful although I have no idea what do these scripts do, and why would they be missing in the patch.

                              I encountered no other dificulties until applying the patchset itself. Adpatch gave this output:

                              Relinking executables...


                              An error occurred while relinking application programs.
                              Continue as if it were successful [No] : No
                              Freeing includes hash table
                              Freeing fixes hash table
                              Freeing basedons hash table
                              Freeing entities hash table

                              You should check the file
                              /d01/oracle/VIS/apps/apps_st/appl/admin/VIS/log/adpatch.log

                              for errors.


                              checked the adrelink.log and it says:

                              Done with link of xdp executable 'XDPCTRLS' on Thu Dec 13 17:09:16 EET 2012

                              Done relinking module XDPCTRLS in product xdp
                              Done with link of product 'xdp' on Thu Dec 13 17:09:16 EET 2012

                              copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/adshell.pl to
                              /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/adshell.pl
                              copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/aducsifm.pm to
                              /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/aducsifm.pm
                              copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/aducssp.pl to
                              /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/aducssp.pl
                              copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/adutils.pl to
                              /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/adutils.pl
                              copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/adpchnew to
                              /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/adpatchnew
                              copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/adadminnew to
                              /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/adadminnew
                              copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/adwrknew to
                              /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/adworker
                              copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/adctrlnew to
                              /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/adctrlnew

                              Swapping bintmp and binstage.
                              Stage preparation complete.

                              adrelink is exiting with status 1

                              End of adrelink session
                              Date/time is Thu Dec 13 17:09:17 EET 2012


                              Can somebody tell me what goes wrong here?

                              Thank you in advance for your help!
                              • 12. Re: upgrade r12.1.1 to r12.1.3
                                Hussein Sawwan-Oracle
                                Please post the output of this query:
                                SQL> select comp_id, comp_name, version, status
                                from dba_registry
                                order by 1;
                                If XDB option is installed, you will need to run the catmetx.sql script -- Best Practices for running catalog, catproc and utlrp script [ID 863312.1]

                                Thanks,
                                Hussein
                                • 13. Re: upgrade r12.1.1 to r12.1.3
                                  i_do_me_you_do_you
                                  It seems like XDB is installed.

                                  Here's the output:


                                  SQL> select comp_id, comp_name, version, status
                                  2 from dba_registry
                                  3 order by 1;

                                  COMP_ID           COMP_NAME
                                  ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                                  VERSION           STATUS
                                  ------------------------------ --------------------------------------------
                                  AMD               OLAP Catalog
                                  11.1.0.7.0          VALID

                                  APEX               Oracle Application Express
                                  3.0.1.00.12          VALID

                                  APS               OLAP Analytic Workspace
                                  11.1.0.7.0          VALID


                                  COMP_ID           COMP_NAME
                                  ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                                  VERSION           STATUS
                                  ------------------------------ --------------------------------------------
                                  B2B               Oracle Application Server Integration B2B
                                  10.1.2.0.2          VALID

                                  BAM               Oracle Application Server Integration BAM
                                  10.1.2.0.2          VALID

                                  CATALOG           Oracle Database Catalog Views
                                  11.1.0.7.0          VALID


                                  COMP_ID           COMP_NAME
                                  ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                                  VERSION           STATUS
                                  ------------------------------ --------------------------------------------
                                  CATJAVA           Oracle Database Java Packages
                                  11.1.0.7.0          VALID

                                  CATPROC           Oracle Database Packages and Types
                                  11.1.0.7.0          VALID

                                  CONTEXT           Oracle Text
                                  11.1.0.7.0          VALID


                                  COMP_ID           COMP_NAME
                                  ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                                  VERSION           STATUS
                                  ------------------------------ --------------------------------------------
                                  DCM               Oracle Application Server Distributed Configuration Management
                                  10.1.2.0.2          VALID

                                  DISCOVERER          Oracle Business Intelligence Discoverer
                                  10.1.2.0.2          VALID

                                  JAVAVM               JServer JAVA Virtual Machine
                                  11.1.0.7.0          VALID


                                  COMP_ID           COMP_NAME
                                  ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                                  VERSION           STATUS
                                  ------------------------------ --------------------------------------------
                                  MRC               Oracle Application Server Metadata Repository Version-R
                                  10.1.2.0.2          VALID

                                  OCA               Oracle Application Server Certificate Authority
                                  10.1.2.0.2          VALID

                                  ODM               Oracle Data Mining
                                  11.1.0.7.0          VALID


                                  COMP_ID           COMP_NAME
                                  ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                                  VERSION           STATUS
                                  ------------------------------ --------------------------------------------
                                  OID               Oracle Internet Directory
                                  10.1.2.0.2          VALID

                                  OLS               Oracle Label Security
                                  10.2.0.3.0          OPTION OFF

                                  ORDIM               Oracle Multimedia
                                  11.1.0.7.0          VALID


                                  COMP_ID           COMP_NAME
                                  ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                                  VERSION           STATUS
                                  ------------------------------ --------------------------------------------
                                  RAC               Oracle Real Application Clusters
                                  11.1.0.7.0          INVALID

                                  SDO               Spatial
                                  11.1.0.7.0          VALID

                                  SSO               Oracle Application Server Single Sign-On
                                  10.1.2.0.2          VALID


                                  COMP_ID           COMP_NAME
                                  ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                                  VERSION           STATUS
                                  ------------------------------ --------------------------------------------
                                  SYNDICATION          Oracle Application Server Syndication Services
                                  10.1.2.0.2          VALID

                                  UDDI               Oracle Application Server UDDI Registry
                                  10.1.2.0.2          VALID

                                  WCS               Oracle Application Server Web Clipping
                                  10.1.2.0.2          VALID


                                  COMP_ID           COMP_NAME
                                  ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                                  VERSION           STATUS
                                  ------------------------------ --------------------------------------------
                                  WIRELESS          Oracle Application Server Wireless
                                  10.1.2.0.2          VALID

                                  WK               Oracle Ultra Search
                                  11.1.0.7.0          VALID

                                  WORKFLOW          Oracle Workflow
                                  10.1.2.0.2          VALID


                                  COMP_ID           COMP_NAME
                                  ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                                  VERSION           STATUS
                                  ------------------------------ --------------------------------------------
                                  XDB               Oracle XML Database
                                  11.1.0.7.0          VALID

                                  XML               Oracle XDK
                                  11.1.0.7.0          VALID

                                  XOQ               Oracle OLAP API
                                  11.1.0.7.0          VALID


                                  30 rows selected.


                                  Where can I find that catmetx.sql script? It wasn't present in the patch.

                                  Question number 2.

                                  Could this error be the reason for adrelink failure during the autopatch process?
                                  • 14. Re: upgrade r12.1.1 to r12.1.3
                                    i_do_me_you_do_you
                                    By the way, how could I know what executable did adrelink failed to relink.

                                    the output is the folowing, no Idea what should I do next.


                                    copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/adshell.pl to /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/adshell.pl
                                    copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/aducsifm.pm to /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/aducsifm.pm
                                    copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/aducssp.pl to /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/aducssp.pl
                                    copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/adutils.pl to /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/adutils.pl
                                    copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/adpchnew to /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/adpatchnew
                                    copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/adadminnew to /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/adadminnew
                                    copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/adwrknew to /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/adworker
                                    copying /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin/adctrlnew to /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bintmp/adctrlnew

                                    Swapping bintmp and binstage.
                                    Stage preparation complete.

                                    adrelink is exiting with status 1

                                    End of adrelink session
                                    Date/time is Fri Dec 14 11:24:42 EET 2012
                                    1 2 Previous Next