In modern data warehousing, the "pure" Oracle environment is a myth. We often manage dozens of Oracle databases but still encounter that one necessary SQL Server instance holding critical data. When you need to pull data from SQL Server into Oracle, you have two primary options: the paid "Oracle Database Gateway for SQL Server" (DG4MSQL) … Continue reading The Oracle DBA’s Guide to SQL Server Integration: Implementing DG4ODBC on Oracle Linux 9
Why my Oracle Database is not dynamically registered with the Listener?
Here, we have couple of puzzles, they are mainly:1- Why the database services are dynamically registered with non-default listener while the local_listener definition doesn't exist in the tnsnames.ora file?2- If you do some changes in the tnsnames.ora file related to the local_listener, are these changes dynamically reflected to the database and listener? or do you … Continue reading Why my Oracle Database is not dynamically registered with the Listener?
O/S-Error: (OS 5) Access is denied while upgrading Oracle 12c Database to 19c
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:: … Continue reading O/S-Error: (OS 5) Access is denied while upgrading Oracle 12c Database to 19c
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
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
[DBT-20052] Database upgrade is not supported from Oracle Home with Oracle Home User “dbuser” to an Oracle Home with Windows Virtual Account.
Background: A customer has an Oracle Database version 12.2.0.1 on Windows server. He asked to upgrade this database to 19c (19.17) on the same server. Procedure: I installed Oracle 19c (19.3) on a new oracle home on the same server.(During the installation I selected "Windows Virtual Account" as the Oracle Home owner) I applied the … Continue reading [DBT-20052] Database upgrade is not supported from Oracle Home with Oracle Home User “dbuser” to an Oracle Home with Windows Virtual Account.
opatch version failed with error: Java (1.7) could not be located. OPatch cannot proceed!
BackgroundI asked one of my colleagues to download the latest opatch patch, in preparation to patching one oracle database 19c home on Oracle Linux platform (8.8).The old utility has version: 12.2.0.1.17 The latest downloaded utility has version: OPATCH_VERSION:12.2.0.1.40 Usually, I start by renaming the old OPatch directory, then extracting the new version under Oracle Home.This … Continue reading opatch version failed with error: Java (1.7) could not be located. OPatch cannot proceed!
Ahmed AbdelFattah Blog ! 