ORA-38760 While starting an Oracle Database

This is a quick post about an issue that I faced while trying to start one database yesterday. When I was trying to open one 12cR1 database, I got the following error: SYS SQL>alter database open;alter database open*ERROR at line 1:ORA-38760: This database instance failed to turn on flashback database The database status was "mounted": … Continue reading ORA-38760 While starting an Oracle Database

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.

Oracle Read Only Tables

Starting from Oracle 11gR1, oracle allows us to change a table to be a read-only table. Let us have a quick demo: I'm connecting as user HR ( to a 19c pluggable database). I have a small table "DEPT": So, now I'm going to change the table to be read only table: Now let us … Continue reading Oracle Read Only Tables

How to create the Scott Demo Database Schema?

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)

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 as explained in this post. Download the Scripts: Starting … Continue reading Installing Oracle Sample Schemas (19.3)

Loading Arabic Data Into Oracle Database using SQLCL

This is a follow up post on my previous post:https://ahmedfattah.com/2019/12/15/loading-data-into-oracle-database-from-text-csv-files/If you read this post, you find that we uploaded some data , part of it was Arabic data, and although it was loaded successfully, the Arabic data was corrupted (appeared as ???????). In this post, we see how we can configure sqlcl to load and … Continue reading Loading Arabic Data Into Oracle Database using SQLCL

Oracle VirtualBox: Create new Virtual Machine

In this post we are going to create a new virtual machine and configure it to use an already existing virtual disk. This disk contains Oracle Linux 6.3 + Oracle Grid Infrastructure 12.2 + Oracle Database 12.2. We will create the machine two times, one time using the VirtualBox Manager (Gui Interface), and another time … Continue reading Oracle VirtualBox: Create new Virtual Machine

Oracle RMAN Database Full Cold Backup Demo

https://www.youtube.com/watch?v=bJjm1U5x61M For similar script for the full database hot backup: https://ahmedfattah.com/2019/11/14/oracle-rman-full-hot-backup-script/ ThanksAhmed

Oracle Application Server 10g – Increase JVM Heap Memory Size

Background: One of my customers still has the old oracle application server (10.1.2.3.0), that is used to host a forms and reports application. Application Tier is running on Windows server (Windows 2008 R2 64-bit) Customer has 6-sites, each one has its own application server (no load balancer). All branches are connecting to the same database … Continue reading Oracle Application Server 10g – Increase JVM Heap Memory Size