Shulou(Shulou.com)06/01 Report--

1. Start the Oracle service (must be an oracle user)

Start Oracle: first start Oracle, start listening

Stop Oracle: stop monitoring first, and then stop Oracle

1. Monitor

Lsnrctl start / / start listening

Lsnrctl stop / / stop snooping

two。 Database opening (here are three different ways to open a database)

1) Open the database 1 / / start the system-- >

Sqlplus sys as sysdba / / Log in to Oracle

SQL > startup nomount; / / Open the instance

SQL > alter database mount; / / Mount the database

SQL > alter database open; / / Open the database

2) Open database 2 / / boot system-- > mount / mnt-- >

Sqlplus sys as sysdba / / Log in to Oracle

SQL > startup mount; / / Open the instance and mount the database

SQL > alter database open; / / Open the database

3) Open the database 3 / / start the system-- > mount / mnt-- > cd / mnt

Sqlplus sys as sysdba / / Log in to Oracle

SQL > startup; / / Open instance, mount database and open

3. Shut down the database

1) stop the database (four different "options" to stop the database)

Sqlplus sys as sysdba / / Log in to Oracle

Turn it off as follows: shutdown+ one of the four colors, or execute shutdown directly

SQL > shutdown [normal | immediate | transcaction | abort] close the database

Detailed explanation of the options:

1) shutdown NORMAL

/ / default value, which has the same effect as shutdown. After all users have finished writing, exit the database and close it.

2) shutdown IMMEDIATE

/ / rollback all uncommitted transaction operations, exit the database and close; more commonly used

3) shutdown TRANSCACTION

/ / wait for all user operations to be completed, then exit the database and close it. It is generally used to close the database on a regular basis.

4) shutdown ABORT

/ / all users are forcibly disconnected and all data is not saved, which will result in data loss. It is generally not recommended to use it.

Operation of Oracle server after boot (local current users can log in to the database without entering password)

2) 1) su-oracle

2) lsnrctl start

3) sqlplus sys as sysdba

SQL > startup

SQL > QUIT

4) emctl start dbconsole

Operation of Oracle server before shutdown

2) 1) su-oracle

2) lsnrctl stop

3) sqlplus sys as sysdba

SQL > shutdown IMMEDIATE

SQL > QUIT

4) emctl stop dbconsole

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.