Oracle RAC 19c Step by Step on RHEL 7.8

[@dineshnagarajan7633]

Thank you very much brother, I have failed many times installing rac database in vm ware before ,After seeing your video I have successfully installed rac database by following your steps Great Video for installing Rac

[@DB2_Oracle]

Glad it worked. Thanks for nice comment.

[@ahteshambabar1678]

Thank you sir for the lovely and detailed video ..Its great that you have already shared the docs in the shared folder without asking .. definitely you have a big heart with great knowledge

[@SanjayKumar-qt3xc]

Rac troubleshooting and performance tuning one videos ❤😊 great learning sir

[@Zen_1835]

The way you explained each and every step is amazing. I really appreciate your efforts.. Thanx Brother !!

[@xoxo0304]

Excellent tutorial. Very helpful to me, thank you very much.

[@kranthikumarkatarapu2928]

excellent teaching

[@DB2_Oracle]

Thank You for the nice comment.

[@alam71773]

Thanks a TON brother!! for such a wonderful tutorial and its very kind of you that you uploaded the documents for our reference. ❤

[@hailelove1]

Dear sir you are amazing thank you. I have two question when you put the virtual IP,scan IP,private Ip,public IP where do we get it could be in production or VMware. is it network admin supposed to give me?the second question is when the +FRA,+DATA is it possible to resize again I said in the production environment very sensitive.

[@DB2_Oracle]

Private IP and Public IP are Physical IPs. They need to be allocated by network admin and then UNIX admin will attach it to the host. Virtual IP and SCAN IP - You can decide what to use or Network Admin can assign them for you. However, one catch is: In your environment, they should not be already in use. +FRA, +DATA - These can be re-sized when required. You can never predict what should be the size. Lets say you allocated only 10GB and data size increased, you have to increase it. In Production environment, you will add new disks to +FRA or +DATA during off-peak hours or low business hours. And you can specify rebalance power.

[@hailelove1]

@@DB2_Oracle thhAnk you sir God bless you.

[@hailelove1]

@@DB2_Oracle I appreciate if you some tutor on ASM

[@DB2_Oracle]

@@hailelove1 Will do

[@ravalisharma6386]

Excellent tutorial!!

[@hameedabdulhafeel]

Which OS version you r using 8.5 or 7.8 ?

[@DB2_Oracle]

Really Sorry - Its Red Hat enterprise Linux 7.8

[@naveedchaudhry2700]

It is very informative video. However, I am using VMWare software instead of Oracle VirtuaI Box and am not able to use putty from my source laptop to VMware machines. I have created two network adaptors as 1. Bridged - 192.168.119.131 2. Host-only - 10.10.10.131 How can I make it work for putty. Whenever I use ping command, it message says host is not reachable. Thanks in advance

[@DB2_Oracle]

Try below Video kzbin.info/www/bejne/iJiaiZ2KhLqVkM0

[@solonomenjanaharyrindrachr1151]

bjr, merci pour le tuto, est ce qu on peut avoir le document ,merci

[@DB2_Oracle]

Le document est déjà partagé. Le lien est dans la description de la vidéo. Document is already shared. Link is in the Video Description.

[@sribalaje]

Thanks for the video. How about VIP & SCAN Address. Do we have to assign it separately. On network settings, you have added only Public & Private IP but not VIP/SCAN address.

[@DB2_Oracle]

Yes. That is correct. SCAN & VIP are virtual. They are created by Oracle Grid. When cluster is up, they are reachable. When cluster is down, they are no reachable. Public and Private IP are physical.

[@dba_guy]

Hi Did i missed or i am unable to look in doc , how to download the iso of rhel7.8?

[@DB2_Oracle]

Downloading RHEL 7.8 is not documented/shown in the video. You can use below link. developers.redhat.com/products/rhel/download You may not get 7.8. Try 7.9 Alternatively you can use Oracle Enterprise Linux which is 100% compatible with RHEL. yum.oracle.com/oracle-linux-isos.html

[@srinadh8666]

Thanks very much sir for vey simple video, how to reach out to you fr any queries ?

[@Actions_Only]

Thank you so much❤

[@aravindhyt]

It is getting stuck at checking resolve.conf integrity. Can you please provide solution for that?

[@DB2_Oracle]

There are multiple solutions to this problem. However, are you using Active Directory and is the resolve.conf entries on same order on all nodes?

[@aravindhyt]

@@DB2_Oracle hi Sir, I just removed dns server details and it worked. I think it tried to connect to the dns server and resolve hostname but the dns did not had the domain. Thanks a lot sir.

