Oracle Virtual Machines for Sale !

Are you looking for a virtual machine to do some hands-on labs or practice something (i.e. for Educational purposes}? Do you have the time to build these virtual machines yourself? Below are some really nice Virtual Machines, that I invested allot of time to build on Oracle Virtual Box, and that I used them personally … Continue reading Oracle Virtual Machines for Sale !

Alter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation

While trying to open one pluggable database, I got the following errors: Background: While installing Apex 20.1 in one PDB, and while being very close to the installation completion, the session fully stucked.I restarted the database (the CDB), then I tried to open the PDB, but I got the above errors. While searching for this … Continue reading Alter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation

Oracle Database 20c is now Generally Available

Oracle Database 20c is now Generally Available on the cloud two days ago, 14-Feb-2020. Oracle 20c is next major database release. It includes many new fetaures espcially in the following areas: BlockchainMachine LearningSecurityJSONIn-Memory For a quick introduction to this new release:https://blogs.oracle.com/database/ga-of-oracle-database-20c-preview-release Also, for complete list of the new features, please refer to the:https://docs.oracle.com/en/database/oracle/oracle-database/20/newft/new-features.html Oracle Database … Continue reading Oracle Database 20c is now Generally Available

The Longest SQL Statement I have ever seen !

Below may be the longest SQL statement that I have ever seen. I don't know if it is written by one developer or group of developers and what is the logic behind it? I really don't like this style of writing sql statements. It is very difficult to be functionally understood. Also, it is very … Continue reading The Longest SQL Statement I have ever seen !

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

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

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?

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?

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)