linux 53版本安装oracle11g.doc

rootoracle # vi /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail. localhost.localdomain localhosts92 oracle查看oracle11g要求安装的软件包，安装rpm -ivh binutils-.6-9.el5.i386.rpmrpm -ivh compat-libstdc+-33-3.2.3-61.i386.rpmrpm -ivh elfutils-libelf-0.137-3.el5.i386.rpmrpm -ivh elfutils-libelf-devel-0.137-3.el5.i386.rpmrpm -ivh glibc-common-2.5-34.i386.rpmrpm -ivh glibc-devel-2.5-34.i386.rpmrpm -ivh glibc-headers-2.5-34.i386.rpmrpm -ivh gcc-4.1.2-44.el5.i386.rpmrpm -ivh gcc-c+-4.1.2-44.el5.i386.rpmrpm -ivh libaio-0.3.106-3.2.i386.rpmrpm -ivh libaio-devel-0.3.106-3.2.i386.rpmrpm -ivh libgcc-4.1.2-44.el5.i386.rpmrpm -ivh libstdc+-4.1.2-44.el5.i386.rpmrpm -ivh libstdc+-devel-4.1.2-44.el5.i386.rpmrpm -ivh make-3.81-3.el5.i386.rpm rpm -ivh sysstat-7.0.2-3.el5.i386.rpmrpm -ivh unixODBC-2.2.11-7.1.i386.rpmrpm -ivh unixODBC-devel-2.2.11-7.1.i386.rpm查看软件包是否安装完rootlocalhost Server# rpm -qa | grep binutilsbinutils-.6-9.el5rootlocalhost Server# rpm -qa | grep compat-libstdccompat-libstdc+-296-2.96-138compat-libstdc+-33-3.2.3-61rootlocalhost Server# rpm -qa | grep elfutils-libelfelfutils-libelf-0.137-3.el5elfutils-libelf-devel-0.137-3.el5elfutils-libelf-devel-static-0.137-3.el5 rootlocalhost Server# rpm -qa | grep elfutils-libelf-develelfutils-libelf-devel-0.137-3.el5elfutils-libelf-devel-static-0.137-3.el5rootlocalhost Server# rpm -qa | grep gcccompat-libgcc-296-2.96-138gcc-gfortran-4.1.2-44.el5libgcc-4.1.2-44.el5gcc-c+-4.1.2-44.el5gcc-4.1.2-44.el5rootlocalhost Server# rpm -qa | grep glibcglibc-2.5-34glibc-devel-2.5-34glibc-common-2.5-34glibc-headers-2.5-34rootlocalhost Server# rpm -qa | grep libaiolibaio-devel-0.3.106-3.2libaio-0.3.106-3.2rootlocalhost Server# rpm -qa | grep libstdccompat-libstdc+-296-2.96-138compat-libstdc+-33-3.2.3-61libstdc+-devel-4.1.2-44.el5libstdc+-4.1.2-44.el5rootlocalhost Server# rpm -qa | grep makeautomake-1.9.6-2.1imake-1.0.2-3automake14-1.4p6-13automake17-1.7.9-7automake16-1.6.3-8automake15-1.5-16make-3.81-3.el5rootlocalhost Server# rpm -qa | grep sysstatsysstat-7.0.2-3.el5rootlocalhost Server# rpm -qa | grep unixODBCunixODBC-2.2.11-7.1rootlocalhost Server# rpm -qa | grep unixODBC-develunixODBC-devel-2.2.11-7.1查看参数是否满足要求：rootoracle # /sbin/sysctl -a | grep semkernel.sem = 250 32000 32 128rootoracle # rootoracle # /sbin/sysctl -a | grep shmvm.hugetlb_shm_group = 0kernel.shmmni = 4096kernel.shmall = 268435456kernel.shmmax = 4294967295rootoracle # rootoracle # /sbin/sysctl -a | grep file-maxfs.file-max = 120571rootoracle # rootoracle # /sbin/sysctl -a | grep ip_local_port_rangenet.ipv4.ip_local_port_range = 32768 61000rootoracle # rootoracle # /sbin/sysctl -a | grep rmem_maxnet.core.rmem_max = 131071rootoracle # rootoracle # /sbin/sysctl -a | grep wmem_defaultnet.core.wmem_default = 109568rootoracle # rootoracle # /sbin/sysctl -a | grep wmem_maxnet.core.wmem_max = 131071rootoracle #修改内核参数在/etc/启动文件，输入以下内容：rootlocalhost Server# vi /etc/sysctl.confkernel.sem=250 32000 100 128net.ipv4.ip_local_port_range=1024 65000net.core.rmem_default=4194304net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=262144rootlocalhost # sysctl -pnet.ipv4.ip_forward = 0net.ipv4.conf.default.rp_filter = 1net.ipv4.conf.default.accept_source_route = 0kernel.sysrq = 0kernel.core_uses_pid = 1net.ipv4.tcp_syncookies = 1kernel.msgmnb = 65536kernel.msgmax = 65536kernel.shmmax = 4294967295kernel.shmall = 268435456kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 262144创建oracle用户和组及安装目录rootlocalhost # groupadd oinstallrootlocalhost # groupadd dbarootlocalhost # useradd -g oinstall -G dba oraclerootlocalhost # passwd oracleChanging password for user oracle.New UNIX password: BAD PASSWORD: it is based on a dictionary wordRetype new UNIX password: passwd: all authentication tokens updated successfully.验证nobody用户:rootlocalhost # id nobodyuid=99(nobody) gid=99(nobody) groups=99(nobody) 创建创建安装目录并赋予权限rootlocalhost # mkdir -p /dbrootlocalhost # chown -R oracle:oinstall /db创建软件存放目录oraclelocalhost $ mkdir /db/sw为oracle用户设置环境变量用文本编辑器vi编辑 .bash_profile 参数文件oraclelocalhost $ vi .bash_profileORACLE_SID=sdzyORACLE_BASE=/db/oracleORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1export ORACLE_SID ORACLE_BASE ORACLE_HOMEPATH=$PATH:/$ORACLE_HOME/bin:$HOME/bin为oracle用户设置Shell限制在/etc/security/limits.conf文件中输入以下内容：rootlocalhost # vi /etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536在/etc/pam.d/login文件中输入以下内容rootlocalhost # vi /etc/pam.d/loginsession required /lib/security/pam_limits.so在/etc/profile文件中输入以下内容rootlocalhost # vi /etc/profileif $USER=oracle ; then if $SHELL=/bin/ksh ; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fifi上传数据库软件到/db/sw目录以oracle用户上传并解压数据库软件注销用oracle用户登陆# netca启动和停止监听： lsnrctl start lsnrctl stop启动和停止Oracle Enterprise Manager: emctl start dbconsole emctl stop dbconsole启动和停止iSQL*Plus isqlplusctl start isqlplusctl stop启动和停止数据库 启动： sqlplus Enter usr-name: / as sysdba SQLstartup 停止： SQLshutdown immediate似乎上面的命令不行，来先让我们做的别的又是一个11g的bug，在安装完数据库后，启动sqlplus命令，会发现下面的错误：oracle* $ sqlplus / as sysdbasqlplus: error while loading shared libraries: /data/oracle/product/11.1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied这个问题发生在ORACLE ENTERPRISE Linux R5上，无论是32位还是64位都存在这个问题。第一次在安装32位的ORACLE 11G for Linux的时候也碰到了，当时没有记录下来，这次特意查询了一下Metalink，Oracle在metalink的文档：Doc ID: Note:454196.1中对于问题进行了详细的描述。最简单的解决方法莫过于将SELinux设置位PERMISSIVE状态：切记：切换用户用su - rootroot* #