3 Pricing Design Center Preinstallation Tasks
Learn about prerequisite tasks, such as installing and configuring the database, that you perform before installing Oracle Communications Pricing Design Center (PDC) for the first time.
Before installing PDC for the first time, do the following:
-
Install and configure Oracle Database. See "Installing and Configuring Oracle Database".
-
Install Java Runtime Environment (JRE)/Java Development Kit (JDK). See "Installing JRE/JDK".
-
Install and configure Oracle WebLogic Server. See "Installing and Configuring Oracle WebLogic Server".
-
Set the JAVA_HOME environment variable. See "Setting the JAVA_HOME Environment Variable".
-
Enable JRE permissions. See "Enabling JRE Permissions".
-
Install the compatible version of BRM on the machine on which you will install PDC BRM Integration Pack. See "Installing BRM" in BRM Installation Guide.
See BRM Compatibility Matrix for the compatible version of BRM.
-
Enable integration between BRM and PDC. See "Enabling BRM-PDC Integration".
Installing and Configuring Oracle Database
Oracle recommends that the installation and configuration of Oracle Database be performed by an experienced database administrator. To install and configure Oracle Database, see the Oracle Database installation documentation.
When you install the software, do the following:
-
Install Oracle Database Enterprise Edition.
-
Create the PDC database.
-
Create a database to store the transformation cross-reference tables, or use the PDC database to store the transformation cross-reference tables.
-
Create a database to store the migration cross-reference tables, or use the PDC database or the transformation cross-reference database to store the migration cross-reference tables.
-
(Optional) Create PDC tablespaces and temporary tablespaces for the following:
-
The PDC schema, to store the pricing and setup components.
-
The transformation cross-reference schema, to store tables that map pricing and setup components in PDC to the corresponding component in a target rating engine.
-
The migration cross-reference schema, to store tables that map the pricing and setup components that are migrated from the BRM database to the corresponding component in a target rating engine.
Oracle recommends that you create separate PDC tablespaces and temporary tablespaces for each schema. However, you can use a single PDC tablespace and temporary tablespace to create all the schemas.
-
Setting the Database Time Zone
The PDC database must have the appropriate local time zone setting.
For more information on setting the time zone, see the Oracle Database Globalization Support Guide.
Note:
Ensure that the BRM database and the PDC database are in the same time zone.
After PDC has been installed, the database time zone cannot be changed. Ensure the time zone is correctly set before installing PDC.
Tuning the Database
Table 3-1 and Table 3-2 provide recommended database parameters for tuning your database for the PDC installation. These are the minimum requirements for PDC.
Table 3-1 Database Creation Parameters
Parameter | Recommended Value |
---|---|
SGA+PGA |
At least 4 GB in total. Oracle recommends that you use as much memory as you have available in the machine, and also use Automatic Memory Management. |
Processes |
2000 |
Connection mode |
Dedicated server |
Redo log file size |
1024 MB minimum |
Table 3-2 Database Initialization Parameters
Parameter | Recommended Value |
---|---|
db_file_multiblock_read_count |
16 |
distributed_lock_timeout |
7200 |
dml_locks |
9700 |
job_queue_processes |
10 |
log_buffer |
31457280 |
open_cursors |
5000 |
parallel_max_servers |
640 |
plsql_code_type |
NATIVE |
Configuring SSL for the PDC Database
You can configure secure sockets layer (SSL) for the Oracle database by creating wallets for storing certificates and then modifying the following configuration files:
-
sqlnet.ora
-
tnsnames.ora
-
listener.ora
You can use the Orapki utility to create the wallets.
For information about configuring SSL for the Oracle database, see the Oracle Database documentation.
Installing JRE/JDK
Install the recommended version of JRE/JDK on the machine on which you want to deploy PDC. See BRM Compatibility Matrix for the recommended version of JRE/JDK.
To verify the JRE/JDK version:
-
Go to the command prompt on the machine on which you want to deploy PDC.
-
Enter the following command:
java -version
The Java version is displayed. For example:
java version "1.8.0_221"
If the version displayed does not start with 1.8.0_, JRE/JDK 1.8 is not installed.
For information about installing JRE/JDK, see the Oracle Java documentation.
Installing and Configuring Oracle WebLogic Server
This section describes procedures relating to installing Oracle WebLogic Server and configuring the WebLogic Server domain in which you will deploy PDC.
See the information in the following sections:
- Downloading and Installing Oracle WebLogic Server
- Copying Library JAR Files for PDC Installation
- Applying WebLogic Server Patch
- Installing Oracle Application Development Runtime
- Creating the Oracle WebLogic Server Domain
- Configuring SSL for the WebLogic Server Domain
- Configuring the SSL Protocol Version
- (Release 15.0.1 only) Enabling TLS in PDC REST Services Manager
- Setting the JDBC Path for the WebLogic Server Domain
- Configuring WebLogic Server to use SSL-Enabled Data Source
- Updating JDBC LLR Table Name
Downloading and Installing Oracle WebLogic Server
WebLogic Server is a component of the Oracle Fusion Middleware media pack. For the compatible version of WebLogic Server, see BRM Compatibility Matrix.
For information on installing Oracle WebLogic Server and the patches (if any), see the Oracle WebLogic Server documentation on the Oracle Help Center:
Copying Library JAR Files for PDC Installation
Copy the needed jar files to your PDC implementation.
-
Apply patch p26626168_122140_Generic.zip on top of your WebLogic Server installation.
-
If you will be installing the PDC software, copy the following files to a directory on your PDC machine:
-
The ojdbc8.jar file from your Oracle database installation
-
Middleware_home/oracle_common/modules/oracle.pki/oraclepki.jar
-
Middleware_home/oracle_common/modules/oracle.osdt/osdt_cert.jar
-
Middleware_home/oracle_common/modules/oracle.osdt/osdt_core.jar
where Middleware_home is the ORACLE_HOME directory of your WebLogic Server installation.
-
-
If you will be installing the BRM Integration Pack, copy the following files to a directory on your PDC machine:
-
The ojdbc8.jar file from your Oracle database installation
-
Middleware_home/oracle_common/modules/oracle.idm/identitystore.jar
-
Middleware_home/oracle_common/modules/oracle.jps/jps-api.jar
-
Middleware_home/oracle_common/modules/oracle.nlsrtl/orai18n.jar
-
Middleware_home/oracle_common/modules/oracle.nlsrtl/orai18n-collation.jar
-
Middleware_home/oracle_common/modules/oracle.xdk/xmlparserv2.jar
-
Middleware_home/oracle_common/modules/oracle.xdk/xml.jar
-
Middleware_home/oracle_common/modules/com.sun.xml.bind.jaxb-impl.jar
-
Middleware_home/oracle_common/modules/com.sun.xml.bind.jaxb-core.jar
-
Middleware_home/oracle_common/modules/oracle.pki/oraclepki.jar
-
Middleware_home/oracle_common/modules/oracle.osdt/osdt_cert.jar
-
Middleware_home/oracle_common/modules/oracle.osdt/osdt_core.jar
-
Middleware_home/oracle_common/modules/javax.jms.javax.jms-api.jar
-
Middleware_home/wlserver/modules/javax.transaction.javax.transaction-api.jar
-
Middleware_home/wlserver/server/lib/wlthint3client.jar
-
Middleware_home/wlserver/server/lib/wlclient.jar
-
Middleware_home/wlserver/server/lib/wljmsclient.jar
-
Middleware_home/wlserver/server/lib/wljmxclient.jar
-
Middleware_home/wlserver/server/lib/wlnmclient.jar
-
Middleware_home/wlserver/server/lib/wlsafclient.jar
-
-
During the PDC and BRM Integration Pack installation process, the installer will prompt you for the directory in which your prerequisite libraries are located. You will need to enter the path where you copied the JAR files.
Applying WebLogic Server Patch
Install Patch 33903365 on top of your WebLogic Server installation.
To apply the WebLogic Server patch:
-
Apply patch p33903365_122140_Generic.zip on top of your WebLogic Server 12.2.1.4.0 installation.
-
Restart WebLogic Server.
Installing Oracle Application Development Runtime
Oracle Application Development Runtime must be installed on the machine on which you will install PDC. For more information on the compatible version, see BRM Compatibility Matrix.
Download Oracle Application Development Runtime from the following page:
https://www.oracle.com/tools/downloads/application-development-framework-downloads.html
For information on installing Oracle Application Development Runtime, see Oracle Fusion Middleware Installation Guide for the appropriate version.
Note:
The Oracle Fusion Middleware Application Developer Installer installs Oracle Application Development Runtime and Oracle Enterprise Manager.
Creating the Oracle WebLogic Server Domain
Before creating a WebLogic Server domain, use the Oracle Fusion Middleware Repository Creation Utility (RCU) to create the required Oracle Identity and Access Management (IAM) database schema. See Fusion Middleware Repository Creation Utility User's Guide for more information on RCU.
To create a WebLogic Server domain in which to deploy PDC, see the description of using the Configuration Wizard in the Oracle WebLogic Server documentation. You can use the Configuration Wizard in graphical mode or console mode.
Note:
If you are migrating the PDC pricing data from a source PDC system to a target PDC system that supports ECE, ensure that you create the WebLogic Server domain for the target PDC system on the same machine on which the WebLogic Server domain for the source PDC system exists.
Table 3-3 shows the values to choose when creating the WebLogic Server domain for PDC.
Create the WebLogic Server domain with at least one managed server configured along with the administration server because Oracle recommends that you deploy PDC on a managed server in the production environment.
Table 3-3 Oracle WebLogic Server Domain Configuration Values
Configuration Value | Description |
---|---|
Domain source |
Select Generate a domain configured automatically to support the following products. From the list, select Oracle JRF - 12.2.1.2.0 [oracle_common]. |
Domain Mode Configuration |
Select Production Mode. |
JDK Selection |
From the Available JDKs list, select the JDK version required for installing PDC. For more information, see BRM Compatibility Matrix. |
Optional Configuration |
Select the following:
|
Administration Server Listen Address |
Use a listen address that is equal to a resolvable DNS host or IP address. |
Administration Server Listen Port |
Enter a free port number. |
Managed Server Listen Address |
(Optional) Enter a listen address that is equal to a resolvable DNS host or IP address. |
Managed Server Listen Port |
(Optional) Enter a free port number. |
Target Deployments to Clusters or Servers |
(Optional) Add all libraries to the managed server target and to the administration server. |
Target Services to Clusters or Servers |
(Optional) Add all services to the managed server target. |
SSL Listen Port Enabled |
Select the SSL Listen Port Enabled check box. |
SSL Listen Port |
Enter a free port number. |
See Oracle Fusion Middleware Installation Guide for Oracle Enterprise Content Management Suite for the appropriate version to see more information on WebLogic Server domains.
You can now start the administration server manually and log in to WebLogic Administration Console.
Configuring SSL for the WebLogic Server Domain
If you want to enable secure communication for PDC, you must configure SSL for the WebLogic Server domain in which you deploy PDC.
To configure SSL for the WebLogic Server domain:
-
Generate the server-side KeyStore file by using the recommended version of the JRE/JDK keytool utility. See Key and Certificate Management Tool for more information.
-
Export the public certificate from the server-side KeyStore file by using the recommended version of the JRE/JDK keytool utility. See Key and Certificate Management Tool for more information.
-
Generate the client-side KeyStore file from the exported public certificate by using the recommended version of the JRE/JDK keytool utility. See Key and Certificate Management Tool for more information.
Note:
Note the path of the client-side KeyStore file. You need to provide this path during the PDC installation if you choose to use SSL.
If you are installing PDC and BRM Integration Pack on different machines, copy the client-side KeyStore file to the machine on which you want to install BRM Integration Pack.
-
Configure SSL for the server on which you want to deploy PDC in WebLogic Server Administration Console. See the Oracle WebLogic Administration Console Help for more information.
-
Enable Java Secure Socket Extension-based SSL for the server on which you want to deploy PDC in WebLogic Server Administration Console. See the Oracle WebLogic Server Administration Console Help for more information.
Configuring the SSL Protocol Version
In a production environment, Oracle recommends using the SSL protocol for sending and receiving messages.
Note:
You need to set the same protocol version for managed servers and the administration server. Ensure that all the managed servers are down when making changes to the administration server for setting up the protocol. Oracle recommends to set the properties in the administration server and then the managed server.
When PDC is acting as a server, you can set the minimum protocol version of TLS to be used by specifying the following as a command-line option in the WebLogic Server startup parameters.
You can set the minimum version to TLS 1.2 using this command:
-Dweblogic.security.SSL.minimumProtocolVersion=TLSv1.2
You can set the minimum version to TLS 1.3 using this command:
-Dweblogic.security.SSL.minimumProtocolVersion=TLSv1.3
Note:
When you set a minimum protocol version, the TLS protocol that is enabled depends on the protocols that are configured in the SSL implementation.
WebLogic Server supports both TLS 1.2 and TLS 1.3 by default when PDC is acting as a client, so no configuration is necessary to set that value.
See the discussion about specifying the version of the SSL protocol in the Oracle WebLogic Server documentation for more information. More information is also available in the following support article: "WebLogic 12.2.1.x Versions That Support TLS 1.3".
(Release 15.0.1 only) Enabling TLS in PDC REST Services Manager
In order to use TLS 1.3 with the PDC REST Services Manager, you must create a self-signed certificate and perform other configuration.
To enable TLS 1.3 in PDC REST Services Manager:
-
Create a directory to contain the certificate, for example PDC_RSM_home/rsm_cert.
-
Change to your new directory and generate an SSL certificate. You can use an OpenSSL command such as the following:
openssl req -x509 -newkey rsa:4096 -keyout openSSLKey.pem -out cert.pem -days 365 -nodes
See "openssl-req" in the OpenSSL documentation for more information about the OpenSSL req command.
-
Generate a PKCS12 KeyStore file. For example, the following OpenSSL command creates a KeyStore file named keystore.p12:
openssl pkcs12 -export -out keyStore.p12 -inkey openSSLKey.pem -in cert.pem
See "openssl-pkcs12" in the OpenSSL documentation for more information about the OpenSSL pkcs12 command.
-
Change to the PDC_RSM_home/apps/bin directory and generate the hashed KeyStore passphrase using the following command:
RestServicesManager.sh hash password
where password is the password you entered when generating the PKCS12 KeyStore file.
Note:
If you get the error: "Error: Could not find or load main class io.helidon.config.encryption.Main," update the version of helidon-config-encryption.jar in the hash method in the RestServicesManager.sh file. -
Add ssl-protocols, keystore-path and keystore-passphrase in the application.yaml file. For example:
server: ... ssl-protocols: - "TLSv1.2" - "TLSv1.3" ssl: private-key: keystore-path: "file_path/certificate.p12" keystore-passphrase: "${passPhrase}"
where file_path is the path to the KeyStore file and passphrase is the hashed passphrase you created using RestServicesManager.sh.
See "PDC REST Services Manager Security" in Security Guide for more information about the application.yaml file.
Setting the JDBC Path for the WebLogic Server Domain
You must obtain the ojdbc8.jar file and set the path to this file for the WebLogic Server domain.
To set the JDBC path for the WebLogic Server domain:
-
Download the ojdbc8.jar file and copy it to the Domain_home/lib directory, where Domain_home is the directory in which the WebLogic Server domain is created.
You can download this file from the following page:
https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html
-
Go to the Middleware_home/user_projects/domains/bin directory, where Middleware_home is the directory in which the Oracle Middleware components are installed.
-
Open the setDomainEnv.sh file in a text editor.
-
Add or modify the following entry to point to ojdbc8.jar:
setDomainEnv.sh CLASSPATH=${Domain_home}/lib/ ojdbc8.jar:${CLASSPATH} export CLASSPATH
-
Save and close the file.
Configuring WebLogic Server to use SSL-Enabled Data Source
You can use the Secure Sockets Layer (SSL)-enabled data source in Oracle WebLogic Server for secured communications.
You must configure WebLogic Server before configuring the data sources. For more information on configuring WebLogic Server, see the discussion about using SSL with data sources and Oracle drivers in the Oracle WebLogic Server documentation and in the following page:
https://www.oracle.com/middleware/technologies/weblogic/configure-use-jdbcdriverssl.html
Updating JDBC LLR Table Name
If you are using an existing database schema during installation, the Logging Last Resource (LLR) table name must be changed to avoid errors.
To change the LLR table name:
-
Log in to WebLogic Server Administration Console.
-
In the Domain Structure section, expand Environment and select Servers.
The Summary of Servers page appears.
-
Select the server for which you want to change the LLR table name.
-
Click the Configuration tab.
-
Click the General subtab.
-
Click Advanced to show the advanced configuration options.
-
Set JDBC LLR Table Name to a different name.
-
Click Save.
For more information on LLR, see the discussion about administrative considerations and limitations for LLR data sources in the WebLogic Server documentation.
Setting the JAVA_HOME Environment Variable
Set the JAVA_HOME environment variable to the recommended version of JRE/JDK before running any PDC processes.
Set the JAVA_HOME environment variable on the machine on which you want to deploy PDC. For example, in C-shell:
-
Open the .cshrc file in a text editor.
-
Add or modify the following entries:
setenv JAVA_HOME jre/jdk_path
where jre/jdk_path is the absolute path to the directory in which JRE/JDK is installed.
For example:
setenv JAVA_HOME /pinhome/jre/1.8.0_144
-
Save and close the file.
-
Update the environment by running the following command:
source .cshrc
-
Verify the Java version by running the following command:
$JAVA_HOME/bin/java -version
The Java version is displayed. For example:
java version "1.8.0_144"Java(TM) SE Runtime Environment (build 1.8.0_144-b07)Java HotSpot(TM) 64-Bit Server VM (build 20.60-b01, mixed mode)
To set the JAVA_HOME environment variable for the WebLogic Server domain:
-
Go to the Middleware_home/user_projects/domains/bin directory, where Middleware_home is the directory in which the Oracle Middleware components are installed.
-
Open the setDomain.sh file in a text editor.
-
Add or modify the following entries before the EXTRA_JAVA_PROPERTIES entry:
JAVA_HOME="${JAVA_HOME}" export JAVA_HOME
-
Save and close the file.
Enabling JRE Permissions
To enable JRE permissions:
-
Go to the jre/jdk_path/lib/security directory.
-
Open the java.policy file in a text editor.
-
Add the following entries to the file:
grant { // JMX Java Management eXtensions permission javax.management.MBeanTrustPermission "register"; };
-
Save and close the file.
Enabling BRM-PDC Integration
After installing BRM, enable the BRM-PDC integration in BRM. This enables PDC to transform and transfer pricing components configured in PDC to BRM.
To enable the BRM-PDC integration:
-
Go to BRM_home/sys/data/config and run the following command, which creates an editable XML file from the pricing instance of the /config/business_params object, where BRM_home is the directory in which BRM is installed.
BRM_home/bin/pin_bus_params -r BusParamsPricing bus_params_pricing.xml
This directory includes the support files used by the pin_bus_params utility. To run it from a different directory, see the discussion about the pin_bus_params utility in the BRM documentation.
This command creates the XML file named bus_params_pricing.xml.out in your working directory. If you do not want this file in your working directory, specify the path as part of the file name.
-
Search the bus_params_pricing.xml.out file for the following line:
<PriceDesignCenterInst>disabled</PriceDesignCenterInst>
-
Change disabled to enabled.
-
Save the file as bus_params_pricing.xml.
-
Run the following command, which loads the updated file into the /config/business_params object:
BRM_home/bin/pin_bus_params bus_params_pricing.xml
-
Read the object with the testnap utility or Object Browser to verify that all fields are correct. See "Reading Objects" in BRM Developer's Guide.
-
Stop and restart the Connection Manager (CM).
For more information, see "Starting and Stopping the BRM System" in BRM System Administrator's Guide.