Startup and Shutdown

How to Stop Oracle Database

Posted on
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 is a less complex job than starting a database. This is because all kinds of shutdown shall go to the idle state eventually, no matter what state currently is. That […]
Startup and Shutdown

How to Start Oracle Database

Posted on
Start Oracle Database To start Oracle database, you have to know what database you want to start. This includes at least two things, where Oracle home is and what Oracle SID is. For remote database startup, you additionally need to know where the server is. The startup can be manual or automatic, it depends on […]
Shell Script

How to Auto Start Oracle Database on Solaris

Posted on
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 to start Oracle database manually and Oracle provided shell script dbstart, then we can keep going to design and deploy our automatic startup scripts. By default, Oracle software installation does […]
Shell Script

How to Auto Start Oracle Database on Linux

Posted on
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 to start Oracle database manually and Oracle provided shell script dbstart, then we can keep going to design and deploy our automatic startup scripts. By default, Oracle software installation does […]
Startup and Shutdown

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

Posted on
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 Listener. This is because dbstart takes the first argument of this command as the database home path for listener to startup. Which means, this command will start both database and […]
PFILE and SPFILE

Where is the Location of PFILE?

Posted on
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 the database started with SPFILE or PFILE. Moreover, if PFILE is used, you have to know the location of PFILE. Of course, we can ask the former DBA for the […]