Ubuntu_12.04+Oracle 11g r2

1、Ubuntu 12.04(64bit) server 安装 Oracle 11G 1.首先，将系统更新到最新，时间可能有点久sudo apt-get updatesudo apt-get dist-upgrade2.由于oracle的安装需要用到图形操作界面，需要在ubuntu server上按图形界面程序sudo apt-get install gnome-core3.oracle需要许多相关环境的支持，安装依赖包sudo apt-get install automake sudo apt-get install autotools-devsudo apt-get install binut

2、ilssudo apt-get install bzip2sudo apt-get install doxygensudo apt-get install elfutilssudo apt-get install expatsudo apt-get install gawksudo apt-get install gccsudo apt-get install gcc-multilibsudo apt-get install g+-multilibsudo apt-get install ia32-libssudo apt-get install kshsudo apt-get install

3、 lesssudo apt-get install lesstif2sudo apt-get install lesstif2-devsudo apt-get install lib32z1sudo apt-get install libaio1sudo apt-get install libaio-devsudo apt-get install libc6-devsudo apt-get install libc6-dev-i386sudo apt-get install libc6-i386 sudo apt-get install libelf-devsudo apt-get insta

4、ll libltdl-devsudo apt-get install libmotif4sudo apt-get install libodbcinstq4-1 libodbcinstq4-1:i386sudo apt-get install libpth-devsudo apt-get install libpthread-stubs0sudo apt-get install libpthread-stubs0-devsudo apt-get install libstdc+5sudo apt-get install lsb-cxxsudo apt-get install makesudo

5、apt-get install openssh-serversudo apt-get install pdkshsudo apt-get install rlwrapsudo apt-get install rpmsudo apt-get install sysstatsudo apt-get install unixodbcsudo apt-get install unixodbc-devsudo apt-get install unzipsudo apt-get install x11-utilssudo apt-get install zlibc4.创建用户sudo groupadd o

6、installsudo groupadd dbasudo mkdir -p /opt/oraclesudo useradd -g oinstall -G dba -d /opt/oracle -s /bin/bash oraclesudo passwd oraclesudo chown -R oracle:oinstall /opt/oracle5.检查系统变量/sbin/sysctl -a | grep sem/sbin/sysctl -a | grep shm/sbin/sysctl -a | grep file-max/sbin/sysctl -a | grep aio-max/sbin

7、/sysctl -a | grep ip_local_port_range/sbin/sysctl -a | grep rmem_default/sbin/sysctl -a | grep rmem_max/sbin/sysctl -a | grep wmem_default/sbin/sysctl -a | grep wmem_max然后根据结果在/etc/sysctl.conf中增加对应数据fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.sh

8、mmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586运行一下命令更新内核参数sysctl p6.添加对oracle用户的内核限制在 /etc/security/limits.conf 文件中增加以下数据oracle soft nproc 2047oracle

9、hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 10240其中oracle是在第四步中创建的用户，跳过第四步的话就写当前用户查看/etc/pam.d/login，增加以下行（有了就不用增加了）session required pam_limits.so同样检查/etc/pam.d/su，没有以下行就自己加上session required pam_limits.so7.创建需要的文件夹（用于安装oracle）mkdir -p /opt/oraclemkdir -p /opt/ora

10、Inventory然后用 chmod -R 命令将Oracle的所有者和用户组设置成自己的用户8.配置环境变量在/.bashrc中增加以下环境变量#这个写刚刚创建的文件夹export ORACLE_BASE= /opt/oracle #这个后面可以随便填写export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1#数据库的sidexport ORACLE_SID=”orcl”#默认字符集export NLS_LANG=.AL32UTF89.oracle本身并不支持ubuntu来安装，所以要进行欺骗oracle的安装程序mkdir /usr/l

