centos7.0 under Installation oracle11g

Objective

System CentOS 7.0 (x86_64)

Database Oracle 11g (x86_64)

Oracle 11g Package Download:http://pan.baidu.com/s/1c0JHYhi

Author:zzm

1. Configure the Firewall

Method 1: Turn off the firewall (not recommended, not secure)

Systemctl Disable Firewalld.service #关闭开机启动防火墙

Systemctl Stop Firewalld.service #关闭防火墙

Method 2: Configure the Firewall

Vi/etc/sysconfig/iptables #编辑防火墙配置文件, add the following:

-A rh-firewall-1-input-m state–state new-m tcp-p tcp–dport 1521-j ACCEPT

/etc/init.d/iptables Restart #重启防火墙使配置生效

2. Turn off SELinux

Vim/etc/seliunx/config

Selinux=disable #修改为disable

3. Creation of users and groups

Graoupadd Oinstall #创建用户组 Oinstqall

Groupadd DBA #创建用户组 dba

Useradd-g oinstall-g dba-m Oracle #创建oracle用户 and joins a group of Oinstall and DBAs

PASSWD Oracle #设置密码

4. Modify the operating system name

Vi/etc/rehat-release

Modify to Redhat-7

(Oracle's officially certified system is redhat, Oracle Linux, SUSE, etc., and CentOS is a release version of Redhat)

5. Modifying kernel parameters

This change is due to the minimum requirements of the Oracle official documentation for the installation configuration.

Vi/etc/sysctl.conf

#在最后添加以下代码

Net.ipv4.icmp_echo_ignore_broadcasts = 1

Net.ipv4.conf.all.rp_filter = 1

Fs.file-max = 6815744 #设置最大打开文件数

FS.AIO-MAX-NR = 1048576

Kernel.shmall = 2097152 #共享内存的总量, 8G memory setting: 2097152*4k/1024/1024

Kernel.shmmax = 2147483648 #最大共享内存的段大小

Kernel.shmmni = 4096 #整个系统共享内存端的最大数

Kernel.sem = 250 32000 100 128

Net.ipv4.ip_local_port_range = 9000 65500 #可使用的IPv4端口范围

Net.core.rmem_default = 262144

net.core.rmem_max= 4194304

net.core.wmem_default= 262144

net.core.wmem_max= 1048576

After you save the exit, do the following to make the configuration effective

Sysctl-p #使配置立即生效

6. Setting limits on Oracle Users

Vi/etc/security/limits.conf #在末尾添加以下代码

Oracle Soft Nproc 2047

Oracle Hard Nproc 16384

Oracle Soft Nofile 1024

Oracle Hard Nofile 65536

Note: Add if vi Edit file content, you can enter the command mode "$" to jump to the end of the text.

7. Configure the user's environment variables

#在最后添加以下代码

Export Oracle_base=/data/oracle #oracle数据库安装目录

Export Oracle_home= $ORACLE _base/product/11.2.0/db_1 #oracle数据库路径

Export ORACLE_SID=ORCL #oracle启动数据库实例名

Export Oracle_term=xterm #xterm窗口模式安装

Export path= $ORACLE _home/bin:/usr/sbin: $PATH #添加系统环境变量

Export ld_library_path= $ORACLE _home/lib:/lib:/usr/lib #添加系统环境变量

Export #防止安装过程出现乱码

Export Nls_lang=american_america. ZHS16GBK #设置Oracle客户端字符集 must be consistent with the CharSet set at Oracle installation, such as: ZHS16GBK, otherwise the data import and export Chinese garbled problem

After you save the exit, enter the following command to make the configuration effective

source. Bash_profile #使设置立刻生效

8. Check Dependencies

Two steps have been examined here, first in accordance with the official documentation, and in the official documentation I refer to redhat-7 all the necessary things, as follows:

Ksh

Sysstat-10.1.5-1.el7.x86_64

Check the use of the following command, direct online installation, if installed will definitely prompt, otherwise installed

Yum Install binutils #以第一个包为例子

Then by the way I refer to an article to detect the relationship between the method has also been used, this command has a wildcard, installed more than the package, the radiation range more wide, to ensure foolproof.

Yum install gcc* gcc-* gcc-c++-* glibc-devel-* glibc-headers-* compat-libstdc* libstdc* elfutils-libelf-devel* libaio-devel* sysstat* unixodbc-* pdksh-*

This has a pdksh may prompt without this package, but it doesn't matter, at the first step has been detected installed Ksh

9.oracle Unpacking the installation package

1. Win64_11gr2_database_1of2.zip
2. WIN64_11GR2_DATABASE_2OF2 (1). zip

Unzip Win64_11gr2_database_1of2.zip/home/oracle/database

Unzip Win64_11gr2_database_1of2 (1). zip/home/oracle/database

Note: Because the owner of the database above is root,oracle, you can use the following command to make the owner of this folder Oracle.

Su-root #切换到root用户

Chown-r Oracle/home/oracle/database

10.yum Installation Graphical interface

Oracle needs to be installed on a graphical interface, so the graphical interface needs to be installed ahead of time when Oracle is installed

Yum Grouplist See if you have installed

Yum Groupinstall ' GNOME Desktop ' runs command installation if not installed

11.VNC Installation

One. Installation

1. Run the following command to install Vncserver as root user;

Yum Install Tigervnc-server

1. Also run the following command to install the vncviewer;

Yum Install VNC

1. Stop and disable the firewall;

Systemctl Stop Firewalld.service

Systemctl Disable Firewalld.service

Two. Configuration

1. Vncviewer is basically not configured;
2. Vncserver configuration, create a new profile to open windows 1th as an example (you can also open multiple windows at the same time, modify the number), as follows:

Cp/lib/systemd/system/[email protected]/lib/systemd/system/[email Protected]:1.service

Or add one more window:

Cp/lib/systemd/system/[email protected]/lib/systemd/system/[email Protected]:2.service

1. Edit/lib/systemd/system/[email Protected]:1.service, set user root related parameters, the final content is as follows:

[Unit] Description=remote Desktop Service (VNC) After=syslog.target Network.target [Service] Type=forking # Clean any existing files in/tmp/. X11-unix Environment Execstartpre=/bin/sh-c '/usr/bin/vncserver-kill%i >/dev/null 2>&1 | | :‘ Execstart=/sbin/runuser-l root-c "/usr/bin/vncserver%i" Pidfile=/root/.vnc/%h%i.pid Execstop=/bin/sh-c '/usr/bin/vncserver-kill%i >/dev/null 2>&1 | | :‘

• The above content is best set as the root user, or you may see the following error:

[Email protected]:1.service-remote Desktop Service (VNC) loaded:loaded (/usr/lib/systemd/system/[email protected]:1.service; enabled) Active:failed (Result:exit-code) since Tue 2015-04-14 10:09:24 CST; 1min 36s ago process:3258 execstart=/sbin/runuser-l sysadmin-c/usr/bin/vncserver%i (code=exited, Status=1/FAILURE) process:3254 execstartpre=/bin/sh-c/usr/bin/vncserver-kill%i >/dev/null 2>&1 | | : (code=exited, Status=0/success) APR 10:09:24 F1a-vmhost-swpe systemd[1]: Starting Remote Desktop Service (VNC) ... APR 10:09:24 f1a-vmhost-swpe runuser[3258]: Password: APR 10:09:24 f1a-vmhost-swpe systemd[1]: [email Protected]:1.service:control process exited, code=exited Status=1 APR 10:09:24 f1a-vmhost-swpe systemd[1]: Failed to start Remote Desktop Service (VNC). APR 10:09:24 f1a-vmhost-swpe systemd[1]: Unit [email Protected]:1.service entered failed state. Warning:unit file changed on disk, ' Systemctl daemon-reload ' recommended.

Three. Application

1. Update Systemctl to make it effective;

Systemctl Daemon-reload

1. Set the vncserver password;

VNCPASSWD Root

Follow the prompts to enter your password and confirm your password

1. Start the 1th window that the service uses to enable VNC;

Systemctl start [email protected]:1.service or vncserver:1

Close Window # 1th:

Systemctl Stop [email protected]:1.service or vncserver-kill:1

1. set to boot automatically;

Systemctl Enable [email protected]:1.service

End.

12. Run the following command to start the installation interface

Export Lang=en_us #设置编码 to prevent garbled graphic interface

./runinstaller

Note: This may be a reminder of how the display failed, and what I overlooked, seemingly unaffected

Next step into the installation step, very simple, steps to be able to, select part by default can be

In the next installation, you may be prompted to ignore the error and other emails to continue,

Then there may be host name and IP not mapped using the following command to modify the hosts file can be

Vi/etc/hosts

#进入之后将你的主机名加入到127.0.0.1, note is the hostname, not your user name

13. Installation Issues

I also encountered two other errors in the installation process is about makefile, and a warning, but I ignored, after the installation, did not find a problem, put the error code here, to be resolved later

Install Makfile Error

Info:exception thrown from Action:make

Exception name:makefileexception

Exception String:error in invoking target ' install ' of makefile '/oracle/oraclebase/product/11.2.0/db_1/ctx/lib/ins_ Ctx.mk '. See '/oracle/orainventory/logs/installactions2014-12-22_05-24-27pm.log ' for details.

Exception severity:1

Info:calling Action unixActions10.2.0.3.0 Make

Registeronly = False

Installmakepath =/usr/bin/make

Installmakefilename =/oracle/oraclebase/product/11.2.0/db_1/racg/lib/ins_has.mk

Installtarget = Racg_install

Installarguments = oracle_home=/oracle/oraclebase/product/11.2.0/db_1

LogFile =/oracle/oraclebase/product/11.2.0/db_1/install/make.log

Progmsg = linking RACG executables

Info:linking RACG Executables

Info:linking RACG Executables

Info:the output of this make operation was also available at: '/oracle/oraclebase/product/11.2.0/db_1/install/make.log '

Agent NMHS Makefile Error

Info:exception thrown from Action:make

Exception name:makefileexception

Exception String:error in invoking target ' agent NMHS ' of makefile '/oracle/oraclebase/product/11.2.0/db_1/sysman/lib/ Ins_emagent.mk '. See '/oracle/orainventory/logs/installactions2014-12-22_05-24-27pm.log ' for details.

Exception severity:1

Info:calling Action unixActions10.2.0.3.0 Make

Registeronly = False

Installmakepath =/usr/bin/make

Installmakefilename =/oracle/oraclebase/product/11.2.0/db_1/rdbms/lib/ins_rdbms.mk

Installtarget = ALL_NO_ORCL

Installarguments = oracle_home=/oracle/oraclebase/product/11.2.0/db_1

LogFile =/oracle/oraclebase/product/11.2.0/db_1/install/make.log

Progmsg = linking RDBMS executables

Info:linking RDBMS Executables

Info:linking RDBMS Executables

Info:the output of this make operation was also available at: '/oracle/oraclebase/product/11.2.0/db_1/install/make.log '

centos7.0 under Installation oracle11g