高校固定资产管理系统

ORACLE12CRACHIS项目ORACLERAC实施报告1.系统环境硬件：P824SanSwitch各两台，3PAR存储；软件：Oracle12C安装规划：1.1系统集成前规划机号机型主机名实例名网卡IP系统1HISDB1Hisdb_1Eth0192.168.0.11AIX7.1OracleClusterOracleSoftVIP192.168.0.16Eth1（心跳）200.100.100.12HISDB2Hisdb_1Eth0192.168.0.12AIX7.1OracleClusterOracleSoftVIP192.168.0.17Eth1（心跳）200.100.100.2SCANIP192.168.0.18~20它其设置网关gateway192.168.0.201子网掩码netmask255.255.255.0DNS1.2.存储的划分ORACLE空间存储柜划分存储柜整列RAIDLUN容量文件格式用途1Array110110GASMOCR/VotingDisk210GASMOCR/VotingDisk310GASMOCR/VotingDisk41TBASMASMDisk51TBASMASMDisk61TBASMASMDisk71TBASMASMDisk8300GBASMORACLEArchielog9300GBASMORACLEArchielog2.安装前的准备2.1.系统补丁补丁列表如下：bos.adt.basebos.adt.libbos.adt.libmbos.perf.libperfstatbos.perf.perfstatbos.perf.proctoolsrsct.basic.rtersct.compat.clients.rte检查补丁文件。lslpp-lbos.adt.basebos.adt.libbos.adt.libmbos.perf.libperfstatbos.perf.perfstatbos.perf.proctoolsrsct.basic.rtersct.compat.clients.rte2.2.修改系统参数VMOvmo-p-ominperm%=3vmo-p-omaxperm%=90vmo-p-omaxclient%=90vmo-p-olru_file_repage=0vmo-p-ostrict_maxclient=1vmo-p-ostrict_maxperm=0ConfigureNetworkTuningParametersno-p-oudp_sendspace=65536no-p-oudp_recvspace=262144no-p-otcp_sendspace=262144no-p-otcp_recvspace=262144no-p-orfc1323=1no-p-osb_max=2*655360no-r-oipqmaxlen=512修改磁盘属性chowngrid:asmadmin/dev/rhdisk1chowngrid:asmadmin/dev/rhdisk2chowngrid:asmadmin/dev/rhdisk3chowngrid:asmadmin/dev/rhdisk4chowngrid:asmadmin/dev/rhdisk5chowngrid:asmadmin/dev/rhdisk6chowngrid:asmadmin/dev/rhdisk7chowngrid:asmadmin/dev/rhdisk8chowngrid:asmadmin/dev/rhdisk9chmod660/dev/rhdisk1chmod660/dev/rhdisk2chmod660/dev/rhdisk3chmod660/dev/rhdisk4chmod660/dev/rhdisk5chmod660/dev/rhdisk6chmod660/dev/rhdisk7chmod660/dev/rhdisk8chmod660/dev/rhdisk9chdev-lhdisk1-areserve_policy=no_reservechdev-lhdisk2-areserve_policy=no_reservechdev-lhdisk3-areserve_policy=no_reservechdev-lhdisk4-areserve_policy=no_reservechdev-lhdisk5-areserve_policy=no_reservechdev-lhdisk6-areserve_policy=no_reservechdev-lhdisk7-areserve_policy=no_reservechdev-lhdisk8-areserve_policy=no_reservechdev-lhdisk9-areserve_policy=no_reserve/usr/sbin/chdev-lhdisk1-apv=clear/usr/sbin/chdev-lhdisk2-apv=clear/usr/sbin/chdev-lhdisk3-apv=clear/usr/sbin/chdev-lhdisk4-apv=clear/usr/sbin/chdev-lhdisk5-apv=clear/usr/sbin/chdev-lhdisk6-apv=clear/usr/sbin/chdev-lhdisk7-apv=clear/usr/sbin/chdev-lhdisk8-apv=clear/usr/sbin/chdev-lhdisk9-apv=clear系统连接数smittychgsysMaximumnumberofPROCESSESallowedperuser[16384]换页空间Smittychps增加换页空间修改/etc/hosts修改/etc/hosts192.168.0.11hisdb1192.168.0.16hisdb1vip192.168.0.12hisdb2200.100.100.2hisdb2priv192.168.0.17hisdb2vip192.168.0.18hisdb.scan.com192.168.0.19hisdb.scan.com192.168.0.20hisdb.scan.com200.100.100.1hisdb1priv2.3.配置NTP#vi/etc/ntp.conf#broadcastclientserver172.16.10.15driftfile/etc/ntp.drifttracefile/etc/ntp.trace启动xntpd守护进程#startsrc-sxntpdxntpd状态查询,使用#lssrc-lsxntpd刚启动xntpd时,syspeer为'insane',表明xntpd还没有完成同步启动xntpd守护进程#startsrc-sxntpdxntpd状态查询,使用#lssrc-lsxntpd2.4.创建用户和组1）创建用户及相应的目录创建组mkgroup-'A'id='1000'adms='root'oinstallmkgroup-'A'id='1100'adms='root'asmadminmkgroup-'A'id='1200'adms='root'dbamkgroup-'A'id='1201'adms='root'opermkgroup-'A'id='1300'adms='root'asmdbamkgroup-'A'id='1301'adms='root'asmoper创建用户mkuserid='1100'pgrp='oinstall'groups='asmadmin,asmdba,asmoper'home='/home/grid'gridmkuserid='1101'pgrp='oinstall'groups='dba,asmdba'home='/home/oracle'oraclechusercapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATEgridchusercapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATEoracle修改两用户权限default:fsize=-1core=2097151cpu=-1data=-1rss=-1stack=-1nofiles=-12）配置GRID用户环境变量#su–gridexportORACLE_BASE=/oracle/app/oracleexportORACLE_HOME=/oracle/app/grid/product/12.1.0exportORACLE_SID=+ASM1exportNLS_LANG=AMERICAN_AMERICA.AL32UTF8exportNLS_DATE_FORMAT=yyyy-mm-ddhh24:mi:ssexportPATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/binexportPATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexportPATH=${PATH}:$ORACLE_BASE/common/oracle/binexportORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/adminexportORACLE_TERM=xtermexportTNS_ADMIN=$ORACLE_HOME/network/adminexportORA_NLS10=$ORACLE_HOME/nls/dataexportLD_LIBRARY_PATH=$ORACLE_HOME/libexportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/libexportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/libexportCLASSPATH=$ORACLE_HOME/JREexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibexportTHREADS_FLAG=nativeexportTEMP=/tmpexportTMPDIR=/tmpexportPS1=`hostname`:'$PWD'$3）配置Oracle用户环境变量；#su–oracle#more.profile（oracle环境变量）exportORACLE_BASE=/oracle/app/oracleexportORACLE_HOME=$ORACLE_BASE/product/12.1.0exportORACLE_SID=020db1exportORACLE_UNQNAME=testdbexportNLS_LANG=AMERICAN_AMERICA.UTF8exportNLS_DATE_FORMAT=yyyy-mm-ddhh24:mi:ssexportPATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/binexportPATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexportPATH=${PATH}:$ORACLE_BASE/common/oracle/binexportORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/adminexp