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.
```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)
相关文章
- 方式Linux桌面快捷方式:快速访问必须资源(linux桌面快捷)
- 临时变量设置——Linux下的强大功能(linux设置临时变量)
- 安全修复Linux.d文件安全修复:完美守护系统(linux.d文件)
- Oracle数据库中查找以首字母开头的信息(oracle查询首字母)
- Linux命令行之精彩世界(linux命令行软件)
- 特性探索Oracle语法特色(oracle的语法)
- 利用Oracle触发器实现数据库功能扩展(oracle触发器类型)
- Linux防火墙关闭指南(关闭linux的防火墙)
- 如何创建和管理 Oracle 数据库账号?(oracle数据库账号)
- 了解Linux系统,探索杨生的技术境界(linux杨生)
- Oracle数据库的全局索引与成功之道(oracle 全库索引)
- Oracle 11gR2数据库出错恢复之路ORA00913(oracle -913)
- NBU Oracle代理提高数据库管理效率(nbu oracle代理)
- Oracle数据库中非空字段的表达(oracle中非空的表示)
- Oracle支持的多种字符集简介(oracle什么字符集)
- Oracle 数据库修改后的管理与操作(oracle修改后操作)
- Oracle数据库优势与不足(oracle优缺点:)
- Oracle数据库中休眠函数的使用(oracle 休眠函数)
- Oracle 数据处理中的正则表达式实现(oracle中正则表达式)
- 探索Oracle数据库中的三个系统用户(oracle三个系统用户)
- Oracle与Veeam,提供更安全的企业数据保护(oracle veeam)
- Oracle DEMP最佳数据库管理实践(oracle demp)