asrblogger, Author at ASRblogger

Manual Database Creation

The specific methods for creating a database are: With Database Configuration Assistant (DBCA), a graphical tool.With the CREATE DATABASE SQL statement. 1. Specify an Instance Identifier (SID) The ORACLE_SID environment variable is used to distinguish this…

asrblogger March 20, 2022No Comments

Oracle

ORA-10635: Invalid segment or tablespace type problem resolution !!

Normally if you are trying to shrink a compressed table lets say you get below error, and the trick to solve it is below :- For partition tables and for…

asrblogger March 20, 2022No Comments

Oracle

UNDO BLOCK

Space allocation in the UNDO tablespace is unique and does not follow the same rules as normal tablespaces. Data within the tablespace frequently grows and shrinks throughout the life of…

asrblogger March 20, 2022No Comments

Oracle

SYSTEM Tablespace is Growing Abnormally in 12c

SYSTEM Tablespace is Growing Abnormally in 12c My SYSTEM tablespace was growing rapidly. This was happening in my test environment. We observe that we were not doing much on this…

asrblogger March 18, 2022No Comments

SQL

ACID PROPERTY : Transactions

A transaction is a logical, atomic unit of work that contains one or more SQL statements. A transaction groups SQL statements so that they are either all committed, which means…

asrblogger March 18, 2022No Comments

RAC

RAC Tools

Cluster Verification Utility (CVU) ... Oracle Enterprise Manager ... SQL*Plus ... Server Control (SRVCTL) ... Database Configuration Assistant ... Fleet Patching and Provisioning ... Cluster Verification Utility (CVU): CVU is…

asrblogger March 17, 2022No Comments

ASM Oracle

ASM Disk Addition & Deletion

Adding Disks to a Disk Group is done with the "alter diskgroup" command.Oracle provides the alter diskgroup command to adding or removing physical disks within SQL*Plus: First we identify the…

asrblogger March 16, 2022No Comments

Oracle

Database Link

A database link (DBlink) is a definition of how to establish a connection from one Oracle database to another. Type of Database Links: Private database link - belongs to a…

asrblogger March 11, 2022No Comments

Oracle

Parameters which require DB bounce.

In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column contains three phases: 1) Immediate 2) Deferred 3) False 1. Immediate : We can change the parameter in fly…

asrblogger March 7, 2022No Comments

Oracle

Creating pluggable database from another pdb, when pdb$seed in in mount state

SQL> create pluggable database PDB1 from DEV1 create_file_dest='+DEV_DG_FLASH'; Pluggable database created. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED MOUNTED 3 PDB1 MOUNTED 4…