How to restart oracle database

How to restart the oracle database

Under Windows, to restart the oracle database, you need to stop and restart it first. The following are the steps:

1. Close the database: win r, enter the following code to stop:

set ORACLE_SID=SID_Name，回车。
sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown immediate
SQL> exit

2. Start the database: win r, enter the following code to start:

set ORACLE_SID=你的数据库SID名字
sqlplus /nolog
SQL> connect / as sysdba
SQL> startup
SQL> exit

More related knowledge and programming Tutorial, please pay attention to the PHP Chinese website. The PHP Chinese website provides a large number of free, original, high-definition PHP video tutorials, and will hold php free training regularly!

The above is the detailed content of How to restart oracle database. For more information, please follow other related articles on the PHP Chinese website!