Database Blog

Adpreclone.pl fails with RC-50007: Could not create cloning stage area

Issue : adpreclone.pl fails with RC-50007: Could not create cloning stage area. Can see the entire log below. # Calling StageAppsTechStack… Evaluated internal cloning stage: /application_r12/apps/apps_st/comn/clone Creating Staging Area Creating bin…

Read More

Points to look for while writing SQL Code

Avoiding the Pitfalls of Database Programming – this is a very good material which every SQL developer should read. I’m sure when each developer reads this they can connect with…

Read More

Paper Presentation in AIOUG – Sangam’13

   We , From Doyensys , are going to present paper in AIOUG – Sangam’13. Below are the presenter and paper to be presented. Presenter: Somu Chockalingam (Director , Doyensys).…

Read More

ORA-10873: file 1 needs to be either taken out of backup mode or media recovered

Scenario : Database went down due to power fluctuation and during that time hot backup was running.So once we started the database we face the following issue. Error: ORA-10873: file…

Read More

Oracle OS Watcher Black Box Analyzer OSWBBA

OSWatcher Black Box Analyzer (oswbba) is a graphing and analysis utility which comes bundled with oswbb v4.0.0 and higher.  oswbba allows the user to graphically display data collected, generate reports containing these…

Read More

Oracle OS Watcher Black Box

OS Watcher Black Box (oswbb) is a collection of UNIX shell scripts intended to collect and archive operating system and network metrics to aid support in diagnosing performance issues.  oswbb…

Read More

Unable to Access Apex due to APEX_PUBLIC_USER password expiry

In 11g database the password for the APEX_PUBLIC_USER expires after 180 days. First check if the details of the profile assigned to the APEX_PUBLIC_USER select username,account_status,profile from dba_users where username=’APEX_PUBLIC_USER’…

Read More

Installation of Oracle Database 12c

Installation of Oracle Database 12c

Read More

ORA-06508 : PL/SQL: Could not find the program unit being called in Package AHL_UMP_SR_GRP Procedure Create_SR_Unit_Effectivity

When we run Depot report in 12.1.3, we end up with the following error. Error: ORA-06508 : PL/SQL: Could not find the program unit being called in Package AHL_UMP_SR_GRP Procedure…

Read More

Oracle 12c Database New Features

Oracle 12c Database New Features  powered by GoBookee.net

Read More