How Oracle Restore SPFILE
Timings to Restore SPFILE At several occasions listed below, you may need to restore it from a previously backed up SPFILE. SPFILE was accidentally deleted.… Read More »How Oracle Restore SPFILE
Single-Instance Database
How Oracle Backup SPFILE
Timings to Backup SPFILE In case that we need to restore SPFILE to the original state at a later time, we should backup SPFILE in… Read More »How Oracle Backup SPFILE
How to Install OPatch
In this post, I'm trying to design the best practice to install OPatch. In fact, the procedure means to replace the old OPatch utility with… Read More »How to Install OPatch
How to Resolve ORA-32002: cannot create SPFILE already being used by the instance
ORA-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 Step by Step
Oracle 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 Step by Step
How to Resolve ORA-29760: instance_number parameter not specified
ORA-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 Guard
Asymmetric 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 busy
Srvctl 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
Alter Database Move Datafile
Move Data File Online Since 12c, we can move data files online simply by one SQL statement. In other words, we move it by ALTER… Read More »Alter Database Move Datafile