Linux Oracle 安装

Linux Oracle安装

 安装oracle是一个比较麻烦的过程,但是领导分配了这个任务, 还是得干啊,  通过搜过博客学习,尽然完成了 , 这里做一下纪录,都是别人的经验

1. 下载

下载地址 ：  https://www.oracle.com/database/technologies/112010-linx8664soft.html

可以在Oracle官网下载资料时使用

用户名：541509124@qq.com
密码：LR4ever.1314

安装包版本 

Linux版本 ：

     CentOS Linux release 7.2.1511 (Core)

 

2. 安装

https://blog.csdn.net/weixin_33769125/article/details/92374631

https://blog.csdn.net/sunsijia21983/article/details/94394764

 

启动失败 ：

ORA-01109:数据库未打开(解决)

https://blog.csdn.net/lydong_/article/details/79812519

 

ORA-01102: cannot mount database in EXCLUSIVE mode

https://blog.csdn.net/lzwgood/article/details/26368323

yum 安装fuser命令

yum install -y psmisc

https://blog.csdn.net/wangyuxuan_java/article/details/8697287

表空间创建

https://blog.csdn.net/jinchaomail/article/details/50125135

 

cd /var/app/admin/orcl11g/pfile

安装命令

./runInstaller -silent -ignorePrereq -ignoreSysPrereqs -responseFile /var/app/oracle/database/response/db_install.rsp

 

https://blog.csdn.net/lzwgood/article/details/26368323

https://blog.csdn.net/skylove111/article/details/9243967

mount -o remount,size=20G /dev/shm/

tnsping ORCL11G

创建表空间, 用户和密码,授权

create user identified by 密码;

CREATE TABLESPACE exs datafile '/var/app/oradata/orcl11g/exs.dbf' size 800m autoextend on next 50m maxsize 20480m extent management local;

CREATE temporary TABLESPACE exs_temp tempfile '/var/app/oradata/orcl11g/exs_temp.dbf' size 100m autoextend on next 50m maxsize 20480m extent management local;

CREATE USER exs_x5_rw identified by exs_x5_rw_pwd DEFAULT TABLESPACE EXS temporary tablespace exs_temp;
CREATE USER exs_x9_rw_base identified by exs_x9_rw_base_pwd DEFAULT TABLESPACE EXS temporary tablespace exs_temp;
CREATE USER exs_x9_rw_core identified by exs_x9_rw_core_pwd DEFAULT TABLESPACE EXS temporary tablespace exs_temp;

 

grant resource,connect,dba to exs_x5_rw;
grant resource,connect,dba to exs_x9_rw_base; 
grant resource,connect,dba to exs_x9_rw_core;

tnsping ORCL11G

终于完成任务.