Tag Archives: ORMB

Unable to load Sfix.ini file: java.io.FileNotFoundException: 22644310\sfix.ini (The system cannot find the path specified)

Situation Trying to apply two below patches onto ORMB database, then got the below errors: 08/08/2017 11:52 AM <DIR> 20986229 02/04/2016 04:11 AM <DIR> 22329775 Directory of D:\PATCHES\V4.3.0.1.0-25963443_MultiPlatform\FW.V4.3.0.1.0-25963443\prereqpatches\RollupPack\FW\Database 08/08/2017 11:52 AM <DIR> . 08/08/2017 11:52 AM <DIR> .. 08/08/2017 11:52 … Continue reading

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

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 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

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

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

Oracle Revenue Management and Billing ( ORMB ) Security Utility OraGenSec

Here is an example of how to run ORMB 2.5.0.1 security utility — OraGenSec.exe. 1) Make sure database vault must be disabled before running. To check database vault is enabled or not. SQL>SELECT * FROM V$OPTION WHERE PARAMETER = ‘Oracle Database … Continue reading

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

Install Oracle Revenue Management and Billing ( ORMB ) 2.5.0.1.0 Database

Here are the practical steps of installing Oracle Revenue Management and Billing ( ORMB ) 2.5.0.1.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 , , , , , , , , , , , , , , , , , , , , , , , , | 2 Comments

ORA-39083: Object type TYPE failed to create with error

SYMPTOMS While importing ORMB schemas from default installation to new schemas for another new ORMB environment. $impdp directory=DUMP_DIR dumpfile=ORMB.dmp REMAP_TABLESPACE=CISTS_01:CISADM_1 SCHEMAS=CISADM,CISUSER,CISOPR,CISREAD REMAP_SCHEMA=CISADM:CISADM_1,CISUSER:CISUSER_1,CISOPR:CISOPR_1,CISREAD:CISREAD_1,CIS_USER:CIS_USER_1,CIS_READ:CIS_READ_1 logfile=imp_cisadm_2_cisadm_1.log   … .. . CREATE TYPE “CISADM”.”TY_RMB_DELETE_BILL_TAB”   OID ’40ACB20E52264074E053530F040AF48D’ AS TABLE OF “CISADM”.”TY_RMB_DELETE_BILL_DTL” ORA-39083: Object type … Continue reading

Posted in DataPump, ORA- ERRORS, ORMB | Tagged , , , , , | Leave a comment