Groovy DBA

  Hello How to check the patching backup files Check what patches OPatch thinks are installed:   $ORACLE_HOME /OPatch/opatch lsinventory $ORACLE_HOME /OPatch/opatch lsinventory  -detail   Oracle documents  lsinventory  as the standard way to verify applied patches and Oracle home inventory state. Check whether rollback files exist under  .patch_storage :   cd   $ORACLE_HOME ls   -ld  .patch_storage find  .patch_storage  -maxdepth   2   -type  d |  sort du  -sh  .patch_storage   If the patch was applied normally, you should see patch-related content there, because OPatch saves the replaced files in  $ORACLE_HOME/.patch_storage  during installation. Check OPatch logs and history:   ls   -ltr   $ORACLE_HOME /cfgtoollogs/opatch tail  -100   $ORACLE_HOME /cfgtoollogs/opatch/history.txt   Regards Martin Gomez 

  select ACTION,ACTION_TIME,PATCH_ID,PATCH_UID,STATUS,DESCRIPTION from dba_registry_sqlpatch order by 2;   I also check for INVALIDs:-   select COMP_ID, COMP_NAME, VERSION, STATUS from dba_registry; select OWNER, OBJECT_NAME, OBJECT_TYPE, STATUS from dba_objects where STATUS = 'INVALID';  

 Legacy comunication mode - crpto - PGP rhel 5 ,  backward compatibility

 revoke create on schema cpnadmin from cpnadmin; In  PostgreSQL , there is  no specific privilege called  CREATE PARTITION  that you can directly  GRANT  or  REVOKE  on a table. Partition creation is  not a standalone privilege  — it is tied to  table ownership . Only: The  table owner  (or a role that is a member of the owning role) A  superuser can create partitions for a partitioned table. This means: If a role can create partitions, it’s because it  owns the table  (or is a member of the owner role). To  remove  that ability, you must  change the table’s ownership  or remove the role from the owner group — not by  REVOKE .

 [prd1ins1@db2prd601  ~] $ db2 " grant connect on database to user ccpa_db2_prd_user" DB20000I  The SQL command completed successfully. [prd1ins1@db2prd601  ~] $ db2 "grant role db2read to user ccpa_db2_prd_user" DB20000I  The SQL command completed successfully. [prd1ins1@db2prd601  ~] [tst2ins2@db2tst601  ~] $ db2 "grant connect on database to user ccpa_db2_tst_user" DB20000I  The SQL command completed successfully. [tst2ins2@db2tst601  ~] $ db2 " grant role db2read to user ccpa_db2_tst_user" DB20000I  The SQL command completed successfully. [tst2ins2@db2tst601  ~] $ Welcome@12345  ccpa_db2_tst_user /   SfYn##+[+m1  ccpa_db2_prd_user /  aIuyM~?ozp1

  reindex index CONCURRENTLY <indexname> ;