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 andprogramming 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 holdphp free trainingregularly!

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!