LATEST TOPICS

Monthly Archive:: March 2016

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
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed