Home 2022 November

Monthly Archives: November 2022

close up shot of keyboard buttons

Protected: Oracle Data Pump – Expdp, Impdp

0
Oracle Data Pump Export is a built-in utility program for unloading data and metadata into a set of dump files. The dump file set...

12cR1 to 19C upgradation with auto upgrade feature

0
We have a 12cR1 database. Database name is ‘sha’ and version is 12.1.0.2.0 as can beseen from below image. Lets make a table in scott...

Upgrade Oracle Database from 12.1.0.2 to 12.2.0.1 using DBUA

0
Supported Upgrade PathsDirect upgrades are possible from existing databases with the following versions.Destination Source=========== ======12c Release 1 (12.1.0.2) 10.2.0.5+, 11.1.0.7+, 11.2.0.2+ or 12.1.0.112c Release...

ASM / GRID Installation

0
Prerequisite. Add below OS groups Add  asmdba as secondary group to Oracle user Create Grid User # useradd -u 54331 -g oinstall -G dba,asmdba,asmoper,asmadmin,racdba grid Change the password for...
Connector for radio equipment, 1942-1946 (electric cable)

Common User Vs Local User In 12c

0
COMMON USER: 1.A common user is a Database user, which perform an activity in all the containers including root container of the CDB. 2.A common user...

How To Rename A Pluggable Database ( PDB)

0
The following explains how to rename a container (pluggable databases). Step-By-Step 1. Shutdown the pluggable database (PDB). SQL> show pdbs; CON_ID CON_NAME OPEN...

Multi-tenant Architecture

0
Oracle Database 12c introduced a new feature called “Multitenant.” The multitenant feature provides the ability for a single instance to manage multiple databases. The...