zl程序教程

您现在的位置是:首页 >  系统

当前栏目

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

LinuxOracle数据库 步骤 启动 完整
2023-06-13 09:12:41 时间

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.
```shelluseradd -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.
```shellvim /etc/profile
#Oracle Environmentexport ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_SID=orclexport 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.
```shellsudo 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.


我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 Linux 下启动 Oracle 数据库的完整步骤(linux下启动oracle)