Відео

As always, your videos are easy to follow and understand. I run into a challenge with my lab setup, one of my hot standby on a separate vlan show unreachable from the primary node with error message below: [postgres@AZ1-PCI-POSTGRES1 ~]$ repmgr cluster show --verbose INFO: checking for package configuration file "/etc/repmgr/17/repmgr.conf" INFO: configuration file found at: "/etc/repmgr/17/repmgr.conf" INFO: connecting to database ERROR: connection to database failed DETAIL: connection to server at "AZ2-PCI-POSTGRESS2" (10.71.142.8), port 5432 failed: timeout expired DETAIL: attempted to connect using: user=repmgr connect_timeout=2 dbname=repmgr host=AZ2-PCI-POSTGRESS2 port=5432 fallback_application_name=repmgr options=-csearch_path= ID | Name | Role | Status | Upstream | Location | Priority | Timeline | Connection string ----+--------------------+---------+---------------+---------------------+----------+----------+----------+--------------------------------------------------------------------------------- 1 | AZ1-PCI-POSTGRES1 | primary | * running | | default | 100 | 3 | host=AZ1-PCI-POSTGRES1 port = 5432 user=repmgr dbname=repmgr connect_timeout=2 2 | AZ1-PCI-POSTGRES2 | standby | running | AZ1-PCI-POSTGRES1 | default | 100 | 3 | host=AZ1-PCI-POSTGRES2 port = 5432 user=repmgr dbname=repmgr connect_timeout=2 4 | AZ2-PCI-POSTGRESS2 | standby | ? unreachable | ? AZ1-PCI-POSTGRES1 | default | 100 | | host=AZ2-PCI-POSTGRESS2 port = 5432 user=repmgr dbname=repmgr connect_timeout=2 WARNING: following issues were detected - when attempting to connect to node "AZ2-PCI-POSTGRESS2" (ID: 4), following error encountered : "connection to server at "AZ2-PCI-POSTGRESS2" (10.71.142.8), port 5432 failed: timeout expired" - node "AZ2-PCI-POSTGRESS2" (ID: 4) is registered as an active standby but is unreachable

Great stuff on Part 6-ha proxy. Kindly share the configuration file for this demo with me. Many thanks.

Great stuff you have on part6 - HAproxy. Kindly share the haproxy configuration file you used in this demonstration with me. Many thanks

The directive `local stratum 10` is the trickiest part here. When I set up a local time server without this directive, the client refused to sync as it considered the time server to be present in stratum 16. Thanks yea!

The directive `local stratum 10` is the tricky part here. When I tried setting up a local server, the client refused to sync as it considered the server to be present in stratum 16. Thanks yea!

i am new to the discord i don't know how to use it please help me. i am trying since long.

Hello, Thanks for the excellent series. Can you please share the patch files so i can proceed further. Thanks in advance

Thank you for the tutorial.

ASM?

hey first of all, I want to really appreciate the effort you put into this - thank you. I followed your series, and I'm stuck after installing grid the installation was successful, but the ASM would not start. any idea what could have gone wrong? CRS-4638: Oracle High Availability Services is online CRS-4535: Cannot communicate with Cluster Ready Services CRS-4530: Communications failure contacting Cluster Synchronization Services daemon CRS-4534: Cannot communicate with Event Manager [grid@rac1 grid_home]$ ps -ef | grep -i d.bin root 5392 1 0 12:32 ? 00:00:40 /u01/19c/grid/grid_home/bin/ohasd.bin reboot grid 6199 1 0 12:32 ? 00:00:17 /u01/19c/grid/grid_home/bin/evmd.bin grid 6201 1 0 12:32 ? 00:00:07 /u01/19c/grid/grid_home/bin/mdnsd.bin grid 6285 1 0 12:32 ? 00:00:12 /u01/19c/grid/grid_home/bin/gpnpd.bin grid 6379 1 0 12:32 ? 00:00:18 /u01/19c/grid/grid_home/bin/gipcd.bin root 15279 1 0 12:38 ? 00:00:36 /u01/19c/grid/grid_home/bin/osysmond.bin grid 51928 33853 0 13:59 pts/0 00:00:00 grep --color=auto -i d.bin [grid@rac1 grid_home]$ [grid@rac1 grid_home]$ pmon grid 52136 33853 0 13:59 pts/0 00:00:00 grep --color=auto -i pmon --> ASM wouldn't start.

Public IP Ping does not work if we stopped the cluster. If we start the cluster, public ip is reachable from db1 to db2. Do you know anything about this?

