NOMOUNT State

How to Resolve ORA-01507: database not mounted

by Ed Chen
May 16, 2022September 25, 2022

ORA-01507 ORA-01507 means that the command you want to execute cannot be done at NOMOUNT state, you should mount the database from NOMOUNT for further… Read More »

How to Check Oracle Database Startup Time

by Ed Chen
September 17, 2021January 24, 2023

Startup Time Varies To check Oracle database startup or restart time, we have to know the difference between instance startup time and database open time.… Read More »

How to Resolve ORA-65011: Pluggable database does not exist

by Ed Chen
August 23, 2021February 20, 2023
2 Comments

ORA-65011 There're several use cases that may throw ORA-65011. Switch Session Container Tried to set a PDB as the current session container, but it failed… Read More »

How to Resolve ORA-12528: TNS:listener: all appropriate instances are blocking new connections

by Ed Chen
June 14, 2021February 8, 2023
6 Comments

ORA-12528 Tried to connect a NOMOUNT database, but it failed with ORA-12528. C:\Users\ed>sqlplus sys/password@orcl as sysdba ... ERROR: ORA-12528: TNS:listener: all appropriate instances are blocking… Read More »

How to Resolve ORA-01109: database not open

by Ed Chen
June 5, 2021December 24, 2022
2 Comments

ORA-01109 ORA-01109 is pretty normal when the database you want to connect or operate with is at MOUNT or NOMOUNT state. In this post, we… Read More »

How to Resolve ASMCMD-9453: failed to register password file as a CRS resource

by Ed Chen
December 6, 2020October 24, 2021

ASMCMD-9453 In the process of creating an empty RAC database, I tried to copy a password file into ASM by pwcopy command in ASMCMD, then… Read More »

How Srvctl Start Database

by Ed Chen
September 28, 2019October 22, 2022

To startup a RAC database, we'd better NOT use commands that we used to startup a normal single-instance database, we should use Server Control Utility… Read More »