Oracle11g for Suse Linux11.1安裝圖解.doc

Oracle DB Installation for Suse VM背景：本想在家里研究一下hibernate 源代碼，做個(gè)數(shù)據(jù)操作的實(shí)驗(yàn)。但發(fā)現(xiàn)以前裝的 windows 版 Oracle 不能啟動(dòng)了。于是就有了做個(gè)Oracle VM 的沖動(dòng)。接下來(lái)就是虛擬機(jī)的制作的操作步驟，跟 大家分享一下。本機(jī)環(huán)境：OS ：win7 cpu: P7350 memory：4G hard driver：250G目的：安裝 Oracle DB for Linux，以后也要會(huì)安裝weblogic 或websphere。無(wú)娛樂(lè)目的。相關(guān)工具：openSUSE-11.1-DVD-i586.iso 下載路徑 /Oracle DB for LinuxSecureCRT telnet工具Xmanager4 圖形界面登陸工具ftp 工具plsqldeveloper操作步驟：一、安裝Oracle VM VirtualBox需要在Oracle 官網(wǎng)下載，但必須先要注冊(cè)一個(gè)賬號(hào)然后默認(rèn)安裝。比較簡(jiǎn)單，操作略。1 新建虛擬機(jī)2 分配內(nèi)存越多越好3 創(chuàng)建虛擬硬盤(pán)為以后使用方便，建議創(chuàng)建固定大小的虛擬應(yīng)硬盤(pán)，雖然前期比較耗時(shí)。4 配置網(wǎng)絡(luò)為以后suse能在線升級(jí)，建議選擇橋連接方式5 配置存儲(chǔ)加載SUSE.iso,一定要按圖所示加載，并且其他保持默認(rèn)狀態(tài)。否則安裝系統(tǒng)時(shí)不能正常光盤(pán)引導(dǎo)。6 啟動(dòng)VM 配置好后，可以啟動(dòng)虛擬器；并正式在創(chuàng)建的虛擬機(jī)上安裝suse 系統(tǒng)。二、 安裝 Suse VM1 開(kāi)始安裝2 建議選擇GNONE desktop3 省略簡(jiǎn)單部署，可根據(jù)個(gè)人愛(ài)好配置4 創(chuàng)建文件系統(tǒng)4.1 添加PVPV 俗稱(chēng)物理卷，可以理解是一塊硬盤(pán)此步驟的意義是單純創(chuàng)建一塊硬盤(pán)，為以后創(chuàng)建VG所用。4.2 創(chuàng)建VGVG 俗稱(chēng)卷組，VG可以包含多個(gè)PV，本次穿件的VG只包含一個(gè)PV,即sda3本次操作完成了 datavg的創(chuàng)建，如圖所示。43 創(chuàng)建LVLV 俗稱(chēng)邏輯卷，將會(huì)被文件系統(tǒng)使用本次操作創(chuàng)建了 /oracle 的文件系統(tǒng)。其意義是在卷組datavg 上劃分了所有的空間，創(chuàng)建了邏輯卷 lv_oracle，然后把邏輯卷 mount 到/oracle 目錄上。5 創(chuàng)建其他用戶(hù)6 安裝前確認(rèn)在正式開(kāi)始安裝suse前，一定要確認(rèn)系統(tǒng)安裝的包是否全面，因?yàn)槟J(rèn)安裝將會(huì)有很多包沒(méi)包含進(jìn)來(lái)，所以一定要查看software 選上自己需要的包。其次一定要調(diào)整系統(tǒng)的空間分配，建議/root 調(diào)整到10G左右。最后一定要設(shè)置root的初始密碼。三 安裝Oracle 數(shù)據(jù)庫(kù)1 配置網(wǎng)絡(luò)建議設(shè)定一個(gè)固定IP。關(guān)閉 suse 系統(tǒng)的防火墻2 開(kāi)始安裝DB以上兩種方式都可以2.1 選擇高級(jí)安裝2.2 默認(rèn)3.3 ORACLE_BASE ORACLE_HOME3.4 執(zhí)行腳本切換到root 用戶(hù)，執(zhí)行如下腳本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因?yàn)?profile 系統(tǒng)不會(huì)自動(dòng)創(chuàng)建，所以需要手工創(chuàng)建。內(nèi)容如上。3.6 創(chuàng)建監(jiān)聽(tīng)執(zhí)行 lsnrctl stop lsnrctl start 啟停監(jiān)聽(tīng)3.7 創(chuàng)建實(shí)例3.7.1 創(chuàng)建 ORACLE_SID=frankdb3.7.2 創(chuàng)建文件系統(tǒng)3.7.3 劃分SGA PGA根據(jù)內(nèi)存大小配置3.8 配置內(nèi)核用文本編輯器編輯/etc/sysctl.conf文件，將以下內(nèi)容復(fù)制到該文件中：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系統(tǒng)上運(yùn)行軟件的性能，必須對(duì)oracle用戶(hù)設(shè)置下列shell 限定 加入下面的行到文件/etc/security/limits.conf（如果沒(méi)有的話(huà)，需要加上）oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 655363.8 創(chuàng)建用戶(hù)- 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