CetnOS 6.9安装配置Oracle 11gR2 11.2.0.4.0

前端之家收集整理的这篇文章主要介绍了CetnOS 6.9安装配置Oracle 11gR2 11.2.0.4.0前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

@H_404_1@一、@H_404_1@环境介绍:

IP:192.168.1.146

OS:CentOS 6.9 x86_64

JDK版本:1.8.0_181

Oracle版本:11.2.0.4.0

@H_404_1@

@H_404_1@二、@H_404_1@安装准备:

1、关闭SElinuxiptables

2、安装依赖软件包:# yum -y install unzip ntp binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*.i686 elfutils-libelf-devel gcc gcc-c++ glibc*.i686 glibc glibc-devel glibc-devel*.i686 ksh libgcc*.i686 libgcc libstdc++ libstdc++*.i686 libstdc++-devel libstdc++-devel*.i686 libaio libaio*.i686 libaio-devel libaio-devel*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686 libXp xorg-x11-utils

3、服务器时间同步:# ntpdate -u ntp.api.bz # date

4、https://edelivery.oracle.com/上下载Oracle软件包p13390677_112040_Linux-x86-64_1of7.zipp13390677_112040_Linux-x86-64_2of7.zip,并上传至服务器,分别解压

# unzip -q p13390677_112040_Linux-x86-64_1of7.zip

# unzip -q p13390677_112040_Linux-x86-64_2of7.zip

备注:上述两步分开执行,执行完成后会生成一个名为database的安装目录

5、 配置主机名:

# echo "192.168.1.146 Oracle11gR2" >> /etc/hosts

# vim /etc/sysconfig/network --> HOSTNAME=Oracle11gR2

# hostname Oracle11gR2

# logout

6、安装配置JDK

# java -version

# rpm -qa | grep jdk

# rpm -e java-1.7.0-openjdk

# rpm -e java-1.6.0-openjdk

备注:如果系统中已经安装了openjdk,按上述方法删除

# rpm -ivh jdk-8u181-linux-x64.rpm

# vim /etc/profile.d/jdk.sh

@H_404_1@export JAVA_HOME=/usr/java/jdk1.8.0_181-amd64

@H_404_1@export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar

@H_404_1@export PATH=$JAVA_HOME/bin:$PATH

# . /etc/profile.d/jdk.sh

7、 安装配置VNC

(1)安装VNC服务端:# yum -y install tigervnc-server

(2)安装桌面环境:# yum -y groupinstall "Desktop"

(3)启用图形界面:# vim /etc/inittab --> id:@H_404_1@5:initdefault:

(4)启动VNC服务端,并设置连接密码(此处为123456):# vncserver

(5)修改配置文件

# vim /etc/sysconfig/vncservers

修改代码

VNCSERVERS="1:root"

VNCSERVERARGS[1]="-geometry 1024x768"

# vim /root/.vnc/xstartup

注释代码

#xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" &

#twm &

新增代码gnome-session &

(6)重启# service vncserver restart

(7)验证VNC服务端是否成功启动:# ss -tunlp | grep vnc

(8)设定VNC服务端开机自启:# chkconfig vncserver on # chkconfig vncserver --list

(9)本地Windows 10中使用VNC客户端工具VNC Viewer,输入@H_404_1@VNC@H_404_1@服务端的@H_404_1@IP@H_404_1@地址@H_404_1@:1即可进行连接。默认第一个端口是5901,第二个端口是5902,以此类推

8、创建运行Oracle时所需的用户和组:

# groupadd dba @H_404_1@//dba@H_404_1@组中的成员用于管理、操作数据库

# groupadd oinstall @H_404_1@//oinstall@H_404_1@组中的成员用于管理@H_404_1@Oracle@H_404_1@数据库软件,即各种@H_404_1@Oracle@H_404_1@物理文件

# useradd -m -g oinstall -G dba oracle

# echo "123456" | passwd --stdin oracle

# id oracle

9、创建安装Oracle时所需的目录,并设置权限:

# mkdir -pv /oracle /oraInventory

# chown -R oracle.oinstall /oracle

# chmod -R 755 /oracle

# chown -R oracle.oinstall /oraInventory

# chmod -R 755 /oraInventory

10、设定oracle用户的环境变量:

# su - oracle

$ vim .bash_profile,末尾追加如下内容

@H_404_1@export ORACLE_BASE=/oracle

@H_404_1@export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

@H_404_1@export ORACLE_SID=@H_404_1@TESTDB @H_404_1@//@H_404_1@名称要与之后新建数据库时输入的@H_404_1@SID@H_404_1@名称一致

@H_404_1@export PATH=$ORACLE_HOME/bin:$PATH

$ . .bash_profile

11、调整系统及内核参数@H_404_1@@H_404_1@root@H_404_1@用户操作)

