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
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
I upgraded one database from 220.127.116.11 to 18.104.22.168 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 22.214.171.124Oracle Database … Continue reading After Oracle Database Upgrade to 12.2, Database Express Did not work
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?
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
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)
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
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