This is a quick demo about how we can create a table with column of type nested table? how to query the nested table data in different ways?. Let us start:
Schedule RMAN Backup Job in one minute
In this demo, I'm going to schedule a backup job to run daily at a specific time. The backup script provided in this video is for demo only, please don't use it in production without proper testing. https://www.youtube.com/watch?v=sNQXBiOpPUk RegardsAhmed
How to Modify an Oracle Database Windows Service?
This is a quick post about how we can change some parameters for one database winodws service. Background:I have a database called PROD with version 19.3, running on Windows. Its service looks like: This Windows service was configured with the parameter file:D:\app\db193\WINDOWS.X64_193000_db_home\database\initPROD.oraFor some reason, I want to change the parameter file to be:M:\app\oracle\database\initPROD.ora{Actually, I'm preparing … Continue reading How to Modify an Oracle Database Windows Service?
What is Oracle Home User in Oracle Database 12c?
In this post, I'm documenting some valuable information from different resources, about the "Oracle Home User" that is introduced in Oracle 12.1, and the difference between the "Oracle Home User" and the "Oracle Installation User"? ThanksAhmed
ORA-01623 & ORA-00312 while dropping one red log file
I got the following errors while dropping one redo log group: Please note that our database is an RAC One Node database that I'm trying to convert to Single-Instance database based on the client requirements.So, thread 2 (instance 2), is not there actually.If we query about the redo log files of instance 2: So, what … Continue reading ORA-01623 & ORA-00312 while dropping one red log file
How to install Oracle Database 19c (19.3) on an Oracle Cloud Compute Instance (with Oracle Linux)?
Demo for Oracle Database Locking Policy
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 !
Oracle Single-Instance Database Creation in a Clustered Environment
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
Ahmed AbdelFattah Blog ! 