下面不过多介绍，请阅读OEL6上安装Oracle 12c。
1、系统信息：
[root@12c~]#uname-a Linux12c.luocs.com2.6.32-300.10.1.el5uek#1SMPWedFeb2217:37:40EST2012x86_64x86_64x86_64GNU/Linux [root@12c~]#grepMemTotal/proc/meminfo MemTotal:3273192kB [root@12c~]#grepSwapTotal/proc/meminfo SwapTotal:8285752kB [root@12c~]#df-h FilesystemSizeUsedAvailUse%Mountedon /dev/sda336G3.8G31G12%/ /dev/sda199M22M72M24%/boot tmpfs1.6G01.6G0%/dev/shm /dev/sdb15.0G5.0G0100%/usr/swap
这里简单说明下，我安装的OEL5 SWAP空间仍然不够大，因此我就扩展了下，扩展方法： 我在虚拟机新增一块儿5G的disk，启动后fdisk分区了下：
[root@12c~]#fdisk-l Disk/dev/sda:42.9GB,42949672960bytes 255heads,63sectors/track,5221cylinders Units=cylindersof16065*512=8225280bytes DeviceBootStartEndBlocksIdSystem /dev/sda1*11310439183Linux /dev/sda214421327726082Linuxswap/Solaris /dev/sda342252213855600083Linux Disk/dev/sdb:5368MB,5368709120bytes 255heads,63sectors/track,652cylinders Units=cylindersof16065*512=8225280bytes DeviceBootStartEndBlocksIdSystem /dev/sdb116525237158+83Linux
ext3格式化：
[root@12c~]#mkfs.ext3/dev/sdb1 mke2fs1.39(29-May-2006) Filesystemlabel= OStype:Linux Blocksize=4096(log=2) Fragmentsize=4096(log=2) 655360inodes,1309289blocks 65464blocks(5.00%)reservedforthesuperuser Firstdatablock=0 Maximumfilesystemblocks=1342177280 40blockgroups 32768blockspergroup,32768fragmentspergroup 16384inodespergroup Superblockbackupsstoredonblocks: 32768,98304,163840,229376,294912,819200,884736 Writinginodetables:done Creatingjournal(32768blocks):done Writingsuperblocksandfilesystemaccountinginformation:done Thisfilesystemwillbeautomaticallycheckedevery31mountsor 180days,whichevercomesfirst.Usetune2fs-cor-itooverride.
创建一个目录，准备将此文件系统挂载：
[root@12c~]#mkdir/usr/swap [root@12c~]#mount/dev/sdb1/usr/swap
在/usr/swap下dd出5GB的空间
[root@12c~]#ddif=/dev/zeroof=/usr/swap/swapdiskbs=10240Kcount=500 dd:writing`/usr/swap/swapdisk':Nospaceleftondevice 490+0recordsin 489+0recordsout 5128712192bytes(5.1GB)copied,33.1548seconds,155MB/s
创建新交换分区空间
[root@12c~]#mkswap/usr/swap/swapdisk Settingupswapspaceversion1,size=5128708kB
查看原先的分区空间
[root@12c~]#free-m totalusedfreesharedbufferscached Mem:319627784170202502 -/+buffers/cache:2552941 Swap:320003200
启动新增加的swaptest的交换空间
[root@12c~]#swapon/usr/swap/swapdisk
查看增加后的交换空间
[root@12c~]#free-m totalusedfreesharedbufferscached Mem:3196314649082885 -/+buffers/cache:2522944 Swap:809108091
将新增加交换分区空间添加进开机启动
[root@12c~]#vi/etc/fstab –添加一行 /dev/sdb1/usr/swapext3defaults00 /usr/swap/swapdiskswapswapdefaults00
最后reboot重启验证
安装rlwrap
[root@12c~]#rpm-ivh/install/rlwrap-0.37-1.el5.x86_64.rpm warning:/install/rlwrap-0.37-1.el5.x86_64.rpm:HeaderV3DSAsignature:NOKEY,keyID217521f6 Preparing…###########################################[100%] 1:rlwrap###########################################[100%]
修改/etc/hosts
[root@12c~]#vi/etc/hosts #Donotremovethefollowingline,orvariousprograms #thatrequirenetworkfunctionalitywillfail. 127.0.0.1localhost.localdomainlocalhost ::1localhost6.localdomain6localhost6 192.168.80.13912c.luocs.com12c
配置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 # wgethttp://public-yum.oracle.com/public-yum-el4.repo
Oracle Linux 5 # cd /etc/yum.repos.d # wgethttp://public-yum.oracle.com/public-yum-el5.repo
Oracle Linux 6 # cd /etc/yum.repos.d # wgethttp://public-yum.oracle.com/public-yum-ol6.repo
Oracle VM 2 # cd /etc/yum.repos.d # wgethttp://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配置文件
[root@12c~]#cd/etc/yum.repos.d/ [root@12cyum.repos.d]#wgethttp://public-yum.oracle.com/public-yum-el5.repo –2013-06-2710:16:02–http://public-yum.oracle.com/public-yum-el5.repo Resolvingpublic-yum.oracle.com…137.254.56.43 Connectingtopublic-yum.oracle.com|137.254.56.43|:80…connected. HTTPrequestsent,awaitingresponse…200OK Length:4220(4.1K)[text/plain] Savingto:`public-yum-el5.repo' 100%[===============================================================================>]4,22011.8K/sin0.4s 2013-06-2710:16:03(11.8KB/s)–`public-yum-el5.repo'saved[4220/4220]
配置文件中将enable全部启动，0改为1。
安装oracle-validated
[root@12cyum.repos.d]#yuminstalloracle-validated-y
安装完成之后，基本的预安装条件都已经满足了
[root@12c~]#idoracle uid=54321(oracle)gid=54321(oinstall)groups=54321(oinstall),54322(dba)
创建安装目录并授权
[root@12c~]#mkdir-p/u01/app/oracle/product/12.1.0/db_1 [root@12c~]#chown-Roracle:oinstall/u01 [root@12c~]#chmod-R775/u01
配置环境变量
[oracle@12c~]$vi.bash_profile exportPATH exportTMP=/tmp exportTMPDIR=$TMP exportORACLE_HOSTNAME=12c.luocs.com exportORACLE_UNQNAME=luocs12c exportORACLE_BASE=/u01/app/oracle exportORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1 exportORACLE_SID=luocs12c exportPATH=/usr/sbin:$PATH exportPATH=$ORACLE_HOME/bin:$PATH exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib exportCLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib aliassqlplus="rlwrapsqlplus" aliasrman="rlwraprman"
解压介质
[root@12c~]#chown-Roracle.oinstall/install/ [root@12c~]#su–oracle [oracle@12c~]$cd/install/ [oracle@12cinstall]$unziplinuxamd64_12c_database_1of2.zip [oracle@12cinstall]$unziplinuxamd64_12c_database_2of2.zip
这里我先仅安装数据库软件，然后netca配置了监听器，略
dbca建库，参考图为主
这里稍作解释，我勾选了Create As Container Database，然后选择了Create a Container Database with one or more PDBs，数量为2个，PDB Name为luocs,到时候就以luocs1、luocs2形式出现。当然，我们也可以在后续手动方式创建或者克隆出PDBs
这里出现网络配置页面，可能在没有提前配置监听的情况下在这里进行配置，这个我没有尝试过
这里备份出脚本来，供手动建库参考
最后简单查看，发现CDB，PDB数据库都有自己的system、sysaux、default tablespace、temp是独立的，但undo、control、redo是共享的
SQL>setline150pages9999 SQL>selectnamefromv$datafile; NAME —————————————————————————————– /u01/app/oracle/oradata/luocs12c/system01.dbf /u01/app/oracle/oradata/luocs12c/sysaux01.dbf /u01/app/oracle/oradata/luocs12c/undotbs01.dbf /u01/app/oracle/oradata/luocs12c/pdbseed/system01.dbf /u01/app/oracle/oradata/luocs12c/users01.dbf /u01/app/oracle/oradata/luocs12c/pdbseed/sysaux01.dbf /u01/app/oracle/oradata/luocs12c/luocs1/system01.dbf /u01/app/oracle/oradata/luocs12c/luocs1/sysaux01.dbf /u01/app/oracle/oradata/luocs12c/luocs1/luocs1_users01.dbf /u01/app/oracle/oradata/luocs12c/luocs2/system01.dbf /u01/app/oracle/oradata/luocs12c/luocs2/sysaux01.dbf /u01/app/oracle/oradata/luocs12c/luocs2/luocs2_users01.dbf 12rowsselected. sys@LUOCS12C>selectnamefromv$tempfile; NAME —————————————————————————————————- /u01/app/oracle/oradata/luocs12c/temp01.dbf /u01/app/oracle/oradata/luocs12c/pdbseed/pdbseed_temp01.dbf /u01/app/oracle/oradata/luocs12c/luocs1/temp01.dbf /u01/app/oracle/oradata/luocs12c/luocs2/temp01.dbf sys@LUOCS12C>selectmemberfromv$logfile; MEMBER —————————————————————————————————- /u01/app/oracle/oradata/luocs12c/redo03.log /u01/app/oracle/oradata/luocs12c/redo02.log /u01/app/oracle/oradata/luocs12c/redo01.log sys@LUOCS12C>selectnamefromv$controlfile; NAME —————————————————————————————————- /u01/app/oracle/oradata/luocs12c/control01.ctl /u01/app/oracle/fast_recovery_area/luocs12c/control02.ctl
如下方式查看两个pdbs目前没有open
sys@LUOCS12C>selectDBID,NAME,OPEN_MODE,CREATE_SCNfromv$pdbs; DBIDNAMEOPEN_MODECREATE_SCN ———-—————————————-———- 4061811736PDB$SEEDREADONLY1720764 1340482989LUOCS1MOUNTED1915011 770810334LUOCS2MOUNTED1915984
先到这里。
