Oracle database Startup and shutdown in Linux

Sometimes you need to restart the Oracle database on Linux.

Note Start the database first, and then listen on the startup database.

Su oraclesqlplus/nologconnect/as sysdbastartup//exit Sqlplusexitlsnrctl start//shut down the database before opening the monitor shutdown immediate

A.startup parameters

Start the DB instance without parameters and open the database so that the user can use the database, and in most cases, use this method!

Nomount, just start the DB instance, but don't open the database, use it when you want to create a new database, or use it when you need it!

Mount, which is used when renaming a database. This time the database is open and ready to use!

B.shutdown parameters

Normal needs to wait for all users to disconnect

Immediate waits for the user to complete the current statement

Transactional waiting for the user to complete the current transaction

Abort does not do any waiting, directly shuts down the database

Normal needs to shut down the database task after all the connected users are disconnected, so sometimes it looks as if the command is not running! New connections are not allowed after this command is executed

Immediate disconnects the user after the user finishes executing the statement, and does not allow the new user to connect.

Transactional disconnects when it advocates executing the current thing, and does not allow new users to connect to the database.

Abort executes a forcibly disconnected connection and shuts down the database directly.

Oracle database Startup and shutdown in Linux