How to Replace OPatchby Ed ChenJanuary 12, 2022March 17, 2022In this post, I'm trying to design the best practice to replace the old OPatch utility with the new one, either in single-instance or RAC… Read More »How to Replace OPatch
How to Resolve ORA-32002: cannot create SPFILE already being used by the instanceby Ed ChenAugust 16, 2021October 23, 2021ORA-32002 Tried to restore the server parameter (SPFILE) to the default location from a parameter file (PFILE), but it failed with ORA-32002 like this. SQL>… Read More »How to Resolve ORA-32002: cannot create SPFILE already being used by the instance
How to Enable Oracle TDE 19c RAC DB - Step by Stepby Ed ChenAugust 9, 2021May 19, 2022Oracle TDE 19c I have talked about how to extract plain text from a normal, non-encrypted data file before. If you're considering a more secure… Read More »How to Enable Oracle TDE 19c RAC DB - Step by Step
How to Resolve ORA-29760: instance_number parameter not specifiedby Ed ChenDecember 4, 2020May 14, 20224 CommentsORA-29760 ORA-29760: instance_number parameter not specified means that Oracle cannot find any INSTANCE_NUMBER for given instance names in the parameter file to startup the instance.… Read More »How to Resolve ORA-29760: instance_number parameter not specified
How to Build Asymmetric Standby Database for Data Guardby Ed ChenJuly 14, 2019October 10, 2021Asymmetric Data Guard Usually we build data guard environments with the symmetric architecture design on primary and standby servers, that is, single-instance to single-instance or… Read More »How to Build Asymmetric Standby Database for Data Guard
How to Resolve ORA-00304: requested INSTANCE_NUMBER is busyby Ed ChenJuly 6, 2019September 27, 2021Srvctl Start Database ORA-00304 Saw some errors when I tried to startup a cluster database by srvctl. [oracle@primary01 ~]$ srvctl start database -d compdb PRCR-1079… Read More »How to Resolve ORA-00304: requested INSTANCE_NUMBER is busy