oracle11g 最终版本11.2.0.4安装详细过程介绍

[root@orcltest Downloads]# vim/etc/sysctl.conf

# add by tim.man

kernel.shmmax = 277495689510912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

fs.file-max = 6815744

 

# Controls the maximum number of shared memory segments, in pages                              

kernel.shmall = 4294967296

net.ipv4.tcp_max_tw_buckets = 6000

net.ipv4.ip_local_port_range = 9000 65500

net.ipv4.tcp_tw_recycle = 0

net.ipv4.tcp_tw_reuse = 1

net.core.somaxconn = 262144

net.core.netdev_max_backlog = 262144

net.ipv4.tcp_max_orphans = 262144

net.ipv4.tcp_max_syn_backlog = 262144

net.ipv4.tcp_synack_retries = 2

net.ipv4.tcp_syn_retries = 1

net.ipv4.tcp_fin_timeout = 1

net.ipv4.tcp_keepalive_time = 30

net.ipv4.tcp_keepalive_probes = 6

net.ipv4.tcp_keepalive_intvl = 5

net.ipv4.tcp_timestamps = 0

fs.aio-max-nr = 1048576

[root@orcltest Downloads]# sysctl –p

[root@orcltestDownloads]# groupadd oinstall

[root@orcltestDownloads]# groupadd dba

[root@orcltestDownloads]# groupadd oper

[root@orcltestDownloads]# useradd -g oinstall -G dba,oper oracle

[root@orcltestDownloads]# passwd oracle

[root@orcltestDownloads]# vim /etc/security/limits.conf

oracle soft nproc 2047 

oracle hard nproc 16384                        

oracle soft nofile 1024

oracle hard nofile 65536

[root@orcltestDownloads]# vim /etc/pam.d/login

session required/lib64/security/pam_limits.so

 [root@orcltest Downloads]# vim /etc/profile               

# add by tim.man

if [ $USER = "oracle" ]; then

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

 ulimit -p 16384

 ulimit -n 65536

else

 ulimit -u 16384 -n 65536

fi

fi

[oracle@orcltest ~]$ vim .bash_profile

export EDITOR=vi

export ORACLE_SID=doea5db

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

export INVENTORY_LOCATION=/oraInventory

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export NLS_LANG="American_america.zhs16gbk"

export NLS_DATE_FORMAT='yyyy-mm-dd hh34:mi:ss'

export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin:$PATH:$HOME/bin

umask 022

[oracle@orcltest ~]$ source .bash_profile

[root@orcltest~]# mkdir /data/oracle

[root@orcltest~]# chown oracle:oinstall /data

 

[root@azure_earth_dbm1_3_112 app]# mkdir /data/oracle

[root@azure_earth_dbm1_3_112 app]# mkdir /data/oraInventory

[root@azure_earth_dbm1_3_112 app]# cd /oracle/app

[root@azure_earth_dbm1_3_112 app]# ln -s /data/oracle oracle

[root@azure_earth_dbm1_3_112 app]# ln -s /data/oraInventory oraInventory               

[root@azure_earth_dbm1_3_112 app]# chown -R oracle.oinstall /data

[root@azure_earth_dbm1_3_112 app]# chown -R oracle.oinstall /oracle

[root@azure_earth_dbm1_3_112 app]#

[root@ azure_earth_dbm1_3_112 oracle]# mkdir -p /oracle/app/oracle

[root@ azure_earth_dbm1_3_112 oracle]# chown -R oracle:oinstall /oracle/app/oracle

[root@ azure_earth_dbm1_3_112 oracle]# chmod -R 775 /oracle/app/oracle

[root@ azure_earth_dbm1_3_112 oracle]#

# 采用yum安装，如下：
yum install -y binutils*

yum install -y compat-libstdc*

yum install -y elfutils-libelf*

yum install -y gcc*

yum install -y glibc*

yum install -y ksh*

yum install -y libaio*

yum install -y libgcc*

yum install -y libstdc*

yum install -y make*

yum install -y sysstat*

 

yum install libXp* -y

yum install -y glibc-kernheaders

 

# 检查下lib是否安装齐全：

