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
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)
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
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
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)?
https://www.youtube.com/watch?v=nOJowoCyw7Y ThanksAhmed
The beauty of Visualization with Oracle Database
https://youtu.be/3N2wgayry4g ThanksAhmed
Protected: Oracle RAC 12c Installation on Linux
There is no excerpt because this is a protected post.
Oracle Listener 19c Starting Error
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
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
Ahmed AbdelFattah Blog ! 