Introduction Solution to fix ORA-15040: diskgroup is incomplete Posted by Karthick ASM is running but diskgroup is not mounted and its in incomplete state. [oracle@primary bin]$ps -ef|grep asm oracle 4222…
Read MoreIntroduction Steps to increase connection timeout in weblogic Posted by Marimuthu Pandu We need to follow below steps to set this option : -Dsun.net.client.defaultConnectTimeout=5000) through Weblogic Admin Console. To set this…
Read MoreIntroduction We will see how to find the last added datafile in oracle Posted by Arun Below query will give you the last added datafile in oracle. This will be useful…
Read MoreIntroduction Solution for sysadmin taking long time to login Posted by Arun Sometimes, SYSADMIN login in particular instance will take long time to log in as it will have open workflow…
Read MorePosted by Venkateshwaran Govindaraj Introduction: When querying *_TAB_MODIFICATIONS view you should ensure that you run DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO before doing so in order to obtain accurate results. FLUSH_DATABASE_MONITORING_INFO Procedure SQL> exec dbms_stats.FLUSH_DATABASE_MONITORING_INFO;PL/SQL procedure…
Read MorePosted by Narasimha Rao.K Introduction: Some of you might be aware of the Oracle Cloud Market place. But there are certain useful Applications services available for DBAs, APPS DBA or Cloud…
Read MorePosted by Narasimha Rao.K Introduction: The Main agenda for this post is to demonstrate basic steps to deploy Oracle EBS Cloud Manager from Market Place. Pre-requirement: Have Oracle Cloud account login, and…
Read MorePosted by Hemanth Sathavalli Introduction: When applying OPatches to our Oracle database, we frequently encounter conflicts with the existing patches in our database and we raise an SR with Oracle support…
Read MorePosted by Hemanth Sathavalli Introduction: Customers whose databases are of huge size and if the RMAN backup size is about 2TB or more and when there is no enough space to…
Read MorePosted by Sathiyaseelan Mariappan Hi .. Lets find out the solution for below issue. Issue: Fresh apex install failed with the below error. ORA-38824: A CREATE OR REPLACE command may…
Read More