Oracle Database Audit
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…
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…