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)

Donate to support our blogging work$1.00Click here to purchase. 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 … Continue reading Installing Oracle Sample Schemas (19.3)

Protected: Oracle RAC 12c Installation on Linux

There is no excerpt because this is a protected post.

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

Oracle Database Password file presentation

https://youtu.be/sHUMO-uVYqU ThanksAhmed

Oracle Database 19c (19.3) Installation on Windows (Step-by-Step)

This is a quick post about installing Oracle Database 19c (19.3) on my laptop (Windows 10). Procedure will be presented as screen cast. As far as I remember, Oracle 19c was released during Mar-2019 for Linux, and during Apr-2019 for SPARC Solaris and during Jun-2019 for Windows,zLinux , HP and AIX Software Download: First of … Continue reading Oracle Database 19c (19.3) Installation on Windows (Step-by-Step)

Oracle 12.2 Database Creation

This post is just a screen cast for the process of creating a new container database with two PDBs in Oracle version 12.2. Login to the database server, set the ORACLE_HOME , PATH and DISPLAY , then run the Database Configuration Assistant "dbca" as oracle user: Check the listener status and ensure that the newly … Continue reading Oracle 12.2 Database Creation