Oracle Archives - Page 19 of 30

How to determine what is keeping Catalog and Catproc invalid in the Registry

SQL> select comp_id, status, version from dba_registry; COMP_ID STATUS VERSION ------------ ----------- -------------- CATALOG INVALID 11.2.0.3.0 CATPROC INVALID 11.2.0.3.0 SQL> select object_name, object_type from dba_objects where owner = 'SYS' and…

asrblogger December 3, 2022No Comments

Oracle

Creating pluggable database from seed, when pdb$seed in in mount state and open state.

SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED MOUNTED 3 PDB1 READ WRITE NO 4 DEV READ WRITE NO SQL> create pluggable database PDB2…

asrblogger November 30, 2022No Comments

Oracle

12cR1 to 19C upgradation with auto upgrade feature

Advantages of AutoUpgrade Utility: ========================== 1. Time saving method (completes the upgrade in a short time) 2. can upgrade multiple Oracle Database deployments at the same time, using a single…

asrblogger November 20, 2022No Comments

Oracle

Upgrade Oracle Database from 12.1.0.2 to 12.2.0.1 using DBUA

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 2 (12.2.0.1) 11.2.0.3+ or 12.1.0.1 or…

asrblogger November 19, 2022No Comments

ASM Oracle RAC

Step by Step ASM/ Grid Installation in Oracle Standalone

Prerequisite. Add below OS groups Add asmdba as secondary group to Oracle user Create Grid User [root@dg11 /]# useradd -u 54331 -g oinstall -G dba,asmdba,asmoper,asmadmin,racdba grid Change the password for…

asrblogger November 19, 2022No Comments

Oracle

Common User Vs Local User In 12c

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 can only be created…

asrblogger November 12, 2022No Comments

Oracle

How To Rename A Pluggable Database ( PDB)

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 MODE RESTRICTED ---------- ------------------ ---------- ---------- 3…

asrblogger November 12, 2022No Comments

Oracle

Multi-tenant Architecture

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

asrblogger November 11, 2022No Comments

Oracle

Azure : Create Gateway Subnet

STEP-1- Create Gateway Subnet Resource Group > VNET>SUBNETS> GATEWAY SUBNETS>ADD – 10.0.1.0/24 (Available Free Subnet). STEP-2 Create Gateway Create. SEARCH > VIRTUAL NETWORK GATEWAY> SELECT VIRTUAL NETWORK GATEWAY >VPN> >ROUTE…