下面不过多介绍,请阅读OEL6上安装Oracle 12c。

1、系统信息:


  1. [[email protected] ~]# uname -a

  2. Linux 12c.luocs.com 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:37:40 EST 2012 x86_64 x86_64 x86_64 GNU/Linux

  3. [[email protected] ~]# grep MemTotal /proc/meminfo

  4. MemTotal:        3273192 kB

  5. [[email protected] ~]# grep SwapTotal /proc/meminfo

  6. SwapTotal:       8285752 kB

  7. [[email protected] ~]# df -h

  8. Filesystem            Size  Used Avail Use% Mounted on

  9. /dev/sda3              36G  3.8G   31G  12% /

  10. /dev/sda1              99M   22M   72M  24% /boot

  11. tmpfs                 1.6G     0  1.6G   0% /dev/shm

  12. /dev/sdb1             5.0G  5.0G     0 100% /usr/swap


这里简单说明下,我安装的OEL5 SWAP空间仍然不够大,因此我就扩展了下,扩展方法:
我在虚拟机新增一块儿5G的disk,启动后fdisk分区了下:


  1. [[email protected] ~]# fdisk -l

  2. Disk /dev/sda: 42.9 GB, 42949672960 bytes

  3. 255 heads, 63 sectors/track, 5221 cylinders

  4. Units = cylinders of 16065 * 512 = 8225280 bytes

  5.   Device Boot      Start         End      Blocks   Id  System

  6. /dev/sda1   *           1          13      104391   83  Linux

  7. /dev/sda2              14         421     3277260   82  Linux swap / Solaris

  8. /dev/sda3             422        5221    38556000   83  Linux

  9. Disk /dev/sdb: 5368 MB, 5368709120 bytes

  10. 255 heads, 63 sectors/track, 652 cylinders

  11. Units = cylinders of 16065 * 512 = 8225280 bytes

  12.   Device Boot      Start         End      Blocks   Id  System

  13. /dev/sdb1               1         652     5237158+  83  Linux


ext3格式化:


  1. [[email protected] ~]# mkfs.ext3 /dev/sdb1

  2. mke2fs 1.39 (29-May-2006)

  3. Filesystem label=

  4. OS type: Linux

  5. Block size=4096 (log=2)

  6. Fragment size=4096 (log=2)

  7. 655360 inodes, 1309289 blocks

  8. 65464 blocks (5.00%) reserved for the super user

  9. First data block=0

  10. Maximum filesystem blocks=1342177280

  11. 40 block groups

  12. 32768 blocks per group, 32768 fragments per group

  13. 16384 inodes per group

  14. Superblock backups stored on blocks:

  15.        32768, 98304, 163840, 229376, 294912, 819200, 884736

  16. Writing inode tables: done                            

  17. Creating journal (32768 blocks): done

  18. Writing superblocks and filesystem accounting information: done

  19. This filesystem will be automatically checked every 31 mounts or

  20. 180 days, whichever comes first.  Use tune2fs -c or -i to override.


创建一个目录,准备将此文件系统挂载:


  1. [[email protected] ~]# mkdir /usr/swap

  2. [[email protected] ~]# mount /dev/sdb1 /usr/swap

