OraCrafts

How to Change Apply Instance in Oracle Data Guard RAC Standby Using DGMGRL

Change Database Name Using NID Utility

Make changes in PDB$SEED when it's in Read only.

Find top CPU Consuming Session or SQLs query in Oracle

Relocate a service with SRVCTL in RAC Environment

ORA-30013: Undo Tablespace ‘UNDOTBS1’ Is Currently In Use

Change the ASM rebalance power in Oracle

Database links

Stop the EXPDP/IMPDP datapump Job in Oracle

ORA-48913: Writing into trace file failed, file size limit

Understanding and Resolving ORA-00942: Table or View Does Not Exist

Troubleshooting ORA-28000: Account Locked in Active Data Guard

srvctl start database fails with CRS-2800: Cannot start resource 'ora.orcl.db' as it is already in the INTERMEDIATE state on server 'hostname02'