Non-Container Database (Non-CDB)

How to Resolve ORA-32001: write to SPFILE requested but no SPFILE is in use

by Ed Chen
December 23, 2022May 12, 2023

ORA-32001 ORA-32001 means that the database cannot write SPFILE at this moment, you should make sure that it has been using by the instance. Let's… Read More »

How to Resolve ORA-30012: undo tablespace does not exist or of wrong type

by Ed Chen
November 11, 2022March 20, 2023

ORA-30012 Tried to restart a normal, typical database after changing the default undo tablespace, but it failed with ORA-30012. SQL> startup ORACLE instance started. ...… Read More »

ORA-01187: cannot read from file because it failed verification tests

How to Resolve ORA-01187: cannot read from file

by Ed Chen
September 12, 2022April 27, 2023

ORA-01187 Found ORA-01187 and ORA-01110 after activating a standby database. ORA-01187: cannot read from file because it failed verification tests ORA-01110: data file 2003: '+DATA/ORCLCDB/ORCLPDB/temp01.dbf'… Read More »

How DBMS_SERVICE.CREATE_SERVICE

by Ed Chen
March 8, 2021November 3, 2022

How to Use DBMS_SERVICE to Create a New Service? The default service name of a database is the DB_UNIQUE_NAME, if we'd like to add some… Read More »

Alter System set Service_Names

by Ed Chen
March 7, 2021December 24, 2022

Add a Service to SERVICE_NAMES Adding a service to the server parameter SERVICE_NAMES is only working for normal, typical databases (non-CDB) or in root containers.… Read More »

DBCA Silent Database Creation 19c

by Ed Chen
August 3, 2019March 4, 2023
4 Comments

By design, we split the entire installation into several clear sections and make the job easy to troubleshoot. Install Oracle Software Only in Silent Mode… Read More »

JavaScript is not enabled. Please enable it and reload the page.