[@beboalhag]

sir from where can i download grid in video (unzip -qq oracle_DB_19cR300_Grid_LIN64_Home.ZIP -d /dbi/oracle/V19Grid) can you give me the link thank you

[@DB2_Oracle]

From the Oracle Website www.oracle.com/in/database/technologies/oracle19c-linux-downloads.html

[@vijaymestry4236]

best

[@DB2_Oracle]

Thank You

[@mohammedsayed1439]

I was using ESX VM's and server only after running the Step 2, by end of it my x11 forwarding was disabled. I am unable to enable X11 forwarding.

[@DB2_Oracle]

I will record video on X11

[@mohammedsayed1439]

@@DB2_Oracle I figured that disabling the IPv6 Steps was stopping my X11 forwarding.

[@DB2_Oracle]

@@mohammedsayed1439 Strange but nice. This does not occur in my environment. However glad, it got resolved.

[@shoebathar1783]

Thank you so much

[@konradnowakowski1692]

I am not able to connect from my computer from sqldeveloper to database (scan ip) do you know what's the reason can be?

[@konradnowakowski1692]

you also use aliases in puty db2 so I think you add aliases to hosts, can you show how do you have it configured, I am asking because that is not showed in video

[@DB2_Oracle]

Is SCAN IP up and listening. Can you connect to the database using host ip?

[@konradnowakowski1692]

@@DB2_Oracle yeah scan IP is up and listening. I can't connect via my public IP but I can connect to server via my third bridge adapter

[@konradnowakowski1692]

@@DB2_Oracle to database i can't connect via any IP, by using SQL developer from my computer. Database is also up and running

[@DB2_Oracle]

@@konradnowakowski1692 Check if there is a firewall blocking any ports on your windows machine and your RAC Server. Are you abe to connect to the server using putty.

[@mohammedsayed1439]

Getting following error [INS-32144] Execution of 'GI Install' script failed on one or more nodes ([vsrl7csrac01]). These nodes require a reboot to complete the configuration. What could be the reason?

[@DB2_Oracle]

Which step you are getting this? What's your OS? ssh is working fine? Firewall disabled?

[@mohammedsayed1439]

@@DB2_Oracle /u01/app/oracle/V19BaseGrid/crsdata/vsrl7csrac01/crsconfig/rootcrs_vsrl7csrac01_2022-11-04_02-33-34AM.log 2022/11/04 02:33:42 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'. 2022/11/04 02:33:42 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'. 2022/11/04 02:33:42 CLSRSC-363: User ignored prerequisites during installation 2022/11/04 02:33:42 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector. 2022/11/04 02:33:42 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'. 2022/11/04 02:33:44 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'. 2022/11/04 02:33:46 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'. 2022/11/04 02:33:46 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'. 2022/11/04 02:33:46 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'. 2022/11/04 02:33:47 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'. 2022/11/04 02:33:53 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'. 2022/11/04 02:33:54 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'. 2022/11/04 02:34:22 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'. 2022/11/04 02:34:23 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'. 2022/11/04 02:34:23 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service' 2022/11/04 02:34:37 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'. 2022/11/04 02:34:38 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'. 2022/11/04 02:38:04 CLSRSC-400: A system reboot is required to continue installing.

[@mohammedsayed1439]

Any clue on this error. I tried to manually run even that is failing [root@vsrl7csrac01 ~]# /u01/app/oracle/V19Grid/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/oracle/V19Grid Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Relinking oracle with rac_on option Using configuration parameter file: /u01/app/oracle/V19Grid/crs/install/crsconfig_params The log of current session can be found at: /u01/app/oracle/V19BaseGrid/crsdata/vsrl7csrac01/crsconfig/rootcrs_vsrl7csrac01_2022-11-04_02-42-33AM.log 2022/11/04 02:42:42 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'. 2022/11/04 02:42:43 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'. 2022/11/04 02:42:43 CLSRSC-363: User ignored prerequisites during installation 2022/11/04 02:42:43 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'. 2022/11/04 02:42:43 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector. 2022/11/04 02:42:45 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'. 2022/11/04 02:42:46 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'. 2022/11/04 02:42:46 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'. 2022/11/04 02:42:46 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'. 2022/11/04 02:42:47 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'. 2022/11/04 02:42:54 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'. 2022/11/04 02:42:54 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'. 2022/11/04 02:43:25 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'. 2022/11/04 02:43:26 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'. 2022/11/04 02:43:26 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service' 2022/11/04 02:43:40 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'. 2022/11/04 02:43:40 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'. 2022/11/04 02:47:09 CLSRSC-400: A system reboot is required to continue installing.

