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 ItemValueRemarksServer NameHOST-01 IP11.11.11.11 CPU #2 Memory32 GB Storage150 … Continue reading Oracle Data Integrator (ODI) 12.2.1.4.0 Installation on Oracle Linux 9.4
Oracle Database 19.24 Installation on Oracle Linux 9.4 Mind Map
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 … Continue reading Oracle Database 19.24 Installation on Oracle Linux 9.4 Mind Map
The system cannot find the batch label specified – execute_task when upgrading an Oracle Database
I created a Windows batch script to upgrade and oracle database from 12.2 to 19.23 on Windows platform. The main script line is the following line (which is the main command to upgrade the Oracle Database):%ORACLE_19C_HOME%\bin\dbupgrade1 -n 4 >> %LOG_FILE% 2>&1 But when running the script, the script is error out when executing the above … Continue reading The system cannot find the batch label specified – execute_task when upgrading an Oracle Database
utltz_upg_apply script hangs while shutting down the Oracle Database
I was upgrading one Oracle Database from 12.2.0.1 to 19.23 on Windows platform manually. While upgrading the time zone files (from 26 to 43) and running the utltz_upg_apply.sql it hangs while shutting down the database for the first time.This is the last line displayed in the log file:utltz_upg_apply is ready to update to RDBMS DSTv43 … Continue reading utltz_upg_apply script hangs while shutting down the Oracle Database
Oradim not able to delete an Oracle database windows service
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 POSDBBut, 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 Management … Continue reading Oradim not able to delete an Oracle database windows service
Oracle Database Hang, no one was able to connect
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 … Continue reading Oracle Database Hang, no one was able to connect
Oracle Cluster Node is Down, bad news
This is one of the difficult situations for any Oracle DBA, where you may receive wrong/conflicting messages from the end users, you may need to run many commands, examine many lengthy trace files, cooperate with other team members, contact vendor support teams. Yesterday, I got a complaint that the database/application is running very slow. I … Continue reading Oracle Cluster Node is Down, bad news
How to change the hostname for an OCI Compute Instance
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 ~]# … Continue reading How to change the hostname for an OCI Compute Instance
OHUC-1026 : unable to authenticate the new password
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? … Continue reading OHUC-1026 : unable to authenticate the new password
OCI Compute Instance Hostname keeps changing after reboot
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 … Continue reading OCI Compute Instance Hostname keeps changing after reboot
Ahmed AbdelFattah Blog ! 