The Oracle DBA’s Guide to SQL Server Integration: Implementing DG4ODBC on Oracle Linux 9

Posted on by Ahmed Abdel Fattah

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?

Posted on by Ahmed Abdel Fattah

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?

OHUC-1026 : unable to authenticate the new password

Posted on by Ahmed Abdel Fattah

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

How to Download Oracle software to VM in a private OCI subnet?

Posted on by Ahmed Abdel Fattah

I have a virtual machine located in an OCI private subnet. I need to install an Oracle software (e.g. Oracle ODI) in this VM.How I can download the software to this VM?We have a couple of options: 1- Download the software to your laptop, then sftp it to the VM (connecting through VPN and your … Continue reading How to Download Oracle software to VM in a private OCI subnet?

Oracle Database 20c is now Generally Available

Posted on by Ahmed Abdel Fattah

Oracle Database 20c is now Generally Available on the cloud two days ago, 14-Feb-2020. Oracle 20c is next major database release. It includes many new fetaures espcially in the following areas: BlockchainMachine LearningSecurityJSONIn-Memory For a quick introduction to this new release:https://blogs.oracle.com/database/ga-of-oracle-database-20c-preview-release Also, for complete list of the new features, please refer to the:https://docs.oracle.com/en/database/oracle/oracle-database/20/newft/new-features.html Oracle Database … Continue reading Oracle Database 20c is now Generally Available

How to Create Autonomous Datawarehouse Database (Always Free Services)?

Posted on by Ahmed Abdel Fattah

https://www.youtube.com/watch?v=nOJowoCyw7Y ThanksAhmed