Monthly Archives: May 2022
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...
Optimizer in Oracle 19c
Optimizer-in-oracle19cDownload
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...