Month: September 2022

Relocating enabl database for oracle 19c

by

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 below and copy the tns enties on db1 mkdir -p /u01/app/oracle/diag/rdbms/enabl/enabl1/trace 3:-Relocate the enabl database to db1 crsctl relocate resource ora.enabl.db -c server01 -f -unsupported … Read more

Oratop Utility

by

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 from http://support.oracle.com/ This tool is only available on Linux platforms for Oracle 11.2 and higher, but can connect to Oracle instances running on other platforms. … Read more

Standby : Unnamed file issue

by

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 data file 185 – see DBWR trace file ORA-01111: name for data file 185 is unknown – rename to correct file ORA-0111: data file 185: … Read more

Blocking sessions in Oracle

by

Blocking sessions are a problem for the DBA which occur when a session issues an insert, update or delete command that changes a row. When the change occurs, the row is locked until the session either commits the change, rolls the change back or the user logs off the system.  Show Active Session: We can … Read more