Kai-Stop Oracle Services
Log on to the server where the Oracle service resides [root@localhost ~]# su Oracle
[Oracle@localhost ~]$ Sqlplus/nolog
Sql> Connect/as SYSDBA
sql> shutdown immediate (Close database instance)
Sql> Startup (starting a database instance, generally do not need to add parameters, as long as the environment variable settings)
sql> quit (Exit SQL mode)
[Oracle@nstlbeta ~]$ CD $ORACLE _home/bin
[Oracle@nstlbeta ~]$ lsnrctl Stop (off listening)
[Oracle@nstlbeta ~]$ lsnrctl Start (starting listening)
Statup three parameters, meaning as follows:
Startup force: Force startup instance and open database
Startup recover: Database recovery
Startup restrict: Block connections to users other than DBA
Shutdown four parameters, meaning as follows:
Shutdown normal needs to wait for all users to disconnect and not allow new connections.
Shutdown immediate waits for the user to complete the current statement and does not allow new users to connect.
Shutdown transactional waits for the user to complete the current transaction and does not allow new users to connect to the database.
Shutdown abort do not do any waiting, directly close the database, in the case of not already, do not recommend the use of