Doug Groves, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts Remote Database Administration Wed, 12 Nov 2025 16:25:32 +0000 en-US hourly 1 https://wordpress.org/?v=6.9.4 https://virtual-dba.com/wp-content/uploads/cropped-VirtualDBA-favicon-32x32.png Doug Groves, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts 32 32 Creating and Sizing the Oracle Fast Recovery Area https://virtual-dba.com/blog/creating-and-sizing-the-oracle-fast-recovery-area/ Thu, 24 Apr 2025 16:45:00 +0000 https://virtual-dba.com/?p=242809 When creating the fast recovery area, place it on a separate disk from the database binaries and data files. For this example, I am using the C drive because this is on a VM, which is what is available. The size of your fast recovery will also depend on several factors The size and location […]

The post Creating and Sizing the Oracle Fast Recovery Area appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> Create Temporary Tablespace in Oracle and Make It the Default Temporary Tablespace https://virtual-dba.com/blog/create-temporary-tablespace-in-oracle-and-make-it-default-temporary-tablespace/ Tue, 15 Apr 2025 21:12:14 +0000 https://virtual-dba.com/?p=242854 This article covers the steps to create a temporary tablespace in Oracle and make it the default temporary tablespace for the database. Step-By-Step This method works for both regular Oracle databases and multitenant databases. Each PDB and CDB has its own separate temporary tablespace. When creating a temporary tablespace for a PDB, make sure you […]

The post Create Temporary Tablespace in Oracle and Make It the Default Temporary Tablespace appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> How to Upgrade Oracle Database to 19c https://virtual-dba.com/blog/how-to-upgrade-oracle-database-to-19c/ Thu, 03 Apr 2025 22:46:55 +0000 https://virtual-dba.com/?p=242778 Below is a step-by-step guide to walk you through how to upgrade oracle database to 19c. Step 1 Download the Oracle 19c binaries, the latest version of OPatch, How To Download And Install The Latest OPatch (6880880) Version (Doc ID 274526.1) and the AutoupGrade Tool (Doc ID 2485457.1) from Oracle support. For this example, the […]

The post How to Upgrade Oracle Database to 19c appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> Resolving the ORA-24247: network access denied by access control list (ACL) error https://virtual-dba.com/blog/resolving-the-ora-24247/ https://virtual-dba.com/blog/resolving-the-ora-24247/#comments Thu, 16 Jul 2020 21:42:27 +0000 https://virtual-dba.com/?p=37585 Before Oracle 11g access to network services was controlled by granting privileges on packages such as UTL_HTTP, UTL_TCP, UTL_SMTP, and UTL_MAIL. After 11.1 Oracle introduced Application Control Lists (ACL) as part of their Application Security and has now added Application Control Entry (ACE). If you run into the ORA-24247: network access denied by access control […]

The post Resolving the ORA-24247: network access denied by access control list (ACL) error appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/resolving-the-ora-24247/feed/ 6 How to Create an RMAN Recovery Catalog in Oracle 18c https://virtual-dba.com/blog/how-to-create-an-rman-recovery-catalog-in-oracle-18c/ https://virtual-dba.com/blog/how-to-create-an-rman-recovery-catalog-in-oracle-18c/#respond Thu, 16 Apr 2020 22:24:22 +0000 https://virtual-dba.com/?p=37296 Recovery Catalog Purpose: The RMAN recovery catalog is a schema created inside of a new or existing database that is used to store metadata about Oracle databases. It’s recommended by XTIVIA that the catalog be created in its own dedicated database due to the importance of its role in database recovery. A few benefits for […]

The post How to Create an RMAN Recovery Catalog in Oracle 18c appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/how-to-create-an-rman-recovery-catalog-in-oracle-18c/feed/ 0