Linux 下启动 Oracle 数据库的完整步骤(linux下启动oracle)

Recenty, Oracle Database became a quite popular with its administration convenience and reliability. Oracle Database widely used in business world and scientific research. So, How do you start Oracle Database in Linux? In this paper, I will explain the complete steps of start Oracle Database in Linux.

First, you need to download and install Oracle Database in your Linux. The detailed install steps please refers to the official Oracle Database Installation Guide. Since Oracle Database needs to use the existing user and groups on the operating system, you need to create a oinstall and dba group.

“`shell

groupadd oinstall

groupadd dba


After that, create a Oracle user, such as oracle, to manage the Oracle Database. Assign the just created oinstall and dba to the Oracle user.

```shell
useradd -g oinstall -G dba oracle

Second, Make sure the Oracle user can access the files and directories in `/opt/oracle` directory by setting permission.

“`shell

chown -R oracle:dba /opt/oracle


Third, Start the Oracle Database environment. To do that, you need to configure Oracle Environment in the profile.

```shell
vim /etc/profile
#Oracle Environment
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin

And then, load the newly added profile in your Linux environment

“`shell

source /etc/profile


Fourth, As the Oracle user, Run the Database Creation.

```shell
sudo su - oracle
$ORACLE_HOME/bin/dbca

This command will start the Configuration Assistant. Follow the configuration assistant, create an Oracle Instance Name and Password, then click the Finish button.

Finally, You can start Oracle Database.

“`shell

sqlplus / as sysdba

SQL> startup


To verify Oracle Database is running, execute following command

```shell
$ORACLE_HOME/bin/lsnrctl status

Through the above steps, we can start Oracle Database in Linux. It is really not difficult for Linux user to Start Oracle Database.


数据运维技术 » Linux 下启动 Oracle 数据库的完整步骤(linux下启动oracle)