Apps DBA Workshop

 This blogpost will provide the steps how to install MYSQL Database on Oracle Enterprise Linux 9. The Database Installation will be performed using dnf package installation uility. - Install the database package using the dnf command: - Start and Enable the MYSQL Database Service. Wow, we are done with the MYSQL Database Installation :) Thanks for reading. regards, Zaheer

 In this blogpost you will learn how quickly we can install postgresql on Oracle Linux 9 Server.  Check the package of PostgreSQL using the dnf command: Installation of PostgreSQL package: - Setup the postgreSQL Database: - Start and Enable the postgreSQL Service: - Check the status of the postgreSQL Service The postgreSQL started, enabled and working fine without any issues.  Hope it helps  !! Thanks for reading. regards, Zaheer

 Oracle released its latest version of Operating System - Linux 9 and its introduced too many new features with this release.  As the demand for computing is growing there is a huge inclined in cyber attacks. Operating System is the first layer where application, Database, middleware's, virtualization and everything is hosted. If this layer is compromised then your complete system is compromised. Hence with this release Oracle advanced its security with Oracle Enterprise Linux 9. In this blogpost we will discuss one of the key improvement security area. The old network-scripts package has been removed in Oracle Linux 9. Hence, there are no files in  /etc/sysconfig/network-scripts directory. Also this package was deprecated in Oracle Linux 8. This is a big change from the Administration perspective, if we use to configure network using legacy scripts  then its a very big setback.  Now the network is managed using the nmcli command: nmcli Information is stored file file: Conclusion:

In this blogpost we will see how we can change the hostname on Oracle Linux 9 Operating System.  We can change hostname on Oracle Linux 9 using the simple "hostnamectl" command without restarting any services and it will be reflected immediately on the host. Check the current hostname: Set new hostname: The hostname has been changed from Linux9 to Linux10 using one simple command. Thanks for reading :)  regards, Zaheer

 This blogpost will help you to disable and enable firewall in Oracle Enterprise Linux 9 Server. By default firewall process will be active on Oracle Linux Server. Check the status of firewall: Disable the firewall: Enable the firewall: In this blogpost we've learned simply how we can enable and disable the firewall in Oracle Linux 9 Server. Thanks for reading :) regards, Zaheer

I encountered this error while extending   2 node 12c cluster to 3 nodes. Error: [INS-30160] Installer has detected the nodes specified for add node operation have uncleaned Inventory. Cause: In /u01 directory there was an oraInventory directory exists. Though the directory is emptly oui still assuming that there is some content in this directory. Action: Delete oraInventory directory from nodes on which you are facing Issues. OUI will create this directory after successful addition of nodes. Hope this helps. Thanks for reading :) regards, Zaheer