Pega7 Installation Support
As per Pega documentation, we have generated below DDL files. Can you please advise the following:
1. Which DDLs and the order in which they should be applied on Oracle Database?
2.Where is Java.jar file located in package?
3. On which schema(rules or data) should we install below prreadstream.jar user-defined function archive file?
Accepted Solution
Pegasystems Inc.
US
Regarding the second point java.jar file, the instruction is "Register the Java .jar file with the database." in the installation guide.
You can verify if your database has Java installed by running the below query in your database.
SQL> select comp_name, version, status from dba_registry where upper(comp_name) like '%JAVA%';
Once you verify if Java is present, you can proceed to next step.
Pegasystems Inc.
US
Is it that you want to apply the DDL yourself instead of having the installation tool do it for you? To install the DDL needed for the install you just need to execute the oracledate.sql file. To install the UDFs you can use the generateudf script to install them. You do not need to install the UDFs before preceding with the rest of the install.
Pegasystems Inc.
US
In the archives/udf directory you will see prreadstream.jar which is the udf jar file for Oracle databases. The UDFs should be installed in both the rules and data schemas.
Accepted Solution
Pegasystems Inc.
US
Regarding the second point java.jar file, the instruction is "Register the Java .jar file with the database." in the installation guide.
You can verify if your database has Java installed by running the below query in your database.
SQL> select comp_name, version, status from dba_registry where upper(comp_name) like '%JAVA%';
Once you verify if Java is present, you can proceed to next step.