Тёмный

Oracle RAC 19c Step by Step on RHEL 7.8 

Database Guy
Подписаться 6 тыс.
Просмотров 21 тыс.
50% 1

Опубликовано:

 

11 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 75   
@SanjayKumar-qt3xc
@SanjayKumar-qt3xc 9 месяцев назад
Rac troubleshooting and performance tuning one videos ❤😊 great learning sir
@kranthikumarkatarapu2928
@kranthikumarkatarapu2928 12 дней назад
excellent teaching
@DB2_Oracle
@DB2_Oracle 12 дней назад
Thank You for the nice comment.
@dineshnagarajan7633
@dineshnagarajan7633 11 месяцев назад
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
@DB2_Oracle 11 месяцев назад
Glad it worked. Thanks for nice comment.
@ahteshambabar1678
@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
@xoxo0304
@xoxo0304 3 месяца назад
Excellent tutorial. Very helpful to me, thank you very much.
@Zen_1835
@Zen_1835 Год назад
The way you explained each and every step is amazing. I really appreciate your efforts.. Thanx Brother !!
@ravalisharma6386
@ravalisharma6386 Год назад
Excellent tutorial!!
@Actions_Only
@Actions_Only 10 месяцев назад
Thank you so much❤
@alam71773
@alam71773 10 месяцев назад
Thanks a TON brother!! for such a wonderful tutorial and its very kind of you that you uploaded the documents for our reference. ❤
@shoebathar1783
@shoebathar1783 Год назад
Thank you so much
@vijaymestry4236
@vijaymestry4236 12 дней назад
best
@DB2_Oracle
@DB2_Oracle 12 дней назад
Thank You
@hailelove1
@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
@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
@hailelove1 Год назад
@@DB2_Oracle thhAnk you sir God bless you.
@hailelove1
@hailelove1 Год назад
@@DB2_Oracle I appreciate if you some tutor on ASM
@DB2_Oracle
@DB2_Oracle Год назад
@@hailelove1 Will do
@naveedchaudhry2700
@naveedchaudhry2700 4 месяца назад
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
@DB2_Oracle 4 месяца назад
Try below Video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Rg7XjTOUbZk.html
@sribalaje
@sribalaje 2 года назад
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
@DB2_Oracle 2 года назад
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.
@srinadh8666
@srinadh8666 Год назад
Thanks very much sir for vey simple video, how to reach out to you fr any queries ?
@hameedabdulhafeel
@hameedabdulhafeel 2 года назад
Which OS version you r using 8.5 or 7.8 ?
@DB2_Oracle
@DB2_Oracle 2 года назад
Really Sorry - Its Red Hat enterprise Linux 7.8
@mohammedsayed1439
@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
@DB2_Oracle Год назад
Which step you are getting this? What's your OS? ssh is working fine? Firewall disabled?
@mohammedsayed1439
@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
@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
@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.
@dohyun0047
@dohyun0047 2 года назад
it would be wonderful if you share docs so we can go to link more easily..!
@DB2_Oracle
@DB2_Oracle 2 года назад
Link is in Description.
@dohyun0047
@dohyun0047 2 года назад
@@DB2_Oracle thank you very much~~~~~~~~~~!!!!!!!!
@solonomenjanaharyrindrachr1151
bjr, merci pour le tuto, est ce qu on peut avoir le document ,merci
@DB2_Oracle
@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.
@biswajitsamal5341
@biswajitsamal5341 2 года назад
Thanks lot...😊.can you please share the doc ?
@DB2_Oracle
@DB2_Oracle 2 года назад
Link is in Description.
@dba_guy
@dba_guy 7 месяцев назад
Hi Did i missed or i am unable to look in doc , how to download the iso of rhel7.8?
@DB2_Oracle
@DB2_Oracle 7 месяцев назад
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
@mohammedsayed1439
@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
@DB2_Oracle Год назад
I will record video on X11
@mohammedsayed1439
@mohammedsayed1439 Год назад
@@DB2_Oracle I figured that disabling the IPv6 Steps was stopping my X11 forwarding.
@DB2_Oracle
@DB2_Oracle Год назад
@@mohammedsayed1439 Strange but nice. This does not occur in my environment. However glad, it got resolved.
@raavanpandey5043
@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
@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
@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
@DB2_Oracle Год назад
@@rockdbaseclass7558 I did record a video on Xming. Did you watch it?
@rockdbaseclass7558
@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
@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.
@aravindhyt
@aravindhyt 9 месяцев назад
It is getting stuck at checking resolve.conf integrity. Can you please provide solution for that?
@DB2_Oracle
@DB2_Oracle 9 месяцев назад
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
@aravindhyt 9 месяцев назад
@@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.
@user-momand
@user-momand 8 месяцев назад
hi sir i configure RAC 19c in VirtualBox i want to connect with sql developer it not work please help me
@DB2_Oracle
@DB2_Oracle 8 месяцев назад
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
@user-momand 8 месяцев назад
@@DB2_Oracle hi sir i ping SCAN ip but not RAC ip please help me
@DB2_Oracle
@DB2_Oracle 8 месяцев назад
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?
@konradnowakowski1692
@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
@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
@DB2_Oracle Год назад
Is SCAN IP up and listening. Can you connect to the database using host ip?
@konradnowakowski1692
@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
@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
@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.
@sribalaje
@sribalaje 2 года назад
Do we have to install grid software on both nodes or only one node..
@DB2_Oracle
@DB2_Oracle 2 года назад
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
@sribalaje 2 года назад
@@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
@DB2_Oracle 2 года назад
@@sribalaje Yes. You are correct
@soumyam6422
@soumyam6422 Год назад
hi can you tell me how to find scan name and scan ip's
@DB2_Oracle
@DB2_Oracle Год назад
If its existing RAC cluster, open /etc/hosts or as a Grid User, run below command. srvctl config scan
@beboalhag
@beboalhag 2 месяца назад
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
@DB2_Oracle 2 месяца назад
From the Oracle Website www.oracle.com/in/database/technologies/oracle19c-linux-downloads.html
@dohyun0047
@dohyun0047 2 года назад
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
@dohyun0047 2 года назад
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
Далее
Oracle RAC 19c Step by Step Add New Node on RHEL 7.8
35:57
Oracle RAC Concepts & Theory - Prepare for Interview
37:09
КОТЁНОК ЗАСТРЯЛ В КОПИЛКЕ#cat
00:37
Обыкновенное чудо
00:48
Просмотров 760 тыс.
Oracle RAC Administration Basic Commands
43:27
Просмотров 3,1 тыс.
Oracle 19c Data Guard 01 Step By Step Setup
36:57
Просмотров 28 тыс.
Setup a CHEAP Homelab Linux Server With CasaOS
27:42
Просмотров 23 тыс.
Oracle 19c Data Guard on Windows Step By Step Setup
1:07:18
КОТЁНОК ЗАСТРЯЛ В КОПИЛКЕ#cat
00:37