单实例环境下安装.docx
- 文档编号:23487237
- 上传时间:2023-05-17
- 格式:DOCX
- 页数:14
- 大小:19.28KB
单实例环境下安装.docx
《单实例环境下安装.docx》由会员分享,可在线阅读,更多相关《单实例环境下安装.docx(14页珍藏版)》请在冰豆网上搜索。
单实例环境下安装
单实例环境下安装ASM
说明:
紫红色字体部分是与我安装环境相关的信息或补充的安装说明,其他是网上下载的原文(<<单实例环境下安装ASM>>)
环境:
版本:
OracleDatabase10gEnterpriseEditionRelease10.2.0.
操作系统:
RedHatEnterpriseLinuxServerrelease(Tikanga)
测试的环境是RedHatEnterpriseLinuxServerrelease
1、首先安装oracle数据库软件,然后向虚拟机中添加三块2G的硬盘,重启虚拟机
2、安装软件包:
2.1、查看好系统版本,本机是redhat5,内核版本如下:
[root@server3dev]#uname-a
LinuxSMPTueMar1621:
52:
43EDT2010i686i686i386GNU/Linux
[root@fwy~]#cat/proc/version
Linuxversion2.6.9(gccversion(RedHat#1SMPWedJul1223:
27:
17EDT2006
或
[root@fwya]#uname-r
2.6.9
、上oracle官方网站,搜索关键字oracleasmredhat5。
去下载如下asm的三个rpm软件包(本机器下载的是标红的三个软件包,安装包一定要下载正确的版本否则第五步会出错,导致后续配置无法进行):
LibraryandTools 2.1.3<2.0.4 2.6.18<2.6.18<2.6.18<2.6.18<2.6.18 、安装上述的三个rpm软件包: [root@server3asm]#rpm-ivh*.rpm warning: 2.6.18HeaderV3DSAsignature: NOKEY,keyID1e5e0159 Preparing...###########################################[100%] 1: oracleasm-support###########################################[33%] 2: 2.6.18######################################[67%] 3: oracleasmlib###########################################[100%] 3、对在1中添加进来的三个磁盘进行分区(我们添加了sdb、sdc和sdd。 注意: 这里是仅进行分区,而不需要进行格式化。 [root@server3dev]#lssd* sdasda1sda2sdbsdcsdd [root@server3dev]#fdisk/dev/sdb Command(mforhelp): n Commandaction eextended pprimarypartition(1-4) p Partitionnumber(1-4): 1 Firstcylinder(1-261,default1): 1 Lastcylinderor+sizeor+sizeMor+sizeK(1-261,default261): 261 Command(mforhelp): w Thepartitiontablehasbeenaltered! Callingioctl()tore-readpartitiontable. Syncingdisks. 同样执行如下的命令,来对sdc和sdd进行分区: [root@server3dev]#fdisk/dev/sdc [root@server3dev]#fdisk/dev/sdd 查看并确认分区的情况: [root@server3dev]#fdisk-l Disk/dev/sda: GB,480bytes 255heads,63sectors/track,2610cylinders Units=cylindersof16065*512=8225280bytes DeviceBootStartEndBlocksIdSystem /dev/sda1*11310439183Linux /dev/sda2142610+8eLinuxLVM Disk/dev/sdb: 2147MB,48bytes 255heads,63sectors/track,261cylinders Units=cylindersof16065*512=8225280bytes DeviceBootStartEndBlocksIdSystem /dev/sdb11261209645183Linux Disk/dev/sdc: 2147MB,48bytes 255heads,63sectors/track,261cylinders Units=cylindersof16065*512=8225280bytes DeviceBootStartEndBlocksIdSystem /dev/sdc11261209645183Linux Disk/dev/sdd: 2147MB,48bytes 255heads,63sectors/track,261cylinders Units=cylindersof16065*512=8225280bytes DeviceBootStartEndBlocksIdSystem /dev/sdd11261209645183Linux 4、配置ASM: [root@server3asm]#/etc/oracleasmconfigure ConfiguringtheOracleASMlibrarydriver. Thiswillconfiguretheon-bootpropertiesoftheOracleASMlibrary driver.Thefollowingquestionswilldeterminewhetherthedriveris loadedonbootandwhatpermissionsitwillhave.Thecurrentvalues willbeshowninbrackets('[]').Hitting answerwillkeepthatcurrentvalue.Ctrl-Cwillabort. Defaultusertoownthedriverinterface[]: oracle Defaultgrouptoownthedriverinterface[]: oinstall StartOracleASMlibrarydriveronboot(y/n)[y]: ScanforOracleASMdisksonboot(y/n)[y]: WritingOracleASMlibrarydriverconfiguration: done InitializingtheOracleASMLibdriver: [OK] ScanningthesystemforOracleASMLibdisks: [OK] 5、系统添加磁盘: [root@server3asm]#/etc/oracleasmcreatediskVOL1/dev/sdb1 Markingdisk"VOL1"asanASMdisk: [OK] [root@server3asm]#/etc/oracleasmcreatediskVOL2/dev/sdc1 Markingdisk"VOL2"asanASMdisk: [OK] [root@server3asm]#/etc/oracleasmcreatediskVOL3/dev/sdd1 Markingdisk"VOL3"asanASMdisk: [OK] 6、创建ASM初始化文件init+,在$ORACLE_HOME/dbs目录下(可以理解为是ASM实例的pfile文件): [oracle@localhostdb_1]$cat>>/opt/ora10g/product10.2.0sm_diskstring='ORCL: VOL*' >*.background_dump_dest='/opt/ora10g/admin/+ASM/bdump' >*.core_dump_dest='/opt/ora10g/admin/+ASM/cdump' >*.instance_type='asm' >*.large_pool_size=24M >*.remote_login_passwordfile='SHARED' >*.user_dump_dest='/opt/ora10g/admin/+ASM/udump' >EOF 注: /opt/ora10g/product10.2.010g10g10g10.2.0-ProductiononTueAug3120: 10: 112010 Copyright(c)1982,2005 ;>,Oracle.Allrightsreserved. Enteruser-name: sysassysdba Enterpassword: Connectedtoanidleinstance. SQL>startup ORA-29701: unabletoconnecttoClusterManager 10、下面来添加CSS,以解决9中出现的问题。 [oracle@localhostdbs]$localconfigadd Youmustbeloggedinasroottorun/opt/ora10g/product10.2.0Loginasrootandrestart/opt/ora10g/product10.2.0提示需要以root来执行命令: [root@localhost~]#/opt/ora10g/product10.2.0Creatingitnow. SuccessfullyaccumulatednecessaryOCRkeys. CreatingOCRkeysforuser'root',privgrp'root'.. Operationsuccessful. ConfigurationforlocalCSShasbeeninitialized Addingtoinittab Startupwillbequeuedtoinitwithin90seconds. CheckingthestatusofnewOracleinitprocess... ExpectingtheCRSdaemonstobeupwithin600seconds. CSSisactiveonthesenodes. localhost CSSisactiveonallnodes. OracleCSSserviceisinstalledandrunningunderinit(1M) 11、我们再启动以下ASM实例,由于我们没有创建磁盘组,所以提示没有mountdiskgroup正常: [root@server3~]#su-oracle [oracle@server3~]$echo$ORACLE_SID +ASM [oracle@server3~]$sqlplus SQL*Plus: Release10.2.0.-ProductiononTueAug3120: 16: 462010 Copyright(c)1982,2005,Oracle.Allrightsreserved. Enteruser-name: sysassysdba Enterpassword: Connectedtoanidleinstance. SQL>startup ASMinstancestarted TotalSystemGlobalAreabytes FixedSize1217908bytes VariableSizebytes ASMCachebytes ORA-15110: nodiskgroupsmounted 12、下面,可以执行dbca,开始创建数据库 ;>了: 第一步的时候,选择新建数据: 第三步的时候,数据库实例的SID要和ASM中的asm_diskstring参数中的SID一致本例中是SID) 第六步时。 指定存储项为ASM: 点击Next的时候,提示需要关闭asm实例: 第七步时,点击CreateNew创建新的DiskGroup: 给新的磁盘组取名为DATA1,并把三块硬盘都加入到改组,冗余项选择normal: 经过上述操作后,一个磁盘组DATA1已经创建好,并且已经加载上: 指定数据文件创建的位置,默认创建在DATA1磁盘组下: 第九步,指定FlashRecoveryArea的位置和大小,按照默认的即可: 第十步,选择安装样例数据库: 第十一步,字符集我们可以进行如下的选择: 第十二步,查看数据库存储相关信息: 第十三步,点击Finish来结束配置过程,进行数据库的创建 安装过程中的截图: 安装完成后的截图: 至此,单机上安装ASM已经完成。 我们现在可以登陆asm实例,查看下一些相关的视图: [oracle@server3~]$echo$ORACLE_SID +ASM [oracle@server3~]$sqlplus SQL*Plus: Release10.2.0.-ProductiononTueAug3120: 56: 292010 Copyright(c)1982,2005,Oracle.Allrightsreserved. Enteruser-name: sysassysdba Enterpassword: Connectedto: OracleDatabase10gEnterpriseEditionRelease10.2.0.-Production WiththePartitioning,OLAPandData ;>Miningoptions SQL>SELECTGROUP_NUMBER,INSTANCE_NAME,DB_NAME,STATUS 2FROMv$asm_client; GROUP_NUMBERINSTANCE_NAMEDB_NAMESTATUS --------------------------------------------------------------------------------- 1ORCLORCLCONNECTED 查看ASM中的数据文件: SQL>setlinesize500 SQL>SELECTFILE_NUMBER,BLOCKS,BLOCK_SIZE/1024BLOCK_KB,BYTES/1024/1024ASMB,SPACE/1024/1024ASMB,TYPEFROMv$asm_file; FILE_NUMBERBLOCKSBLOCK_KBMBMBTYPE ------------------------------------------------------------------------------------------------------------------- 256614418965DATAFILE 257307218485DATAFILE 2584481875DATAFILE 259641812DATAFILE 2604311624CONTROLFILE 2614311624CONTROLFILE 262102401.5115ONLINELOG 263102401.5115ONLINELOG 264102401.5115ONLINELOG 265102401.5115ONLINELOG 266102401.5115ONLINELOG FILE_NUMBERBLOCKSBLOCK_KBMBMBTYPE ------------------------------------------------------------------------------------------------------------------- 267102401.5115ONLINELOG 2682561842TEMPFILE 269128018205DATAFILE 2705.5.0024414062PARAMETERFILE 登陆ORCL实例 [oracle@server3~]$exportORACLE_SID=ORCL [oracle@server3~]$sqlplus SQL*Plus: Release10.2.0.-ProductiononTueAug3120: 53: 522010 Copyright(c)1982,2005,Oracle.Allrightsreserved. Enteruser-name: sysassysdba Enterpassword: Connectedto: OracleDatabase10gEnterpriseEditionRelease10.2.0.-Production WiththePartitioning,OLAPandDataMiningoptions SQL>selectinstance_namefromv$instance; INSTANCE_NAME ---------------- ORCL 查看表空间及其所对应的文件名。 发现具体的路径不详,由ASM自动给我们的文件命名进行管理 ;>: SQL>selectFILE_NAME,TABLESPACE_NAMEfromdba_data_files; FILE_NAMETABLESPACE_NAME ---------------------------------------------------------------------------------------------------- +DATA1/orcl/datafile/USERS +DATA1/orcl/datafile/SYSAUX +DATA1/orcl/datafile/UNDOTBS1 +DATA1/orcl/datafile/SYSTEM +DATA1/orcl/datafile/EXAMPLE 用命令行添加新硬盘: 1、以root命令来运行oracleasm命令 [root@server3dev]#/etc/oracleasmcreatediskVOL4/dev/sde1 Markingdisk"VOL4"asanASMdisk: [OK] 2、登陆至ASM实例中,输入如下命令,需要有addfailgroup子句: SQL>alterdiskgroupDATA1addfailgroupVOL4disk'ORCL: VOL4'; 可以看到,添加好了VOL4之后,会进行"重平衡",每个磁盘的使用容量是相同的: SQL>SELECTGROUP_NUMBER,DISK_NUMBER,NAME,TOTAL_MB,FREE_MB 2FROMv$asm_disk; GROUP_NUMBERDISK_NUMBERNAMETOTAL_MBFREE_MB ---------------------------------------------------------------------------- 10VOL120471377 11VOL220471376 12VOL320471376 13VOL420471377 Asm工具初体验 [oracle@server3~]$asmcmd ASMCMD> ASMCMD>ls-l+DATA1/ORCL/DATAFILE TypeRedundStripedTimeSysName DATAFILEMIRRORCOARSESEP0113: 00: 00YMIRRORCOARSESEP0114: 00: 00YMIRRORCOARSESEP0113: 00: 00YMIRRORCOARSESEP0113: 00: 00YMIRRORCOARSESEP0113: 00: 00Yhelp asmcmd[-p][command] TheenvironmentvariablesORACLE_HOMEandORACLE_SIDdeterminethe instancetowhichtheprogramconnects,andASMCMDestablishesa bequeathconnectiontoit,inthesamemannerasaSQLPLUS/AS SYSDBA.TheusermustbeamemberoftheSYSDBAgr
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 实例 环境 安装