Yearly Archives: 2020

ORA-12152 “Unable To Send Break Message” on Connection

When trying to login to the database from a client(Toad, SQL Developer) when using a Cisco GSS and a CSM (Content Switch Module) the connection fails to complete or fails…

Read More

Error: “Unable to Connect” Oracle Apex Access Issue

Recently we had install the Oracle Apex and installation done successfully and access via local system Oracle Apex running perfectly but while we access in remote then we had faced…

Read More

resolving libdb.so.2: cannot open shared object file: No such file or directory issue

ERROR:  libdb.so.2: cannot open shared object file: No such file or directory CAUSE: While creating a new clone with R12.1.3 when starting the Apache i get the errors: error while…

Read More

How to resolve ORA-01994: GRANT failed: password file missing or disabled

ERROR: ORA-01994: GRANT failed: password file missing or disabled SOLUTION: 1)Log in as the same user who owns the file $ORACLE_HOME and create the password file as follows. $orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID…

Read More

ORA-30012: undo tablespace ‘UNDOTBS’ does not exist or of wrong type

ERROR: ORA-30012: undo tablespace ‘UNDOTBS’ does not exist or of wrong type. CAUSE: The parameter UNDO_MANAGEMENT is set to AUTO but the undo_tablespace does not exist or is not of…

Read More

Cannot Start Oracle HTTP Server on Privileged Port (80/443) on Solaris 9

APPLIES TO: Oracle HTTP Server - Version 9.0.2 to 10.1.3.0.0 [Release 9iAS to AS10gR3] Oracle Solaris on SPARC (64-bit) Oracle Solaris on SPARC (32-bit) Web Cache - Version: 9.0.2 to…

Read More

OPMN Fails to Start Oracle HTTP Server 10g After Changing ‘apachectl’ to Root Ownership and 6750 Permissions

APPLIES TO: Oracle Fusion Middleware - Version 9.0.4.0.0 to 10.1.4.3.0 [Release AS10g to AS10gR3] Oracle HTTP Server - Version 9.0.4.0.1 to 10.1.3.5.0 [Release AS10g to AS10gR3] Information in this document…

Read More

How to get item cost for period wise.

SELECT ACCTG_COST FROM gl_item_cst gic, org_acct_periods_v oap WHERE 1 = 1 AND gic.organization_id = oap.organization_id AND gic.organization_id =:P_org_id AND gic.inventory_item_id = :P_item_id AND oap.rec_type = ‘ORG_PERIOD’ AND oap.period_name =:P_period_name AND…

Read More

Customized Checkbox using CSS

Step 1: Create a region in the name Check Box and select region type as Static Content. Step 2: Then, create a Check Box and name it as Regular Check Box,…

Read More

Pipeline function to return Week Start Date and End Date

Pipeline function to return Week Start Date and End Date of a particular month based on inputs parameter Overview: This document talks about how to return Week Start Date and End Date of a particular month…

Read More