Home 2022 May

Monthly Archives: May 2022

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


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