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

Is it possible to map one Tablespace to many Tablespaces with impdp?

I got this question from one of my clients. He is going to migrate one database from one platform to another. In this database many users are sharing the same tablespace. For example: In the current database, all application users are sharing the tablespaces “USERS” The client wants to change this, so as each schema … Continue reading Is it possible to map one Tablespace to many Tablespaces with impdp?

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.

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)

The beauty of Visualization with Oracle Database

https://youtu.be/3N2wgayry4g ThanksAhmed

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