After Oracle Database Upgrade to 12.2, Database Express Did not work

I upgraded one database from 11.2.0.4 to 12.2.0.1 on one Solaris Sparc server. After that I configured the Enterprise Manager Database Express, but when I tried to access it, I got the following error: For more information about Oracle Enterprise Manager Database Express, please refer to my post:https://ahmedfattah.com/2018/10/14/oracle-enterprise-manager-database-express-12c-overview/ Environment: Oracle Solaris 11Oracle Restart 12.2.0.1Oracle Database … Continue reading After Oracle Database Upgrade to 12.2, Database Express Did not work

How to Enable Archivelog Mode for an Oracle database

This is a quick post about the steps required to enable the ARCHIVELOG mode for an oracle database (Single Instance or RAC) To check if the archive log mode is enabled or not, use the following command: SYS@XPS 01-SEP-18 SQL> archive log list Database log mode               No Archive Mode … Continue reading How to Enable Archivelog Mode for an Oracle database

Oracle tnsnames.ora Distribution Management System!

What? Does tnsnames.ora file need a Distribution Management System? In our case, the answer is yes. It is a headache to implement our client requirements without some sort of automation. What is tnsnames.ora file? tnsnames.ora is a text file that resides on the ORACLE_HOME/network/admin and contains some simple information about our databases connection information, it … Continue reading Oracle tnsnames.ora Distribution Management System!

Oracle Database 32-bit Funny Migration to 64-bit

Objective: Migrating one 11.1.0.7 32-bit database that resides on an old Windows 2008 (32-bit) (4GB memory) to Windows 2008 64-bit (no upgrade) on a brand new server with 64GB memory. {At 2017 and still there is 11.1.0.7 database ==> yes there is!} Introduction and Background I have a client with the following very old environment: … Continue reading Oracle Database 32-bit Funny Migration to 64-bit

The Power of the Oracle Trace Files

Although I had different topics planned for my first blog, but I just received this client issue this morning, and I decided to share it with you to explain how to take advantage of the powerful information contained in the oracle trace files. What is the issue? I received a call from one of my … Continue reading The Power of the Oracle Trace Files