Shell Script

How to Auto Start Oracle Database on Solaris

Posted on
By default, Oracle software installation does not deploy 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. Turn on startup option in oratab Please change the startup option to “Y” at the last character of the line. […]
Shell Script

How to Auto Start Oracle Database on Linux

Posted on
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. Turning on startup option in oratab Please change the startup option to “Y” at the last character of the […]
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 […]
Startup and Shutdown

Can I Open Database to READ ONLY with RESETLOGS?

Posted on
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 this.SQL> ALTER DATABASE OPEN READ ONLY RESETLOGS;You cannot use the RESETLOGS clause with a READ ONLY clause. (Reference: Opening a Database in Read-Only Mode)That is, you have to go there by three steps.Open the database […]