How to set up Automatic Custom Code / Patches Upload using Oracle Wallet?
  • 1 Minute to read
  • Dark
    Light
  • PDF

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

  • Dark
    Light
  • PDF

Article Summary

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

  • TLS 1.2 protocol support 
  • Oracle EBS DB version 12.1.0.2 and above or Oracle EBS DB version 11.2.0.4


  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


Creating 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


Configuring existing Oracle Wallet 

  1. Download the 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