How to create the Scott Demo Database Schema?

Posted on by Ahmed Abdel Fattah

Scott schema is the most famous oracle database demo schema that is available since 1990 !. Scott is a database user used for demonstration purposes containing the famous EMP, DEPT, BONUS and SALGRADE tables.This account was named after Bruce Scott (co-author and co-architect of Oracle v1 to v3) and the password was the name of his daughter's cat, Tiger. … Continue reading How to create the Scott Demo Database Schema?

Installing Oracle Sample Schemas (19.3)

Posted on by Ahmed Abdel Fattah

In this post, I'm going to explain how to install Oracle sample schemas, if they are not already installed. If you created a database sing DBCA , you can select to install the sample schemas: Please note that using this method (dbca) will install only the HR sample schema. Or you can install sample schemas … Continue reading Installing Oracle Sample Schemas (19.3)

The beauty of Visualization with Oracle Database

Posted on by Ahmed Abdel Fattah

https://youtu.be/3N2wgayry4g ThanksAhmed

What is the difference between Oracle RAC One Node and Oracle RAC?

Posted on by Ahmed Abdel Fattah

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

Oracle Listener 19c Starting Error

Posted on by Ahmed Abdel Fattah

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

Install Error [DBT-50000] Unable to check for available memory

Posted on by Ahmed Abdel Fattah

While creating an Oracle 19c database I received this error: Install Error [DBT-50000] Unable to check for available memory After some research, I found the following workaround, to start the dbca with specific option: dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false This fixed the error. ThanksAhmed

Oracle Database Password file presentation

Posted on by Ahmed Abdel Fattah

https://youtu.be/sHUMO-uVYqU ThanksAhmed

Oracle Database 19c (19.3) Installation on Windows (Step-by-Step)

Posted on by Ahmed Abdel Fattah

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)