Monday, March 5, 2018

Patch Inventory is missing in Alert log while DB is bounced.


In some cases, when a particular database is started the patch inventory is not loaded in the alert log and  says  “No patches have been applied” in the alert log.
To make the inventory to be loaded in alert log. Run the below statement in the database (and expect output as “OK”  and re-start the database again).
Note:- Don’t run ./datapatch from now

select dbms_sqlpatch.verify_queryable_inventory from dual;







Hope this Helps...

1 comment:

PostgreSql: Useful Commands-

 1)   ************************* Users ***************************  -- List of users with roles assigned: SELECT usename AS role_name,   CASE...