Database Blog

R12 E-Business Suite Output Post Processor (OPP) Fails To Pick Up Concurrent Requests With Error ‘Unable to find an Output Post Processor service to post-process request nnnnn’

E-Business Suite R12 Concurrent Processing, Output Post Processing related issues Requests fail during Post Processing with the following errors: ‘Unable to find an Output Post Processor service to post-process request…

Read More

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

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

Full details about oracle database startup and shutdown in background

Here this blog is useful to understand what will happen while giving startup or shutdown database commands in background.   Full details about  oracle database startup and shutdown in background.…

Read More

IMPDP Hangs – Wait For Unread Message On Broadcast Channel

If IMPDP hangs long time, and if checking in v$sessionwait shows it is waiting on “wait for unread message on broadcast channel”, check the alert log. You may see something…

Read More

Add Services to a Single instance

Please follow to Add Services to a Single instance While the database is up, run the following as sys: alter system set service_names=’DB_DEFAULT_SERVICE, DB_HTML_DB, DB_DEV_SERVICE’ When you check lsnrctl it…

Read More