Linux installation oracle11g Database steps detailed

1. Installation Development Package Group

Yum Groupinstall "Development Libraries" "Development Tools"

2. Install other Packages

Yum install-y libaio glibc compat-libstdc++-33.x86_64 elfutils-libelf-devel\* gcc-c++ libaio-devel unixODBC\* readline\ * glibc-2.12-1.80.el6.i686 libxext.i686

PDKSH-5.2.14-37.EL5_8.1.X86_64.RPM is not a system-brought package

3, network settings
1, IP address
2, Hosts file

127.0.0.1 localhost.localdomain localhost 192.168.0.100 redhat5

4. Create users and Groups

Groupadd oinstall groupadd dba useradd-g oinstall-g dba Oracle

5, modify the kernel parameters, because of the resource consumption of Oracle is very large, so modify the kernel parameters so that the server can withstand a lot of pressure, to adjust the kernel parameters, so that Linux support large software

Vim/etc/sysctl.conf

kernel.core_user_pid = 1     kernel.shmall = 2097152      kernel.shmmax = 2147483648   #是物理内存的1半, the default is 2G, the experiment is equal to 1 half of physical memory can       kernel.shmmni = 4096     kernel.sem = 250  32000 100 128     fs.file-max = 65536      net.ipv4.ip_local_port_range = 1024 65000     net.ipv4.ip.tcp_ wmem =      net.ipv4.ip.tcp_rmem =       net.core.rmem_default = 262144     net.core.rmem_max = 262144      net.core.wmem_default = 262144      net.core.wmem_max = 262144     kernel.sem = 250 32000  100 128

Syscpl-p

6, modify the largest file open book

vim /etc/security/limits.conf     oracle   soft    nproc   2047     #oracle用户可以运行的最大进程数      oracle  hard    nproc   16384      oracle  soft    nofile  1024      #oracle用户可以打开的最大文件数      oracle  hard    nofile   65555   vim /etc/pam.d/login session required     pam_limits.so   #   vim /etc/profile if [  $USER  =   "Oracle"  ];then if [  $SHELL  =  "/bin/ksh"  ];then ulimit -p  16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi  fi 

7. Create Oracle Software Installation directory

Mkdir-pv/u01/app/oracle chown-r oracle:oinstall/u01 chmod-r 755/u01

8. Set Oracle User Environment variables

Su – Oracle VIM. Bash_profile Export Editor=vim export oracle_base=/u01/app/oracle export oracle_home=/u01/app/oracle/ Product/11.2/db_1 Export ORACLE_SID=ORCL Export ORACLE_UNQNAME=ORCL export oracle_hostname=localhost export PATH= $PATH :/$ORACLE _home/bin export nls_lang= "

Simplified Chinese_china. UTF8 "#设置oracle字符集为utf8

#alias sqlplus= ' rlwrap sqlplus ' #alias rman= ' rlwrap rman ' #export path= $PATH:/usr/local/rlwrap/bin stty, Erase ^h #设置进入sqlplus后 backspace key can be used

#重新登录oracle, you must log on to a graphical interface with an Oracle user, or the installation of Oracle will cause the graphics check to pass.

Add font file

Download font Files Zysong.ttf

MKDIR/USR/SHARE/FONTS/ZH_CN/TRUETYPE-PV CP Zysong.ttf/usr/share/fonts/zh_cn/truetype

9. Configure the Xmanager so that you can perform the installation command under Xhell and display the Oracle graphical interface directly on Windows

Using Xshell to connect Linux

Click “ File ”—-“ properties ”—–“ tunnel ”

10. Install Oracle

Set Language

. UTF8

Performing an Oracle installation script

Graphical inspection will eject the Oracle-installed graphical interface under Windows

Do not enter the mailbox here

Enter admin password, use Oracle

Ignore warning

Click Next

Check for errors, click “ Patch and check again for ”, pop-up patched Script Path dialog, prompt to execute the following script in the root province

Check again after executing script, install Sysstat

Continue installation after check pass

Create an instance

Set Database user password

EXECUTE AS Root

/u01/app/orainventory/orainstroot.sh/u01/app/oracle/product/112.0/dbhome_1/root.sh

Complete the installation

Sign in Oracle

Sqlplus/nolog Conn Sys/oracle as Sysdba