How to set up Automatic Custom Code / Patches Upload using Oracle Wallet?

This article explains how to how to set up automatic custom code upload using Oracle Wallet
See also - How to implement Automatic Custom Code Upload using API?

Prerequisites

  1. Follow these instructions to retrieve the Panaya Certificate
  2. Save the Certificate in Base-64 encoded X.509 (.CER) format
  3. Follow the instruction below to create a new Oracle Wallet or configure an existing wallet

To create a new Oracle Wallet - 

  1. Download and install PuTTY
    PuTTy will allow you to access your Oracle server
  2. Download and configure VNC client
    The VNC client will allow you view your Oracle Wallet GUI
  3. Use PuTTY to connect to your Oracle EBS server
    Then, type vncserver 
    Input your password 

  4. Use VNC Viewer to connect to your Oracle Wallet
  5. Open the VNC Viewer command line and type - owm

  6. Create a new wallet certificate

  7. In the first dialog box, select NO to create a default new wallet
  8. Right-click on the Trusted Certificate node and select Import - Trusted Certificate...
  9. Select the Paste the certificate option
  10. Open the Panaya Certificate file downloaded previously 

    Copy the entire content (Ctrl+ C)
    and Paste the content (Ctrl + P) into the Import Trusted Certificate dialog box in VNC

    Click OK
  11. Click on Wallet and select Save As
    Save the wallet on your server machine
  12. Check to see that the new certificate appears in the list of Trusted Certificates
  13. Use Unix to verify the location of the wallet by using the 'cd' and 'is command' with the relevant path

To configure your existing Oracle Wallet - 

  1. Download Oracle Wallet file and save it on your Oracle EBS server
  2. Import the file to your existing wallet (using OWM)
  3. Take note of the directory path of the exact wallet location to be used in the scheduling process below

Scheduling the Concurrent Program
Configure your EBS to work with a concurrent program in order to upload the custom code extraction file to the Panaya servers on a regular basis.
Follow these instructions to set up the concurrent program

Configuring the Concurrent Program
Configure your EBS to work with a concurrent program in order to automatically extract and upload patches to Panaya
Follow these instructions to set up the concurrent program