Upgrade Integrated Axia Services in CR2 to Axia 3.0 Implementation Compatibility

(V 02.00.20-00)

Upgrade Existing Axia 2.0 integrated schema

• I(2) & II

• Compile the 3.0 compatible Axia program by using compile.bat

New installation (Axia 3.0)

• Execute steps in I and II.

• Compile the 3.0 compatible Axia program by using compile.bat

Extend the Axia usage on a new schema

• I(1a)

• I(2) & II

• Compile the 3.0 compatible Axia program by using compile.bat

Axia 3.0 Upgrade Steps

I. Set up AXIA configuration on a schema

Oracle Wallet manager setup with certificate

1. Option 1: Set the oracle wallet at DB server using the certification file Axia#1.p7b, steps:

   1. Connect DB server and create UBS_R2 folder at D drive

      1. Create wallets folder under D:\UBS_R2

      2. Create AXIA folder under D:\UBS_R2

   2. Place the Axia#1.p7b files into D:\UBS_R2\AXIA

   3. Run the below scripts to setup the wallet.

      1. orapki wallet create -wallet <Wallet Path> -pwd <Password> -auto_login

      2. orapki wallet add -wallet <Wallet Path> -trusted_cert -cert <Axia certification file and path> -pwd <Password>

Sample script to execute

@Windows DB Server:

orapki wallet create -wallet D:\UBS_R2\wallets -pwd test1234 -auto_login

orapki wallet add -wallet D:\UBS_R2\wallets -trusted_cert -cert D:\UBS_R2\Axia#1.p7b -pwd test1234

@Linux DB Server:

Change directory to /D and give permissions of read, write, and execute permissions to /D/UBS_R2/. And then run Oracle scripts.

sudo chmod -R 777 UBS_R2/

Change directory to /D/UBS_R2

orapki wallet create -wallet /D/UBS_R2/wallets -pwd test1234 -auto_login

orapki wallet add -wallet /D/UBS_R2/wallets -trusted_cert -cert /D/UBS_R2/AXIA/Axia#1.p7b -pwd test1234

Note: 'Oracle' should have read, write, and execute permissions the folders created above and files in it

2. Option 2: Import the certification at Oracle wallet using wallet manager

   1. Once the wallet has set at DB Server, then the Wallet Path and Password should be set at R2 Wallet Manager at Configuration. Path should set like below if the database which R2/CR2 connect.

      1. Windows: D:\UBS_R2\wallets

      2. Linux: /D/UBS_R2/wallets

   2. Set the ACL for Axia procedure execution.

      1. Use SetupAxiaACL.bat program by feeding the sys schema details and the schema where Axia ACL should be created.

      2. Verify the success of the above program through the log file SetupAxiaACL.log.

II. Setup Axia 3.0 API URL

• Execute the Scripts.txt which sets the Axia production URL which need to invoke on every action.

III. Delete existing privilege from ACL for a schema (if need to redo setup on same schema)

• Use DeleteAxiaACL.bat program by feeding the sys schema details and the schema where Axia ACL should be deleted.

• Verify the success of the above program through the log file log file DeleteAxiaACL.log

Note:

1. The above steps to be done only once in the database to setup the Axia.

2. On every upgrade, the procedure packages of Axia should be compiled using Compile.bat.

3. Sandbox_Scripts.txt can be used if there is a Sandbox credential avaialble for a test instance.