(1)# vim /etc/security/limits.conf,末尾追加如下内容

@H_404_1@oracle soft nproc 2047

@H_404_1@oracle hard nproc 16384

@H_404_1@oracle soft nofile 1024

@H_404_1@oracle hard nofile 65536

(2)# vim /etc/pam.d/login,末尾追加内容@H_404_1@session required pam_limits.so

(3)# vim /etc/profile,末尾追加如下内容

@H_404_1@if [ "$USER" == "oracle" ];then

@H_404_1@ if [ "$SHELL" == "/bin/ksh" ];then

@H_404_1@ ulimit -p 16384

@H_404_1@ ulimit -n 65536

@H_404_1@ else

@H_404_1@ ulimit -u 16384 -n 65536

@H_404_1@ fi

@H_404_1@fi

# . /etc/profile

(4)# vim /etc/sysctl.conf,末尾追加如下内容@H_404_1@(等号左右两边都有空格)

@H_404_1@fs.file-max = 6815744

@H_404_1@fs.aio-max-nr = 1048576

@H_404_1@kernel.sem = 250 32000 100 128

@H_404_1@kernel.shmall = 2097152

@H_404_1@kernel.shmmax = 2147483648

@H_404_1@kernel.shmmni = 4096

@H_404_1@net.ipv4.ip_local_port_range = 9000 65500

@H_404_1@net.core.rmem_default = 262144

@H_404_1@net.core.rmem_max = 4194304

@H_404_1@net.core.wmem_default = 262144

@H_404_1@net.core.wmem_max = 1048576

@H_404_1@# sysctl -p

@H_404_1@三、@H_404_1@安装@H_404_1@Oracle 11gR2@H_404_1@

@H_404_1@@H_404_1@VNC@H_404_1@远程终端中执行如下操作:

# export DISPLAY=localhost:1

# xdpyinfo | grep "name of display" --> @H_404_1@name of display: localhost:1

# xhost + --> @H_404_1@access control disabled,clients can connect from any host

$ export DISPLAY=localhost:1

$ xdpyinfo | grep "name of display" --> @H_404_1@name of display: localhost:1

$ export

$ cd database

$ ./runInstaller



@H_404_1@选中@H_404_1@Fixable@H_404_1@列中为“@H_404_1@Yes@H_404_1@”的行,点击“@H_404_1@Fix & Check Again@H_404_1@”:


@H_404_1@按照提示,以@H_404_1@root@H_404_1@用户身份执行上述脚本:


@H_404_1@点击“@H_404_1@OK@H_404_1@”,重新检查:


@H_404_1@上传@H_404_1@pdksh-5.2.14-37.el5_8.1.x86_64.rpm@H_404_1@至服务器,安装软件包:

Check Again@H_404_1@”:


@H_404_1@修改@H_404_1@Swap@H_404_1@分区大小:

@H_404_1@1、 @H_404_1@创建@H_404_1@swapfile@H_404_1@@H_404_1@# dd if=/dev/zero of=swapfile bs=1024 @H_404_1@count=8061108@H_404_1@ @H_404_1@//@H_404_1@参照@H_404_1@Expected Value@H_404_1@的值

@H_404_1@2、 @H_404_1@@H_404_1@swapfile@H_404_1@设置为@H_404_1@swap@H_404_1@空间:@H_404_1@# mkswap swapfile

@H_404_1@3、 @H_404_1@启用@H_404_1@# swapon swapfile

Check Again@H_404_1@”:

root@H_404_1@用户身份执行上述脚本:

OK@H_404_1@”:

@H_404_1@

@H_404_1@四、@H_404_1@配置监听:

$ netca








@H_404_1@五、@H_404_1@新建数据库实例@H_404_1@TESTDB@H_404_1@

$ dbca


@H_404_1@@H_404_1@Enterprise Manager@H_404_1@标签页:

Automatic Maintenance Tasks@H_404_1@标签页:


@H_404_1@启用快速恢复区,启用归档:


@H_404_1@@H_404_1@Memory@H_404_1@标签页,设置为@H_404_1@60%@H_404_1@左右:

Sizing@H_404_1@标签页,设置@H_404_1@1000@H_404_1@个进程:

Character Sets@H_404_1@标签页,设置字符集:

@H_404_1@六、@H_404_1@配置数据库连接:

1、 查看数据库版本、字符集:

sql> select * from v$version;

sql> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';

sql> select userenv('language') from dual;

2、 创建数据库连接用户DB_ADMIN,密码为DB_ADMIN,权限为dba

sql> create user DB_ADMIN identified by DB_ADMIN;

sql> grant dba to DB_ADMIN;

sql> commit;

3、 使用Navicat Premium连接数据库

猜你在找的Oracle相关文章