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

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 RMAN Database Full Cold Backup Demo

Posted on by Ahmed Abdel Fattah

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 RMAN Database Full Hot Backup Demo

Posted on by Ahmed Abdel Fattah

https://www.youtube.com/watch?v=EItbFz09Thc For similar script for the database full cold backup, please refer to: https://ahmedfattah.com/2019/11/14/oracle-rman-database-full-cold-backup-demo/ ThanksAhmed

How to Create Autonomous Datawarehouse Database (Always Free Services)?

Posted on by Ahmed Abdel Fattah

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

The beauty of Visualization with Oracle Database

Posted on by Ahmed Abdel Fattah

https://youtu.be/3N2wgayry4g ThanksAhmed

Protected: Oracle RAC 12c Installation on Linux

Posted on by Ahmed Abdel Fattah

There is no excerpt because this is a protected post.

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