Oracle是全球領先的資料庫管理系統，其11g版本受到許多企業和個人使用者的青睞。然而，Oracle11g的安裝過程較為繁瑣，如果需要在多台機器上進行安裝，則會耗費大量的時間和人力資源。為了提高安裝效率，Oracle提供了靜默安裝的方法，可在不人為幹預的情況下完成軟體的自動安裝。本文將介紹如何進行Oracle11g的靜默安裝。

一、準備工作
在進行Oracle11g的靜默安裝之前，需要先準備好以下工作：
1.Oracle11g安裝介質，一般為光碟或ISO鏡像；
2.Oracle11g安裝檔案的回應檔案(.rsp檔案)，可以使用Oracle提供的範本檔案進行修改；
3.安裝計畫表(.lst檔案)，用於記錄安裝流程和錯誤訊息；
4.管理員權限的命令列介面或終端，以及足夠的磁碟空間和記憶體資源。

二、建立回應檔
回應檔(.rsp檔)是Oracle11g靜默安裝的關鍵，其記錄了安裝過程中需要輸入的各種參數資訊。 Oracle提供了範本檔案(如db_install.rsp)可供修改，如果需要自訂安裝參數，可以根據實際情況對檔案內容進行修改。以下是典型的回應檔案範例：

The response file for installing Oracle Database 11gR2

This file is generated by the Oracle Universal Installer.

[GENERAL]

Location of the Oracle base directory.

ORACLE_BASE="/u01/app/oracle"

Name of the Oracle inventory directory.

INVENTORY_LOCATION="/ u01/app/oraInventory"

The location for your Oracle home.

ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1"

The name of the database. This is typically a name that

starts with a letter and contains up to 8 characters.

ORACLE_SID="orcl"

Global database name.

GDBNAME="orcl"

Character set of the database.

CHARACTERSET="AL32UTF8"

Specify whether to install the database software or create a

database. Choose "Software Only" for database software

installation.

INSTALL_OPTION="INSTALL_DB_AND_CONFIG"

Specify whether to create a database or upgrade an existing Specify whether to create a database or upgrade an existing Specify whether to create a database or upgrade an existing .

Choose "Create Database" for new database creation.

Choose "Upgrade an Existing Database" to upgrade an

existing database.

#CREATE_DATABASE_TYPE= "CREATE_DATABASE"

Password for SYS and SYSTEM users.

SYS_PASSWORD="password"
SYSTEM_PASSWORD="password"

Database file location.

#DATA_LOCATION="/u01/app/oracle/oradata"

Control file location.

DB_CONTROL_FILES_LOCATION="/u01/app/oracle/oradata"
DB_CONTROL_FILES="ora_control1/app/oracle/oradata"

DB_CONTROL_FILES="ora_control1/app/ora_control1,2 。 PGA.

TOTAL_MEMORY=2048

[LANGUAGE]

Language of the installation.

##Valid values are: AMERICAN_AMERICA.WE8ISO8859P1,

#P1,

# #AMERICAN_AMERICA.UTF8, or other valid character set names.

You can also supply your own language name.

SELECTED_LANGUAGES="AMERICAN_AMERICA.UTF8"#O.

##Installation type.

INSTALL_TYPE="Typical"

[INSTALLUPDATES]

Specify whether to check for product updates.

##UPDATES_CHECK= TRUE

[SECURITY]

Activate security options

SECURITY_UPDATES_VIA_MYORACLESUPPORT=FALSE

[SYSTEMCLASS]

Enter the system class,

[SYSTEMCLASS]

Enter the system class, which determines the maximum number

of memory allowed for SGA and PGA.

Valid values are: Desktop, Server, or Custom

#If you choose Custom, you must specify the memory size##If you choose Custom, you must specify the memory size##If you choose Custom, you must specify the memory size##If you choose Custom, you must specify the memory size yourself.

The following example is for a server class machine.

oracle.install.db.config.starterdb.memoryLimit=1024

[DATABASE]

Specify the template to use when creating the database.

TEMPLATE_NAME="General_Purpose.dbc"

Global database name for this database.

GDBNAME="orcl"

Password for SYS and SYSTEM users.

SYS_PASSWORD="password"

SYSTEM_PASSWORD="password"

Character set for the database.

CHARACTERSET ="AL32UTF8"

National character set for the database.

NATIONAL_CHARACTERSET="UTF8"

Database file location.

#DATA_LOCATION="/u01/ app/oracle/oradata"

Control file location.

DB_CONTROL_FILES_LOCATION="/u01/app/oracle/oradata"

Redo log file location.

######################################################################################################################################################################################### # #DB_RECOVERY_FILE_DEST="/u01/app/oracle/flash_recovery_area"###DB_RECOVERY_FILE_DEST_SIZE=2G###