In this session, we will see the high level steps to install or configure Oracle Two node RAC on Linux. Thanks…….All the steps will be perform by multiple teams in organization, but here we are using Oracle VM virtual Box for learnings purpose. Next–> Let’s start to install Oracle VM virtual Box and prepare the …
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
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%’; …
Read more “Automate the purging audit records for Unified Auditing in the Database.”
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 …
Read more “Unified Auditing:-Changing the default tablespace”
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 …
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 …
Read more “Facing error ORA-00742: Log read detects lost write in thread 1 sequence YYY block XXXXX”
Demo session to start replication of tables from Source oracle database to target oracle database Step-1 To create Extract process, click on + sign and click on Next button. What is Extract:- The Extract process captures data from the source database and writes it to a trail file (EN). Step-2 Now to create Replicat process …
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 …
Read more “My Intro:- Oracle RAC (Real Application Cluster)”
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
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, …
Read more “Change the Port number in Oracle RAC environment”