Oracle

Oracle Database Audit This week there was a specific demand to configure and work with auditing in the Oracle database, in this way I will unravel how to use auditing …

1 – Checking if the broker is being used. sqlplus / as sysdba show parameter dg_broker; show parameter dg_broker_start; select name, value from v$parameter where name = ‘dg_broker_start’;     …

In this blog I have explained the step by step installation of Oracle Enterprise Manager 13c on Windows server. Make sure you have sufficient resources on your laptop or server …

Hi everyone, I will start complete guide of Oracle RAC 19c lab setup. I have listed all the main points that I will cover during my up coming videos on …

Download Software Download the Oracle software from OTN or MOS depending on your support status. Hosts File The “/etc/hosts” file must contain a fully qualified name for the server. For …

 Incorrect environment. ORACLE_HOME for grid should be pointing to grid directory and ORACLE_SID for ASM should be +ASM. Try this: export ORACLE_HOME=$GRID_HOME export $ORACLE_SID=+ASM export PATH=$GRID_HOME/bin:$PATH

 How to resolve the error   RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause ? Error:Starting Duplicate Db at 9-SEP-14RMAN-00571: ===========================================================RMAN-00569: =============== …

 This error normally occur  because of the INDEX or table structure is in consistent mode. Analyze the index structure and tables.If index structure is failed in analyze , drop the …

 In this article, we will learn steps needed to perform recovery of User wrong operation like delete/drop/truncate action on the production table without using Restore and Recover command on PRIMARY DATABASE. …

 There are various methods (RMAN, Online datafiles move 12c onwards, ASMCMD, DBMS_FILE_TRANSFER, etc) to achieve migrate databases from Non-ASM to ASM. Here we will use two types of RMAN mix …