使用靜默方式安裝11g資料庫

環境：
LINUX 6.3 
oracle11g 11.2.0.3

現象：
在安裝資料庫時，無法啟動資料庫安裝的圖形介面，一直報could not execute auto check for display colors using command /usr/bin/xdpyinfo，導致無法啟動oracle的安裝介面。

採用靜默方式安裝資料庫

1）修改rsp檔案，下面是我修改的rsp檔案內容
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=r11g
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oracle/oraInventory
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba

oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.config.starterdb.password.ALL=oracle

2）安裝資料庫軟體
執行命令

[oracle@r11g database]$ ./runInstaller -silent -responseFile /opt/setup/database/init.rsp 
說明：
-responseFile 引數必須是絕對路徑
執行過程中，這個頁面不要動，也不要關閉。可以在新的頁面進行日誌監控

tail -100f /u01/app/oracle/oraInventory/logs/installActions2013-11-08_11-37-44PM.log

指令碼執行完後，有如下提示
[oracle@r11g ~]$ The installation of Oracle Database 11g was successful.

Please check '/u01/app/oracle/oraInventory/logs/silentInstall2013-11-08_11-37-44PM.log' for more details.

 

As a root user, execute the following script(s):

        1. /u01/app/oracle/oraInventory/orainstRoot.sh

        2. /u01/app/oracle/product/11.2.0/db_1/root.sh

 Successfully Setup Software.

3）執行相關指令碼

[root@r11g ~]# /u01/app/oracle/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oracle/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

 Changing groupname of /u01/app/oracle/oraInventory to oinstall.

The execution of the script is complete.

[root@r11g ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh

Check /u01/app/oracle/product/11.2.0/db_1/install/root_r11g_2013-11-08_23-47-49.log for the output of root script

檢查root.sh指令碼執行情況

[root@r11g ~]# more  /u01/app/oracle/product/11.2.0/db_1/install/root_r11g_2013-11-08_23-47-49.log

 Performing root user operation for Oracle 11g

 The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/db_1

 Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

4）軟體安裝後測試

[oracle@r11g ~]$ sqlplus "/as sysdba"

 SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 8 23:49:57 2013

 Copyright (c) 1982, 2011, Oracle.  All rights reserved.

 Connected to an idle instance.

 SQL>  

5）編輯初始化引數檔案

db_name='db'

db_block_size=8192

memory_target=1G

memory_max_target=1G

processes = 150

control_files = ('/u01/app/oracle/oradata/control/control01.ctl', '/u01/app/oracle/oradata/control/control02.ctl')

job_queue_processes=10

open_cursors=300

fast_start_mttr_target=500

undo_tablespace='UNDOTBS1'

undo_management=AUTO

remote_login_passwordfile='EXCLUSIVE'

audit_file_dest='/u01/app/oracle/admin/db/adump'

audit_trail ='db'

db_domain=''

db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'

db_recovery_file_dest_size=2G

diagnostic_dest='/u01/app/oracle'

dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'

compatible ='11.2.0'

6）建立相關目錄

mkdir -p /u01/app/oracle/oradata/control

mkdir -p /u01/app/oracle/admin/db/adump

mkdir -p /u01/app/oracle/flash_recovery_area

 

在建庫指令碼中的路徑，也需要提前建立。

7）執行建庫指令碼

CREATE DATABASE db

   USER SYS IDENTIFIED BY oracle

   USER SYSTEM IDENTIFIED BY oracle

   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/redolog/redo01a.log','/u01/app/oracle/oradata/redolog/redo01b.log') SIZE 100M,

           GROUP 2 ('/u01/app/oracle/oradata/redolog/redo02a.log','/u01/app/oracle/oradata/redolog/redo02b.log') SIZE 100M,

           GROUP 3 ('/u01/app/oracle/oradata/redolog/redo03a.log','/u01/app/oracle/oradata/redolog/redo03b.log') SIZE 100M

   MAXLOGFILES 5

   MAXLOGMEMBERS 5

   MAXLOGHISTORY 1

   MAXDATAFILES 200

   CHARACTER SET ZHS16GBK

   NATIONAL CHARACTER SET AL16UTF16

   EXTENT MANAGEMENT LOCAL

   DATAFILE '/u01/app/oracle/oradata/db/system01.dbf' SIZE 500M

   SYSAUX DATAFILE '/u01/app/oracle/oradata/db/sysaux01.dbf' SIZE 500M

   DEFAULT TABLESPACE users

      DATAFILE '/u01/app/oracle/oradata/db/users01.dbf'

      SIZE 500M AUTOEXTEND off

   DEFAULT TEMPORARY TABLESPACE tempts1

      TEMPFILE '/u01/app/oracle/oradata/db/temp01.dbf'

      SIZE 20M

   UNDO TABLESPACE UNDOTBS1

      DATAFILE '/u01/app/oracle/oradata/db/undotbs01.dbf'

      SIZE 200M AUTOEXTEND off;

8）執行指令碼建立資料字典檢視

使用sys使用者執行下面指令碼

 @?/rdbms/admin/catalog.sql

@?/rdbms/admin/catproc.sql

 使用system使用者執行下面指令碼

@?/sqlplus/admin/pupbld.sql

至此，資料庫安裝完成