After Oracle Database Upgrade to 12.2, Database Express Did not work

Posted on by Ahmed Abdel Fattah

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

How to drop an Oracle Database using dbca in silent mode?

Posted on by Ahmed Abdel Fattah

I have one 12c (12.2) database called "TEST" that is running in archivelog mode, and for some reason I want to drop this database. grid@test01:~$ ps -ef|grep pmongrid 11233 1 0 21:32:47 ? 0:03 asm_pmon_+ASMoracle 11360 1 0 21:33:19 ? 0:07 ora_pmon_TEST Unfortunately, I can't run dbca in GUI mode, so, I want to drop … Continue reading How to drop an Oracle Database using dbca in silent mode?

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)

Loading Arabic Data Into Oracle Database using SQLCL

Posted on by Ahmed Abdel Fattah

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

Loading Data into Oracle Database from text CSV files

Posted on by Ahmed Abdel Fattah

In this post we are going to load data from text files (formatted as CSV “comma separated values”) into oracle database (12.1) using 3 different techniques: Oracle SQL LoaderOracle SQL DeveloperOracle sqlcl command line utility. We will just touch the above techniques; you still need to drill down for more options and more details. Environment: … Continue reading Loading Data into Oracle Database from text CSV files

Removing Oracle Database Software 12.2 (Grid + Database)

Posted on by Ahmed Abdel Fattah

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 VirtualBox: Resize Linux Filesystem

Posted on by Ahmed Abdel Fattah

We have an Oracle Linux Virtual Machine that we created in our previous post https://ahmedfattah.com/2019/12/10/oracle-virtualbox-create-new-virtual-machine/ up and running. When I examined the space on this VM, I found that I have only 2GB of free space available in "/" filesystem, which is not enough for me to do my work. So, I decided to increase … Continue reading Oracle VirtualBox: Resize Linux Filesystem

Oracle VirtualBox: Create new Virtual Machine

Posted on by Ahmed Abdel Fattah

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