oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 DECLINE_SECURITY_UPDATES=true #以下参数根据实际情况更改,ORACLE_HOSTNAME的值由hostname命令获得7 o/ @1 I& D! P" z) _$ W$ B' s, C" e
ORACLE_HOSTNAME=localhost.localdomain
3 ]( j2 R* a% W/ X) B INVENTORY_LOCATION=/home/oracle/inventory
8 r+ c: A; M" x! i( l6 d W UNIX_GROUP_NAME=oinstall SELECTED_LANGUAGES=en,zh_CN) J7 I; p9 w. D! D
oracle.install.db.InstallEdition=EE oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=dba #-------------------------------------------------------------------- 各参数含义如下:
3 @4 Y7 _. K' S5 G0 r; A -silent 表示以静默方式安装,不会有任何提示! P) B7 S( J9 u8 A
-force 允许安装到一个非空目录2 V. f& h& m& N* B4 U! q
-noconfig 表示不运行配置助手netca- o/ [; x" t7 Z0 ^8 H3 O
-responseFile 表示使用哪个响应文件,必需使用绝对路径
$ E9 X' s8 c1 w$ n) b oracle.install.responseFileVersion 响应文件模板的版本,该参数不要更改
& x: U* n$ p. f( O! n: ~/ h oracle.install.option 安装选项,本例只安装oracle软件,
, |7 g3 C) X; P8 B8 i/ ]# { DECLINE_SECURITY_UPDATES 是否需要在线安全更新,该参数不要更改7 s& w% `, j E" U- G
ORACLE_HOSTNAME 安装主机名; b$ o4 v/ B O& E' P! L
UNIX_GROUP_NAME oracle用户用于安装软件的组名; I; }' Q4 D% k- E
INVENTORY_LOCATION oracle产品清单目录
' v6 l* k3 {' h" O" j$ P SELECTED_LANGUAGES oracle运行语言环境,一般选en,zh_CN
, J6 i* [( N0 n* F2 g* j* b. T ORACLE_HOME Oracle安装目录 ORACLE_BASE oracle基础目录
! I6 c% p: e# B/ ~! o. W, K+ Z W5 T oracle.install.db.InstallEdition 安装版本类型,一般是企业版6 u8 V) [* F0 f. M+ r* _) P
oracle.install.db.isCustomInstall 是否定制安装,默认Partitioning,OLAP,RAT都选上了
' Z* ~! o" \/ @8 [ oracle.install.db.customComponents 定制安装组件列表:除了以上默认的,可加上Label Security和Database Vault+ S% p+ J6 W. v# K6 W s7 T6 L
oracle.install.db.DBA_GROUP oracle用户用于授予OSDBA权限的组名/ o. O% p* p- Z
oracle.install.db.OPER_GROUP oracle用户用于授予OSOPER权限的组名
' C# F8 a; A, V$ q: L. l 开始安装oracle软件0 Z E. U0 _( I/ |$ ~# ?
$ ./runInstaller -silent -force -noconfig -responseFile /home/oracle/db_install.rsp
7 H- D0 p9 A! ?2 S) y& N! s6 e 控制台直到出现以下提示则表示安装完成:0 R/ }4 M, S0 E D1 E/ M$ \! \! }% ~
#------------------------------------------------------------------- …9 k7 q/ R2 f' w5 W
/opt/oracle/oraInventory/orainstRoot.sh /opt/oracle/product/11.2.0/dbhome_1/root.sh To execute the configuration scripts:8 V# x+ s6 H- C8 O. ~2 w0 a, A
1. Open a terminal window) ]+ M$ u7 u3 K+ w4 ~3 z% E
2. Log in as "root"2 p5 S# J; Z: k& R) H" E |
3. Run the scripts. y0 k' n& f E H% d
4. Return to this window and hit "Enter" key to continue Successfully Setup Software. #-------------------------------------------------------------------
; W0 A i; S1 t O1 A8 h $ cd $ORACLE_BASE/oraInventory/logs/ ]) W3 @+ D% d( x; T
$ tail -100f installActions*.log 运行orainstRoot.sh和root.sh2 u! P' k D2 O6 g8 Y* ^
$ su -- S \1 T$ K, t
# /opt/oracle/oraInventory/orainstRoot.sh
+ V i4 a2 \/ D+ z a2 k # more /etc/oraInst.loc0 F) T( q. I0 i& N) `
# /opt/oracle/11.2.0/root.sh # more /etc/oratab( q) u; e c4 U! v9 k& g$ m
# su - oracle $ $ORACLE_HOME/bin/netca /silent /responsefile /home/oracle/netca.rsp $ ll $ORACLE_HOME/network/admin/*.ora $ lsnrctl status 静默建库
. W( R- k/ i4 ~7 y! f7 k4 O [GENERAL] RESPONSEFILE_VERSION = "11.2.0" OPERATION_TYPE = "createDatabase" [CREATEDATABASE]
1 D ]0 c& _) m8 s' D# ]2 r" | TEMPLATENAME = "General_Purpose.dbc"- o$ T* A# m3 z6 z
[CREATEDATABASE] GDBNAME = "ge01" SID = "ge01" SYSPASSWORD = "georacle" SYSTEMPASSWORD = "georacle" EMCONFIGURATION = "LOCAL" DBSNMPPASSWORD = "georacle" CHARACTERSET = " ZHS16GBK" MEMORYPERCENTAGE = "40"
+ D# j8 P* K) o. [4 y& y # !/bin/bash' Z2 M/ J# R' ]7 W
# chkconfig: 345 51 49" r1 o: |+ J7 F$ p! o% [9 v7 r
# description: starts the oracle dabase deamons
/ D4 S8 L7 `7 c' g7 V% i: N$ C # ORACLE_HOME=/opt/oracle/11.2.0 ORACLE_OWNER=oracle ORACLE_DESC="Oracle 11g" ORACLE_LOCK=/opt/oracle/oracle.lock case "$1" in 'start') echo -n \"Starting ${ORACLE_DESC}:\" runuser - $ORACLE_OWNER -c '$ORACLE_HOME/bin/dbstart' touch ${ORACLE_LOCK}
1 Y+ q" \/ l- g1 z echo ;; 'stop') echo -n "shutting down ${ORACLE_DESC}: " runuser - $ORACLE_OWNER -c '$ORACLE_HOME/bin/dbshut' rm -f ${ORACLE_LOCK}
1 _4 D: O9 z( b echo ;; 'restart') echo -n "restarting ${ORACLE_DESC}:" $0 stop $0 start echo ;; *)
+ O/ a/ O# ]) G6 _ echo "usage: $0 { start | stop | restart }" exit 1 esac exit 0 chmod 744 /etc/init.d/oracle11g
. Z8 D+ j; A5 M7 d9 q3 o2 X ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;9 \/ c" t2 a1 }1 u- N* F
alter database add logfile '/opt/oracle/oradata/ge01/redo04.log' size 150M;! u" U6 A2 h f
alter database add logfile '/opt/oracle/oradata/ge01/redo05.log' size 150M;$ M6 ~2 V* w! W
alter database add logfile '/opt/oracle/oradata/ge01/redo06.log' size 150M;5 i' W5 @% a$ O
alter tablespace users add datafile '/opt/oracle/oradata/ge01/users02.dbf' size 100M autoextend on next 10M;
" M5 i& J6 w! ] alter tablespace users add datafile '/opt/oracle/oradata/ge01/users03.dbf' size 100M autoextend on next 10M;
6 z3 V" i# { [0 L5 s alter system set open_cursors = 500 scope=spfile;0 i# @. P0 ^, V ~: v7 ^
alter system set processes=350 scope=spfile;
2 G$ n: X9 `/ C" G6 u6 C alter system set sessions=350 scope=spfile;: \/ M) j" {5 k/ }: F9 w
shutdown immediate
) i. }2 R* e: z startup |