Oracle Archives - Page 19 of 30

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…

asrblogger October 24, 2022No Comments

Oracle

Protected: AZURE MONITORING – VIA LOG ANALYTICS

This content is password protected. To view it please go to the post page and enter the password.

asrblogger October 24, 2022

Oracle

Undo Tablespace & ORA-01555 snapshot too old error..!!

As an “Oracle DBA ” normally interviewer ask about ORA-01555 snapshot too old error. What is Undo? Oracle Database maintain information that is used to roll back, or undo. Such information consists of records…

asrblogger October 19, 2022No Comments

Oracle

Create Duplicate Database Using RMAN

Source Database Name is PRODDB Target (duplicate) Database name is MYDB Source Host Name : server1.localdomain Target Host Name : server2.localdomain Put Database in archivelog mode. SQL> archive log list; Database…