Article 10 Oracle Database startup and Shutdown

Article 10 Oracle Database startup and Shutdown

I. Start data
$ Sqlplus "sys/pass as sysdba"
SQL> startup

Ii. Start the listener
After the database is started, if the listening process is not started, the client cannot connect to the database. The method for starting a listening process is as follows:
$ LSNRCTL start
In Widnows, listeners can be started from the service list.
The listening mileage configuration file is listener. ora, which is located in the/home/APP/Oracle/product/10.1.0/db1/Network/admin/directory /.
This configuration file is divided into two parts, one is the configuration of the listener itself, including the protocol, address, port number, and the other is the instance information of the database connected to the listener, including: instance name, global database name, and Oracle Home Directory. Listeners can be configured using the Oracle Net config wizard.
To display the running status of the listener: $ LSNRCTL status;
To stop the listener: $ LSNRCTL stop.

Iii. Database Startup Process
There are three phases:
1. Start the instance, including the following operations:
1) read the parameter file
2) SGA allocation
3) Start the background process
2. Load the database
The database is loaded to associate the database with the started instance. After the database is loaded, the database remains closed.
3. Open the database
In this step, the database can be used for normal operations. Open Control Files, database files, and log files.

Iv. Database startup parameters
1. nomount: only start the instance, not load the database
SQL> startup nomount
2. Mount: Start the instance and load data, but do not open the database
SQL> startup Mount
3. Read Only: Set the database to read-only
SQL> startup Mount
SQL> alter database open read only
4. Read Write: Open Data in read/write mode. This is the default mode.
SQL> startup Mount
SQL> alter database open read write
5. Open: Open the database. This is the default method.
SQL> startup Mount
SQL> alter database open;
6. Restrict: only users with restricted session permission can access the database.
SQL> startup restrict
7. pfile: Specify the parameter file at startup
SQL> startup pfile =/u02/user/mypfile. ora
8. Force: Start the database forcibly.
SQL> startup pfile =/u02/user/mypfile. ora open restrict force

5. Database Shutdown
As opposed to the startup process, closing involves three processes.
1). Shut down the database
2). Uninstall the database
3). Shut down the database instance

1. Normal Close Mode
The normal closing mode is the normal closing mode, which is the default closing mode. In this mode, the database server can shut down the database only after all clients exit from Oracle normally.
SQL> shutdown normal
2. Immediate close Method
When you close a database in this way, the system rolls back all transactions that have not been committed by all users connected to the database, interrupts the connection, and closes the database.
SQL> shutdown immediate
3. Abort close Method
Abort closes the database in an abnormal way. When the database is closed in this way, the system immediately closes the database instance and does not check the data integrity of the transaction chamber. Is the fastest way to shut down.
SQL> shutdown abort;
4. Disable transactional
In this shutdown mode, the database must wait for all the clients to end the transaction, submit or roll back.
SQL> shutdown transactional