Start and Stop oracle in linux

To start or stop a service in oracle in linux, you must have sysdba permissions. Two methods can be used for connection: first, connect to c: \> sqlplus sys/change_on_install as sysdba; Second: www.2cto.com C: \> sqlplus/nolog SQL> connect/as sysdba is connected. SQL> after entering, you can perform the following operations! There are four parameters for shutting down the database. The four parameters are described as follows: Normal needs to wait for all users to disconnect Immediate and wait for the user to complete the current statement Transactional waiting for the user to complete the current transaction. Abort does not wait, to directly close the normal database, you need to close the database task after all connected users are disconnected, so sometimes it looks like the command is not running! After executing this command, the new connection immediate is not allowed to disconnect the user after the user executes the statement being executed, and the new user is not allowed to connect. Transactional disconnects after it supports executing the current transaction and does not allow new users to connect to the database. Www.2cto.com abort forcibly disconnects and closes the database directly. The first three methods do not return lost user data. The fourth option is not recommended if it is no longer available! The startup command is used to start a database. There are three situations: the first one is to start the database instance and open the database without parameters, so that you can use the database. In most cases, use this method! Type 2: With the nomount parameter, only the database instance is started, but the database is not opened. It is used when you want to create a new database, or when you need it! Type 3: Use the mount parameter when renaming a database. In this case, the database is opened and can be used!