In the beginning of data migration, we usually recreate some tablespaces to accommodate data from the source. The best way to do this is to… Read More »How to Generate Tablespace DDL with Uniform Rules
Let me ask you a question, why would you like to create an empty RAC database? In my experience, there're two use cases that will… Read More »How to Create an Empty RAC Database without Using DBCA
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
OPW-00010 Tried to create a password file by orapwd, an Oracle utility for a RAC database and got OPW-00010: Could not create the password file.… Read More »How to Resolve OPW-00010: Could not create the password file. This resource has a Password File.
Even though I chose NOT to use Oracle Managed Files (OMF) during Oracle 19c RAC database creation, I still got OMF spfile and password file… Read More »How to Revert OMF Spfile and Password File in RAC
How to Resolve ORA-03206: maximum file size of (4194304) blocks in AUTOEXTEND clause is out of range
ORA-03206 Theoretically, we can add a data file with maximum size of 32 GB to a tablespace with 8 KB block size. Actually, we can't.… Read More »How to Resolve ORA-03206: maximum file size of (4194304) blocks in AUTOEXTEND clause is out of range