[root@powerlong4 ~]# rpm -q --queryformat %-{name}-%{version}-%{release}-%{arch}"\n" \ compat-libstdc++-33 glibc-kernheaders glibc-headers libaio libgcc glibc-devel xorg-x11-deprecated-libs

[root@azure_earth_dbm1_3_112 ~]# exportDISPLAY=10.254.3.112:1.0

[root@azure_earth_dbm1_3_112 ~]# xhost +

access control disabled, clients canconnect from any host

[root@azure_earth_dbm1_3_112 ~]#

[oracle@azure_earth_dbm1_3_111 database]$./runInstaller

"You are attempting to install 64-bitOracle on a 32-bit operating system. This is not supported and will not work."

[oracle@azure_earth_dbm1_3_111 database]$vim runInstaller

# 注释掉exit 126即可

 

if [ `$UNAME` = "Linux" ]; then

 if [ -e $GETCONF ]; then

 value=`$GETCONF LONG_BIT`

 if [ $value != 64 ]; then

  echo "\"You are attempting to install 64-bit Oracle on a32-bit operating system. This is notsupported and will not work.\"";

  #exit 126; #corresponding to the exit code of oui

 fi

 fi

fi

# 查找文件路径

[oracle@azure_earth_dbm1_3_111 database]$ find /data/ -name orainstRoot.sh

/data/oraInventory/orainstRoot.sh

[oracle@azure_earth_dbm1_3_111 database]$ find /data/ -name root.sh

/data/oracle/product/11.2.0/dbhome_1/inventory/Templates/root.sh

/data/oracle/product/11.2.0/dbhome_1/root.sh

[oracle@azure_earth_dbm1_3_111 database]$

 

# 开始执行脚本

[root@azure_earth_dbm1_3_111 soft]# sh /data/oraInventory/orainstRoot.sh

Changing permissions of /oracle/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

 

Changing groupname of /oracle/app/oraInventory to oinstall.

The execution of the script is complete.

[root@azure_earth_dbm1_3_111 soft]#

 

[root@azure_earth_dbm1_3_111 soft]# sh /data/oracle/product/11.2.0/dbhome_1/root.sh

Performing root user operation for Oracle 11g

 

The following environment variables are set as:

 ORACLE_OWNER= oracle

 ORACLE_HOME= /oracle/app/oracle/product/11.2.0/dbhome_1

 

Enter the full pathname of the local bin directory: [/usr/local/bin]: 

 Copying dbhome to /usr/local/bin ...

 Copying oraenv to /usr/local/bin ...

 Copying coraenv to /usr/local/bin ...

 

 

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

[root@azure_earth_dbm1_3_111 soft]#

[root@azure_earth_dbm1_3_112 ~]# exportDISPLAY=192.168.3.112:1.0

[root@azure_earth_dbm1_3_112 ~]# xhost +

access control disabled, clients canconnect from any host

[root@azure_earth_dbm1_3_112 ~]#

[oracle@azure_earth_dbm1_3_111 database]$ dbca

# 修改spfile参数

SQL> alter system set log_archive_dest_1='location=/doea5/arch';

SQL> alter system set log_archive_format='arch_%t_%s_%r.log' scope=spfile;

SQL> alter system set db_recovery_file_dest_size=20G scope=spfile;

SQL> alter system set db_recovery_file_dest='/oracle/app/oracle/flash_recovery';                                

SQL> alter system set db_flashback_retention_target=10080 scope=spfile;

SQL> alter system set undo_retention=10800;

# 打开归档和闪回

SQL> shutdown immediate

SQL> startup mount

SQL> alter database archivelog ;

SQL> alter database flashback on;

SQL> alter database open;

[root@pddbnew ~]# export DISPLAY=10.251.3.31:1.0
[root@pddbnew ~]# xhost +
xhost: unable to open display "10.251.3.31:1.0"
[root@pddbnew ~]# 
[root@pddbnew ~]# 
[root@pddbnew ~]# export DISPLAY=pddbnew:1.0
[root@pddbnew ~]# xhost +
xhost: unable to open display "pddbnew:1.0"
[root@pddbnew ~]#