1 min read
PROBLEM : The attempt to create a password file for a 12.2 database failed : $ orapwd file=$ORACLE_HOME/dbs/orapwprod101 password=oracle OPW-00029:...
1 min read
1 min read
Splunk is a software platform to search, analyse & visualize the machine generated data gathered from different websites, applications, sensors,...
3 min read
Primary Key Constraints A primary key constraint designates a column as the primary key of a table or view. A...
1 min read
This property specifies connection information used to connect to an Oracle database. The Oracle installer generally places a sample tnsnames.ora...
Identify if Grid ASM is Cluster ware or High Availability Solution Check in OS Platform (Oracle /Redhat Linux) if ];then...
1 min read
2 min read
Scenario: If current Archivelog mountpoint is full then we want to change the Archivelog destination in the database. It can...
1 min read
SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to...
1 min read
cassandra -f ./nodetool status ./nodetool ring ./nodetool -h 192.168.0.101 clean ./nodetool -h 192.168.0.101 info ./nodetool -h 192.168.0.101 compact ./nodetool flush...
3 min read
PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for...
5 min read
To identify the number of diskgroup ,status from below query. select group_number,name from v$asm_diskgroup; select group_number, name, state, type from...
2 min read
DB_NAME On a primary database, specify the name used when the database was created. On a physical standby database, use...
1 min read
Oracle hangs only when he is waiting for a resource. It might be a software resource (a latch or lock),...
2 min read
Data Concurrency A requirement of a multiuser RDBMS is the control of data concurrency, which is the simultaneous access of...
2 min read
12.2 Index Advanced Compression “High” Let’s begin by creating a table and explicitly creating a NOCOMPRESS index in the WHALE...
4 min read
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...
2 min read
Normally if you are trying to shrink a compressed table lets say you get below error, and the trick to...
2 min read
Space allocation in the UNDO tablespace is unique and does not follow the same rules as normal tablespaces. Data within...
3 min read
SYSTEM Tablespace is Growing Abnormally in 12c My SYSTEM tablespace was growing rapidly. This was happening in my test environment....
3 min read
A transaction is a logical, atomic unit of work that contains one or more SQL statements. A transaction groups SQL...
2 min read
Cluster Verification Utility (CVU) ... Oracle Enterprise Manager ... SQL*Plus ... Server Control (SRVCTL) ... Database Configuration Assistant ... Fleet...
2 min read
Adding Disks to a Disk Group is done with the "alter diskgroup" command.Oracle provides the alter diskgroup command to adding...
2 min read
A database link (DBlink) is a definition of how to establish a connection from one Oracle database to another. Type...
2 min read
In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column contains three phases: 1) Immediate 2) Deferred 3) False...
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 ----------...
