How do I start the Oracle database

Publication Date:  2016-11-21 Views:  274 Downloads:  0
Issue Description
How do I start the Oracle database
Solution
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

NOTE: 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.

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.

END