Configure Oracle Wallet - Intergraph Smart Materials - 2017 R2 (2.2) - Administration & Configuration - Hexagon

Intergraph Smart Materials EcoSys Integration 2017 R2 (2.2)
Language
English
Product
Intergraph Smart Materials
Subproduct
EcoSys Integration
Search by Category
Administration & Configuration
Version Smart Materials Web API
2017 R2 (2.2)

This process is required only for those EcoSys service URLs that starts with https.

You can configure the Oracle wallet in a two-step process:

  1. Download the SSL Certificates

  2. Create a wallet using the Oracle Wallet Manager.

Download the SSL Certificates

To download SSL Certificates, do the following:

  1. Add the https URL in a browser address bar.

  2. In the browser, click Show/View site information, and then click Certificate.

  3. In the Certificate pop-up, select Certification Path.

  4. Select a Certificate (root or intermediate), and then click View Certificate.

  5. Select the Details tab> click Copy to File, and then click Next.

  6. Select the export file format as Base-64 encoded X.509(.CER), and then click Next.

  7. Select the folder to save the certificate > click Next > click Save.

  8. To add all the root and intermediate certificates repeat steps 4 through 7.

Create a wallet using Oracle Wallet Manager

To create a wallet using Oracle Wallet Manager, do the following:

  1. Open Oracle Wallet Manager.

  2. Click New. To create a default wallet directory, click Yes, and to continue, click Yes.

  3. Type the wallet password and then reconfirm the password.

  4. To create a Certificate request, click No.

  5. To import the certificates, select the empty certificate, and click Operations > Import Trusted Certificate.

  6. Select the option Select a file that contains the certificate, and then click OK.

  7. Navigate and select the certificates from the certificate folder, and then click Open.

    The certificates are added to the Trusted Certificates list.

  8. Save the Oracle Wallet on a machine where the PL/SQL code can access the wallet.

    If Oracle wallet is not created in DB server, then copy this wallet to DB server where the PL/SQL Code can access the wallet.

After configuring the Oracle Wallet, to access it, provide the Oracle Wallet path and password in the following CIP:

  • Set wallet path at M_PCK_ECOSYS_CUSTOM.get_wallet_path CIP, provide the path format "p_wallet_path:='file:<filepath in db server>"

  • Set wallet password at M_PCK_ECOSYS_CUSTOM.get_wallet_pwd CIP.