Oracle11g for Suse Linux11.1安装图解.doc

Oracle DB Installation for Suse VM背景：本想在家里研究一下hibernate 源代码，做个数据操作的实验。但发现以前装的 windows 版 Oracle 不能启动了。于是就有了做个Oracle VM 的冲动。接下来就是虚拟机的制作的操作步骤，跟 大家分享一下。本机环境：OS ：win7 cpu: P7350 memory：4G hard driver：250G目的：安装 Oracle DB for Linux，以后也要会安装weblogic 或websphere。无娱乐目的。相关工具：openSUSE-11.1-DVD-i586.iso 下载路径 /Oracle DB for LinuxSecureCRT telnet工具Xmanager4 图形界面登陆工具ftp 工具plsqldeveloper操作步骤：一、安装Oracle VM VirtualBox需要在Oracle 官网下载，但必须先要注册一个账号然后默认安装。比较简单，操作略。1 新建虚拟机2 分配内存越多越好3 创建虚拟硬盘为以后使用方便，建议创建固定大小的虚拟应硬盘，虽然前期比较耗时。4 配置网络为以后suse能在线升级，建议选择桥连接方式5 配置存储加载SUSE.iso,一定要按图所示加载，并且其他保持默认状态。否则安装系统时不能正常光盘引导。6 启动VM 配置好后，可以启动虚拟器；并正式在创建的虚拟机上安装suse 系统。二、 安装 Suse VM1 开始安装2 建议选择GNONE desktop3 省略简单部署，可根据个人爱好配置4 创建文件系统4.1 添加PVPV 俗称物理卷，可以理解是一块硬盘此步骤的意义是单纯创建一块硬盘，为以后创建VG所用。4.2 创建VGVG 俗称卷组，VG可以包含多个PV，本次穿件的VG只包含一个PV,即sda3本次操作完成了 datavg的创建，如图所示。43 创建LVLV 俗称逻辑卷，将会被文件系统使用本次操作创建了 /oracle 的文件系统。其意义是在卷组datavg 上划分了所有的空间，创建了逻辑卷 lv_oracle，然后把逻辑卷 mount 到/oracle 目录上。5 创建其他用户6 安装前确认在正式开始安装suse前，一定要确认系统安装的包是否全面，因为默认安装将会有很多包没包含进来，所以一定要查看software 选上自己需要的包。其次一定要调整系统的空间分配，建议/root 调整到10G左右。最后一定要设置root的初始密码。三 安装Oracle 数据库1 配置网络建议设定一个固定IP。关闭 suse 系统的防火墙2 开始安装DB以上两种方式都可以2.1 选择高级安装2.2 默认3.3 ORACLE_BASE ORACLE_HOME3.4 执行脚本切换到root 用户，执行如下脚本3.5 配置profileecho You execute nowest profile. /etc/profileexport ORACLE_BASE=/oracleexport ORACLE_HOME=$ORACLE_BASE/app/oracle/product/11.1.0/db_1export ORACLE_SID=frankdbexport ORA_NLS33=$ORACLE_HOME/nls/dataexport NLS_LANG=american_america.AL32UTF8PATH=$PATH:$ORACLE_HOME/lib:$ORACLE_HOME/binPS1=whoami:$PWD set -o vialias l=ls -lF因为.profile 系统不会自动创建，所以需要手工创建。内容如上。3.6 创建监听执行 lsnrctl stop lsnrctl start 启停监听3.7 创建实例3.7.1 创建 ORACLE_SID=frankdb3.7.2 创建文件系统3.7.3 划分SGA PGA根据内存大小配置3.8 配置内核用文本编辑器编辑/etc/sysctl.conf文件，将以下内容复制到该文件中：kernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 6553600net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 26214为了提高在linux系统上运行软件的性能，必须对oracle用户设置下列shell 限定 加入下面的行到文件/etc/security/limits.conf（如果没有的话，需要加上）oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 655363.8 创建用户- Create tablespace-Create TABLESPACE for Data tableCREATE TABLESPACE DATA_HBMDATAFILE /oracle/oradata/frankdb/DBdata/DATA_HBM.dbf size 100MAUTOEXTEND ONEXTENT MANAGEMENT localUNIFORM SIZE 1MSEGMENT SPACE MANAGEMENT AUTO/-Create TABLESPACE for index of Data table CREATE TABLESPACE IDX_HBMDATAFILE /oracle/oradata/frankdb/DBdata/IDX_HBM.dbf size 100MAUTOEXTEND ONEXTENT MANAGEMENT localUNIFORM SIZE 1MSEGMENT SPACE MANAGEMENT AUTO/- Create the user create user HBMUSER IDENTIFIED BY hbmuser default tablespace DATA_HBM temporary tablespace TEMP profile DEFAULT password expire quota unlimited on data_hbm quota unlimited on idx_hbm quota unlimited on users; - Grant/Revoke object privileges grant select on DBA_COL_COMMENTS to HBMUSER;grant select on DBA_CONSTRAINTS to HBMUSER;grant select on DBA_CONS_COLUMNS to HBMUSER;grant select on DBA_DATA_FILES to HBMUSER;grant select on DBA_DEPENDENCIES to HBMUSER;grant select on DBA_ERRORS to HBMUSER;grant select on DBA_INDEXES to HBMUSER;grant select on DBA_IND_COLUMNS to HBMUSER;grant select on DBA_JOBS to HBMUSER;grant select on DBA_JOBS_RUNNING to HBMUSER;grant select on DBA_OBJECTS to HBMUSER;grant select on DBA_SEQUENCES to HBMUSER;grant select on DBA_SOURCE to HBMUSER;grant select on DBA_SYNONYMS to HBMUSER;grant select on DBA_TABLES to HBMUSER;grant select on DBA_TAB_COLUMNS to HBMUSER;grant select on DBA_TRIGGERS to HBMUSER;grant select on DBA_VIEWS to HBMUSER;grant execute on DBMS_ALERT to HBMUSER;grant execute on DBMS_APPLICATION_INFO to HBMUSER;grant execute on DBMS_DEFER_SYS to HBMUSER;grant execute on DBMS_LOB to HBMUSER;grant execute on DBMS_LOCK to HBMUSER;grant execute on DBMS_PIPE to HBMUSER;grant execute on DBMS_REFRESH to HBMUSER;grant execute on DBMS_RLS to HBMUSER;grant execute on DBMS_SESSION to HBMUSER;grant execute on DBMS_SQL to HBMUSER;grant execute on DBMS_SYSTEM to HBMUSER;grant execute on DBMS_UTILITY to HBMUSER;grant execute on UTL_FILE to HBMUSER;grant select on V_$DATABASE to HBMUSER;grant select on V_$INSTANCE to HBMUSER;grant select on V_$LOCK to HBMUSER;grant select on V_$LOCKED_OBJECT to HBMUSER;grant select on V_$LOG to HBMUSER;grant select on V_$LOGFILE to HBMUSER;grant select on V_$PARAMETER to HBMUSER;grant select on V_$PROCESS to HBMUSER;grant select on V_$ROLLNAME to HBMUSER;grant select on V_$SESSION to HBMUSER;grant select on V_$SESSTAT to HBMUSER;grant select on V_$SQL to HBMUSER;grant select on V_$STATNAME to HBMUSER;grant select on V_$SYSSTAT to HBMUSER;grant select on V_$TIMER to HBMUSER;- Grant/Revoke role privileges grant connect to HBMUSER;grant exp_full_database to HBMUSER;grant imp_full_database to HBMUSER;grant resource to HBMUSER;grant role_finware to HBMUSER;- Grant/Revoke system privileges grant create any directory to HBMUSER;grant create any sequence to HBMUSER;grant create any synonym to HBMUSER;grant create any type to HBMUSER;grant create database link to HBMUSER;grant create library to HBMUSER;grant create procedure to HBMUSER;grant create public synonym to HBMUSER;grant create sequence to HBMUSER;grant create session to HBMUSER;grant create table to HBMUSER;grant create trigger to HBMUSER;grant create view to HBMUSER;grant debug any procedure to HBMUSER;grant debug connect session to HBMUSER;grant unlimited tablespace to HBMUSER;3