Home 2022 May

Monthly Archives: May 2022

two women looking at the code at laptop

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...
close up photo of programming of codes

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...

Grid Restart (HAS) & Clusterware (CRS)

Identify if Grid ASM is Cluster ware or High Availability Solution Check in OS Platform (Oracle /Redhat Linux) if ];then echo "GRID Restart found..." elif...
orange usb charger cable on black surface

Optimizer in Oracle 19c

a text on a pink surface

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...

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...