Oracle Database startup and shutdown in Linux, linuxoracle

Oracle Database startup and shutdown in Linux, linuxoracle

Sometimes you need to restart the Oracle database on Linux.

Start the database first, and then start the database listening.

A. Switch to oracle user identity, or use su-to switch both home and path to oralce user.

su oracle

B. Start Sqlplus (using SQL statements) Without Logon

sqlplus /nolog

C. Use the database administrator to connect to the database

connect /as sysdba

D. Start the database and exit the sqlplus command status.

Startup // exit sqlplusexit before enabling the listener

E. Start the listener and close the database.

Lsnrctl start shutdown immediate // close the database

F. startup some common parameters

• Without parameters, start the database instance and open the database so that you can use the database. In most cases, this method is used!
• Nomount: only starts database instances, but does not open the database. It is used when you want to create a new database, or when you need it!
• Mount: used when renaming a database. In this case, the database is opened and can be used!

G. Some common shutdown Parameters

• Normal: wait until all users are disconnected.
• Immediate waits for the user to complete the current statement
• Transactional waits for the user to complete the current transaction
• Abort closes the database without waiting.
• Normal requires that you close the database only after all connected users are disconnected. Sometimes it seems that the command is not running! New connections are not allowed after this command is executed.
• Immediate disconnects the user after the user executes the statement being executed, and does not allow new users to connect.
• Transactional disconnects after it supports executing the current transaction and does not allow new users to connect to the database.
• Abort forcibly disconnects and closes the database.