Error: When starting up a standby database in open mode I noticed the following error in the alertlog: Unable to obtain current patch information as the database or pluggable database was opened for read-only access. =========================================================== Dumping current patch information =========================================================== Unable to obtain current patch information due to error: 16000 =========================================================== Analysis: SQL> select […]

Error: When Starting a RAC DB instance I noticed the following error in the alertlog which was hampering the display of installed patches list: QPI: opatch executable does not exist, opatch QPI: OPATCH_INST_DIR not present:/u01/oracle/12.2.0.3/db/OPatch Unable to obtain current patch information due to error: 20013, ORA-20013: DBMS_QOPATCH ran mostly in non install area ORA-06512: at […]

Scenario: Let’s suppose you want to investigate a recent case on a database whereas auditing is NOT enabled, or it’s enabled but it didn’t cover the activities you are looking for, in this case, you still have the ability to dig and find those activities using LogMiner feature. LogMiner is a free feature (No license required) available […]

>When granting a role to a user the user have to re-login to get use of that role.>When granting a privilege to a user the user can use it immediately. NO need to re-login.>Roles doesn’t give the granted user the right to create objects based on the role given to him.  Come again.. What does the last […]

In this scenario I’ll explain how to hide data on a table from unauthorized users even if these unauthorizes users have DBA privilege.After hiding the data from unauthorized users whenever they try to select from the secured table they will receive “no rows selected” message. The advantage of this way that the secured table will look like having no […]

There was a conversation between me and an auditor: Auditor: What is the default role for the database?Me:        What do you mean by default role for the database? !!!!!!!!!!!Auditor: We found this output in the script log we asked you to run for us:GRANTEE       GRANTED_ROLE         […]