11、ib64ln -s /etc /etc/rc.dln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /lib64/ln -s /usr/bin/awk /bin/awkln -s /usr/bin/basename /bin/basenameln -s /usr/bin/rpm /bin/rpmln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib64/ln -s /usr/lib/x86_64-linux-gnu/libstdc+.so.6 /lib64/ln -s /usr/lib/x86_64-l

12、inux-gnu/libstdc+.so.6 /usr/lib64/echo Red Hat Linux release 5 > /etc/redhat-release10. Oracle 11g需要 libstdc+5 in 32bits version，但ubuntu并不提供，所以需要自己去下载安装，可以参考howto to install libstdc+5 on Ubuntu Karmicmkdir /tmp/libstdc+5cd /tmp/libstdc+5去http:/ubuntu-cd.reacciun.ve/trisquel/pool/extras/g/

13、60; 下载放这里libstdc+5_3.3.6-17ubuntu1_amd64.deb libstdc+5_3.3.6-17ubuntu1_i386.debsudo dpkg -force-architecture -i libstdc+5_3.3.6-17ubuntu1_i386.debsudo mv /usr/lib/libstdc+.so.5* /usr/lib32/sudo dpkg -i libstdc+5_3.3.6-17ubuntu1_amd64.deb11. 下载oracle安装程序 download Oracle 11gR2 Enterprise/Standard

14、 Edition for Linux x86-64 ，下载linux.x64_11gR2_database_1of2.zip，linux.x64_11gR2_database_2of2.zipunzip linux.x64_11gR2_database_1of2.zipunzip linux.x64_11gR2_database_2of2.zip运行安装程序，运行vncview (本安装是基于openstack平台虚拟机的，所以直接点击实例vnc 控制平台即可进行图形化安装)oracle用户连接ubuntu12.04 servercd /XXX/database./ runInsta

15、ller11.安装遇到问题案例解决方案如下问题一解决步骤：Sudo vi $ORACLE_HOME/sysman/lib/ins_emagent.mkSearch for the line$(MK_EMAGENT_NMECTL)Change it to:$(MK_EMAGENT_NMECTL) -lnnz11然后retry通过，之后可能遇到如下情况解决方案：依次执行如下步骤sed -i 's/(TNSLSNR_LINKLINE.*$(TNSLSNR_OFILES) ($(LINKTTLIBS)/1 -Wl,-no-as-needed 2/g' $ORACLE_HOME/netw

16、ork/lib/env_network.mksed -i 's/(ORACLE_LINKLINE.*$(ORACLE_LINKER) ($(PL_FLAGS)/1 -Wl,-no-as-needed 2/g' $ORACLE_HOME/rdbms/lib/env_rdbms.mksed -i 's/($LD $LD_RUNTIME) ($LD_OPT)/1 -Wl,-no-as-needed 2/g' $ORACLE_HOME/bin/genorasdkshsed -i 's/(s*)($(OCRLIBS_DEFAULT)/1 -Wl,-no-as-ne

17、eded 2/g' $ORACLE_HOME/srvm/lib/ins_srvm.mk上面两个问题是在ubuntu 64位上安装oracle11出现的最典型的问题了，这两个问题解决了，基本上就可以顺利安装了12.接下来按照图形安装提示执行如下步骤即可成功完成安装sudo /opt/oracle/oraInventory/orainstRoot.shsudo /opt/oracle/Oracle11gee/product/11.2.0/dbhome_1/root.sh你可以通过https:/localhost:1158/em进行网络访问Error in invoking target &

18、#39;client_sharedlib' of makefile '/u01/app/oracle/product/10.2.0/db_1/network Exception String: Error in invoking target 'client_sharedlib' of makefile '/u01/app/oracle/product/10.2.0/db_1/network/lib/ins_net_client.mk'. See'/u01/app/oracle/oraInventory/logs/installActions2012-02-21_11-03-51AM.log' for details.1. cd $ORACLE_HOME/bin2. cp gennttab gennttab_orig3. vi gennttab将这段配置中的112改成96修改前：ntcontab:  &