Startup and Shutdown

How to Resolve "Connected to an idle instance"

by Ed Chen
November 9, 2019May 30, 2020

Connected to an idle instance Actually, Connected to an idle instance is a message rather than an error, it indicates that the database you entered… Read More »

How to Stop Oracle Database

by Ed Chen
September 29, 2019November 6, 2019

Stop Oracle Database After knowing how to start an Oracle database, we may begin to learn something about stopping an Oracle database. Stopping a database… Read More »

How to Start Oracle Database

by Ed Chen
September 28, 2019January 9, 2020

Start Oracle Database To start an Oracle database, you have to know which database you want to start. This includes at least two things, Oracle… Read More »

How to Resolve Oracle SHUTDOWN IMMEDIATE Hangs

by Ed Chen
September 4, 2019November 6, 2019

SHUTDOWN IMMEDIATE Hangs Database shutdowns may not go smoothly as you thought, they could seem to be stuck in an infinite waiting. If you wait… Read More »

How to Auto Start Oracle Database on Solaris

by Ed Chen
March 31, 2018October 17, 2019

For Linux Os, you should check this post: How to Auto Start Oracle Database on Linux. Assuming that you already have some knowledge about how… Read More »

How to Auto Start Oracle Database on Linux

by Ed Chen
March 24, 2018October 17, 2019

For Solaris OS, you should check this post: How to Auto Start Oracle Database on Solaris. Assuming that you already have some knowledge about how… Read More »

How to Resolve ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener

by Ed Chen
February 4, 2018April 24, 2019

ORACLE_HOME_LISTNER is not SET Got this error when I used dbstart to startup all required instances: ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net… Read More »

Where is the Location of PFILE?

by Ed Chen
September 9, 2017May 27, 2019

If we were trying to change parameters in an unfamiliar database that was handed over from other DBA, we have to figure it out whether… Read More »

Can I Open Database to READ ONLY with RESETLOGS?

by Ed Chen
April 14, 2016October 2, 2019

You can have this one: SQL> ALTER DATABASE OPEN READ ONLY; And also this one: SQL> ALTER DATABASE OPEN RESETLOGS; But there's NO combined statement like… Read More »

Possible Reasons Why Shutdown Stuck

by Ed Chen
September 12, 2014October 18, 2019

The fastest way to solve the hanging is to do a SHUTDOWN ABORT or even kill SMON process, but they do not remove the root… Read More »