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. By default, Oracle software installation does not deploy automatic startup and shutdown init scripts on the platform, you have to create them by yourself. Here I introduce my scripts for you to use or modify with. oratab in Linux […]
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 […]