Oracle9i starts, cancel the server manager (SVRMGL), and internal users, the database startup and stop are completed by SQL * Plus! Oracle10g can start and stop database services through browsers! Here mainly talks about the start and stop service under 9i, the following command can also be used at 8i
To start or stop the service, you must have SYSDBA permissions. You can use two middle ways:
First, connect with SYS users
C: /> SQLPLUS SYS / CHANGE_ON_INSTALL AS SYSDBA;
Enter the SQL * PLUS environment; For good memory, the default password is immediately restored immediately after the installation is completed.
Second:
C: /> SQLPLUS / NOLOG
SQL * Plus: Release 9.2.0.1.0 - Production on Monday April 26 09:42:00 2004
CopyRight (C) 1982, 2002 [/ IMG] [/ IMG], Oracle Corporation. All Rights Reserved.
SQL> Connect / as sysdba
connected.
SQL>
After entering, you can do the following operations!
Close the database
Shutdown has four parameters, the meaning of four parameters is as follows: Normal needs to wait for all users to disconnect IMMEDIATE Waiting for users to complete the current statement Transactional Waiting for users to complete the current transaction Abort Do not do anything, directly shut down the database Normal needs to be connected in all connections After the user is disconnected, the database task is turned off, so sometimes it seems that the command is not running! After performing this command, the new connection IMMEDITE is not allowed to disconnect the user connection after the user performs the statement being executed, and the new user is not allowed to connect. Transactional is disconnected after the support is performed, and does not allow new users to connect to the database. Abort performs an forced disconnection and shut down the database directly.
The first three ways are not lost back to the user data. The fourth type is not recommended!
Start of the database
The database starts using the startup command, there are three situations:
The first: without parameters, start the database instance and open the database so that users use the database, in most cases, use this way!
The second: with the Nomount parameters, only start the database instance, but do not open the database, use when you want to create a new database, or use it when you need this!
The third: with the mount parameters, use it when the database is changed. This time the database opens and can be used!
