Restart Oracle Database Command

Restart the Oracle database command to restart the database (two database instances and listening services need to be started) execute the following command to require oracle users. If the current user is root, switch to the oracle user first. The command is as follows: su-oracle (1) Start the brasdv1 instance: In the environment variable, ORACLE_SID is brasdv1, input sqlplus/nolog, SQL> prompt, and enter conn/as sysdba. After the connection is successful, start the database: after the database is restarted successfully, enter exit to exit sqlplus. Www.2cto.com (2) Start the bradev instance and enter the export ORACLE_SID = bradev command, which is used to set the current oracle instance as bradev. Enter sqlplus/nolog, SQL> prompt, and then enter conn/as sysdba. After the connection is successful, start the database: After the startup database is restarted successfully, enter exit to exit sqlplus. (3) start the database listening service and input lsnrctl start in the command line. This command does not need to be executed in sqlplus. After completing the preceding operations, you can use the pl/SQL tool on the local machine to test the connection.