OPW-00029: Password complexity failed for SYS !!
PROBLEM : The attempt to create a password file for a 12.2 database failed :…
Read more2022
What is SPLUNK?
Splunk is a software platform to search, analyse & visualize the machine generated data gathered…
Read morePart 3: Constraints (Primary Key) in SQL
Primary Key Constraints A primary key constraint designates a column as the primary key of…
Read moreConnect String
This property specifies connection information used to connect to an Oracle database. The Oracle installer…
Read moreGrid Restart (HAS) & Clusterware (CRS)
Identify if Grid ASM is Cluster ware or High Availability Solution Check in OS Platform…
Read moreOptimizer in Oracle 19c
Optimizer-in-oracle19cDownload
Read moreChange Archivelog Destination (FRA)
Scenario: If current Archivelog mountpoint is full then we want to change the Archivelog destination…
Read moreORA-01194: file 1 needs more recovery to be consistent
SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194:…
Read moreCassandra Commands
cassandra -f ./nodetool status ./nodetool ring ./nodetool -h 192.168.0.101 clean ./nodetool -h 192.168.0.101 info ./nodetool…
Read moreORA-00020: maximum number of processes (3000) exceeded
PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to…
Read moreASM Day to Day Life Scripts
To identify the number of diskgroup ,status from below query. Size of ASM Diskgroup Check…
Read moreImportant Parameters in Data Guard
DB_NAME On a primary database, specify the name used when the database was created. On…
Read moreConnect To Hung Database In Oracle
Oracle hangs only when he is waiting for a resource. It might be a software…
Read moreData Concurrency & Data Consistency.
Data Concurrency A requirement of a multiuser RDBMS is the control of data concurrency, which…
Read more12.2 Index Advanced Compression “High”.
12.2 Index Advanced Compression “High” Let’s begin by creating a table and explicitly creating a…
Read moreManual Database Creation
The specific methods for creating a database are: With Database Configuration Assistant (DBCA), a graphical…
Read moreORA-10635: Invalid segment or tablespace type problem resolution !!
Normally if you are trying to shrink a compressed table lets say you get below…
Read moreUNDO BLOCK
Space allocation in the UNDO tablespace is unique and does not follow the same rules…
Read moreSYSTEM Tablespace is Growing Abnormally in 12c
SYSTEM Tablespace is Growing Abnormally in 12c My SYSTEM tablespace was growing rapidly. This was…
Read moreACID PROPERTY : Transactions
A transaction is a logical, atomic unit of work that contains one or more SQL…
Read moreRAC Tools
Cluster Verification Utility (CVU) ... Oracle Enterprise Manager ... SQL*Plus ... Server Control (SRVCTL) ...…
Read moreASM Disk Addition & Deletion
Adding Disks to a Disk Group is done with the “alter diskgroup” command.Oracle provides the…
Read moreDatabase Link
A database link (DBlink) is a definition of how to establish a connection from one…
Read moreParameters which require DB bounce.
In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column contains three phases: 1)…
Read moreCreating pluggable database from another pdb, when pdb$seed in in mount state
→ Here we can see that new pluggable database PDB1 created from another pluggable database…
Read more