oracle database to start and stop

Posted on 2009-11-06 filed under: Oracle Database (RSS) 24 views

While Oracle will be in the above development, but the management really is unreasonable, especially in linux, the company recently to restart the server always gets to have to restart the database, always remember the command, and now paste these commands in the Here, have been prepared forgotten inspection.

Oracle user to log on

Login, enter the following command:
oracle-> sqlplus / nolog
SQL * Plus: Release 9.2.0.1.0 - Production on Monday April 26 09:42:00 2004

Copyright (c) 1982, 2002>>, Oracle Corporation. All rights reserved.

SQL>; connect / as sysdba
Is connected.
SQL>;
After entering the following actions can be a!
Let me talk about shutting down the database
shutdown has four parameters, four parameters, the following meanings:
Normal users need to wait for all of the disconnected
Immediate waiting for the user to complete the current statement
Transactional waiting for the user to complete the current transaction
Abort without any waiting, direct closure of the database
normal need to disconnect all connected users off the database after the implementation of the task, sometimes looks as if the command is not running the same! In the implementation of this command does not allow new connections
immediate implementation of the end user statement is being executed after the user connections disconnect, and does not allow new users to connect.
transactional in supporting the implementation of the End of the current after disconnect things, and does not allow new users to connect to the database.
abort the implementation of forced disconnect and directly close the database.
The first three methods do not return to lost user data. Fourth, that has been not the case, is not recommended!
DATABASE
The database to start using the startup command, it has three kinds of situations
The first: with no parameters, start the database instance and open the database, so that users using the database, in most cases, the use in this way!
The second: with nomount argument, only to start the database instance, but does not open the database you want to create a new database to use, or when you need to use this!
The third: with mount parameters, making use of the database when the name change. This time the database is open and ready to use!