This chapter contains Setup instructions for DidiSoft ORA_RSA PL/SQL package.

Table of contents

1. Setup
2. Upgrade
3. Uninstall
4. Switch from trial to production version

Setup

Step 1) Extract the distribution ZIP archive to a folder on your disk drive (referred below as “extraction
folder”)
Step 2) Load the JAR files
Load the JAR files using the loadjava.sh/.batutility located in the Oracle Database instance /BIN/ folder.
(For example on Windows C:\app\\product\\db_1\BIN\loadjava.bat)
Note:Replace below user/pass with a real database schema/user name and password applicable for your
Oracle Database.

[Windows environment]

loadjava.bat -r -v – u user/pass [extraction folder]\SetupFiles\jce-jdk13-152.jar
loadjava.bat -r -v – u user/pass [extraction folder]\SetupFiles\ora-rsa-1.1.0.jar

[Unix environment]

loadjava.sh -r -v – u user/pass [extraction folder]/SetupFiles/jce-jdk13-152.jar
loadjava.sh -r -v – u user/pass [extraction folder]/SetupFiles/ora-rsa-1.1.0.jar

Step 3) Register the ORA_RSA PL/SQL package
Using your favorite PL/SQL execution environment (SQL*Plus, Oracle(c) SQLDeveloper(c), etc.) execute the
scripts:

[extraction folder]/SetupFiles/Ora_RSA_Pack age.sql
[extraction folder]/SetupFiles/Ora_RSA_Pack age_Body.sql

Step 4) Permissions
Using your favorite PL/SQL execution environment (SQL*Plus, Oracle(c) SQLDeveloper(c), etc.) execute:

CALL dbms_java.grant_permission( 'user',
'SYS:java.security.SecurityPermission', 'putProviderProperty.BC', '' );
CALL dbms_java.grant_permission( 'user',
'SYS:java.security.SecurityPermission', 'insertProvider.BC', '' );
commit;

Note: Replace above ‘user’with the database user/schema name that will
execute the code.

Upgrade

Upgrading to a new version of ORA_RSA requires first to unload the old version JAR files from the
Oracle© database:

dropjava.sh/.bat -r -v – u user/pass [extraction folder]\SetupFiles\jce-jdk13-152.jar
dropjava.sh/.bat -r -v – u user/pass [extraction folder]\SetupFiles\ora-rsa-1.0.0.jar

Then continue to Setup

Note: Replace above user/password with the database user/schema name and password used in the initial Setup.

Uninstall

The uninstall process requires first to unload the old version JAR files from the Oracle© database:

dropjava.sh/.bat -r -v – u user/pass [extraction folder]\SetupFiles\jce-jdk13-152.jar
dropjava.sh/.bat -r -v – u user/pass [extraction folder]\SetupFiles\ora-rsa-1.1.0.jar

and afterwards to drop the ORA_RSA package using your favorite PL/SQL execution environment
(SQL*Plus, Oracle(c) SQLDeveloper(c), etc.

DROP package ORA_RSA;
DROP package body ORA_RSA;

Note: Replace above user/pass with the database user/schema name and password
that were used in sub chapter Setup

From Trial to Production

To switch from an evaluation (trial) version of the software to a licensed production version, please execute
the steps in