How to Tell What State of Database
We have already known that there're 4 states in life cycle of an instance. They are idle, nomount, mount and open. In this post, we… Read More »How to Tell What State of Database
Startup and Shutdown
How to Resolve "Connected to an idle instance"
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 Resolve "Connected to an idle instance"
How to Restart Oracle Database
In this post, we'll talked about how to restart a database in a efficient way, which includes: Restart a Single-Instance DB Restart a RAC DB… Read More »How to Restart Oracle Database
How to Stop Oracle Database
A. Stop Oracle Database After knowing how to start an Oracle database, we may begin to learn something about stopping an Oracle database. Stopping a… Read More »How to Stop Oracle Database
How to Start Oracle Database
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 Start Oracle Database
How to Resolve Oracle SHUTDOWN IMMEDIATE Hangs
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 Resolve Oracle SHUTDOWN IMMEDIATE Hangs
How to Auto Start Oracle Database on Solaris
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 Solaris
How to Auto Start Oracle Database on Linux
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 Auto Start Oracle Database on Linux
How to Resolve ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
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 »How to Resolve ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Where is PFILE Location in Oracle
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 »Where is PFILE Location in Oracle