Oracle Revenue and Management Billing 2.5 Installation Step by Step

Oracle ORMB 2.5.0.0.0 Installation High Level Steps                             

-- Click here to BUY ORMB 2.5 Installation Complete Steps with Screenshots - Rupees 3000 only /-  

We have following Prequisite Hardware: Please follow oracle documentation for more options:

  • Operating System - Windows Server 2012 R2 64-bit
  • CPU 2 Core
  • Memory – 16 GB
  • Disk – 500 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.

Oracle Database and DB Client software download path:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html

ORMB .25 – www.edelivery.oracle.com  

https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=wqymg6lvg_70&_afrLoop=439366770904382

Below is the Installation Steps for ORMB 2.5

(Step 1)

Connect to the remote windows server 2012 R2 64 bitand copy the ORMBsoft waresdownloaded from local machine to remote 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…. So we are installing Java JDK to this path D:\java\ JDK 1.7.0_45

Next…..

Click Ok…Select the path as D:\Java\jdk1.7.0_45

Click Next…

Click On to install JRE7….

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

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

(Step 3)

Installing Oracle Database Enterprise Edition product 12.1.0.2 64 –bit

Extract the zip files show below in same folder database:

 winx64_12102_database_1of2

 winx64_12102_database_2of2

The path for extracting should be same as shown above D:\ORMB_SOFT. With this it will create a folder as database and extract merge both the zip files content in the same database folder.

Run the setup file.

Click Next…

Select 2ndoption Install database Software only……

Select 1st 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 - ormb@321

Oracle Base and Software installation path:

Click Install

Wait for installation to complete.

Oracle Database Product 12.1.2.0 (Enterprise Edition 64-bit is installed successfully)

(Step 4)

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

Oracle Base – D:\oracle12c

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

Oracle SID - ORMBDB

Administrative Password – capg$321

Oracle Password – capg$321

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

4. Create default tablespace named CISTS using the following command:

CREATE TABLESPACE CISTS_01 LOGGING DATAFILE 'D:\oracle12c\oradata\ORMBDB\DATAFILE\cists01.dbf' SIZE 1024M REUSE AUTOEXTEND ON NEXT 8192K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

5. Create the CIS_USER and CIS_READ roles using the following commands:

CREATE ROLE CIS_USER;
REATE ROLE CIS_READ;

6. Create the CISADM, CISUSER, CISOPR, and CISREAD users using the following commands:

SQL> CREATE USER CISADM IDENTIFIED BY CISADM DEFAULT TABLESPACE CISTS_01 TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;
GRANT UNLIMITED TABLESPACE TO CISADM WITH ADMIN OPTION;


GRANT SELECT ANY TABLE TO CISADM;
GRANT CREATE DATABASE LINK TO CISADM;
GRANT CONNECT TO CISADM;
GRANT RESOURCE TO CISADM;
GRANT DBA TO CISADM WITH ADMIN OPTION;
GRANT CREATE ANY SYNONYM TO CISADM;
GRANT SELECT ANY DICTIONARY TO CISADM;

SQL> CREATE USER CISUSER PROFILE DEFAULT IDENTIFIED BY CISUSER DEFAULT TABLESPACE CISTS_01 TEMPORARY TABLESPACE TEMP;

 

GRANT SELECT ANY TABLE TO CISUSER;
GRANT CIS_USER TO CISUSER;
GRANT CIS_READ TO CISUSER;
GRANT CONNECT TO CISUSER;

CREATE USER CISOPR PROFILE DEFAULT IDENTIFIED BY OPRPLUS DEFAULT TABLESPACE CISTS_01 TEMPORARY TABLESPACE TEMP;

GRANT CONNECT,RESOURCE,EXP_FULL_DATABASE TO CISOPR;

CREATE USER CISREAD IDENTIFIED BY CISREAD DEFAULT TABLESPACE CISTS_01 TEMPORARY TABLESPACE TEMP;

GRANT SELECT ANY TABLE TO CISREAD;

GRANT CIS_READ TO CISREAD;
 

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= D:\oracle12c\admin\ormb\dpdump\data_pump_dir\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 – capg$321

Oracle Client Base Path D:\oracle12

Click Install…..

Oracle Client 12.1.0.2 is installed successfully………

(Step 8)

Installing Oracle Revenue Management and Billing Version 2.5.0.0.0

 

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

D:\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

grant execute on USER_LOCK to public;

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=

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:

jarxvf 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. Installing Oracle WeblogicServer 12.1.3.0

Weblogic 12.1.3.0 is installed successfully.

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 installSFgrouputility 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\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 initialSetuputility using the following command:

CCB, ETPM, ORMB Issue With Configuring and Deploying in Weblogic With Custom Server Name (Doc ID 1382439.1)

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

cd $SPLEBASE/bin

perldemo_gen_cert.plx

Start the application environment using the following command:

%SPLEBASE%\bin\spl.cmd start

Login to ORMB application once the above spl.cmd script shows running……

https://arlarlormb.igatecorp.com:6501/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 DEV02

Start the Application

%SPLEBASE%\bin\spl.cmd stop

capg321

User SYSUSER can’t login…….

Make sure to add the user password in Weblogic admin console once and restart the application and check again.