If you want to grow/make money on Instagram, I found this valuable training guide: “Instagram Mastery Craze” https://payhip.com/b/scBwC ..read more

https://treasuree.gumroad.com/l/RAC1 ..read more

Background: I was upgrading an Oracle Database version 12c(12.2.0.1) to version 19c (19.24) on Microsoft Windows.This is a manual command line line upgrade ( I didn’t use DBUA).I started by doing some preparation tasks like::: Task #1: Run pre-upgrade checks:: Task #2: Run the preupgrade_fixups.sql:: Task #3: Connect to sqlplus and create pfile from pfile ..read more

In this post, you will find all the details to install Oracle Data Integrator 12.2.1.4.0 on Oracle Linux 9.4, plus creating the back end repositories (Master & Work repositories). Also, you find the steps to create a standalone agent along with its standalone domain and how to start/stop it. Environment Details Item Value Remarks Server ..read more

The following mind map highlights the key steps to install Oracle Database 19.24 on Oracle Linux 9.4 Please note that installation of Oracle database 19.3 on Oracle Linux 9.4 is a little bit different.As the base release 19.3 is a little-bit old compared to Oracle Linux 9.4, then we have to apply the release update ..read more

As an intermediate step in a database upgrade process, there is one step to delete an Oracle database Windows Service using the following command:oradim.exe -delete -sid POSDB But, I received the following error message:O/S-Error: (OS 1072) The specified service has been marked for deletion. I tried many things, like:Closing the Task Manager.Ensuring event viewer, Microsoft ..read more

What is the problem? I received an email from the client that no one was able to connect to the database this morning (after 8:20 am). This case is a good example to show you how it is important to collect information about the issue from the concerned people before diving into the log files and trace file. Environment This is an Oracle RAC cluster, 2-nodes, Oracle 19c, IBM-AIX Analysis Let us see what is there in Node #1, using the adrci utility: Let us see the details of the last incident: What is there in the alert.log file of instance#1? Let us review Node #2 also: What is the Oracle Ha ..read more

Following are the steps that I followed to change the hostname of one OCI Compute Instance for one of my clients. Note that the operating system for this instance is Oracle Linux: 1. Use the hostnamectl utility to change the hostname hostnamectl set-hostname new_hostname 2. Update the /etc/hosts file with the new name [root@infodqmdm001 ~]# cat /etc/hosts 127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6 172.17.15.112 new_hostname.app.oraclevcn.com new_hostname 3 ..read more

One of my clients faced the following error, while starting an 12.2 database service on Windows: OHUC-1026 : unable to authenticate the new password Background: The client was trying to change the Oracle Home User password using the orahomeuserctl, after that he was not able to start the Database Windows Service. What is Oracle Home User? Oracle Home User is used to run the instance services (You still install the software as Administrator). In Oracle Database 12.1, there are 3 choices for this user: Use existing Windows user, Create new Windows user or SYSTEM (Use Windows Built-in account) I ..read more

I created an OCI compute Linux Instance with hostname = hostname_1. After a while, and based on the client request, I changed the above virtual machine hostname to be hostname_2. Client used this machine for a while, and then reboot it for some reason, but surprisingly, he found that the compute Instance hostname changed back to the original one, which is hostname_1!!! What is the reason behind this? The reason behind that is that OCI doesn’t preserve the hostname across reboots. By Default, OCI will update the hostname from the OCI metadata service. Luckily, this behavior is configurable an ..read more