Why we need Oracle AVDF in our organization?

Oracle Audit Vault and Database Firewall (AVDF) is a complete Database Activity Monitoring (DAM) solution. To prevent unauthorized access or tampering, AVDF encrypts audit and event data at every stage, in transmission and at rest. For Oracle Databases, AVDF can track changes to data, user entitlements, and stored procedures. Under Oracle Advanced Security options Oracle …

Oracle DB Unified Audit: Few of the major key points

NEXT–>  Changing the default tablespace for Unified Auditing. Caution: It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using. Thank you,A. RawatEmail: 88arawat@gmail.com

Automate the purging audit records for Unified Auditing in the Database.

To maintain the space and performance, We are scheduling the job which will be remove the audit records older then 30 days from the database. Step-1 Login to the database and check the any of the job is existing related to purge the auditing records SELECT OWNER, JOB_NAME, JOB_ACTION,START_DATE,REPEAT_INTERVAL,STATE,NEXT_RUN_DATE FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME like ‘%PURGE%’; …

Unified Auditing:-Changing the default tablespace

With unified audit, audit records from all audit sources are written to a consolidated audit trail–AUDSYS.AUD$UNIFIED table or OS files, and exposed through the UNIFIED_AUDIT_TRAIL view. In this session, We are changing the default tablespace for Unified Auditing Trail. Step-1 Login to the database and create the tablespace in the DB. Note:- AUDIT_DATA is the …

AdminClient:- cmd tool used in OGG microservice

In this session, We will see the command line tool for OGG microservice Architecture Let’s learn how to connect to OGG MA using command line Check the Location of trails generated in OGG HUB architecture (if not specified the location) We can Enable/Register Auto-restart of Goldengate (In case od Server startup) Thank you…We will be …

Facing error ORA-00742: Log read detects lost write in thread 1 sequence YYY block XXXXX

In this session, we will try to solve the issue related to redo log corruption. We are trying to open the database but facing error ORA-00742 and ORA-00312 Now, checking the logfile status and the location in database Trying to recover the database and then let try to open the database Now at last, Rename …

My Intro:- Oracle RAC (Real Application Cluster)

Oracle Real Application Cluster formally known as Oracle RAC. Let’s understand in simple words in this session. Below the simple architecture of Oracle non-RAC and Oracle RAC environment Let’s understand the terminology or keywords used in Oracle RAC(Real Application Cluster) Let’s see the deployment/Installation option we have in Oracle database Thanks…….We covered a lot about …

Oracle Real Application Cluster and ASM

Caution: It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using. Thank you,A. RawatEmail: 88arawat@gmail.com

Change the Port number in Oracle RAC environment

In this session, Lets change the port number for Listener and SCAN listener in existing Oracle RAC environment. Step-1 From the oracle user, Check the listener configuration including port number used srvctl config listener Step-2 From the oracle user, Change the listener port using srvctl utility. srvctl modify listener -l LISTENER -p “TCP:1438” Step-3 Now, …