Oracle Revenue and Management Billing Installation and Support: 2016

Oracle ORMB 2.5.0.0.0 High Level Installation Steps

This are the high level steps made for reference purpose. Please refer the Oracle Installation guide for more detailed information on the same

Prequisite Hardware:

Operating System - Windows Server 2012 R2 64-bit

Memory – 8 GB

Disk – 250 GB

Software List:

Oracle Database Enterprise Edition 12.1.0.2

Oracle Database Client 32 -bit - 12.1.0.2

Oracle Weblogic Server Standard Edition 12.1.3.0

Java 7 Update 45 or Java 8 Update 40

Hibernate 4.1.0

Oracle Revenue Management and Billing 2.5.0.0.0.

Below is the Installation Steps for ORMB 2.5

(Step 1)

Connect to the windows server 2012 R2 64 bit and copy the ORMB softwares downloaded from local machine to server.

(Step 2)

Installing Java 1.7.0_45 64-bit in any drive like c: or d: Installing in default C:\Program Files will cause problem later once we are installing ORMB application due to space involved in Program Files….

Java JDK 1.7.0_45 64-bit default installation is completed and shown here.

I am using the JAVA_HOME path as F:\java\ JDK 1.7.0_45.

(Step 3)

Installing Oracle Database Enterprise Edition product 12.1.0.2 64 -bit

Select 2^nd option Install database Software only……

Select 1^st option Single instance database installation

English as default language

Select Enterprise Edition

Give administrator credentials here.

I am using oracle12c as user-id and password - capg$321

Oracle Base and Software installation path:

Click Install

(Step 4)

Now we have to create ORMB database using Database configuration Assistant ( DBCA)

Oracle Base – F:\oracle12c

Oracle Home - F:\oracle12c\product\12.1.0\dbhome_1

Oracle SID - ORMBDB

Administrative Password – XXXXXX

Oracle Password – XXXXXX

Click Finish to create database….

Database creation in progress……Monitor the database and alert logs for any errors while creating database….

Database is created successfully…..

(Step 5)

We have to run few database related scipts which will create users, roles and compile invalid objects in the database……

In below query the value should be VALID……

SQL> SELECT COMP_NAME, STATUS FROM DBA_REGISTRY WHERE COMP_NAME IN ('Spatial','Oracle Text');

COMP_NAME

--------------------------------------------------------------------------------

STATUS

--------------------------------------------

Spatial

VALID

Oracle Text

VALID

User and role creation done…..

Note:- Storage.xml file needs to be updated in case we need some change in tablespace. Please check if there is any custom change needed……

(Step 6)

Installing Demo database components (DEMO Database)

This section describes how to install the demo database components of Oracle Revenue Management and Billing. It includes the following topics:

a) Copying and Decompressing Install Media

b) Creating the Database

c) ORMBDB is created for demo install.

d) Importing the Demo Dump File

a) Download the Oracle Revenue Management and Billing V2.5.0.0.0 Oracle Database package from the Oracle Revenue Management and Billing V2.5.0.0.0 media pack which is available on Oracle Software Delivery Cloud. A zip file is downloaded.

b) Created a ORMBDB database already in above step.

c) Create a temporary directory named TEMPDIR on your local machine.

d) Unzip the downloaded file in the TEMPDIR directory. The contents include the following sub-folders:

· Demo_dump

· FW

· RMB

Data_pump_dir created.

Set ORACLE_SID and ORACLE_HOME

Run the demo data import with the imp command.

impdp system/capg$321@ormb NOLOGFILE=N DIRECTORY=DATA_PUMP_DIR DUMPFILE=demo_dump.dmp SCHEMAS=CISADM

Importing demo database objects……

Demo Database is installed successfully……….

(Step 7)

Post Demo Database Creation Tasks

Install Oracle Client 32-bit 12.1.0.2 same as DB product version (12.1.0.2) installed in above step..

Selecting Administrator option……

English as default language…….

Creating new user for oracle client…..

userid – oracle12

password – XXXXXX

