Home 2022 May

Monthly Archives: May 2022

two women looking at the code at laptop

Part 3: Constraints (Primary Key) in SQL

0
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

0
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)

0
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

0
Optimizer-in-oracle19cDownload
a text on a pink surface

Change Archivelog Destination (FRA)

0
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

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