Steps to enable recycle bin in oracle 10g and 11g
Posted by Abishek Kathiresan Below are the steps to enable recycle bin in oracle 10 & 11g Step 1: log into sqlplus SQL> SHOW PARAMETER RECYCLEBIN NAME …
Read MoreOracle Database and Applications Security Audit Part 1
Posted by Narasimha Rao.K Oracle Database and Applications Security Audit Part 1 Introduction: Hello Everyone, I would like to start series of write ups/post based on the experience regarding How to…
Read MoreSuspend and Resume in Oracle Database
Posted by Abishek Kathiresan Here we will see the suspend/resume feature in Oracle Database. ALTER SYSTEM SUSPEND statement stops all input and output (I/O) to datafiles (file header and file…
Read MoreRenaming redolog members
Posted by Mahendran Manickam Introduction: In this session we will discuss that how to remane redolog members Steps to be followed: Step1: To complete this requirement you have to shutdown the…
Read MoreFLUSH_DATABASE_MONITORING_INFO Procedure
Posted 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 MoreUseful Information Regarding Oracle Cloud Marketplace
Posted 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 MoreHow to deploy Oracle EBS Cloud Manager from Market Place?
Posted 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 MoreOPatch Conflict Checker
Posted 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 MoreDBA Tip : RMAN restore when backup file are spread across 2 different mount points
Posted 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 MoreORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property during Apex install in 12.2
Posted 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