Oracle Client Base Path F:\oracle12

Click Install…..

(Step 8)

Installing Oracle Revenue Management and Billing Version 2.5.0.0.0

Go to TEMPDIR and find CdxDBI.exe script…..

F:\TEMPDIR\RMB\Upgrade\Oracle\Install-Upgrade

Execute the CdxDBI.exe

Press Y to install and then again Y to upgrade the database. Once this is done please enable user_lock….

Enable USER_LOCK Package…… Script would be there in Oracle_Home\RDBMS\ADMIN directory

Note:- In Installation guide db client version to be used is 12.1.0.1. It was giving error so used the same version of the db server 12.1.0.2 and it the cdxDBI.exe ran success.

Grant Permissions to the DBMS_LOCK Package and Recompile Database Objects

Check for Invalid Objects with below query:

COLUMN object_name FORMAT A30

SELECT owner,

object_type,

object_name,

status

FROM dba_objects

WHERE status = 'INVALID'

ORDER BY owner, object_type, object_name;

Recompiling invalid objects

ALTER PACKAGE PKG_RMB_PRICEASSIGN COMPILE;

ALTER PACKAGE PKG_RMB_TFM_DISAGG COMPILE;

ALTER TRIGGER CIFKVALID COMPILE;

2.3.2.5 Configuring Security

Database vault must be disabled:

SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';

Run the OraGenSec utility…..

Enter Details as below:

Application Schema User – CISADM

Password – cisadm

Oracle Users – CISUSER, CISREAD

Security script ran successfully…..

(Step 9)

Now we have to do Application Installation Steps:

The following checklist will help guide you through the installation process of the application tier. The details for each step are presented in subsequent sections.

1) Install the database as described in Oracle Revenue Management and Billing Database Administrator’s Guide. ---

Done in Above Steps

2) Create Group/User ID.

For windows it’s the admin user who is login

3) Install prerequisite software (for complete details about installing and configuring the prerequisite third-party software for your specific platform, see the Installing Application Server Prerequisite Software section):

Oracle Database Client 12.1.0.2 - Done in Above Steps

Java 7 Update 45 - Done in Above Steps

Hibernate 4.1.0 – Steps below

We must install Hibernate 4.1.0 before installing Oracle Revenue Management and Billing.

To install Hibernate below are the steps:

a) Create a Hibernate jar external depot:

export HIBERNATE_JAR_DIR=<Hibernate 3rd party jars depot>

b) Download the hibernate-release-4.1.0.Final.zip file from

http://sourceforge.net/projects/hibernate/files/hibernate4/

Click the “4.1.0.Final” link to download the zip file.

c) Extract the contents of the archive file:

jar xvf hibernate-release-4.1.0.Final.zip

Note: You must have Java JDK installed on the machine to use the jar command. Be sure to install the JDK that is supported for your platform.

d) Copy the jar files to your Hibernate jar directory ($HIBERNATE_JAR_DIR) using the following commands:

cp hibernate-release-4.1.0.Final/lib/optional/ehcache/ehcache-core-2.4.3.jar $HIBERNATE_JAR_DIR

cp hibernate-release-4.1.0.Final/lib/optional/ehcache/hibernate-ehcache-4.1.0.Final.jar $HIBERNATE_JAR_DIR

cp hibernate-release-4.1.0.Final/lib/required/hibernate-commons-annotations-4.0.1.Final.jar $HIBERNATE_JAR_DIR

cp hibernate-release-4.1.0.Final/lib/required/hibernate-core-4.1.0.Final.jar $HIBERNATE_JAR_DIR

cp hibernate-release-4.1.0.Final/lib/required/hibernate-jpa-2.0-api-1.0.1.Final.jar $HIBERNATE_JAR_DIR

cp hibernate-release-4.1.0.Final/lib/required/javassist-3.15.0-GA.jar $HIBERNATE_JAR_DIR

cp hibernate-release-4.1.0.Final/lib/required/jboss-logging-3.1.0.CR2.jar $HIBERNATE_JAR_DIR

