新闻学研究历程10.doc

Oracle10G Installation On RHEL5杉德巍康起草人: 公司: 杉德巍康文档编号: SD-DC-XXXX-0001文档版本号: 1.0密级: 内部日期: 2010-3-25文档信息项目名称:Oracle10G Installation on RHEL5起草人:文档版本号:1.0文档编号:SD-DC-XXXX-0001日期:2010-03-25分发名单自日期部门给行动*部门*行动类别：批准，复审，通知，存档，所需行动，参加会议，其它（请指明）版本记录版本编号版本日期修改者说明1.02010-03-25初始稿修改记录修改日期修改人当前版本修改内容目录1LINUX 系统设置32Oracle安装前设置43ORACLE 安装54DATABASE 安装55用户管理71 LINUX 系统设置l LINUX版本rootsslpora # uname -rm 2.6.18-164.el5 x86_64l LINUX硬件配置RAM Swap SpaceUp to 512 MB 2 times the size of RAMBetween 1024 MB and 2048 MB 1.5 times the size of RAMBetween 2049 MB and 8192 MB Equal to the size of RAMMore than 8192 MB 0.75 times the size of RAMrootsslpora /# grep MemTotal /proc/meminfoMemTotal: 2048876 kBrootsslpora /# grep SwapTotal /proc/meminfoSwapTotal: 4095992 kBrootsslpora /# grep model name /proc/cpuinfomodel name : Intel(R) Celeron(R) CPU 450 2.20GHzl HOST FILE 配置 Like: localhost.localdomain localhostl 参数设置在/etc/sysctl.conf文件中加入kernel.shmmax=1610612736 /1.5G /单个共享内存段最大值 大于等于SGA内存 保证SGA在一个共享内存段内kernel.shmall=393216 /1.5g/4096 = 393216 大于多个数据库的SGA和/允许使用的最大共享内存大小 90%总内存/page size (getconf PAGESIZE)net.core.rmem_max=262144net.core.rmem_default=262144net.core.wmem_max=262144net.core.wmem_default=262144net.ipv4.ip_local_port_range=1024 65000kernel.sem=250 32000 100 128执行命令：/sbin/sysctl p 使设置生效添加以下行到 /etc/security/limits.conf file / 设置可打开的文件数 和 单用户的进程数* soft nproc 2047* hard nproc 16384 用户进程数限制* soft nofile 1024* hard nofile 65536 用户文件数量限制添加以下行到 /etc/pam.d/login file session required pam_limits.so设置 /etc/selinux/config file:SELINUX=disabledl PACKAGES 安装binutils-.2-10.EL4compat-db-4.1.25-9control-center-2.8.0-12gcc-3.4.3-9.EL4gcc-c+-3.4.3-9.EL4glibc-2.3.4-2glibc-common-2.3.4-2libstdc+-3.4.3-9.EL4libstdc+-devel-3.4.3-9.EL4make-3.80-5pdksh-5.2.14-30sysstat-5.0.5-1compat-libstdc+-33-3.2.3 compat-libstdc+-33-3.2.3（32 位） elfutils-libelf-0.125 elfutils-libelf-devel-0.125 glibc-2.5-12 glibc-2.5-12（32 位） glibc-devel-2.5 glibc-devel-2.5-12（32 位） libaio-0.3.106 libaio-0.3.106（32 位） libaio-devel-0.3.106 libgcc-4.1.1 libgcc-4.1.1（32 位） libstdc+-4.1.1 libstdc+-4.1.1（32 位） libstdc+-devel 4.1.1 libXp-1.0.0-8.1.el5.i386.rpm libXp-1.0.0-8.1.el5.x86_64.rpm / unixODBC-2.2.11-7.1.x86_64.rpm 不装 后面使用32位的驱动unixODBC-2.2.11-7.1.i386.rpmrpm -Uvh 安装包rpm aq 确认已经安装的包2 Oracle安装前设置l GROUP USER 设置rootsslpora /# groupadd oinstallrootsslpora /# groupadd dbarootsslpora /# useradd -g oinstall -G dba oraclerootsslpora /# passwd oracle - password: oracleChanging password for user oracle.New UNIX password: BAD PASSWORD: it is based on a dictionary wordRetype new UNIX password: passwd: all authentication tokens updated successfully.l 安装文件准备 oraclesslpora INSTALL_FILE$ cpio -idcmv Xhost +l Oracle 用户登录 设置环境变量 .bash_profile file# Oracle SettingsTMP=/tmp; export TMPTMPDIR=$TMP; export TMPDIRORACLE_BASE=/home/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product//db_1; export ORACLE_HOMEORACLE_SID=sslpdb; export ORACLE_SIDORACLE_TERM=xterm; export ORACLE_TERMPATH=/usr/sbin:$PATH; export PATHPATH=$ORACLE_HOME/bin:$PATH; export PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNELif $USER = oracle ; then if $SHELL = /bin/ksh ; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fifi3 ORACLE 安装l 图形安装Oracle用户登录 执行安装命令 ./runInstaller * 只安装ORACLE SOFTWAREl 如果无图形界面 可以选择Oracle数据库静默安装4 DATABASE 安装l 使用DBCA GUI 安装l 手动安装1. 参数文件 /home/oracle/product//db_1/dbs/initsslpdb.ora以别的为模板，修改相关参数如下*.audit_file_dest=/home/oracle/ora_log/sslpdb/adump*.background_dump_dest=/home/oracle/ora_log/sslpdb/bdump*.compatible=.0*.control_files=/home/oracle/ora_data/sslpdb/control01.ctl,/home/oracle/ora_data/sslpdb/control02.ctl,/home/oracle/ora_data/sslpdb/control03.ctl*.core_dump_dest=/home/oracle/ora_log/sslpdb/cdump*.db_block_size=8192*.db_domain=*.db_file_multiblock_read_count=16*.db_name=sslpdb*.job_queue_processes=10*.open_cursors=300*.pga_aggregate_target=200000000*.processes=200*.remote_login_passwordfile=EXCLUSIVE*.sga_target=1000000000*.undo_management=AUTO*.undo_tablespace=UNDOTBS1*.user_dump_dest=/home/oracle/ora_log/sslpdb/udump*.log_archive_dest=/home/oracle/ora_log/sslpdb/arch*.log_archive_format=arch_%t_%s_%r.dbf*.workarea_size_policy=AUTO2. 建立物理目录 按照上面参数设置的目录3. 创建口令文件 orapwd file=$ORACLE_HOME/dbs/orapwsslpdb password=oracle4. 启动实例$ export ORACLE_SID=sslpdb$ sqlplus / as sysdbaSQL*Plus: Release .0 - Production on Tue Apr 6 10:00:44 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.SQL startup nomount5. 创建数据库create database sslpdb logfile group 1 (/home/oracle/ora_data/sslpdb/redo01a.log) size 50m, group 2 (/home/oracle/ora_data/sslpdb/redo02a.log) size 50m, group 3 (/home/oracle/ora_data/sslpdb/redo03a.log) size 50m datafile /home/oracle/ora_data/sslpdb/system1.dbf size 1024m autoextend on next 10m maxsize unlimited sysaux datafile /home/oracle/ora_data/sslpdb/sysaux1.dbf size 1024m autoextend on next 10m maxsize unlimited undo tablespace undotbs1 datafile /home/oracle/ora_data/sslpdb/undo1.dbf size 1024m autoextend on next 10m maxsize unlimited character set zhs16gbk;6. 安装数据字典视图Sys: sql$ORACLE_HOME/rdbms/admin/catalog.sql7. 安装系统包及过程Sys: sql$ORACLE_HOME/rdbms/admin/catproc.sql8. 安装客户资源集System: sql$ORACLE_HOME/sqlplus/admin/pupbld.sql9. 重启监听Lsnrctl start10. 建立临时表空间create temporary tablespace temp tempfile /home/oracle/ora_data/sslpdb/temp1.dbf size 1024m autoextend on next 10m maxsize unlimited;Alter database default temporary tablespace temp;11. 用户数据空间管理create tablespace SSLP_DATA_TS datafile /home/oracle/ora_data/sslpdb/sslp_data_ts1.dbf size 2000m autoextend on next 10m maxsize unlimited logging extent management local segment space management auto;create tablespace SSLP_INDEX_TS datafile /home/oracle/ora_data/sslpdb/sslp_index_ts1.dbf size 2000m autoextend on next 10m maxsize unlimited logging extent management local segment space management auto;如果需要额外添加数据文件如下 Alter tablespace add datafile . size 1024m;查看所有表空间状态Select tablespace_name,status from dba_tablespaces;12. 创建用户create user sslp_user identified by sslp default tablespace SSLP_DATA_TS temporary tablespace temp;grant connect, resource, create public synonym, create view, create session, create table, unlimited tablespace, debug any procedure, debug connect session to sslp_user;l 原AIX 64位 数据导出到linux 64位exp sslp_user/sslpsslpdb162 file=d:sslp.dmp log=d:log.txtimp sslp_user/sslpsslpdb93 file=d:sslp.dmp log=d:log3.txt 5 规范化和参数调整l 表空间 ALTER TABLESPACE SSLP_DATA_TS RENAME TO TS_PRO_DATA; ALTER TABLESPACE SSLP_INDEX_TS RENAME TO TS_PRO_INDEX;l 数据文件改名 shutdown immediate mv sslp_data_ts1.dbf ts_pro_data1.dbf mv sslp_index_ts1.dbf ts_pro_index1.dbf startup mount alter database rename file /home/oracle/ora_data/sslpdb/sslp_data_ts1.dbf to /home/oracle/ora_data/sslpdb/ts_pro_data1.dbf; alter database rename file /home/oracle/ora_data/sslpdb/sslp_index_ts1.dbf to /home/oracle/ora_data/sslpdb/ts_pro_index1.dbf; ALTER DATABASE OPEN;l 创建新表空间create tablespace TS_HIS_DATA datafile /home/oracle/ora_data/sslpd