Installing Oracle OE Sample Schema

If you are interested in installing all oracle database sample schemas, please refer to my post:Installing Oracle Sample Schemas (19.3) If you want to install the scott demo schema, please refer to:https://ahmedfattah.com/2019/12/25/how-to-create-the-scott-oracle-database-demo-schema/ Here is a live demo about Order Entry (OE) schema installation: https://www.youtube.com/watch?v=c8dxF-1rGZo Please note that before installing the OE schema, you should first install … Continue reading Installing Oracle OE Sample Schema

Oracle Database 21c Documentation

Oracle Database is the world's most popular database. Available on cloud and on-premise platforms, Oracle Database 19c is the most recent long term release, with an extended support window. Oracle Database 21c is the latest innovation release, initially available on Oracle cloud through Autonomous Database Free Tier and Database Cloud Service. For Oracle Database 21c documentation:https://docs.oracle.com/en/database/oracle/oracle-database/21/index.html For Oracle Database … Continue reading Oracle Database 21c Documentation

Oracle Database Locking Policy – Back to Basics

Understanding how oracle internally manages the transactions is very crucial for your applications. Dealing with the database as a black box (sending queries and receiving results), will end up with bad performance to your application or/and non-scalable application. Oracle uses locks to internally manages the concurrent access to data.Only one transaction can modify any piece … Continue reading Oracle Database Locking Policy – Back to Basics

Oracle Virtual Machines for Sale !

Are you looking for a virtual machine to do some hands-on labs or practice something (i.e. for Educational purposes}? Do you have the time to build these virtual machines yourself? Below are some really nice Virtual Machines, that I invested allot of time to build on Oracle Virtual Box, and that I used them personally … Continue reading Oracle Virtual Machines for Sale !

Installing Oracle Sample Schemas (19.3)

Donate to support our blogging work$1.00Click here to purchase. 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: Or you can install sample schemas manually after the database creation … Continue reading Installing Oracle Sample Schemas (19.3)

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

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

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

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 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