Make DBA Life Easy

We bring you the latest updates from Make DBA Life Easy through a simple and fast subscription.

We can deliver your news in your inbox, on your phone or you can read them here on this website on your personal news page.

Unsubscribe at any time without hassle.

Make DBA Life Easy's title: Make DBA Life Easy

Is this your feed? Claim it!

Publisher: Unclaimed!

Message frequency: 1.71 / week

Message History

DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(audit_trail_type=>DBMS_AUDIT_MGMT.AUDIT_TRAIL_OS): ORA-46264 ORA-0651214 days ago

Subscribe to keep reading

class="has-text-align-center" style="text-align: center; color: #50575E; font-weight: 400; font-size: 16p...

Read full story

ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container20 days ago

Subscribe to keep reading

class="has-text-align-center" style="text-align: center; color: #50575E; font-weight: 400; font-size: 16p...

Read full story

How to Reset User Expired Password to the Original Password28 days ago

We want to keep using the old password due to application restraints.

SQL> alter user TESTUSER identified by "Testuser#Password123";
alter user TESTUSER identified by "Testuser#Password123"
*
ERROR at line 1:
ORA-28007: the password cannot be reused

Check profile DEFAULT resource limits:

DEFAULT PASSWORD_R...

Read full story

Oracle RMAN to Restore and Recover Database to a Previous Incarnation28 days ago

Subscribe to keep reading

class="has-text-align-center" style="text-align: center; color: #50575E; font-weight: 400; font-size: 16p...

Read full story

How to Check PDB is compatible with a new CDBlast month

To test if a PDB is compatible with a new CDB before plugging it in, use the DBMS_PDB.CHECK_PLUG_COMPATIBILITY function in the target CDB. This function checks for incompatibilities like patch levels, character sets, database options, and the COMPATIBLE parameter setting.

Generate a PDB Description File (XML): Before you can run the check, you must ...

Read full story