How Do I Start the Oracle Database
Question
I do not know how to start the Oracle database.
Answer
- Log in to the SUSE Linux as user oracle.
- On the command line interface (CLI), run the following command to connect to the Oracle database:
$ sqlplus / as sysdba
The user name and password are required in remote login mode. The following describes how to use the command to connect the system user to the Oracle database with password testpwd.
$ sqlplus system/testpwd as sysdba
If the information similar to the following is displayed, the system user is connected to the Oracle database:
SQL >
- Run the following command to start the Oracle database:
Before starting the Oracle database, you can check whether the Oracle database has started. For details, see How Do I Check the Startup of the Oracle Database.
> startup
If the following information is displayed, the Oracle database is successfully started:
ORACLE instance started. Total System Global Area 1610612736 bytes Fixed Size 2046264 bytes Variable Size 385877704 bytes Database Buffers 1207959552 bytes Redo Buffers 14729216 bytes Database mounted. Database opened.