Thank you for amazing work indeed. I have an issue while testing when i am apply this command select inet_server_addr(); on primary for the first time it returns ip of primary for the first time but when i do quit and return back and apply same command on primary it returns ip of secondary. Is this the expected behaviour? this is happening on both the machines

I am following your video, but getting this response what could be the issue? Server backend_readwrite/prd1 is DOWN, reason: Layer7 invalid response, info: "TCPCHK did not match cont> Sep 30 10:21:15 prd1 haproxy[133416]: [WARNING] (133416) : Server backend_readonly/prd1 is DOWN, reason: Layer7 invalid response, info: "TCP

Hello, thank you for doing such amazing videos. Can you confirm if secondary db is read replica or both primary and secondary are read write replicas?

It is good to see the roadmap and architecture. It sets a very good foundation for the rest of this series.

good video. question though. I need to use Chrony as my NTP server for Cisco CUCM. Can I use the IP of the Chrony Server for the CUCM NTP resource or do I need to setup a client also and then use the client as the Resource for CUCM? I am not a linux guy so just trying to understand the reason for a Chrony Server and Chrony Client?

Hi Bro can you please make a step by step video on configuring OpenVPN with split tunnelling & configure Ubuntu as a VPN client. Please, Please its a request. Kindly reply

Thank you for your great content I hope in the future that the content will be in Arabic due to the lack of content

Simple and informative video.

sir ,the invite link is expired please share the opatch files sir

Hello. Can you give me the oracleasm support installation table? I have installed linux oracle 9.4. Thanks.

Hello, can you please share the oracle grid patch table with me? thanks

- -static in hostnamectl?

I have problem with sqlplus / as sysdba write: sqlplus: comand not found ... 11:43

Hello, i am stuck with configurate the Database. getting errors

The only video that helped me and provided the right link and command for everithings. bless you man

i accidentally formated my whole disk drive with windows and all of my documents 😭

The vmware site isnt allowing the download any more, do you have a clean vmware workstation 17pro that you can share via a download link ? 🙏🏻

I don't have those patch files. Is it possible you can share pls?

Will this work on Fedora 40 wirh 6.9 kernel?

I have joined Discord. From where can I get the Oracle 19.15 Patch files?

[Fedora 40] (VMWare Workstation Pro 17.5.2 Kernel version 6.8.5-301.fc40.x84_64 were not found. How can i fix it. thanks for help

thank you!

Great tutorial. Well explained in easy to follow steps. This helped me a lot. thanks! May we know what tool/app is that on the right tiling window, which is being referred for the commands. 11:35

Hi there! First of all thank you a lot for making this tutorial, it made some things clear for me. But I've a problem, and I need help. I've one SSD installed in my machine, gpt partition. I've made one of disk partitions bootable by unmounting pop os 22.04 lts iso to there. I managed to boot it. I did the same thing as you shown: I made 1GB fat32 partition for /boot, 4GB for /restore and the rest for general purposes. Then I created physical volume from the general one, and divided it into swap and root as you shown. Problem is the installer is only seeing the osvg, not boot or restore. I think I should make /boot as physical volume but I have no clue about file systems. I would be glad if someone help me, thanks!

[Fedora 40] (VMWare Workstation Pro 17.5.2 Kernel version 6.8.10-300.fc40.x86_64) Could not open /dev/vmmon: No such file or directory. Please make sure that the kernel module `vmmon' is loaded.

Excellent tutorial! Thank you so much!

Sir i need assistance, I am trying to test it at my home network and has only one network subnet. Please let me know in this scenario how can i create a server client setup Many thanks

Great video abu rahim. Keep them coming 👌

Great efforts

hey sir thanks for the video. I have an issue whenever I run the installer it keeps bringing up an error message and I seem not being able to fix it. just right after the command ./ runInstaller. how can I fix it.

Great video! I've looked a quite a few how to videos, but this was perfect. One question though. If I run oracle on a VM that I'm starting/stopping quite a bit, how do I get the PDB to auto mount? Each time I reboot, I have to run "ALTER PLUGGABLE DATABASE ALL OPEN;" Thanks again!

Hello, I followed your tutorial and it worked fine until I ran show pdbs in sql shell at 11:45. It is giving me the error 'Oracle not available'. Somehow I don't have a database created yet. For disclaimer, I used yum instead of dnf and did install instead of localinstall. Can you please help?

thank you brother

Thank you so mutch, I wasn't expecting a very specific video for Fedora 39. A life saver

Thank You So Much. It worked

@ICyb3r Do you similar doc for OEL 9.3 using UDEV?

Thank you, very helpful. Best series on RAC on youtube.

So cool! Thank you 😊