& & VM虚拟机下在LINUX上安装ORACLE 11G单实例数据库& & 1.环境及安装前规划：虚拟机及OS如下& & 环境：VMware Wordstation ACE版 6.0.2& & 操作系统：OracleLinux-R5-U8-Server-i386-dvd&&3.2G& & 安装操作系统，这里需要注意的是磁盘空间要预留足够。& & 我的规划是：& & 虚拟机分配1024M内存，当然如果主机内存足够，安装时内存设置2048M可以更快。& & 虚拟机分配一块磁盘，30G磁盘空间。& & /boot 100M ext3& & /&&20G&ext3& & swap 2048M& & 剩余的近8G空间留着做ASM时用。& & 同时最好安装系统时选择图形模式安装，直接安装好图形模式，比较省事。& & 2.OS的配置：& & 操作系统安装好后，暂时需要配置以下内容& & 固定IP及DNS /etc/sysconfig/network-scripts/ifcfg-eth0& & 主机名&/etc/sysconfig/network& & 修改开机运行级别 /etc/inittab& & 关闭SELINUX /boot/grub/menu.lst& & 修改sshd_config，解决SSH超时自动断开问题& & login as: root& & root@192.168.1.212's password:& & Last login: Wed Jun&5 09:11:26 2013& & [root@oel-01 ~]# hostname& & oel-01& & [root@oel-01 ~]# cat/etc/sysconfig/network-scripts/ifcfg-eth0& & # Advanced Micro Devices [AMD] 79c970[PCnet32 LANCE]& & DEVICE=eth0& & BOOTPROTO=none& & HWADDR=00:0C:29:99:8B:C9& & NBOOT=yes& & NETMASK=255.255.255.128& & IPADDR=192.168.1.212& & GATEWAY=192.168.1.254& & TYPE=Ethernet& & USERCTL=no& & IPV6INIT=no& & PEERDNS=yes& & [root@oel-01 ~]# cat /etc/resolv.conf& & nameserver 222.88.88.88& & [root@oel-01 ~]# cat /etc/sysconfig/network& & NETWORKING=yes& & NETWORKING_IPV6=yes& & HOSTNAME=oel-01& & [root@oel-01 ~]# vi /etc/inittab& & id:3:initdefault:& & [root@oel-01 ~]# vi /boot/grub/menu.lst& & 在kernel 行末尾增加selinux=0关闭SELINUX。也可以在安装完系统时的图形配置界面中关闭。& & [root@oel-01 ~]# cd /etc/ssh/& & [root@oel-01 ssh]# grep"ClientAlive" sshd_config& & #ClientAliveInterval 0& & #ClientAliveCountMax 3& & [root@oel-01 ssh]# cp sshd_configsshd_config.bak& & [root@oel-01 ssh]# sed -i"s/#ClientAliveInterval 0/ClientAliveInterval 60/g" sshd_config& & [root@oel-01 ssh]# grep"ClientAlive" sshd_config& & ClientAliveInterval 60& & #ClientAliveCountMax 3& & [root@oel-01 ssh]# sed -i"s/#ClientAliveCountMax 3/ClientAliveCountMax 10/g" sshd_config& & [root@oel-01 ssh]# grep"ClientAlive" sshd_config& & ClientAliveInterval 60& & ClientAliveCountMax 10& & [root@oel-01 ssh]# service sshd restart& & Stopping sshd:&&&&&&&&&&&&&&&&&&&&&&[&OK&]& & Starting sshd:&&&&&&&&&&&&&&&&&&&&&&[&OK&]& & 到此应该将系统重启，验证以上各项配置是否生效。如生效，关机，在VMWARE中做快照& & 3.创建安装ORACLE的用户组& & [root@oel-01 ~]# groupadd -g 1000 oinstall& & [root@oel-01 ~]# groupadd -g 1031 dba& & [root@oel-01 ~]# groupadd -g 1032 oper& & [root@oel-01 ~]# useradd oracle& & [root@oel-01 ~]# passwd oracle& & Changing password for user oracle.& & New UNIX password:& & BAD PASSWORD: it is based on a dictionaryword& & Retype new UNIX password:& & passwd: all authentication tokens updatedsuccessfully.& & [root@oel-01 ~]# usermod -g oinstall -Gdba,oper oracle& & [root@oel-01 ~]# mkdir -p/u01/app/oracle/product/11.2.0/dbhome_1& & [root@oel-01 ~]# chown -R oracle:oinstall/u01/& & [root@oel-01 ~]# chmod 775 /u01/& & [root@oel-01 app]# pwd& & /u01/app& & [root@oel-01 app]# ls -al& & total 16& & drwxrwxr-x 4 oracle oinstall 4096 Jun&5 10:56 .& & drwxrwxr-x 3 oracle oinstall 4096 Jun&5 10:55 ..& & drwxrwxr-x 2 oracle oinstall 4096 Jun&5 10:55 oracle& & 4.挂载光盘，安装软件& & [root@oel-01 ~]# cd /etc/yum.repos.d/& & [root@oel-01 yum.repos.d]# ls& & [root@oel-01 yum.repos.d]# viOEL_CDROM.repo& & [root@oel-01 yum.repos.d]# catOEL_CDROM.repo& & [OEL5.8]& & name=oracle linux& & baseurl=file:///mnt/cdrom/Server& & enabled=1& & gpgcheck=0& & [root@oel-01 yum.repos.d]# cd /mnt/& & [root@oel-01 mnt]# mkdir cdrom& & [root@oel-01 mnt]# mount /dev/cdrom/mnt/cdrom& & mount: block device /dev/cdrom iswrite-protected, mounting read-only& & [root@oel-01 mnt]# ls& & cdrom& & [root@oel-01 mnt]# cd cdrom/& & [root@oel-01 cdrom]# ls& & blafdoc.css&&eula.py&README-en.html&&&&Server& & Cluster&&&&GPL&&&&RELEASE-NOTES-en&&&supportinfo& & ClusterStorage&images&&RELEASE-NOTES-en.html&TRANS.TBL& & EULA&&&&&&isolinux&RPM-GPG-KEY&&&&&&VT& & eula.en_US&&&README-en RPM-GPG-KEY-oracle& & [[root@oel-01 Server]# pwd& & /mnt/cdrom/Server& & [root@oel-01 Server]# ls /etc/pki/rpm-gpg/& & RPM-GPG-KEY&&&RPM-GPG-KEY-fedora&&&RPM-GPG-KEY-oracle& & RPM-GPG-KEY-EL4&RPM-GPG-KEY-fedora-test& & [root@oel-01 Server]# rpm --import/etc/pki/rpm-gpg/RPM-GPG-KEY-oracle& & 开始安装软件& & 方法一：& & [root@oel-01 Server]# yum -y installoracleasm-support-2.1.7-1.el5.i386.rpm& & [root@oel-01 Server]# yum -y installreadline-devel-5.1-3.el5.i386.rpm& & [root@oel-01 Server]# yum -y installunixODBC& & [root@oel-01 Server]# yum -y install&make* gcc* glibc* compat-db* compat-gcc*compat-gcc* compat-libstdc++* compat-libstdc* openmotif* setarch*& & [root@oel-01 Server]# yum -y installelfutils-libelf-devel-* libaio-devel-0.3.106-5.i386.rpm&sysstat-7.0.2-11.el5.i386.rpm unixODBC-devel-2.2.11-10.el5.i386.rpm& & 安装rlwrap-0.37.tar.gz,这里我也是上传上去的，这个软件可以在网上自己找。& & [root@oel-01 ~]# ls& & anaconda-ks.cfg&install.log&&&&rlwrap-0.37& & Desktop&&&&&install.log.syslog&rlwrap-0.37.tar.gz& & [root@oel-01 ~]# tar -zxvfrlwrap-0.37.tar.gz& & [root@oel-01 rlwrap-0.37]# pwd& & /root/rlwrap-0.37& & [root@oel-01 rlwrap-0.37]# ./configure& & [root@oel-01 rlwrap-0.37]# make& & [root@oel-01 rlwrap-0.37]# make install& & 方法二：批量安装& & 挂载光盘后& & [root@oel-01 mnt]#mkdir cdrom& & [root@oel-01 mnt]# mount /dev/cdrom/mnt/cdrom/& & mount: block device /dev/cdrom is write-protected, mounting read-only& & [root@oel-01 mnt]# cd /etc/yum.repos.d/& & [root@oel-01 yum.repos.d]# vi public-yum-el5.repo& & [oel5]& & name = Enterprise Linux 5.7 DVD& & baseurl=file:///mnt/cdrom/Server/& & gpgcheck=0& & enabled=1& & [root@oel-01 yum.repos.d]# yum installoracle-validated& & 如果是OEL5: yum install oracle-validated& & 如果是OEL6: yum install oracle-rdbms-server-11gR2-preinstall& & 5.修改LINUX中的环境变量& & 修改oracle的.bash_profile，示例如下：oracle_sid之类要提前规划好。& & [root@oel-01 oracle]# pwd& & /home/oracle& & [root@oel-01 oracle]# cat .bash_profile& & if [ -f ~/.bashrc ]; then& & . ~/.bashrc& & fi& & PATH=$PATH:$HOME/bin& & #after is add by admin.& & #& & ORACLE_SID=bys001& & ORACLE_BASE=/u01/app/oracle& & ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1& & PATH=$ORACLE_HOME/bin:$PATH:/user/sbin& & export ORACLE_BASE ORACLE_SID ORACLE_HOMEPATH& & LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib:/usr/X11R6/lib/& & exportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib& & alias sqlplus='rlwrap sqlplus'& & alias rman='rlwrap rman'& & 使用ORACLE用户验证下& & [oracle@oel-01 ~]$ source .bash_profile& & [oracle@oel-01 ~]$ sqlplus& & rlwrap: Cannot execute sqlplus: No suchfile or directory& & [oracle@oel-01 ~]$ rman& & rlwrap: Cannot execute rman: No such fileor directory& & 说明：其它的内核参数等可以不修改，在安装时检查系统环境时可以使用ORACLE给出的脚本进行修改，我这里就用的这种方法。& & 6.把ORACLE DATABASE软件上传并解压& & 我这里使用的是SSH Secure Shell.这个软件里的传文件功能& & 注意要用ORACLE用户上传并解压文件，避免文件权限问题。& & [oracle@oel-01 u01]$ ls& & app&&&&&&&&&&&&&linux_11gR2_database_2of2.zip& & linux_11gR2_database_1of2.zip& & [oracle@oel-01 u01]$ du -sh /u01/linux*& & 1.2G&/u01/linux_11gR2_database_1of2.zip& & 951M&/u01/linux_11gR2_database_2of2.zip& & [oracle@oel-01 u01]$ unziplinux_11gR2_database_1of2.zip& & [oracle@oel-01 u01]$ unziplinux_11gR2_database_2of2.zip& & 解压后删除原压缩文件节省磁盘空间& & [oracle@oel-01 u01]$ du -sh database/& & 2.3G&database/& & [oracle@oel-01 u01]$ rm -rf linux_11gR2_*& & [oracle@oel-01 u01]$ ls& & app database& & [oracle@oel-01 u01]$& & 到此，关机，做一次快照。安装前准备工作完成。& & 7.使用OUI图形界面安装& & [root@oel-01 ~]# init 5& & ORACLE软件的安装& & 去图形界面，使用oracle用户登陆，然后在桌面右键菜单中，打开一个命令行终端窗口& & [oracle@oel-01 ~]$ cd /u01/database/& & [oracle@oel-01 database]$ ls& & doc install&response&rpm runInstaller&sshsetup&stage welcome.html& & [oracle@oel-01 database]$ ./runInstaller& & 安装时的注意事项：& & 在安装时过程中，要查看ORACLE_BASE/HOME等是否正确。& & 在安装到检查安装环境时，会出现一些内核参数调整、缺少包（如果缺少包,按我这个说明上的环境及软件如果都安装的话是不会缺少包的）等提示。& & 根据提示框中 Fixable下有YES参数的，都是ORACLE可以自动修复的。& & 选择上方的FIX&CHECK AGAIN。& & 这时打开一个终端，注意要使用root用户.根据对话框提示，打开一个终端输入下面：& & [root@oel-01 ~]# sh/tmp/CVU_11.2.0.1.0_oracle/runfixup.sh& & Response file being used is :/tmp/CVU_11.2.0.1.0_oracle/fixup.response& & Enable file being used is:/tmp/CVU_11.2.0.1.0_oracle/fixup.enable& & Log file location:/tmp/CVU_11.2.0.1.0_oracle/orarun.log& & Setting Kernel Parameters...& & kernel.sem = 250 8& & fs.file-max = 6815744& & net.ipv4.ip_local_port_range = & & net.core.rmem_default = 262144& & net.core.wmem_default = 262144& & net.core.rmem_max = 4194304& & net.core.wmem_max = 1048576& & fs.aio-max-nr = 1048576& & uid=501(oracle) gid=1000(oinstall)groups=1000(oinstall),1031(dba),1021(asmdba)& & [root@oel-01 ~]#& & 再点击对话框中OK选项。& & 此时重新检查，发现这些参数都自动修复了。& & 如果有未安装的包再进行安装并重新检查环境。& & 此时再进行检查，发现就SWAP SIZE未通过，这个可以直接选择IGNORE-ALL。& & 然后在下一步时检查一下配置是否正确，然后点击下一步进行安装。& & #######################################################& & 安装到启动NETCA时会出错，不能启动，需要打一个补丁& & 其实我的打了补丁还是不行，安装完成后手动修改了下LISTNER.ORA文件& & [INS-20802] Oracle Net ConfigurationAssistant failed& & Cause-The plug-in failed in its performmethod& & 解决方案：& & 需打名为p010_LINUX.zip的补丁。& & 出现此错误时，先不要关闭安装程序：& & 使用oracle用户上传和解压文件以及操作& & unzip p010_LINUX.zip& & cd 8670579& & /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatchapply -invPtrLoc /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc& & 其中/apps/oracle/product/11.2.0/db_1/为ORACLE_HOME，可使用$ORACLE_HOME代替& & 补丁打好后，点击安装程序的retry，继续安装即可。& & 查看系统中安装的补丁& & [oracle@orasrv 8670579]$/u01/app/oracle/OPatch/opatch lsinventory& & #########################################################& & 安装完成后根据提示运行以下两个脚本。& & [root@oel-01 Server]# sh/u01/app/oraInventory/orainstRoot.sh& & Changing permissions of/u01/app/oraInventory.& & Adding read,write permissions for group.& & Removing read,write,execute permissions forworld.& & Changing groupname of /u01/app/oraInventoryto oinstall.& & The execution of the script. is complete.& & [root@oel-01 Server]# sh/u01/app/oracle/product/11.2.0/dbhome_1/root.sh& & Running Oracle 11g root.sh script...& & The following environment variables are setas:& & ORACLE_OWNER= oracle& & ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1& & Enter the full pathname of the local bindirectory: [/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/oratabfile as needed by& & Database Configuration Assistant when adatabase is created& & Finished running generic part of root.shscript.& & Now product-specific root actions will beperformed.& & Finished product-specific root actions.& & 8.安装完成后续工作& & 1.防火墙开放1521端口& & [root@oel-01 ~]# iptables-I INPUT 1 -p tcp --dport 1521 -j ACCEPT& & [root@oel-01 ~]# /etc/rc.d/init.d/iptablessave& & Saving firewall rules to/etc/sysconfig/iptables:&&&[&OK&]& & [root@oel-01 ~]# services iptables restart& & -bash: services: command not found& & [root@oel-01 ~]# service iptablesrestart& & Flushing firewall rules:&&&&&&&&&&&&&&&[&OK&]& & Setting chains to policy ACCEPT:filter&&&&&&&&[&OK&]& & Unloading iptables modules:&&&&&&&&&&&&&&[&OK&]& & Applying iptables firewall rules:&&&&&&&&&&&[&OK&]& & Loading additional iptables modules: ip_conntrack_netbios_ns& & 2.配置LISTENER---如安装过程中已经正常配置完成可以不做。& & 安装完成后，启动LISTENER& & [oracle@oel-01 admin]$ lsnrctl start& & 输出的最后两句：& & The listener supports no services& & The command completed successfully& & 这样启动后远程连接会报错：& & oracle ORA-12514:TNS:listener does notcurrently know of service requested in connect descriptor& & 原因：数据库实例没注册到listener& & 在listener.ora里面添加了如下内容：--配置为静态监听。& & SID_LIST_LISTENER =& & (SID_LIST =& & (SID_DESC =& & (GLOBAL_DBNAME = orcl)& & (SID_NAME = orcl)& & )& & )& & 注：里面的orcl根据你安装的数据库实例名确定，我用此法解决了这个报错。& & 解决方法二：这个网上看的，我自己没使用，使用第一种就解决了。& & 这种应该是解决非动态注册问题的，要手动注册实例到listener& & 登录数据库：& & $sqlplus / as sysdba& & 显示服务名：& & SQL>show parameter service_names& & 强制注册服务：& & SQL>a& & 查看监听状态：& & $lsnrctl status& & 9.配置数据库开机自启动& & 安装好Oracle数据库后:执行 dbstart和dbshut会提示：& & [oracle@oracle11g ~]$ dbstart& & ORACLE_HOME_LISTNER is not SET, unable toauto-start Oracle Net Listener& & Usage:/u01/app/oracle/oracle/product/10.2.0/db_1/bin/dbstart ORACLE_HOME& & 错误原因是：dbstart和dbshut脚本文件中ORACLE_HOME_LISTNER的设置有问题，& & 分别打开两个文件找到：ORACLE_HOME_LISTNER=$1,（在文件开头,比较好找）修改为& & ORACLE_HOME_LISTNER=$ORACLE_HOME& & 修改后保存退出，问题已解决;& & 测试：& & 1.SQLPLUS能否启动，如不能，检查.bash_profile中环境变量&ORACLE_HOME&PATH等，按我的方法做就可以。& & 2.使用SQLPLUS登陆测试& & sqlplus / as sysdba& & 需要解锁SCOTT用户，并配置/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora& & [oracle@oel-01 admin]$ cat tnsnames.ora& & # tnsnames.ora Network Configuration File:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora& & # Generated by Oracle configuration tools.& & BYS001 =& & (DESCRIPTION =& & (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.212)(PORT = 1521))& & (CONNECT_DATA =& & (SERVER = DEDICATED)& & (SERVICE_NAME = bys001)& & )& & )& & sqlplus scott/tiger@bys001& & sqlplusscott/tiger@192.168.1.212:1521/bys001& & 3.正常情况下数据库实例未启动，此时用SYS登陆，启动数据库，看数据库能否启动& & 4.实现开机ORACLE自动启动监听和实例& & 第一步:修改/etc/oratab文件，命令如下：& & 格式如下：& & --------------------------------------------------------------------------------& & SID:ORACLE_HOME:AUTO& & --------------------------------------------------------------------------------& & [oracle@oracle11g ~]$ vi /etc/oratab& & 添加或修改成（默认好像是N）这一句：& & bys001:/u01/app/oracle/product/11.2.0/dbhome_1/:Y& & [root@oel-01 ~]# cat /etc/oratab& & bys001:/u01/app/oracle/product/11.2.0/dbhome_1:Y& & 第二步:把lsnrctl start和dbstart添加到rc.local文件中,命令如下:& & [oracle@oracle11g ~]$ vi /etc/rc.d/rc.local& & 添加如下内容：& & su oracle -lc"/u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start"& & su oracle -lc"/u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart"& & [root@oel-01 ~]# cat /etc/rc.d/rc.local& & #!/bin/sh& & #& & # This script. will be executed *after* allthe other init scripts.& & # You can put your own initialization stuffin here if you don't& & # want to do the full Sys V style. initstuff.& & touch /var/lock/subsys/local& & su oracle -lc"/u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start"& & su oracle -lc "/u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart"& & 第三步，重启后直接用SQLPLUS登陆测试数据库是否已经打开哈哈。
声明：该文章系网友上传分享，此内容仅代表网友个人经验或观点，不代表本网站立场和观点；若未进行原创声明，则表明该文章系转载自互联网；若该文章内容涉嫌侵权，请及时向
上一篇：下一篇：
相关经验教程
的原创经验被浏览，获得 ￥0.005 收益
的原创经验被浏览，获得 ￥0.005 收益
的原创经验被浏览，获得 ￥0.001 收益
的原创经验被浏览，获得 ￥0.001 收益
的原创经验被浏览，获得 ￥0.001 收益
的原创经验被浏览，获得 ￥0.001 收益
的原创经验被浏览，获得 ￥0.005 收益
的原创经验被浏览，获得 ￥0.005 收益
的原创经验被浏览，获得 ￥0.001 收益
的原创经验被浏览，获得 ￥0.005 收益
的原创经验被浏览，获得 ￥0.005 收益
的原创经验被浏览，获得 ￥0.005 收益
的原创经验被浏览，获得 ￥0.005 收益
的原创经验被浏览，获得 ￥0.001 收益
的原创经验被浏览，获得 ￥0.005 收益
的原创经验被浏览，获得 ￥0.001 收益
的原创经验被浏览，获得 ￥0.005 收益
的原创经验被浏览，获得 ￥0.005 收益
的原创经验被浏览，获得 ￥0.001 收益
的原创经验被浏览，获得 ￥0.001 收益
的原创经验被浏览，获得 ￥0.005 收益
的原创经验被浏览，获得 ￥0.005 收益
的原创经验被浏览，获得 ￥0.005 收益
的原创经验被浏览，获得 ￥0.002 收益如何在虚拟机（Oracle VM VirtualBox）中安装iso格式的软件（Pro.E） 注：不是安装虚拟机_百度知道
如何在虚拟机（Oracle VM VirtualBox）中安装iso格式的软件（Pro.E） 注：不是安装虚拟机
提问者采纳
1、打开已经装好的VirtualBox虚拟机，在设备菜单-分配光驱-选择一个虚拟光驱，选择你要安装的ISO文件2、这个时候应该能看到软件的安装界面了。如果没有看到安装界面，打开虚拟机我的电脑，找到光驱并打开，运行里面的安装程序。&另外，你已经在用虚拟机了，何必再在虚拟机里装个虚拟光驱？那不是很蛋疼么？
那个方法早试过了，不行，所以才安装的Daemon Tool
进虚拟机的安全模式，安装增强功能，把3D选项勾上试试。在此之前，要把显存设置为26M以上。再不行就是虚拟机的系统有问题，换原版系统试试。
虽然还是不行，但仍然很感谢你
也许Pro.E这个软件是禁止装在虚拟机里安装的。物理机上应该能装
提问者评价
其他类似问题
为您推荐：
其他3条回答
在虚拟机上装虚拟光驱软件，如daemon tool就可以了如果是要用iso文件在virtualbox中安装操作系统的话，那就在设置-存储的控制器下添加一个虚拟光驱，然后选中你要使用的iso文件就可以了
不行啊，无法加载
这个和virtual box 没关系吧？这个是你都打不开那个文件试试把这个文件复制到你本地？
虚拟机的光驱设置为用镜像
难道不可以先解压iso文件在安装么？？
virtualbox的相关知识
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁| 漏洞检测 |
| 隐藏捆绑 |
【Oracle】Exadata虚拟机配置（一）
Exadata是Oracle软硬结合的一体机，通过自己的机子不可能完全模拟出来，这里搭建的虚拟机只是一个简单的、可以供我们学习Exadata的环境。 最简单可以模拟的Exadata虚拟机需要两个节点，CELL节点和DB节点。 首先说一下CELL节点安装介质： OEL5.6-x86-64 cell-
Exadata是软硬结合的一体机，通过自己的机子不可能完全模拟出来，这里搭建的只是一个简单的、可以供我们学习Exadata的环境。
最简单可以模拟的Exadata需要两个节点，CELL节点和DB节点。
首先说一下CELL节点安装介质：
OEL5.6-x86-64
cell-11.2.3.3.1_LINUX.X64
这两个在/ 可以下载的到
下面是具体安装步骤：
关闭UEK，否则启动cellsrv会报错：
[root@CELL ~]# vi /etc/grub.conf
# grub.conf generated by anaconda
# Note that you do not have to rerun grub after making changes to this file
# NOTICE: You have a /boot partition. This means that
# all kernel and initrd paths are relative to /boot/, eg.
# root (hd0,0)
# kernel /vmlinuz-version ro root=/dev/VolGroup00/LogVol00
# initrd /initrd-version.img
#boot=/dev/sda
default=1 原本为0 改为1
splashimage=(hd0,0)/grub/splash.xpm.gz
hiddenmenu
。。。。略。。。
重启系统：
[root@CELL ~]# reboot
hosts文件如下：
[root@CELL ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.90.151 CELL
网卡如下：
[root@CELL ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0# Intel Corporation 82545EM Gigabit Ethernet Controller (Copper)
DEVICE=eth0
BOOTPROTO=static
BROADCAST=192.168.90.255
HWADDR=00:0C:29:3D:9A:03
IPADDR=192.168.90.151
IPV6INIT=yes
IPV6_AUTOCONF=yes
NETMASK=255.255.255.0
NETWORK=192.168.90.0
ONBOOT=yes
使用oracle-validated安装一些rpm包
[root@CELL ~]# vi /etc/yum.repos.d/public-yum-el5.repo
name = Enterprise Linux 5.6 DVD
baseurl=file:///mnt/Server/
gpgcheck=0
[root@CELL ~]# mount /dev/cdrom /mnt
mount: block device /dev/cdrom is write-protected, mounting read-only
[root@CELL ~]# yum install oracle-validated
Loaded plugins: rhnplugin, security
This system is not registered with ULN.
ULN support will be disabled.
oel5 | 1.1 kB 00:00
oel5/primary | 1.4 MB 00:00
Setting up Install Process
Resolving Dependencies
--& Running transaction check
---& Package oracle-validated.x86_64 0:1.1.0-7.el5 set to be updated
oel5/filelists | 3.1 MB 00:00
--& Processing Dependency: /usr/lib/libaio.so for package: oracle-validated
--& Processing Dependency: unixODBC-devel for package: oracle-validated
--& Processing Dependency: sysstat for package: oracle-validated
--& Processing Dependency: /usr/lib64/libodbccr.so for package: oracle-validated
--& Processing Dependency: libaio-devel for package: oracle-validated
--& Processing Dependency: compat-gcc-34-c++ for package: oracle-validated
--& Processing Dependency: /usr/lib/libodbc.so.1 for package: oracle-validated
--& Processing Dependency: compat-gcc-34 for package: oracle-validated
--& Processing Dependency: /usr/lib64/libaio.so for package: oracle-validated
--& Processing Dependency: /usr/lib/libodbccr.so for package: oracle-validated
--& Processing Dependency: libXp.so.6 for package: oracle-validated
--& Processing Dependency: libdb-4.2.so()(64bit) for package: oracle-validated
--& Processing Dependency: libodbc.so.1()(64bit) for package: oracle-validated
--& Running transaction check
---& Package compat-db.x86_64 0:4.2.52-5.1 set to be updated
---& Package compat-gcc-34.x86_64 0:3.4.6-4.1 set to be updated
---& Package compat-gcc-34-c++.x86_64 0:3.4.6-4.1 set to be updated
---& Package libXp.i386 0:1.0.0-8.1.el5 set to be updated
---& Package libaio-devel.i386 0:0.3.106-5 set to be updated
---& Package libaio-devel.x86_64 0:0.3.106-5 set to be updated
---& Package sysstat.x86_64 0:7.0.2-3.el5_5.1 set to be updated
---& Package unixODBC.i386 0:2.2.11-7.1 set to be updated
---& Package unixODBC.x86_64 0:2.2.11-7.1 set to be updated
---& Package unixODBC-devel.i386 0:2.2.11-7.1 set to be updated
---& Package unixODBC-devel.x86_64 0:2.2.11-7.1 set to be updated
--& Finished Dependency Resolution
Dependencies Resolved&
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
oracle-validated x86_64 1.1.0-7.el5 oel5 23 k
Installing for dependencies:
compat-db x86_64 4.2.52-5.1 oel5 1.6 M
compat-gcc-34 x86_64 3.4.6-4.1 oel5 4.3 M
compat-gcc-34-c++ x86_64 3.4.6-4.1 oel5 13 M
libXp i386 1.0.0-8.1.el5 oel5 22 k
libaio-devel i386 0.3.106-5 oel5 12 k
libaio-devel x86_64 0.3.106-5 oel5 11 k
sysstat x86_64 7.0.2-3.el5_5.1 oel5 175 k
unixODBC i386 2.2.11-7.1 oel5 830 k
unixODBC x86_64 2.2.11-7.1 oel5 835 k
unixODBC-devel i386 2.2.11-7.1 oel5 743 k
unixODBC-devel x86_64 2.2.11-7.1 oel5 799 k
Transaction Summary
================================================================================
Install 12 Package(s)
Upgrade 0 Package(s)
Total download size: 22 M
Is this ok [y/N]: y
....略....
建立目录：
[root@CELL ~]# mkdir -p /var/log/oracle
[root@CELL ~]# chmod -R 775 /var/log/oracle
上传介质后解压：
[root@CELL soft]# tar -pxvf cellImageMaker_11.2.3.3.1_LINUX.X64_.x86_64.tar
。。。略。。。
解压后得到dl180文件夹
[root@CELL soft]# cd dl180/boot/cellbits/
[root@CELL cellbits]# unzip cell.bin
Archive: cell.bin
warning [cell.bin]: 20038 extra bytes at beginning or within zipfile
(attempting to process anyway)
inflating: cell-11.2.3.3.1_LINUX.X64_.x86_64.rpm
解压得到cell-11.2.3.3.1_LINUX.X64_.x86_64.rpm，进行安装
[root@CELL cellbits]# rpm -ivh cell-11.2.3.3.1_LINUX.X64_.x86_64.rpm
error: Failed dependencies:
jdk &= 1.5.0_12 is needed by cell-11.2.3.3.1_LINUX.X64_.x86_64
安装包报错，提示需要JDK，JDK我们可以从同目录下cellrpms.tbz中找到
[root@CELL cellbits]# tar -tf cellrpms.tbz
cellrpmlist
exadata-firmware-cell-11.2.3.3.1..x86_64.rpm
exadata-validations-cell-11.2.3.3.1..x86_64.rpm
extradepsrpmlist
image_functions
imagerpmlist
install.sh
jdk-1.7.0_55-fcs.x86_64.rpm
python-numeric-23.7-2.2.2.el5_6.1.x86_64.rpm
scsi-target-utils-1.0.14-2.el5.x86_64.rpm
selinux-policy-2.4.6-346.el5.noarch.rpm
selinux-policy-targeted-2.4.6-346.el5.noarch.rpm
将jdk解压出来并安装
[root@CELL cellbits]# tar -pxvf cellrpms.tbz jdk-1.7.0_55-fcs.x86_64.rpm
jdk-1.7.0_55-fcs.x86_64.rpm
[root@CELL cellbits]# rpm -ivh jdk-1.7.0_55-fcs.x86_64.rpm
warning: jdk-1.7.0_55-fcs.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:jdk ########################################### [100%]
Unpacking JAR files...
jsse.jar...
charsets.jar...
tools.jar...
localedata.jar...
jfxrt.jar...
[root@CELL cellbits]# rpm -ivh cell-11.2.3.3.1_LINUX.X64_.x86_64.rpm
Preparing... ########################################### [100%]
Pre Installation steps in progress ...
1:cell ########################################### [100%]
Post Installation steps in progress ...
Set cellusers group for /opt/oracle/cell11.2.3.3.1_LINUX.X64_140708/cellsrv/deploy/log directory
Set 775 permissions for /opt/oracle/cell11.2.3.3.1_LINUX.X64_140708/cellsrv/deploy/log directory
Installation SUCCESSFUL.
Starting RS and MS... as user celladmin
Done. Please Login as user celladmin and create cell to startup CELLSRV to complete cell configuration.
If this is a manual installation, please stop and restart ExaWatcher to pick up newly installed binaries.
You can run &/opt/oracle.ExaWatcher/ExaWatcher.sh --stop& and then &/opt/oracle.ExaWatcher/ExaWatcher.sh --fromconf& to stop and restart ExaWatcher.
Logout and then re-login to use the new cell environment.
[root@CELL ~]# mkdir -p /opt/oracle/cell/disks/raw
[root@CELL ~]# cd /opt/oracle/cell/disks/raw
[root@CELL raw]# vi dd.sh
[root@CELL raw]# cat dd.sh
dd if=/dev/zero of=disk01 bs=1M count=1000
dd if=/dev/zero of=disk02 bs=1M count=1000
dd if=/dev/zero of=disk03 bs=1M count=1000
dd if=/dev/zero of=disk04 bs=1M count=1000
dd if=/dev/zero of=disk05 bs=1M count=1000
dd if=/dev/zero of=disk06 bs=1M count=1000
dd if=/dev/zero of=disk07 bs=1M count=1000
dd if=/dev/zero of=disk08 bs=1M count=1000
dd if=/dev/zero of=disk09 bs=1M count=1000
dd if=/dev/zero of=disk10 bs=1M count=1000
dd if=/dev/zero of=disk11 bs=1M count=1000
dd if=/dev/zero of=disk12 bs=1M count=1000
dd if=/dev/zero of=FLASH01 bs=1M count=1000
dd if=/dev/zero of=FLASH02 bs=1M count=1000
dd if=/dev/zero of=FLASH03 bs=1M count=1000
dd if=/dev/zero of=FLASH04 bs=1M count=1000
执行脚本：
[root@CELL raw]# sh dd.sh
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 36.0089 seconds, 29.1 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 45.0823 seconds, 23.3 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 38.5387 seconds, 27.2 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 66.3054 seconds, 15.8 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 37.9832 seconds, 27.6 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 33.8476 seconds, 31.0 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 57.1281 seconds, 18.4 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 34.5081 seconds, 30.4 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 52.1244 seconds, 20.1 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 58.0057 seconds, 18.1 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 42.3233 seconds, 24.8 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 50.184 seconds, 20.9 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 41.2316 seconds, 25.4 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 38.1167 seconds, 27.5 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 39.3045 seconds, 26.7 MB/s
1000+0 records in
1000+0 records out
bytes (1.0 GB) copied, 34.2013 seconds, 30.7 MB/s
进行赋权：
[root@CELL raw]# chmod 660 *
[root@CELL raw]# ls -ltr
-rw-rw---- 1 root root 692 Sep 28 12:29 dd.sh
-rw-rw---- 1 root root
Sep 28 12:30 disk01
-rw-rw---- 1 root root
Sep 28 12:31 disk02
-rw-rw---- 1 root root
Sep 28 12:32 disk03
-rw-rw---- 1 root root
Sep 28 12:33 disk04
-rw-rw---- 1 root root
Sep 28 12:34 disk05
-rw-rw---- 1 root root
Sep 28 12:34 disk06
-rw-rw---- 1 root root
Sep 28 12:35 disk07
-rw-rw---- 1 root root
Sep 28 12:36 disk08
-rw-rw---- 1 root root
Sep 28 12:37 disk09
-rw-rw---- 1 root root
Sep 28 12:38 disk10
-rw-rw---- 1 root root
Sep 28 12:38 disk11
-rw-rw---- 1 root root
Sep 28 12:39 disk12
-rw-rw---- 1 root root
Sep 28 12:40 FLASH01
-rw-rw---- 1 root root
Sep 28 12:41 FLASH02
-rw-rw---- 1 root root
Sep 28 12:41 FLASH03
-rw-rw---- 1 root root
Sep 28 12:42 FLASH04
[root@CELL raw]# rm dd.sh
rm: remove regular file `dd.sh'? yes&
切换到celladmin下重启cell服务
[celladmin@CELL ~]$ cellcli -e alter cell restart services all&
Stopping the RS, CELLSRV, and MS services...
The SHUTDOWN of services was successful.
Starting the RS, CELLSRV, and MS services...
Getting the state of RS services... running
Starting CELLSRV services...
The STARTUP of CELLSRV services was not successful.
CELL-01553: Incorrect IP in cellinit.ora. IP is invalid or has incorrect/missing netmask. Please refer to RS incident log.
Starting MS services...
The STARTUP of MS services was successful.
报错说没有ip配置
[celladmin@CELL ~]$ cellcli -e create cell cell1 interconnect1=eth0&
Cell cell1 successfully created
Starting CELLSRV services...
The STARTUP of CELLSRV services was not successful.
CELL-02018: Internal error detected: Not enough open file descriptors.&
ip配置好后依然报错
alert日志位置：
/opt/oracle/cell11.2.3.3.1_LINUX.X64_140708/log/diag/asm/cell/CELL/trace/alert.log
从中可以看到以下内容：
Number of open file descriptors per process is 1024
The minimum number is 16384. Please change ulimit
CELLSRV boot failed to start due to the error 11 (Not enough open file descriptors)
接下来我们调整限制：
[root@CELL ~]# vi /etc/sysctl.conf
最后一行添加：
fs.file-max = 65536
生效一下：
[root@CELL ~]# sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 2
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax =
kernel.shmall =
fs.file-max = 65536
继续修改/etc/security/limits.conf文件：
[root@CELL ~]# vi /etc/security/limits.conf
最后添加两行：
* soft nofile 65536
* hard nofile 65536
修改完后用celladmin用户重新登录，查看限制：
[celladmin@CELL ~]$ ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 16384
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 65536
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 16384
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
重启cell服务：
[celladmin@CELL ~]$ cellcli -e alter cell restart services all&
Stopping the RS, CELLSRV, and MS services...
The SHUTDOWN of services was successful.
Starting the RS, CELLSRV, and MS services...
Getting the state of RS services... running
Starting CELLSRV services...
The STARTUP of CELLSRV services was successful.
Starting MS services...
The STARTUP of MS services was successful.&
[celladmin@CELL ~]$ cellcli
CellCLI: Release 11.2.3.3.1 - Production on Mon Sep 29 10:04:46 CST 2014&
Copyright (c) , . All rights reserved.
Cell Efficiency Ratio: 1&
CellCLI& create celldisk all
CellDisk CD_disk01_cell1 successfully created
CellDisk CD_disk02_cell1 successfully created
CellDisk CD_disk03_cell1 successfully created
CellDisk CD_disk04_cell1 successfully created
CellDisk CD_disk05_cell1 successfully created
CellDisk CD_disk06_cell1 successfully created
CellDisk CD_disk07_cell1 successfully created
CellDisk CD_disk08_cell1 successfully created
CellDisk CD_disk09_cell1 successfully created
CellDisk CD_disk10_cell1 successfully created
CellDisk CD_disk11_cell1 successfully created
CellDisk CD_disk12_cell1 successfully created
CellDisk FD_00_cell1 successfully created
CellDisk FD_01_cell1 successfully created
CellDisk FD_02_cell1 successfully created
CellDisk FD_03_cell1 successfully created&
CellCLI& create flashcache all size=2G
Flash cache cell1_FLASHCACHE successfully created&
CellCLI& create flashlog all
Flash log cell1_FLASHLOG successfully created&
CellCLI& list flashcache detail
name: cell1_FLASHCACHE
cellDisk: FD_00_cell1,FD_02_cell1,FD_03_cell1,FD_01_cell1
creationTime: T10:27:46+08:00
degradedCelldisks:
effectiveCacheSize: 2G
id: 5a6f81d4-c9a1-4494-adf0-cdea2a3243ea
status: normal&
CellCLI& list flashlog detail
name: cell1_FLASHLOG
cellDisk: FD_03_cell1,FD_00_cell1,FD_02_cell1,FD_01_cell1
creationTime: T10:28:14+08:00
degradedCelldisks:
effectiveSize: 512M
efficiency: 100.0
id: 4acce90-959b-5ead
size: 512M
status: normal&
CellCLI& list cell
cell1 online&
CellCLI& list celldisk
CD_disk01_cell1 normal
CD_disk02_cell1 normal
CD_disk03_cell1 normal
CD_disk04_cell1 normal
CD_disk05_cell1 normal
CD_disk06_cell1 normal
CD_disk07_cell1 normal
CD_disk08_cell1 normal
CD_disk09_cell1 normal
CD_disk10_cell1 normal
CD_disk11_cell1 normal
CD_disk12_cell1 normal
FD_00_cell1 normal
FD_01_cell1 normal
FD_02_cell1 normal
FD_03_cell1 normal&
CellCLI& create griddisk all harddisk prefix=data, size=300M
GridDisk data_CD_disk01_cell1 successfully created
GridDisk data_CD_disk02_cell1 successfully created
GridDisk data_CD_disk03_cell1 successfully created
GridDisk data_CD_disk04_cell1 successfully created
GridDisk data_CD_disk05_cell1 successfully created
GridDisk data_CD_disk06_cell1 successfully created
GridDisk data_CD_disk07_cell1 successfully created
GridDisk data_CD_disk08_cell1 successfully created
GridDisk data_CD_disk09_cell1 successfully created
GridDisk data_CD_disk10_cell1 successfully created
GridDisk data_CD_disk11_cell1 successfully created
GridDisk data_CD_disk12_cell1 successfully created&
CellCLI& create griddisk all harddisk prefix=reco, size=160M
GridDisk reco_CD_disk01_cell1 successfully created
GridDisk reco_CD_disk02_cell1 successfully created
GridDisk reco_CD_disk03_cell1 successfully created
GridDisk reco_CD_disk04_cell1 successfully created
GridDisk reco_CD_disk05_cell1 successfully created
GridDisk reco_CD_disk06_cell1 successfully created
GridDisk reco_CD_disk07_cell1 successfully created
GridDisk reco_CD_disk08_cell1 successfully created
GridDisk reco_CD_disk09_cell1 successfully created
GridDisk reco_CD_disk10_cell1 successfully created
GridDisk reco_CD_disk11_cell1 successfully created
GridDisk reco_CD_disk12_cell1 successfully created&
CellCLI& list griddisk
data_CD_disk01_cell1 active
data_CD_disk02_cell1 active
data_CD_disk03_cell1 active
data_CD_disk04_cell1 active
data_CD_disk05_cell1 active
data_CD_disk06_cell1 active
data_CD_disk07_cell1 active
data_CD_disk08_cell1 active
data_CD_disk09_cell1 active
data_CD_disk10_cell1 active
data_CD_disk11_cell1 active
data_CD_disk12_cell1 active
reco_CD_disk01_cell1 active
reco_CD_disk02_cell1 active
reco_CD_disk03_cell1 active
reco_CD_disk04_cell1 active
reco_CD_disk05_cell1 active
reco_CD_disk06_cell1 active
reco_CD_disk07_cell1 active
reco_CD_disk08_cell1 active
reco_CD_disk09_cell1 active
reco_CD_disk10_cell1 active
reco_CD_disk11_cell1 active
reco_CD_disk12_cell1 active&
CellCLI& list celldisk FD_00_cell1 detail
name: FD_00_cell1
creationTime: T10:26:28+08:00
deviceName: /opt/oracle/cell11.2.3.3.1_LINUX.X64_140708/disks/raw/FLASH01
devicePartition: /opt/oracle/cell11.2.3.3.1_LINUX.X64_140708/disks/raw/FLASH01
diskType: FlashDisk
errorCount: 0
freeSpace: 336M
freeSpaceMap: offset=688M,size=336M
id: 09b329a7-a-f0e23c
interleaving: none
lun: /opt/oracle/cell11.2.3.3.1_LINUX.X64_140708/disks/raw/FLASH01
physicalDisk: /opt/oracle/cell11.2.3.3.1_LINUX.X64_140708/disks/raw/FLASH01
raidLevel: &RAID 0&
status: normal&
CellCLI& list celldisk CD_disk01_cell1 detail
name: CD_disk01_cell1
creationTime: T10:05:19+08:00
deviceName: /opt/oracle/cell11.2.3.3.1_LINUX.X64_140708/disks/raw/disk01
devicePartition: /opt/oracle/cell11.2.3.3.1_LINUX.X64_140708/disks/raw/disk01
diskType: HardDisk
errorCount: 0
freeSpace: 528M
freeSpaceMap: offset=496M,size=528M
id: 43697fde-2a47-4f84-a496-de3b516ecaca
interleaving: none
lun: /opt/oracle/cell11.2.3.3.1_LINUX.X64_140708/disks/raw/disk01
physicalDisk: /opt/oracle/cell11.2.3.3.1_LINUX.X64_140708/disks/raw/disk01
raidLevel: &RAID 0&
status: normal&
CellCLI& list griddisk data_CD_disk01_cell1 detail
name: data_CD_disk01_cell1
asmDiskgroupName:
asmDiskName:
asmFailGroupName:
availableTo:
cachingPolicy: default
cellDisk: CD_disk01_cell1
creationTime: T10:30:56+08:00
diskType: HardDisk
errorCount: 0
id: d085144e-f71a-42b2-9db7-0b8f2bee95b4
offset: 48M
size: 288M
status: active&
至此CELL节点ok
(责任编辑：幽灵学院)
------分隔线----------------------------
和大家分享一下我在Oracle数据库定义语言的学习笔记 1、创建表空间语法 create tables...
插入空 执行以下的查询： INSERT INTO emp(empno,ename,job,sal) VALUES(1005,杨华, C...
Oracle临时表空间主要用来做查询和存放一些缓冲区数据。临时表空间消耗的主要原因是需...
#!/bin/shsource /home/oracle/.bash_profileif [ -z $1 ]then echo Please Input a n...
一、描述 在64位的win7操作系统中安装Oracle11gR2数据库，我们首先需要下载Oracle数据...
oracle的自增主键需要用序列和触发器来实现， 我们首先创建一张表：主键为int，实现自...
admin@1744.cc
工作日：9:00-21:00
周　六：9:00-18:00
&&扫一扫关注幽灵学院
广告服务：QQ: