May 2022 - ASRblogger

What is SPLUNK?

Splunk is a software platform to search, analyse & visualize the machine generated data gathered from different websites, applications, sensors, devices etc. which make up your IT infrastructure and business.…

asrblogger May 25, 2022No Comments

SQL

Part 3: Constraints (Primary Key) in SQL

Primary Key Constraints A primary key constraint designates a column as the primary key of a table or view. A composite primary key designates a combination of columns as the…

asrblogger May 22, 2022No Comments

Oracle RAC

Connect String

This property specifies connection information used to connect to an Oracle database. The Oracle installer generally places a sample tnsnames.ora file in your $ORACLE_HOME/network/admin directory, but you can see many sample tnsnames.ora…

asrblogger May 18, 2022No Comments

Oracle

Grid Restart (HAS) & Clusterware (CRS)

Identify if Grid ASM is Cluster ware or High Availability Solution Check in OS Platform (Oracle /Redhat Linux) if [[ `grep ^HAS_USER /etc/init.d/init.ohasd` = "HAS_USER=oracle" ]];then echo "GRID Restart found..."…

asrblogger May 18, 2022No Comments

RAC

Optimizer in Oracle 19c

Optimizer-in-oracle19cDownload

asrblogger May 16, 2022No Comments

Oracle RAC

Change Archivelog Destination (FRA)

Scenario: If current Archivelog mountpoint is full then we want to change the Archivelog destination in the database. It can be done in up are running condition of DB .…

asrblogger May 4, 2022No Comments

DataGuard Oracle

ORA-01194: file 1 needs more recovery to be consistent

SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: ‘/u01/app/oracle/oradata/prod/system01.dbf' Suppose we are…