在/usr/swap下dd出5GB的空间


  1. [[email protected] ~]# dd if=/dev/zero of=/usr/swap/swapdisk bs=10240Kcount=500

  2. dd: writing `/usr/swap/swapdisk': No space left on device

  3. 490+0 records in

  4. 489+0 records out

  5. 5128712192 bytes (5.1 GB) copied, 33.1548 seconds, 155 MB/s

创建新交换分区空间


  1. [[email protected] ~]# mkswap /usr/swap/swapdisk

  2. Setting up swapspace version 1, size = 5128708 kB

查看原先的分区空间


  1. [[email protected] ~]# free -m

  2.             total       used       free     shared    buffers     cached

  3. Mem:          3196       2778        417          0         20       2502

  4. -/+ buffers/cache:        255       2941

  5. Swap:         3200          0       3200

启动新增加的swaptest的交换空间


  1. [[email protected] ~]# swapon /usr/swap/swapdisk

查看增加后的交换空间


  1. [[email protected] ~]# free -m

  2.             total       used       free     shared    buffers     cached

  3. Mem:          3196       3146         49          0          8       2885

  4. -/+ buffers/cache:        252       2944

  5. Swap:         8091          0       8091

将新增加交换分区空间添加进开机启动


  1. [[email protected] ~]# vi /etc/fstab

  2. – 添加一行

  3. /dev/sdb1               /usr/swap               ext3    defaults        0 0

  4. /usr/swap/swapdisk      swap                    swap    defaults        0 0

最后reboot重启验证

安装rlwrap


  1. [[email protected] ~]# rpm -ivh /install/rlwrap-0.37-1.el5.x86_64.rpm

  2. warning: /install/rlwrap-0.37-1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 217521f6

  3. Preparing…                ########################################### [100%]

  4.   1:rlwrap                 ########################################### [100%]

修改/etc/hosts


  1. [[email protected] ~]# vi /etc/hosts

  2. # Do not remove the following line, or various programs

  3. # that require network functionality will fail.

  4. 127.0.0.1               localhost.localdomain localhost

  5. ::1             localhost6.localdomain6 localhost6

  6. 192.168.80.139  12c.luocs.com   12c

配置yum源,这里我参考了http://public-yum.oracle.com,其中有如下内容:
Getting Started
1. Download and Install Oracle Linux
2. Download and copy the appropriate yum configuration file in place, by running the following commands as root:
Oracle Linux 4, Update 6 or Newer
# cd /etc/yum.repos.d
# mv Oracle-Base.repo Oracle-Base.repo.disabled
# wget http://public-yum.oracle.com/public-yum-el4.repo

Oracle Linux 5
# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-el5.repo

Oracle Linux 6
# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ol6.repo

Oracle VM 2
# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ovm2.repo
3. Enable the appropriate repository by editing the yum configuration file
 ○ Open the yum configuration file in a text editor
 ○ Locate the section in the file for the repository you plan to update from, e.g. [el4_u6_base]
 ○ Change enabled=0 to enabled=1
4. Begin using yum, for example:
yum list
yum install firefox
You may be prompted to confirm the import of the Oracle OSS Group GPG key.

首先下载linux 5 对应的yum配置文件


  1. [[email protected] ~]# cd /etc/yum.repos.d/

  2. [[email protected] yum.repos.d]# wget http://public-yum.oracle.com/public-yum-el5.repo

  3. –2013-06-27 10:16:02–  http://public-yum.oracle.com/public-yum-el5.repo

  4. Resolving public-yum.oracle.com… 137.254.56.43

  5. Connecting to public-yum.oracle.com|137.254.56.43|:80… connected.

  6. HTTP request sent, awaiting response… 200 OK

  7. Length: 4220 (4.1K) [text/plain]

  8. Saving to: `public-yum-el5.repo'

  9. 100%[===============================================================================>] 4,220       11.8K/s   in 0.4s    

  10. 2013-06-27 10:16:03 (11.8 KB/s) – `public-yum-el5.repo' saved [4220/4220]


配置文件中将enable全部启动,0改为1。

安装oracle-validated


  1. [[email protected] yum.repos.d]# yum install oracle-validated -y

安装完成之后,基本的预安装条件都已经满足了


  1. [[email protected] ~]# id oracle

  2. uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba)

创建安装目录并授权


  1. [[email protected] ~]# mkdir -p /u01/app/oracle/product/12.1.0/db_1

  2. [[email protected] ~]# chown -R oracle:oinstall /u01

  3. [[email protected] ~]# chmod -R 775 /u01

配置环境变量


  1. [[email protected] ~]$ vi .bash_profile

  2. export PATH

  3. export TMP=/tmp

  4. export TMPDIR=$TMP      

  5. export ORACLE_HOSTNAME=12c.luocs.com

  6. export ORACLE_UNQNAME=luocs12c

  7. export ORACLE_BASE=/u01/app/oracle

  8. export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1

  9. export ORACLE_SID=luocs12c

  10. export PATH=/usr/sbin:$PATH

  11. export PATH=$ORACLE_HOME/bin:$PATH

  12. export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

  13. export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

  14. alias sqlplus="rlwrap sqlplus"

  15. alias rman="rlwrap rman"

解压介质


  1. [[email protected] ~]# chown -R oracle.oinstall /install/

  2. [[email protected] ~]# su – oracle

  3. [[email protected] ~]$ cd /install/

  4. [[email protected] install]$ unzip linuxamd64_12c_database_1of2.zip

  5. [[email protected] install]$ unzip linuxamd64_12c_database_2of2.zip

这里我先仅安装数据库软件,然后netca配置了监听器,略

Oracle Eneterprise Linux 5.8上安装Database 12c

dbca建库,参考图为主

Oracle Eneterprise Linux 5.8上安装Database 12c

Oracle Eneterprise Linux 5.8上安装Database 12c

Oracle Eneterprise Linux 5.8上安装Database 12c


这里稍作解释,我勾选了Create As Container Database,然后选择了Create a Container Database with one or more PDBs,数量为2个,PDB Name为luocs,到时候就以luocs1、luocs2形式出现。当然,我们也可以在后续手动方式创建或者克隆出PDBs

Oracle Eneterprise Linux 5.8上安装Database 12c

Oracle Eneterprise Linux 5.8上安装Database 12c

Oracle Eneterprise Linux 5.8上安装Database 12c


这里出现网络配置页面,可能在没有提前配置监听的情况下在这里进行配置,这个我没有尝试过

Oracle Eneterprise Linux 5.8上安装Database 12c

Oracle Eneterprise Linux 5.8上安装Database 12c

Oracle Eneterprise Linux 5.8上安装Database 12c

Oracle Eneterprise Linux 5.8上安装Database 12c

Oracle Eneterprise Linux 5.8上安装Database 12c

Oracle Eneterprise Linux 5.8上安装Database 12c


这里备份出脚本来,供手动建库参考

Oracle Eneterprise Linux 5.8上安装Database 12c

Oracle Eneterprise Linux 5.8上安装Database 12c

Oracle Eneterprise Linux 5.8上安装Database 12c

最后简单查看,发现CDB,PDB数据库都有自己的system、sysaux、default tablespace、temp是独立的,但undo、control、redo是共享的


  1. SQL> set line 150 pages 9999

  2. SQL> select name from v$datafile;

  3. NAME

  4. —————————————————————————————–

  5. /u01/app/oracle/oradata/luocs12c/system01.dbf

  6. /u01/app/oracle/oradata/luocs12c/sysaux01.dbf

  7. /u01/app/oracle/oradata/luocs12c/undotbs01.dbf

  8. /u01/app/oracle/oradata/luocs12c/pdbseed/system01.dbf

  9. /u01/app/oracle/oradata/luocs12c/users01.dbf

  10. /u01/app/oracle/oradata/luocs12c/pdbseed/sysaux01.dbf

  11. /u01/app/oracle/oradata/luocs12c/luocs1/system01.dbf

  12. /u01/app/oracle/oradata/luocs12c/luocs1/sysaux01.dbf

  13. /u01/app/oracle/oradata/luocs12c/luocs1/luocs1_users01.dbf

  14. /u01/app/oracle/oradata/luocs12c/luocs2/system01.dbf

  15. /u01/app/oracle/oradata/luocs12c/luocs2/sysaux01.dbf

  16. /u01/app/oracle/oradata/luocs12c/luocs2/luocs2_users01.dbf

  17. 12 rows selected.

  18. [email protected]> select name from v$tempfile;

  19. NAME

  20. —————————————————————————————————-

  21. /u01/app/oracle/oradata/luocs12c/temp01.dbf

  22. /u01/app/oracle/oradata/luocs12c/pdbseed/pdbseed_temp01.dbf

  23. /u01/app/oracle/oradata/luocs12c/luocs1/temp01.dbf

  24. /u01/app/oracle/oradata/luocs12c/luocs2/temp01.dbf

  25. [email protected]> select member from v$logfile;

  26. MEMBER

  27. —————————————————————————————————-

  28. /u01/app/oracle/oradata/luocs12c/redo03.log

  29. /u01/app/oracle/oradata/luocs12c/redo02.log

  30. /u01/app/oracle/oradata/luocs12c/redo01.log

  31. [email protected]> select name from v$controlfile;

  32. NAME

  33. —————————————————————————————————-

  34. /u01/app/oracle/oradata/luocs12c/control01.ctl

  35. /u01/app/oracle/fast_recovery_area/luocs12c/control02.ctl


如下方式查看两个pdbs目前没有open


  1. [email protected]> select DBID, NAME, OPEN_MODE, CREATE_SCN from v$pdbs;

  2.      DBID NAME                           OPEN_MODE  CREATE_SCN

  3. ———- —————————— ———- ———-

  4. 4061811736 PDB$SEED                       READ ONLY     1720764

  5. 1340482989 LUOCS1                         MOUNTED       1915011

  6. 770810334 LUOCS2                         MOUNTED       1915984


先到这里。

原文链接:http://www.luocs.com/archives/800.html