Database Blog

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

How to Create a Custom Concurrent Manager

Adding Concurrent Manager is a crucial decision. Lots of things needs to be examined before adding new Concurrent Manager. One of the major area is resources.If you have less number…

Read More

How To Remove Error Notifications From The Worklist (Doc ID 357904.1)

racle Workflow – Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2] Oracle Order Management – Version 12.2.4 to 12.2.4 [Release 12.2] Information in this document applies to any platform. GOAL…

Read More

EBS R12: Oracle Application Manager – All Self Service page Display format and images not showing and overlapping:

We are on Oracle Linux 6.5, Oracle Database 11.2.0.4, Oracle EBS 12.1.3 for all Self Service Application, under Oracle Application Manager, like – Workflow, License Manager, Patching and Utilities and…

Read More

R12 HTTP_Server Shows Status as Down After Running Apachectl.sh Start, and the Apache Log Shows Error ‘apachectl is not owned by this user’

APPLIES TO: Oracle E-Business Suite Technology Stack - Version 12.1.3 to 12.1.3 [Release 12.1] Information in this document applies to any platform. SYMPTOMS: E-Business Suite 12.1.3, IAS for Applications Technology…

Read More