Dear All, Those who want to learn Oracle RAC DBA from starting to Expert level follow the below course content . All Below content will make video's and post on my Channel ..  YouTube @racsinfotech  https://www.youtube.com/@RACSINFOTECH RAC Course Contents: 1. Introduction to Oracle Custer ware / Cluster ware Architecture >> Standalone Vs RAC >> What is Oracle Cluster ware >> Oracle Cluster ware Architecture and Cluster Services >> RAC One Node Vs RAC database >> Online Relocation >> Networking in Cluster ware  >> Cluster ware s ..read more

Dear All, In this post i am sharing few Data Guard Interview Q&A :   Oracle Data Guard: Architecture: Primary database, Data Guard uses the following processes: Log writer (LGWR): LGWR collects transaction redo information and updates the online redo logs.   Synchronous (SYNC) standby database, LGWR passes the redo to an LNS (Log Writer Network Server) process, which ships the redo directly to the remote file server (RFS) process on the standby database. LGWR waits for confirmation from the LNS process before acknowledging the commit.   Asynchronous (ASYNC)standby datab ..read more

  Oracle RAC DBA Online Training Demo session on 6th Apr 2024 7:30AM IST to 8:30AM IST. Join Zoom Meeting https://us06web.zoom.us/j/89577110408?pwd=qtoOaRG6YKQJbtiNGegVoaEn7AuaUw.1 Meeting ID: 895 7711 0408 Passcode: 556114   Course Index : https://anjaniappsdba.blogspot.com/2024/03/oracle-19c-rac-dba-online-training.html         Contact us for online training's , Interview and job support +91 9392634440 racsinfotech@gmail.com    Join WhatsApp's Group : https://chat.whatsapp.com/BctnmdzEH3pJh8yUhjtQDA   Telegram Group : https://t.me/+R2pg2-9Nsb1lNjF ..read more

 DEAR ALL, In this Post i am sharing ORACLE 19C RAC  DBA Online Training details . Oracle 19C RAC DBA Course : Duration 35 hours  9th Apr 2024  -  7:30PM to 8:30 PM IST ..( Only on Weekdays) Course Fee : 15K INR  Contact us :  racsinfotech@gmail.com   / +91 9392634440     for more details .. MODULE 1: INTRODUCTION TO ORACLE RAC What is Oracle RAC? Advantages and use cases of Oracle RAC. Architecture of Oracle RAC. Key components of Oracle RAC (Cluster ware, Database Instances, ASM, VIPs, SCAN). High Availability and Scalability in ..read more

 Dear All, In this Post i am sharing ORACLE 19C DBA Online Training details . Oracle 19C DBA Course : Duration 40 hours  9th Apr 2024  -  7:30AM to 8:30 AM IST ..( Only on Weekdays) Course Fee : 15K INR  Contact us :  racsinfotech@gmail.com   / +91 9392634440     for more details .. This training Prepared with Realtime Scenarios   , It will useful for jobseekers and students those who are looking for jobs in IT post studies . Course Index :  Oracle 19C DBA Training with Live Labs. 1. 12c and 19c Architecture. 2 ..read more

 Dear All, In this post i am going to share the rac node addition steps .. Present we are having 2 node Rac setup , we are going to add Node3 .. Before node addition :  Node addtion :: RAC  --------------- 1)  Configure Node3 will all pre-requisites and add IP's into remain nodes. >> Add these IPs into resvers zone / forward zone .. /var/named/localdomain.zone ..   /var/named/4.38.10.in-addr.arpa node3 : preparation steps  ------------------------- cat /etc/resolv.conf cd /var/named/ 0.168.192.in-addr.arpa localdomain.zone [root@racs2 named ..read more

 Dear All, In this post i am going to show you RMAN Duplicate database clone errors fixup on Oracle database 19C . while im doing RAC to Non RAC clone i faced this error on Target server . [oracle@uatdb01 ~]$ rman auxiliary / Recovery Manager: Release 19.0.0.0.0 - Production on Wed Mar 6 09:06:18 2024 Version 19.22.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved. connected to auxiliary database: UATDB (not mounted) RMAN> duplicate database to 'UATDB' backup location '/u01/Backup' nofilenamecheck; Starting Duplicate Db at 06-MAR-24 searching ..read more

  In this post i am going to share few of the oracle Linux commands .. i have posted total 4 post for Complete Linux high level commands . part 1 : https://anjaniappsdba.blogspot.com/2023/09/oracle-linux-commands-part-14.html this is  part 2 .. in my next post will share part 3 commands  In Linux Searching Commands =====================  locate filename>> to search entire file system for given file name  find / -name filename>> to search entire / file system for given file name  find . –name filename>> it searches the file in cu ..read more

 Dear All, Please find the Oracle DBA with RAC DBA Online Training Course Index and details . Join my WhatsApp Group :  https://chat.whatsapp.com/BctnmdzEH3pJh8yUhjtQDA Join Zoom Meeting :  7th Jan 2023 7:30 PM IST   https://us04web.zoom.us/j/76132525611?pwd=zxZaiIgIORbCwkTlYDhcMDYCfBrOwD.1 Meeting ID: 761 3252 5611 Passcode: 4nif7B   My Mail id :  racsinfotech@gmail.com  /   mobile no : +91 9392634440 ( WhatsApp  ) Course Index :  =============== 1. 12c and 19c Architecture. 2. DBA Roles and Responsibilities  3. Requ ..read more

  Dear All, In this post i am going to show you how to start and stop Oracle 19c RAC Database services including cluster services . Check the db and grid background process status from putty ( backend )  ps -ef |grep oracle / ps -fu $USER  >> this will show you the all the process which are running under specific login user . ps -ef |grep grid ps -ef |grep d.bin ps -ef |grep smon Check the DB and Oracle Instance status from SQL prompt :  select name,open_mode,instance_name from v$database,v$instance;        Stop the database ::  &nb ..read more