VM虚拟机下在LINUX上安装ORACLE 11G单实例数据库 电脑资料

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/work-scripts/ifcfg-eth0 主机名 /etc/sysconfig/work 修改开机运行级别 /etc/inittab 关闭SELINUX /boot/grub/menu.lst 修改sshd_config，解决SSH超时自动断开问题 login as: root root192.168.1.212s password: Last login: Wed Jun 5 09:11:26 xx rootoel-01 # hostname oel-01 rootoel-01 # cat/etc/sysconfig/work-scripts/ifcfg-eth0 # Advanced Micro Devices AMD 79c970PC32 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=Ether USERCTL=no IPV6INIT=no PEERDNS=yes rootoel-01 # cat /etc/resolv.conf nameserver 222.88.88.88 rootoel-01 # cat /etc/sysconfig/work NETWORKING=yes NETWORKING_IPV6=yes HOSTNAME=oel-01 rootoel-01 # vi /etc/inittab id:3:initdefault: rootoel-01 # vi /boot/grub/menu.lst 在kernel 行末尾增加selinux=0关闭SELINUX。也可以在安装完系统时的图形配置界面中关闭。 rootoel-01 # cd /etc/ssh/ rootoel-01 ssh# grepClientAlive sshd_config #ClientAliveInterval 0 #ClientAliveCountMax 3 rootoel-01 ssh# cp sshd_configsshd_config.bak rootoel-01 ssh# sed -is/#ClientAliveInterval 0/ClientAliveInterval 60/g sshd_config rootoel-01 ssh# grepClientAlive sshd_config ClientAliveInterval 60 #ClientAliveCountMax 3 rootoel-01 ssh# sed -is/#ClientAliveCountMax 3/ClientAliveCountMax 10/g sshd_config rootoel-01 ssh# grepClientAlive sshd_config ClientAliveInterval 60 ClientAliveCountMax 10 rootoel-01 ssh# service sshd restart Stopping sshd: OK Starting sshd: OK 到此应该将系统重启，验证以上各项配置是否生效。如生效，关机，在VMWARE中做快照 3.创建安装ORACLE的用户组 rootoel-01 # groupadd -g 1000 oinstall rootoel-01 # groupadd -g 1031 dba rootoel-01 # groupadd -g 1032 oper rootoel-01 # useradd oracle rootoel-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 updatedsuessfully. rootoel-01 # usermod -g oinstall -Gdba,oper oracle rootoel-01 # mkdir -p/u01/app/oracle/product/11.2.0/dbhome_1 rootoel-01 # chown -R oracle:oinstall/u01/ rootoel-01 # chmod 775 /u01/ rootoel-01 app# pwd /u01/app rootoel-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.挂载光盘，安装软件 rootoel-01 # cd /etc/yum.repos.d/ rootoel-01 yum.repos.d# ls rootoel-01 yum.repos.d# viOEL_CDROM.repo rootoel-01 yum.repos.d# catOEL_CDROM.repo OEL5.8 name=oracle linux baseurl=file:/mnt/cdrom/Server enabled=1 gpgcheck=0 rootoel-01 yum.repos.d# cd /mnt/ rootoel-01 mnt# mkdir cdrom rootoel-01 mnt# mount /dev/cdrom/mnt/cdrom mount: block device /dev/cdrom iswrite-protected, mounting read-only rootoel-01 mnt# ls cdrom rootoel-01 mnt# cd cdrom/ rootoel-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 rootoel-01 Server# pwd /mnt/cdrom/Server rootoel-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 rootoel-01 Server# rpm -import/etc/pki/rpm-gpg/RPM-GPG-KEY-oracle 开始安装软件 方法一： rootoel-01 Server# yum -y installoracleasm-support-2.1.7-1.el5.i386.rpm rootoel-01 Server# yum -y installreadline-devel-5.1-3.el5.i386.rpm rootoel-01 Server# yum -y installunixODBC rootoel-01 Server# yum -y install make* g* glibc* pat-db* pat-g*pat-g* pat-libstdc+* pat-libstdc* openmotif* setarch* rootoel-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,这里我也是上传上去的，这个软件可以在网上自己找， rootoel-01 # ls anaconda-ks.cfg install.log rlwrap-0.37 Desktop install.log.syslog rlwrap-0.37.tar.gz rootoel-01 # tar -zxvfrlwrap-0.37.tar.gz rootoel-01 rlwrap-0.37# pwd /root/rlwrap-0.37 rootoel-01 rlwrap-0.37# ./configure rootoel-01 rlwrap-0.37# make rootoel-01 rl