Posted inOracle RAC

Relocating enabl database for oracle 19c

Relocating enabl database for oracle 19c 1:- After the upgrade add this hosting members as below $GRID_HOME/bin/crsctl modify resource ora.enabl.db -attr "HOSTING_MEMBERS='server01 server02' PLACEMENT='favored'" -unsupported 2:- Create directories as show…
No Comments
Posted inOracle Scripts SQL

Oratop Utility

Oratop is a text based user interface tool similar to top command for monitoring basic database operations in real time for RAC and Standalone DB. oratop utility can be downloaded…
No Comments
Posted inDataGuard Oracle

Standby : Unnamed file issue

Sun Jan 1 22:02:11 2022 Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_pr00_117080.trc: ORA-01111: name for data file 185 is unknown - rename to correct file ORA-0111: data file 185: '/u01/oracle/product/19/db/dbs/UNNAMED00185' ORA-01157: cannot identify/lock…
No Comments