[@DB2_Oracle]

@@mohammedsayed1439 You are getting an error after step 14 which is InstallACFS. Did you look at /u01/app/oracle/V19BaseGrid/crsdata/vsrl7csrac01/crsconfig/rootcrs_vsrl7csrac01_2022-11-04_02-42-33AM.log? This looks like ACFS Issues. There are some solutions available on Google for workaround. Have a look at those solution. Unfortunately my support to you will be limited as I do not have access to your VM.

[@raavanpandey5043]

I am getting an error. " Unable to verify the graphical display setup ..." While doing export DISPLAY= Kindly provide some help. How to select the display also, why can't i do it in VM?

[@DB2_Oracle]

If your display is not working, you can definitely do it in VM. I have recorded a separate video on how to do Xming Display Forwarding. You can watch it to solve your display problems.

[@rockdbaseclass7558]

@@DB2_Oracle I desperately need help. My host is RHEL 8.8 ; virtualbox 7.0, rhel 7.9 , I 've been on this for about 15 hours , tried all not working. I really want to get it. please advise.

[@DB2_Oracle]

@@rockdbaseclass7558 I did record a video on Xming. Did you watch it?

[@rockdbaseclass7558]

@@DB2_Oracle Yes I did watch it, bit it addresses if with windows being the host. Linux 8.8 is my host. So I could not proceed on that basis. I am going to review again to see how to apply same thing from Rhel 8.8 place.

[@DB2_Oracle]

@@rockdbaseclass7558 Video is coming your way. However host is Fedora 38 Linux and guest is RHEL 9.1. Similar but not same. However Linux to linux so this video should help.

[@user-momand]

hi sir i configure RAC 19c in VirtualBox i want to connect with sql developer it not work please help me

[@DB2_Oracle]

There can be multiple problems. 1. Can you ping the Oracle RAC Server from your local machine 2. Can you ping the Oracle RAC SCAN from your local machine 3. Is your SCAN listener running? I suspect, either your local machine is not on the same subnet as RAC Database Server or there can be firewall blocking it.

[@user-momand]

@@DB2_Oracle hi sir i ping SCAN ip but not RAC ip please help me

[@DB2_Oracle]

You should use scan ip to connect to the database. If you can ping scan ip means rac cluster is up. Is your database up?

[@biswajitsamal5341]

Thanks lot...😊.can you please share the doc ?

[@DB2_Oracle]

Link is in Description.

[@dohyun0047]

it would be wonderful if you share docs so we can go to link more easily..!

[@DB2_Oracle]

Link is in Description.

[@dohyun0047]

@@DB2_Oracle thank you very much~~~~~~~~~~!!!!!!!!

[@soumyam6422]

hi can you tell me how to find scan name and scan ip's

[@DB2_Oracle]

If its existing RAC cluster, open /etc/hosts or as a Grid User, run below command. srvctl config scan

[@sribalaje]

Do we have to install grid software on both nodes or only one node..

[@DB2_Oracle]

Choice is yours. You can install on only 1 node and add second node to the cluster. However, in this video, I have installed on one node. Oracle internally installs it on the second node if you selected that node in the beginning.

[@sribalaje]

@@DB2_Oracle Thank you so much. Is it the same for 19c software and dbca also.Like installing on one node and it internally does on second node?

[@DB2_Oracle]

@@sribalaje Yes. You are correct

[@dohyun0047]

i am having error when i install grid at "Step 5 of 17" i get the following error -------------- [INS-41116] Installer has detected that the selected following nodes do not have connectivity with other cluster nodes through the selected interface. [[db2]]. -------------- and when i click detail -------------- db2 - PRVF-4190 : Verification of the hosts config file failed - Cause: The '/etc/hosts' file(s) contain incorrect, or incomplete, network host information. - Action: Review the contents of the node's '/etc/hosts' file and ensure that each entry contains a valid IP address and a canonical host name for the specified IP address. db1 - PRVF-4190 : Verification of the hosts config file failed - Cause: The '/etc/hosts' file(s) contain incorrect, or incomplete, network host information. - Action: Review the contents of the node's '/etc/hosts' file and ensure that each entry contains a valid IP address and a canonical host name for the specified IP address. -------------- i can ping public ip "db1" and private ip"db1" from db2 but cannot ping "db1-vip" and "db-scan" any idea..?

[@dohyun0047]

never mind there was typo in my /etc/hosts i didn't comment properly i will not erase this because someone might face same issue