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)
In this post we are going to create a new virtual machine and configure it to use an already existing virtual disk. This disk contains Oracle Linux 6.3 + Oracle Grid Infrastructure 12.2 + Oracle Database 12.2. We will create the machine two times, one time using the VirtualBox Manager (Gui Interface), and another time … Continue reading Oracle VirtualBox: Create new Virtual Machine
This is my first post after my blog was recognized by feedspot as one of the Top 100 Oracle blogs https://blog.feedspot.com/oracle_blogs/ . I'm really happy of this recognition, and I hope I'll continue providing high quality content and sharing a real oracle experience, thanks feedspot. Coming back to our subject today. I have a valuable … Continue reading Oracle VirtualBox: Change Disk UUID
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
https://youtu.be/3N2wgayry4g ThanksAhmed
https://www.youtube.com/watch?v=ZM6ckWFlyeM ThanksAhmed
If you describe the dba_objects, you will find two IDs called: object_id & data_object_id, so , what is the difference between them? object_id is the primary key. Any object will have object_id irrespective, if it has an associated segment or not. For example, sequence, package, synonym are all objects with object_id but without any physical … Continue reading What is the difference between object_id and data_object_id?
There is no excerpt because this is a protected post.
https://youtu.be/sHUMO-uVYqU ThanksAhmed
Oracle Database 12c introduced Oracle Enterprise Manager Database Express 12c. Oracle Enterprise Manager Express is a Web-based interface for managing an Oracle database. Using Oracle EM Database Express, you can perform basic administrative tasks such as user, performance, memory, and space management. Oracle Enterprise Manager Database Control is no longer available. EM Database Express is … Continue reading Oracle Enterprise Manager Database Express 12c Overview