Category: Data Guard

Those days, my production dataguard system suddenly started to receive a weird ORA-01031: insufficient privileges on DGMGRL for any task like "show configuration" or "edit database set state". More weird is that nothing (apparently) was changed on the system. Another troubleshooting saga in my DBA life was about to start.. My broker was configured with …

Continue reading

Those days, I was updating some of my lab environments running Oracle Database 12.1.0.2 to the 190716 quarterly update Bundle Patch. However, during the Datapatch execution phase, I was getting some ORA errors. Patch 29496791 apply (pdb CDB$ROOT): SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29496791/22993732/29496791_apply_ORCL_CDBROOT_2019Jul31_11_55_12.log (no errors) Patch 29496791 apply (pdb PDB$SEED): WITH ERRORS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29496791/22993732/29496791_apply_ORCL_PDBSEED_2019Jul31_11_58_00.log (errors) Error at …

Continue reading

Those days, while testing Oracle Management Cloud Service (OMC), I was trying to deploy the agent to monitor my Oracle Database, but it was failing with "Value for property: DBUserName for credential ID=SQLCreds has an invalid format". [oracle@test bin]$ ./omcli add_entity agent /home/oracle/agent_json/entity.json -credential_file /home/oracle/agent_json/credential.json Oracle Management Cloud Agent Copyright (c) 1996, 2019 Oracle Corporation. …

Continue reading

I have a Primary 11g Oracle Database with a single Physical Standby. Those days I tried to create an encrypted column inside one table for testing purposes. I end up accidentally messing the things: Force closing the keystore for standby rekey. Please re-copy the keystore from primary before re-open as needed. Apply redo for database master …

Continue reading