Oracle Boot process and mode

I. Start of Oracle Services (must be an Oracle user)
Start Oracle: Start Oracle First, start monitoring
Stop Oracle: Stop listening first, stop Oracle

1. Monitoring
Lsnrctl start//boot monitoring
Lsnrctl stop//stops monitoring

2. The database is turned on (the following are the different ways to open three databases)
1) Open database 1//boot system--
Sqlplus sys as SYSDBA//Login to Oracle
sql> startup Nomount; Open instance
Sql> ALTER DATABASE Mount; Mount Database
sql> ALTER DATABASE open; Open Database

2) Open database 2//boot system-mount/MNT-
Sqlplus sys as SYSDBA//Login to Oracle
sql> startup Mount; Open an instance and mount the database
sql> ALTER DATABASE open; Open Database
3) Open database 3//boot system-mount/mnt--cd/mnt
Sqlplus sys as SYSDBA//Login to Oracle
Sql> startup; Open the instance, mount the database, and open

3. Close the database
1) Stop the database (four different "options" to stop the database mode)
Sqlplus sys as SYSDBA//Login to Oracle
The closing method is as follows: shutdown+ Four colors One of the options, or directly perform the shutdown;
sql> Shutdown [Normal | immediate | transcaction | abort] Close the database

The options are detailed:
1) Shutdown NORMAL
Default value, same as shutdown effect, after all users have finished writing, exit the database and close
2) Shutdown IMMEDIATE
Rollback does not commit all transaction operations, exits the database and shuts down; more commonly
3) Shutdown transcaction
Wait for all users to finish, then exit the library and close; typically used to periodically close the database
4) Shutdown ABORT
Force disconnect all users, data are not saved, will cause data loss, generally not recommended to use

Oracle Server Post-boot operation (local current user login database can not enter password)

2) 1) su–oracle
2) lsnrctl Start
3) sqlplus Sys as SYSDBA
Sql> startup;
Sql> QUIT;
4) emctl Start Dbconsole

Oracle Server shutdown Pre-operation

2) 1) su-oracle
2) Lsnrctl Stop
3) sqlplus Sys as SYSDBA
Sql>shutdown IMMEDIATE;
Sql> QUIT;
4) Emctl Stop Dbconsole

Oracle Boot process and mode