Oracle startup and shutdown, monitoring start/shutdown of services

One: Sql*plus start/close:

1.sqlplus/nolog start Sql*plus "Do not connect to the database"

2.conn/as SYSDBA Connect to Oracle as a DBA

3.startup Startup Database

Three ways to start a database and application scenarios

1> Normal Start

Startup [Open] boot order: 1. Launch Instance "parameter file" to create background processes and services　　　　　　　　　　　　　　　　　　　　　

2. Loading the database "control file"for the instance, loading the database opens the control file,

　　　　　　　　　　　　　　　　　　　　　　Get information about the physical structure of the database, such as the database name, the location and name of the data file, and prepare to open the database

3. Open the database, set the database to open, instance open all data files and redo log files

Application scenario:Open mode is also divided into non- restricted state and restricted state, restricted state:

　　　　　　　　　　　　　　　　　1. perform data import and export

　　　　　　　　　　　　　　　　　2. extracting external data using Sql*loader

3. Prohibit Normal user access to the database

　　　　　　　　　　　　　　　　　　　　　4. Database porting or upgrade operations

　　

2> startup mount boot sequence: 1, 2 steps for normal startup

Application scenario: Because the physical data file is not open, it is suitable for:

1. Data operation of the file

2. Operation of log files

3. Database recovery operations

4. Operation of the archive mode of the database

3>startup nomount Boot sequence: 1 steps for normal startup

Application scenario: Because the control file, data file is not open, it is applicable to:

1. Create a database,

2. Resetting the control file

4. Close the database

Normal shutdown shutdown

Close shutdown immediate now

Close transaction shutdown transactional

forcibly closing shutdown abort

Second: Start/shutdown of Oracle monitoring service:

Start: Lsnrctl start

Stop: Lsnrctl stop

strong>     Status: Strong> lsnrctl status

Non-restricted and restricted states

Oracle startup and shutdown, monitoring start/shutdown of services