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
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
[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.
Database Cloud Service Provisioning Fails With “Cannot access Object Storage using the subnet with the following OCID”
While creating an oracle Database cloud service (or the new name "Oracle Base Database"), and after passing all the required information, and then clicking "Create DB System", I received the following error:Cannot access Object Storage using the subnet with the following OCID: ocid1.subnet.ocx.zz-yyy-xxxxxx-1.aaaaaaaaxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx. Review your VCN configuration. If you need further assistance, contact Oracle Support. … Continue reading Database Cloud Service Provisioning Fails With “Cannot access Object Storage using the subnet with the following OCID”
Oracle Database 19c Vault Operations Control
This is an extra layer of protection above the normal Database Vault Realms & Command Rules. In a multitenant database, you can now use Oracle Database Vault to block common users (infrastructure database administrators, for example) from accessing local data in pluggable databases (PDBs), even if you don't have the database vault enabled at the … Continue reading Oracle Database 19c Vault Operations Control
Oracle Database 19c Release Updates (RUs) and Release Update Revisions (RURs)
Following is a list of all RU (Release Updates) and RUR (Release Update Revisions) issued for the Oracle Database 19c (19.3) since Apr-2019 till today 24-Jun-2021. Please zoom-in to see the above picture clearly, or see it partitioned below: Please note that:– Both RUs & RURs are released quarterly (Jan, April , Jul & Oct).– … Continue reading Oracle Database 19c Release Updates (RUs) and Release Update Revisions (RURs)
Installing Oracle OE Sample Schema
If you are interested in installing all oracle database sample schemas, please refer to my post:Installing Oracle Sample Schemas (19.3) If you want to install the scott demo schema, please refer to:https://ahmedfattah.com/2019/12/25/how-to-create-the-scott-oracle-database-demo-schema/ Here is a live demo about Order Entry (OE) schema installation: https://www.youtube.com/watch?v=c8dxF-1rGZo Please note that before installing the OE schema, you should first install … Continue reading Installing Oracle OE Sample Schema
Oracle Database 21c Documentation
Oracle Database is the world's most popular database. Available on cloud and on-premise platforms, Oracle Database 19c is the most recent long term release, with an extended support window. Oracle Database 21c is the latest innovation release, initially available on Oracle cloud through Autonomous Database Free Tier and Database Cloud Service. For Oracle Database 21c documentation:https://docs.oracle.com/en/database/oracle/oracle-database/21/index.html For Oracle Database … Continue reading Oracle Database 21c Documentation
Ahmed AbdelFattah Blog ! 