cp hibernate-release-4.1.0.Final/lib/required/jboss-transaction-api_1.1_spec-1.0.0.Final.jar $HIBERNATE_JAR_DIR

4. Install web server.

Installing Oracle Weblogic Server 12.1.3.0

5. Third Party Software Configuration:-

Third Party Software Configuration menu while executing the install utility:

Enter 1 – Details required Oracle Client Home, Java Home, Hibernate Directory

Enter 2 – Optional use default values

Enter 50 – Environment details like Environment name, Web application Server type (WLS)

Once this is processed we have to install all 1, 2,3,4,5 and 6 menu option from the install utility….

Environment Description – 1

Business Application Server Configuration – 2

Web Application Server Configuration – 3

Database Configuration – 4

General Configuration Options – 5

SSL Certificate Keystore – 6 (default values)

6. Oracle Utilities Application Framework Version 4.3.0.0.1 is installed on the application server.

Install the rollup pack for Oracle Utilities Application Framework (prerequisite single fixes for ORMB).

To install the rollup pack for Oracle Utilities Application Framework Version 4.3.0.0.1:

Unzip the downloaded file in the TEMPDIR directory. The contents include the ORMB-V25000-FW-PREREQ-MultiPlatform.jar file.

Decompress the JAR file using the following command:

cd TEMPDIR

jar -xvf ORMB-V25000-FW-PREREQ-MultiPlatform.jar

A sub-directory named FW-V4.3.0.0.1-Rollup is extracted. It contains the following two sub-folders:

Application

Database

Initialize the application environment where you want to install the rollup pack using the following command:

$SPLEBASE\bin\splenviron.cmd -e %SPLENVIRON%

Change to the Application directory using the following command:

cd TEMPDIR/FW-V4.3.0.0.1-Rollup/Application

Execute the installSFgroup utility using the following command:

installSFgroup.cmd

7. To install Oracle Revenue Management and Billing (ORMB) Version 2.5.0.0.0:

Login to the application server using the administrator’s credentials.

Initialize the application environment (on which you want to install the application) using the following command:

%SPLEBASE%\bin\splenviron.cmd -e %SPLENVIRON%

Where, $SPLEBASE or %SPLEBASE% is the path where the application environment is installed, and $SPLENVIRON or %SPLENVIRON% is the name of the application environment for which you want to set the environment variables.

Stop the application environment using the following command:

%SPLEBASE%\bin\spl.cmd stop

Set the Java Home path using the following command:

The <Java_Home> is the location where you have installed Java 1.7.

cd <TEMPDIR>\ORMB.V2.5.0.0.0

Execute the install utility using the following command:

install.cmd

The following message appears in the command line:

Do you wish to proceed with the installation? Y/N:

Type Y and then press Enter. A message appears informing you to type P if you want to proceed with the installation.

Type P, and then press Enter. The installation process might take some time to generate the WAR files. Once the build is deployed successfully, the following message appears in the command line:

Do you wish to start the environment now? Y/N:

Type N and then press Enter.

Execute the initialSetup utility using the following command:

In case you are using demo certificates, please execute the below command before starting the environment:

cd $SPLEBASE/bin

perl demo_gen_cert.plx

Start the application environment using the following command:

%SPLEBASE%\bin\spl.cmd start

https://servername:7300/ouaf/loginPage.jsp

Start Scripts

Environment Set

%SPLEBASE%\bin\splenviron –e DEV01

Start the Application

%SPLEBASE%\bin\spl.cmd start

Stop Scripts

Environment Set

%SPLEBASE%\bin\splenviron –e DEV01

Start the Application

%SPLEBASE%\bin\spl.cmd stop

************************************thanks********************************

Note: - If you need to setup a LAB on ORMB for educational or learning purpose please contact us at info@orainstall.com

We can do it for some maintenance cost.

Oracle Revenue and Management Billing Installation and Support

Sunday, January 17, 2016

Error while running the splenviron environment command in ORMB 2.5

Wednesday, January 13, 2016

ORMB 2.5 Installation Steps