Tag: Oracle

How to install Vertica for test purposes

The column-oriented Vertica Analytics Database Platform was designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications. The following instructions show how to create a Vertica database…

Read More >

How to use createGoldImage For Cloning in 19c

The clone.pl script has been deprecated – Database Upgrade Guide: Deprecation of clone.pl Script To clone Oracle software, use createGoldImage and then install the software as usual. DEMO for DB: Source: /u01/app/oracle/product/19.0.0/dbhome_1 Target: /u01/app/oracle/product/19.0.0/dbhome_2 DEMO for GI: Source: /u01/app/19.0.0/grid Target:…

Read More >

Oracle E-Business Suite and 12cR1 database in Extended support – What to do?

If you are one of the folks who have already upgraded the production E-Business Suite database to 19c Certified, then you are a superhero and this post is not for you. The majority of us are still running the good…

Read More >

How to Find Clusterware Configuration Details Using srvctl

At times, you may be required to gather information about Oracle Clusterware configuration details. Instead of running multiple commands, information can be gathered using one simple command. This should work with srvctl version: 18.0.0.0.0 or higher. oracle@ol7-19-rac2 ~]$ echo $ORACLE_HOME…

Read More >

How To Fix ASM Disk Header Status from “FORMER” To “MEMBER”

I made an error when creating an Oracle ASM disk group which resulted in not being able to drop or mount the disk group because the ASM header_status was FORMER. The following steps were performed to modify the ASM header_status…

Read More >

Issues and workarounds for Exadata Patching (JAN-2019)

This post describes some of the most recent issues I have faced while patching an Oracle database machine (Exadata).   0 / Details Applying PSU 01/04/2019 (version 18.1.12.0.0.190111) Database Machine X5-2 / X6-2 stacks, which were running 12.1.2.3.5.170418 before the…

Read More >

Exadata Smart Scan: A Quick Overview

I decided to write about Exadata Smart Scan feature for this blog post. Why Smart Scan? Well, because it is awesome and I don’t know any other relational database system that has this feature. So what is Smart Scan and…

Read More >

Using MDBUtil To Create Grid Infrastructure Management Repository Database

Whether Grid Infrastructure Management Repository (GIMR) database MGMTDB is required or not depends on the version of Oracle you are using. For 19c, GIMR is not required –  About the Grid Infrastructure Management Repository However, GIMR is being created to…

Read More >

How to manage Oracle Flashback Log size

Here we will learn how to manage the size of flashback logs generated in our environment. This is useful especially when you are hitting the error “ORA-00242: maximum allowed filename records used up in control file” which can be related…

Read More >

How to work around OMS 12.1.0.3 error: Metric evaluation error start – Get dynamic property error

Have you received this error on OMS 12.1.0.3? “Metric evaluation error start – Get dynamic property error,” After performing some research on MOS and a confirmation SR, it seems related to Bug 17575631 CLUSTER DB HOME PAGE ERRORS- REGIONS FETCH…

Read More >
Page 5 of 163« First Page...34567...10...Last Page »