This is a quick post about installing Oracle Database 19c (19.3) on my laptop (Windows 10). Procedure will be presented as screen cast. As far as I remember, Oracle 19c was released during Mar-2019 for Linux, and during Apr-2019 for SPARC Solaris and during Jun-2019 for Windows,zLinux , HP and AIX Software Download: First of … Continue reading Oracle Database 19c (19.3) Installation on Windows (Step-by-Step)
Oracle Enterprise Manager Database Control & Time Zone
Background: Egypt time zone is GMT+2. Starting from year 1988, Egypt started to use the summer time zone (GMT +3) starting from the last Thursday of Apr till the last Thursday of September (5 months), then it reset back to GMT +2 for the remaining of the year. Summer time zone was cancelled at 20-Apr-2011, … Continue reading Oracle Enterprise Manager Database Control & Time Zone
Oracle Database 19c is now Available
Oracle Database 19c is now available for Linux x86-64. To download the software:https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Also, the documentation is available at: https://docs.oracle.com/en/database/oracle/oracle-database/19/books.html Enjoy ! ThanksAhmed
Oracle Enterprise Manager Database Express 12c Overview
Oracle Database 12c introduced Oracle Enterprise Manager Database Express 12c. Oracle Enterprise Manager Express is a Web-based interface for managing an Oracle database. Using Oracle EM Database Express, you can perform basic administrative tasks such as user, performance, memory, and space management. Oracle Enterprise Manager Database Control is no longer available. EM Database Express is … Continue reading Oracle Enterprise Manager Database Express 12c Overview
Oracle Apex Deployment Models in a Multitenant Database
Following are screen shots from one of my latest presentations about this topic: References: https://docs.oracle.com/database/121/HTMIG/db_pluggable.htm https://oracle-base.com/articles/12c/multitenant-uninstall-apex-from-the-cdb-12cr1 ThanksAhmed
Oracle 12.2 Database Creation
This post is just a screen cast for the process of creating a new container database with two PDBs in Oracle version 12.2. Login to the database server, set the ORACLE_HOME , PATH and DISPLAY , then run the Database Configuration Assistant "dbca" as oracle user: Check the listener status and ensure that the newly … Continue reading Oracle 12.2 Database Creation
Installing Oracle Database 18.3 on Windows
This is a quick post about installing Oracle Database 18.3 on my laptop (Windows 10). First of all download the software media file. You can download the media from: https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-windows-180000-5066774.html The file name is called:WINDOWS.X64_180000_db_home.zip and it is about 4.5GB Create a folder under d:\app called db183 Unzip the media under this folder d:\app\db183 The … Continue reading Installing Oracle Database 18.3 on Windows
Oracle Database Guard 12c Implementation with RAC (Step-by-Step)
Introduction: This is a real data guard implementation case for one of my clients. Data Guard is implemented between two clusters that reside on two different supercluster machines. The below procedure applies between any two clusters, it doesn't matter if it is a supercluster or Exadata or normal servers. I tried to put as much … Continue reading Oracle Database Guard 12c Implementation with RAC (Step-by-Step)
Protected: Oracle Data Guard 12c Switchover Issues
There is no excerpt because this is a protected post.
Oracle Database Services in (Oracle RAC + Oracle Data Guard) Environment
Introduction: We may classify the database services into two types of services : 1- Database Services 2- Cluster Managed Database Services Please note that: - The procedure dbms_service.start_service - used with the first type - is deprecated in databases managed by Oracle Clusterware and Oracle Restart with Release 11.2. While the procedure remains available in … Continue reading Oracle Database Services in (Oracle RAC + Oracle Data Guard) Environment
Ahmed AbdelFattah Blog ! 