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