Oracle Database 19c (19.3) Installation on the Oracle Cloud Compute Instance.

As, I already have access to one Oracle Cloud Free Compute Instance (Oracle Linux), then I decided to install Oracle database 19c there and create a test database. This time, I'll use a different technique by installing Oracle Database rpm.Oracle delivered the oracle database software as rpm for Linux since Oracle 18c. Installation procedure is … Continue reading Oracle Database 19c (19.3) Installation on the Oracle Cloud Compute Instance.

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

Removing Oracle Database Software 12.2 (Grid + Database)

I have an Oracle Restart virtual machine that has both Oracle grid Infrastructure 12cR2 (12.2) and Oracle Database 12c R2 (12.2) + one CDB database called "orcl". I need to fully remove all oracle components from this machine. About the Deinstallation Tool Starting with Oracle Database 12c, the deinstallation tool is integrated with the database … Continue reading Removing Oracle Database Software 12.2 (Grid + Database)

Oracle Listener 19c Starting Error

While starting a newly created Oracle 19c Listener, I received the following errors; C:\Users\win>lsnrctl start LSNR19C LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production on 06-SEP-2019 13:58:09 Copyright (c) 1991, 2019, Oracle. All rights reserved. Starting tnslsnr: please wait… Unable to OpenSCManager: err=5 TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error The listener configuration file … Continue reading Oracle Listener 19c Starting Error