Category Archives: ORMB

Change the ORMB DB User Password

After the DB user password is changed by DBA, or after the ORMB schema is refreshed from other environment and need keep the password of old one. The DB user password needs to be changed as per Oracle Doc. For … Continue reading

Posted in ORMB | Tagged , , , , , | Leave a comment

How to Set Up ORMB Batch Scheduling with Oracle DBMS Scheduler

Download and Apply Oracle DBMS Scheduler Patch $ unzip Oracle_Scheduler_Integration.zip Archive: Oracle_Scheduler_Integration.zip inflating: Getting Started Guide ORMB Batch Scheduling.pdf inflating: ORACLE_DBMS_SCHEDULER_SETUP_LINUX.pdf inflating: ORMB_Integration_Installer/lastDayPrevMonthJobs.properties inflating: ORMB_Integration_Installer/readme.txt inflating: ORMB_Integration_Installer/setup.sh inflating: ORMB_Integration_Installer/sql/oem_ouaf_package.sql inflating: ORMB_Integration_Installer/sql/ouaf_batch_package.sql inflating: ORMB_Integration_Installer/sql/setup.sql inflating: ORMB_Integration_Installer/sql/user_cisadm_setup.sql inflating: ORMB_Integration_Installer/sql/user_schadm_NEW_I.sql inflating: ORMB_Integration_Installer/sql/user_schadm_NEW_S.sql inflating: ORMB_Integration_Installer/sql/user_schadm_setup_NEW.sql … Continue reading

Posted in dbms_scheduler, ORMB | Tagged , , , , , , , , , , , , , , , | Leave a comment

How to Apply Database Component Of a Patch Onto ORMB Database

Here is an example of applying an ORMB patche onto ORMB Oracle database.  There working environment is as below ; Oracle Database 12c Oracle Client 32bit 12c ORMB 2.5.0.3 JDK 8 Before applying patching, make a backup of database in any way … Continue reading

Posted in ORMB | Tagged , , , , , , | Leave a comment

How to Install Database Component of a Patch onto ORMB Database

Be aware of the below warning when applying database component of a patch onto ORMB database. Warning: De-installation of the patch is not supported. Make sure that you have a backup of the database schema you are installing into. It … Continue reading

Posted in ORMB | Tagged , , , , , , , , , , , , , , , , , , | Leave a comment

How to Check the Successful Installation of a Database Patch Onto ORMB Database

After applied the database component of a patch, we can run below sql to check  whether the database component was installed successfully , or skipped because it has been installed before: SQL> select sr_no,run_status_flg,END_DTTM from cisadm.ci_ut_instl where sr_no in ( ‘22505470’ … Continue reading

Posted in ORMB | Tagged , , , | 2 Comments

Install Oracle Revenue Management and Billing ( ORMB ) 2.5.0.3.0 Database

Here are the practical steps of installing Oracle Revenue Management and Billing ( ORMB ) 2.5.0.3.0 Database in RAC environment. Mandatory Software Binaries List Oracle Database Enterprise Edition 12.1.0.2 Oracle Database Client 32bit – 12.1.0.2 JDK 1.7 or JDK 1.8 7-zip … Continue reading

Posted in ORMB | Tagged , , , , , , , , , , , , , , , , , , , , , | Leave a comment

How to Tell if Oracle Client is 32 or 64 bit installed on Windows

It is easy to tell 32 bit or 64 bit oracle on Unix/Linux by : $ file sqlplus sqlplus: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), not stripped In Windows, … Continue reading

Posted in Client, ORMB | Tagged , , , , , , , | Leave a comment

“ORA-12505, TNS:listener does not currently know of SID given in connect descriptor” from ORMB ouafDatabasePatch

SYMPTOMS When  installing Rollup Pack for Oracle Utilities Application Framework Version 4.3.0.1.0, ran ouafDatabasePatch.cmd command , and got the below errors: D:\RMB\RMB-V2.5.0.1.0-FW-PREREQ-MultiPlatform\FW-V4.3.0.1.0-Rollup\Database>set TOOLSBIN=D:\dbpatch_tools\bin D:\RMB\RMB-V2.5.0.1.0-FW-PREREQ-MultiPlatform\FW-V4.3.0.1.0-Rollup\Database>set JAVA_HOME=D:\java D:\RMB\RMB-V2.5.0.1.0-FW-PREREQ-MultiPlatform\FW-V4.3.0.1.0-Rollup\Database>ouafDatabasePatch.cmd “CMDLINE::: D:\java\bin\java.exe -cp D:\RMB\RMB-V2.5.0.1.0-FW-PREREQ-MultiPlatform\dbpatch_tools\lib\*;D:\RMB\RMB-V2.5.0.1.0-FW-PREREQ-MultiPlatform\dbpatch_tools\config com.oracle.ouaf.database.patch.OUAFPatch” Enter the target database type (O/M/D) [O]: O Enter the … Continue reading

Posted in Client, Configuration, ORA- ERRORS, ORMB | Tagged , , , , , , | 1 Comment

Java SE Installation for ORMB

Purpose To install the Java SE JDK 1.8 as a prerequisite for deploying ORMB 2.5.0.1. Download Java Download required JDK 1.8 binary (  jdk-8u112-windows-x64.exe )  here. Install Java It is strongly advised to choose an installation directory that does not include … Continue reading

Posted in JAVA, ORMB | Tagged , , , , | Leave a comment

How to Run Security Utility in ORMB Multiple Instances Environment

There are situations  when there are multiple ORMB ( Oracle Revenue Management and Billing ) database instances in one physical database. Normally we run security utility in interactive  mode. It will by default grant permissions to CIS_USER and CIS_READ role. So … Continue reading

Posted in ORMB | Tagged , , , , , , , | 1 Comment