Interesting

What is Dbstart?

What is Dbstart?

The dbstart command simply parses the oratab file and starts those databases that have a Y in the third field. It also uses the ORACLE_HOME specified in the file to connect internally to the database and issue the startup command.

How do you automate starting and shutting down of databases in Unix?

To automate database startup and shutdown, use the dbstart and dbshut scripts, which are located in the $ORACLE_HOME/bin directory. The scripts refer to the same entries in the oratab file, which are applied on the same set of databases.

How do I start and stop Oracle Service in Linux?

Do one of the following:

  1. On Windows: Click Start, point to Programs (or All Programs), point to Oracle Database 11g Express Edition, and then select Stop Database.
  2. On Linux with Gnome: In the Applications menu, point to Oracle Database 11g Express Edition, and then select Stop Database.

What are the 4 option of database shutdown?

There are several modes for shutting down a database: normal, immediate, transactional, and abort.

What is Startup restrict in Oracle?

Restrict Mode in which Oracle database allow making connection with special rights such as DBA, SYSDBA to perform the maintenance activity like rebuilding index, remove fragmentation etc. It is very use full for DBA for start database in restricted mode for planned maintenance activity.