linux本位安装oracleg

1、rootoracle # vi /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1 localhost.localdomain localhosts92 oracle查看oracle11g要求安装的软件包，安装rpm -ivh binutils-.0.6-9.el5.i386.rpmrpm -ivh compat-libstdc+-33-61.i386.rpmrpm -ivh elfutils-libel

2、f-0.137-3.el5.i386.rpmpmrpm -ivh gcc-44.el5.i386.rpmrpm -ivh gcc-c+-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-44.el5.i386.rpmrpm -ivh libstdc+-rpm -ivh libstdc+-devel-44.el5.i386.rpmrpm -ivh make-3.81-3.el5.i386.rpm rpm -ivh sysstat-

3、rpm -ivh unixODBC-rpm -ivh unixODBC-devel-查看软件包是否安装完rootlocalhost Server# rpm -qa | grep binutilsbinutils-rootlocalhost Server# rpm -qa | grep compat-libstdccompat-libstdc+-296-2.96-138compat-libstdc+-33-61rootlocalhost Server# rpm -qa | grep elfutils-libelf rootlocalhost Server# rpm -qa | grep elfu

4、tils-libelf-develrootlocalhost Server# rpm -qa | grep gcccompat-libgcc-296-2.96-138gcc-gfortran-44.el5libgcc-44.el5gcc-c+-44.el5gcc-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 libaiorootloca

5、lhost Server# rpm -qa | grep libstdccompat-libstdc+-296-2.96-138compat-libstdc+-33-61libstdc+-devel-44.el5libstdc+-44.el5rootlocalhost Server# rpm -qa | grep makeautomake-2.1imake-3automake14-1.4p6-13automake17-7automake16-8automake15-1.5-16rootlocalhost Server# rpm -qa | grep sysstatsysstat-3.el5ro

6、otlocalhost Server# rpm -qa | grep unixODBCunixODBC-7.1rootlocalhost Server# rpm -qa | grep unixODBC-develunixODBC-devel-7.1查看参数是否满足要求：rootoracle # /sbin/sysctl -a | grep semkernel.sem = 250 32000 32 128rootoracle # rootoracle # /sbin/sysctl -a | grep shmvm.hugetlb_shm_group = 0kernel.shmmni = 4096k

7、ernel.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.co

8、re.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 128n

9、et.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_

10、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.

11、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: pa

12、sswd: 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

13、参数文件oraclelocalhost $ vi .bash_profileORACLE_SID=sdzyORACLE_BASE=/db/oracleORACLE_HOME=$ORACLE_BASE/product/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

14、 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&q

15、uot; ; 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 dbconso

16、le启动和停止iSQL*Plus    isqlplusctl start    isqlplusctl stop启动和停止数据库  启动：   sqlplus   Enter usr-name: / as syadba   SQL>startup  停止：   SQL>shutdown immediate似乎上面的命令不行，来先让我们做的别的又是一个11g的bug，在安装完数据库后，启动sqlplus命令，会发现下面的错误

17、：oracle* $ sqlplus "/ as sysdba"sqlplus: 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* # getenforceEnforcingroot* # setenforce 0root*