Tag: Oracle

Considerations for Converting from Oracle to Other RDBMS Platforms

Oracle software is known for being complex, expensive, and even cumbersome. However, while legacy database management systems (DBMS) like Oracle often hang around well past their best before date – in many cases due to corporate inertia and well-worn habit…

Read More >

How To Reclaim ASM Disks

The project I have been working on is migrating GoldenGate trails from DBFS and ACFS. Now that the migration has completed and DBFS database has been dropped, the next step is to reclaim ASM disks. DBFS is running on 2…

Read More >

Oracle Cloud Infrastructure: Should you consider it for your Oracle database workloads?

Oracle users have had the ability to run database workloads in the cloud for years, but options have always been limited to third-party providers like Amazon Web Services (AWS) – at least, until recently. That’s because Oracle has a second-generation…

Read More >

How to extend the /u01 filesystem on an Exadata

Marketers are very good at selling everyone on the fact that resources (CPU, disks, memory) are now infinite, which is mainly true on a slide but it’s less true in real life. You may one day face this situation with…

Read More >

Weighing the pros and cons of Oracle Autonomous Database

The next generation of managed database services is upon us, offering organizations of all sizes the ability to scale database workloads quickly without forking out huge investments in either hardware or specialized expertise. One of these services is Oracle Autonomous…

Read More >

Testing the 19c Grid Infrastructure by Performing a Dry-Run Upgrade

In reviewing Grid Infrastructure Installation and Upgrade Guide for Linux, I discovered the dry-run upgrade mode to test upgrades. With dry-run being a new feature, I tested it first using GUI. From the response file above grid_2019-08-06_00-20-31AM.rsp, create dryRunForUpgradegrid.rsp: Create…

Read More >

Why it’s Good Practice To Run datapatch -prereq After Creating Database

Starting with 12c, running datapatch may be required after creating a database, depending on the database version and method for creating the database. Instead of having to remember all the variations, it’s much simpler just to run datapatch -prereq after creating…

Read More >

How to delete an RAC Database Using DBCA silent mode

I was recently working on a Proof Of Concept to migrate RAC non-CDB to CDB. I faced multiple issues and wanted to start fresh. In order to do this, I needed to delete the newly RAC CDB database. Review database…

Read More >

How to Prevent Linux 7 Housekeeping from Breaking Oracle

Linux 7 introduced multiple changes and enhancements to the kernel. Among them was automated housekeeping for temporary files. In version 6, tmpwatch is available to manage unused files in temp directories. It can be scheduled via cron to automatically keep…

Read More >

How to Find Cluster Resources Where Target!=State

DBA typically checks cluster resources as part of patching efforts. However, when checking cluster resources returns 200+ results, it’s not feasible to verify the results and it’s too time-consuming. A better solution is to find a cluster resource where the…

Read More >
Page 7 of 164« First Page...56789...20...Last Page »