LATEST TOPICS

ORA-22992, ORA-64202: When you treat CLOB as string

One of my client contacted me to solve a database problem. The problem they were facing was that they were trying to insert a record in the source database (CDB1_PDB_1) by fetching (SELECT) records from a remote

catupgrd.sql and ORA-01722: invalid number

Recently while upgrading one of the database from Oracle version 11.2.0.3 to 11.2.0.4, the catupgrd.sql script failed with following errors DOC>####################################################################### DOC>####################################################################### DOC> The following error is generated if (1) the old release uses a time DOC>

Oracle 12c: Restrict OS authentication to a single pluggable database

In my last article, I have discussed about the process of implementing OS authentication in a multitenant Oracle 12c database without setting the deprecated parameter REMOTE_OS_AUTHENT. We have seen that we can create a common user for

Oracle 12c RAC: Move management repository database (MGMTDB) to different location

Introduction This article outlines the steps required to relocate the Grid Infrastructure Management Repository (GIMR) database MGMTDB to a different file system storage. By default OUI (Oracle Universal Installer) creates the MGMTDB on the same file system

Oracle 12c RAC: Solving ‘Grid Infrastructure Management Repository connection error’

While trying to query the management repository path using OCLUMON utility, I was receiving the following error. ---// ---// error while accessing management repository //--- ---// myracserver1 {/home/oracle}: $GRID_HOME/bin/oclumon manage -get reppath Connection Error. Could not get

Oracle 12c: OS authentication and the multitenant architecture

Are you upgrading/migrating your databases to Oracle 12c? Are you using OS (external) authentication for schemas running batch jobs? If yes, then this post covers the areas that you need to look into, to be able to

Oracle 12c (12.1.0.2): Now we can preserve the PDB state between instance startup

As we know, Oracle has introduced the multitanent architecture with Oracle version 12c, where we can have multiple pluggable databases (PDB) within a single container database (CDB). However, when we start up a container database (CDB), all

Oracle 12c RAC: Clusterware logs are now centralized

When dealing with a Oracle Real Application Cluster (RAC) issue, a DBA generally needs to jump around multiple directories to find the relevant logs. Those days are now history as Oracle has centralized all the Clusterware (RAC)

Oracle 12c: Track and analyze privilege utilization with DBMS_PRIVILEGE_CAPTURE

Introduction It is always desired to grant least possible privileges to database users to prevent any potential security threat. Granting additional/excessive privilege to a user is always associated with a potential database security threat. If we are

Oracle: All about recovering UNDO with no backup

Today’s post is all about recovering a database from a UNDO datafile loss (when there is no backup available). Ideally, we keep backup of our databases for PROD and PRE-PROD environments. However, most of the organizations do

Shareplex: Script to fix startup issue caused by shared memory segments

In my previous post, I had discussed about the workaround to fix Shareplex startup issue related to the shared memory segment or stale process. In today’s post, I would be presenting a shell script that can be

Shareplex: Fixing startup issue caused by shared memory segments

While trying to start Shareplex instance, it is failing with following errors. ##--- ##--- starting Shareplex instance ---## ##--- [oracle@mylab-01 log]$ $SP_BIN/sp_cop -u$SP_COP_TPORT & [1] 406 [oracle@mylab-01 log]$ ******************************************************* * SharePlex for Oracle Startup * Copyright 2014

Sometimes things don’t work as expected in Oracle

In today’s post, I am going to discuss an issue that I had faced recently. One of my application team sent me an e-mail stating that they are not able to connect to the database and are

Shareplex: Restore or Recreate missing/corrupted object cache on Target system

Introduction This post explains and demonstrates the process involved in restoring or recreation of an object cache when it is found to be missing or corrupted. An object cache is a file that is created on source

GoldenGate: Setting trail files auto purge and purging trails on demand

Introduction In today’s post, I will discuss about purging old trail files for a GoldenGate replication setup. GoldenGate generates two set of trail files. The first set is generated by the EXTRACT process after processing the transactions
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed