1、大家可以根据自己的操作系统是多少位(32位或64位)的,到官网下载相应的安装程序,如下图所示。 有一点需要注意,Oracle的安装程序分成2个文件,下载后将2个文件解压到同一目录即可。
2、环境规划说明安装环境:64位redhat6.5操作系统;安装软件:oracle 11g for Linux-x86-64安装机器:118.0.0.47安装目录:/opt/ora安装用户:oracle
3、修改机器名称[root@localhost mnt]# vi /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4118.0.0.47 MAS[root@localhost etc]# cd /etc/sysconfig/[root@localhost sysconfig]# vi networkNETWORKING=yesNETWORKING_IPV6=noHOSTNAME=MAS
4、修改机器时间实例:设置时间伟2008年8月8号12:00 # date -s "2016-11-28 12:06:00"修改完后,记得输入:clock -w
5、打系统补丁光盘介质准备[root@localhost ~]# mkdir -p /mnt/soft/ [root@localhost ~]# mount /dev/cdrom /mnt/soft/
6、外部介质准备建目录放补丁包[root@localhost ~]# mkdir /soft[root@localhost ~]# cd /soft[root@localhost soft]# mkdir rpm[root@localhost soft]# cd rpm[root@localhost rpm]# ls到其他机器拿补丁包[root@MAS Packages]# cd /soft/Packages[root@MAS Packages]# ls pdk*pdksh-5.2.14-1.i386.rpm pdksh-5.2.14-30.x86_64.rpm[root@MAS Packages]# scp pdksh* [email protected]:/soft/rpm
7、安装磁盘补丁[root@localhost yum.repos.d]# yum install gcc*[root@localhost yum.repos.d]# yum install libaio*[root@localhost yum.repos.d]# yum install glibc*[root@localhost yum.repos.d]# yum install compat-libstdc*[root@localhost yum.repos.d]# yum install elfutils-libelf-devel*[root@localhost yum.repos.d]# yum install libstdc*[root@localhost yum.repos.d]# yum install unixODBC*安装外部补丁[root@localhost rpm]# cd /soft/rpm[root@localhost rpm]# rpm -ivh pdksh-5.2.14-30.x86_64.rpm安装结束解挂[root@localhost rpm]# umount /dev/cdrom
8、修改swap大小[root@MAS home]# dd if=/dev/zero of=/home/swap bs=1024 count=16000000记录了16000000+0 的读入记录了16000000+0 的写出16384000000字节(16 GB)已复制,29.7171 秒,551 MB/秒[root@MAS home]# mkswap /home/swapmkswap: /home/swap: warning: don't erase bootbits sectors on whole disk. Use -f to force.Setting up swapspace version 1, size = 15999996 KiBno label, UUID=0155deec-1583-41b8-b678-3036253a5681[root@MAS home]# swapon /home/swap
9、设置重启生效[root@MAS home]# cd /etc[root@MAS etc]# cp fstab fstab.20161128[root@MAS et艘早祓胂c]# vi fstab## /etc/fstab# Created by anaconda on Mon Nov 21 21:37:49 2016## Accessible filesystems, by reference, are maintained under '/dev/disk'# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info#UUID=ea38995e-71dd-49e3-8f1e-c37f45fbfe4b / ext4 defaults 1 1UUID=a002445e-7c42-4112-8a30-96f5d9c62e15 /DATA ext4 defaults 1 2UUID=4df207bd-bb6c-4497-b9d6-47a8bec50d78 /boot ext4 defaults 1 2UUID=28530338-db67-45ec-b7f0-881dbcd6276b /home ext4 defaults 1 2UUID=9500e2f4-b9e4-4acf-b5e5-134204592466 /opt ext4 defaults 1 2UUID=907296f5-6d48-47d9-a93e-99a501c49e7a swap swap defaults 0 0tmpfs /dev/shm tmpfs defaults 0 0devpts /dev/pts devpts gid=5,mode=620 0 0sysfs /sys sysfs defaults 0 0proc /proc proc defaults 0 0UUID=0155deec-1583-41b8-b678-3036253a5681 /home/swap swap defaults 0 0~~~"fstab" 19L, 1181C written
10、创建组和用户[root@localhost ~]# groupadd dba[root@localhost ~]# groupadd oinstall[root@localhost ~]# useradd -g oinstall -G dba oracle[root@localhost ~]# passwd oracleChanging password for user oracle.New UNIX password:
11、安装数据库介质准备把墙绅褡孛数据库安装介质插入光驱:[root@MAS ~]# mkdir -p /soft/ora/[root@MAS ~]# mount /dev/cdrom /soft/ora/mount: block device /dev/sr0 is write-protected, mounting read-only[root@MAS ~]#[root@MAS ~]# cd /soft/ora/[root@MAS ora]# lsdoc install response rpm runInstaller sshsetup stage welcome.html环境修改Oracle用户在文件/home/oracle/.bash_profile 最后增加下列内容:########## For oracle added #############export ORACLE_BASE=/opt/oraexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0export ORACLE_SID=MADBexport ORACLE_TERM=xtermexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/lib:/usr/local/libexport PATH=$PATH:$ORACLE_HOME/bin########## For oracle ended #############[root@MAS /]# mkdir -p /opt/ora[root@MAS /]# chown oracle:oinstall /opt/ora
12、创建并配置数据库配置图形化参数1、 打开xmanager passive2、 查看本地ip3、 设置环境变量:[oracle@MAS ~]$ export DISPLAY=118.0.0.131:0.0[oracle@MAS ~]$ xhostaccess control disabled, clients can connect from any hostINET:118.0.0.131环境变量修改[oracle@MAS ~]$export.UTF-8 #中文[oracle@MAS ~]$export.UTF-8 #英文
13、创建数据库开始安装[oracle@MAS ~]$ export.UTF-8[oracle@MAS ~]$ /soft/ora/runInstallerStarting Oracle Universal Installer...
14、进入sqlplus,测试成功!可以直接输入SQL语句了!