How To Use Patch Wizard Without Setting Up Internet Connection

 Below document describes the process for using Patch Wizard without setting up an Internet connection

Follow the steps below to run Patch Wizard without an internet connection to generate the latest EBS Patch Recommendation Analysis or to analyze any EBS patch(es) against your current EBS Application.

The infobundle is updated daily and should be refreshed/downloaded each time/day you wish to analyze patches on your EBS Environment using Patch Wizard.

If you want to get the latest Oracle E-Business Suite patch recommendations:

  1. Download the Patch Information Bundle (InfoBundle) on to a system that has Internet access.

    The InfoBundle is generated daily, and can be downloaded from the following locations:

    https://updates.oracle.com/download/InfoBundleR12.zip (for R12)
    or
    https://updates.oracle.com/download/InfoBundle11i.zip (for 11i)

  2. From Patch Wizard > Preferences, set up a staging directory if not already done so.

    Make sure the Patch Wizard can read from and write to the staging directory. The InfoBundle Zip file must be copied to a system which can access the Patch Wizard staging directory. If the staging directory is on a local disk, it must be copied to the system where you run Patch Wizard. If the staging directory is on shared (network) disk, they can be copied to any system with access to the shared disk.

    For example: Patch Wizard runs in the concurrent tier and is usually owned by SYSADMIN, so ensure SYSADMIN can access the staging directory from the concurrent tier
     
  3. Copy the InfoBundle Zip file to the staging directory.

  4. Go to Patch Wizard > Recommend/Analyze Patches.

  5. Select Create Recommendation, choose any Patch Filters and click OK.
  6. When the patch analysis is complete, the recommendation report appears on the Patch Wizard page. Click the Details icon to view the detailed report.

If you want to analyze one or more patches:

  1. If the InfoBundle has not already been downloaded and made available, follow steps 1-6 in the above instructions on generating recommendations.

  2. Download the patch Zip file(s) onto a system that has Internet access.

    The patch Zip files are available from My Oracle Support --> Patches & Updates --> Patch Search section (https://support.oracle.com/epmos/faces/PatchHome) 

    ie p12345678_12.1.0_R12_LINUX.zip

  3. From Patch Wizard > Preferences, set up a staging directory if you have not already done so.

    Make sure the Patch Wizard can read from and write to the staging directory. The patch Zip files must be copied to a system which can access the Patch Wizard staging directory. If the staging directory is on a local disk, they must be copied to the system where you run Patch Wizard. If the staging directory is on shared (network) disk, they can be copied to any system with access to the shared disk.

    For example: Patch Wizard runs in the concurrent tier and is usually owned by SYSADMIN, so ensure SYSADMIN can access the staging directory from the concurrent tier

  4. Copy the downloaded patch Zip file(s) to the Patch Wizard staging directory.

    In Oracle E-Business Suite R12.2 and higher, all patches must be placed in the staging directory, which is recommended to be set as $PATCH_TOP.
    In Oracle E-Business Suite R12.1, all the AD product patches must be placed in the <staging  directory>/ad directory, and all the non-AD patches must be placed in the <staging directory>/nonad directory.

  5. Go to Patch Wizard > Recommend/Analyze Patches.

  6. Select Analyze Specific Patches.
    NOTE: Enter the patch number(s) in the text box and click OK


     

  7. When the patch analysis is complete, the analysis report appears on the Patch Wizard page. Click the Details icon to view the detailed report.



Comments

Post a Comment

Popular posts from this blog

How to fix Oracle SQL Developer connection issue "Got minus one from a read call"

Image
 During connection from SQL Developer to EBS database got below error message: Status : Failure - Test failed: IO Error: Got minus one from a read call Following solution can be done : 1. Go to directory $ORACLE_HOME / network / admin 2. Modify sqlnet.ora file with following parameter : tcp.validnode_checking = no 3. If you don 't want to disable this, you can put the machine names as follows: tcp.invited_nodes=(machine1, machine2) 3. Bounce the listener. Due to security enhancements it is not good to put tcp.validnode_checking = no or comment out will through error when we start listener like below: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=shsebs7idb1.appsolworld.com)(PORT=1522))) TNS-00584: Valid node checking configuration error TNS-12560: TNS:protocol adapter error Better plan is to add localhost or IP address of client (Local Computer) in the sqlnet.ora file That will solve the problem NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME) SQLNET.EXPI
Read more

Few Important steps of Oracle Database Clone

 Make Sure oraInst.loc location is correct and accessble. [demantra@dsiddem ~]$ cat /etc/oraInst.loc inventory_loc=/orastage/oraInventory inst_group=dba [demantra@dsiddem ~]$ cd /orastage/oraInventory [demantra@dsiddem oraInventory]$ ls -ltr total 16 drwxrwx---. 5 demantra dba 4096 Jul 22 19:37 backup drwxrwx---. 2 demantra dba 4096 Jul 22 19:37 ContentsXML drwxrwx---. 2 demantra dba 4096 Jul 22 19:37 locks drwxrwx---. 3 demantra dba 4096 Jul 23 10:08 logs Remove Oracle Home from Inventory [demantra@dsiddem oraInventory]$ cd $ORACLE_HOME/oui/bin [demantra@dsiddem bin]$ ./runInstaller -detachHome ORACLE_HOME=$ORACLE_HOME Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB.   Actual 3039 MB    Passed The inventory pointer is located at /etc/oraInst.loc Run Clone.pl [demantra@dsiddem bin]$ echo $ORACLE_HOME /dnbsid/demantra/oracle/19.0.0 [demantra@dsiddem bin]$ echo $ORACLE_BASE /dnbsid/demantra [demantra@dsiddem bin]$ E01=ORACLE_HOME=$ORACLE_HOME [dema
Read more

How to autopopulate user_guid in fnd_user table ( EBS Blank Page)

  Issue:  EBS Local Login url is working fine. When accessing sso url, users are getting error as below appended to the url. And login page will be blank. One of the reason could be : OAM Authentication is fine but during authorization process, OAM is unable to map guid from oid to user_guid in fnd_user. This can be due to user_guid being null in fnd_user table. As per the process, when user logins for the first time, user_guid need to be populated automatically (from oid) Query guid from oid and update fnd_user table with that. ldapsearch -h oidhost.appsolworld.com -p 3060 -D "cn=orcladmin" -w orcladmpwd -b "cn=Users,dc=dc,dc=online,dc=org" -s sub "(uid=$1)" orclsamaccountname krbprincipalname mail orcluserprincipalname orclguid Pass userid to this command which gives guid along with other details. Update fnd_user table with above guid : update fnd_user  set user_guid=' ' where user_name like ' '; Solution:  As per the process,  when user
Read more