發現9i的Silent安裝和10以上版本還有所不同，簡單描述一下安裝過程。

首先是檢查系統情況：

root@newtrade1 # /usr/sbin/prtconf | grep "Memory size"
Memory size: 32768 Megabytes
root@newtrade1 # /usr/sbin/swap -l
swapfile             dev swaplo blocks   free
/dev/md/dsk/d20     85,20     16 63498224 63498224
root@newtrade1 # df -k /data
Filesystem            kbytes    used   avail capacity Mounted on
/dev/dsk/emcpower4g 619339184 280169072 332976721    46%    /data

對於當前的伺服器而言，硬體方面不是問題。

下面是檢查作業系統的情況：

root@newtrade1 # uname -a
SunOS newtrade1 5.10 Generic_127111-06 sun4u sparc SUNW,Sun-Fire-V490
root@newtrade1 # pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWsprot SUNWtoo SUNWi1of SUNWxwfnt
system      SUNWarc   Lint Libraries (usr)
system      SUNWbtool CCS tools bundled with SunOS
system      SUNWhea   SunOS Header Files
system      SUNWi1of ISO-8859-1 (Latin-1) Optional Fonts
system      SUNWlibm Math & Microtasking Library Headers & Lint Files (Usr)
system      SUNWlibms Math & Microtasking Libraries (Usr)
system      SUNWsprot Solaris Bundled tools
system      SUNWtoo   Programming Tools
system      SUNWxwfnt X Window System platform. required fonts

對於Solaris 10而言，安裝920這種低版本的資料庫，也不會存在問題。

檢查JRE所需版本，最新版本要求是1.1.8：

root@newtrade1 # java -version
java version "1.5.0_12"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04)
Java HotSpot(TM) Server VM (build 1.5.0_12-b04, mixed mode)

下面檢查/etc/system檔案，確保其中的設定大於Oracle推薦的預設設定。

這裡由於安裝過一個其他版本的資料庫，因此不需要在進行調整了：

set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=21474836479
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10

如果這裡進行設定，需要重啟伺服器。當然Solaris10已經有辦法不重啟系統來修改這些引數的設定了，這裡就不詳細描述了。

執行下面的語句建立oracle使用者和dba、oinstall組，由於當前伺服器上，oracle使用者已經存在，就跳過這個步驟了。

# groupadd dba
# groupadd oinstall
# mkdir /export/home/oracle
# useradd -g oinstall -G dba -d /export/home/oracle oracle
# passwd oracle
# chown -R oracle:oinstall /export/home/oracle
# chown -R oracle:oinstall /data

下面切換為oracle使用者，編輯.profile檔案如下：

umask 022
ORACLE_SID=single92
export ORACLE_SID
ORACLE_BASE=/data/oracle
export ORACLE_BASE
ORACLE_HOME=/data/oracle/product/9.2
export ORACLE_HOME
NLS_LANG='SIMPLIFIED CHINESE_CHINA.ZHS16GBK'
export NLS_LANG
PATH=$PATH:$ORACLE_HOME/bin
export PATH

由於採用SILENT安裝模式，因此不需要設定DISPLAY引數。

下面開始安裝過程，首先編輯一個my_install.rsp檔案，內容大致如下：

[General]

RESPONSEFILE_VERSION=1.7.0

[SESSION]
UNIX_GROUP_NAME="oinstall"

FROM_LOCATION="/data/oracle9/oracle_cd/disk1/stage/products.jar"

ORACLE_HOME="/data/oracle/product/9.2"

ORACLE_HOME_NAME="OracleHome92"

TOPLEVEL_COMPONENT={"oracle.server","9.2.0.1.0"}

DEINSTALL_LIST={"oracle.server","9.2.0.1.0"}

SHOW_ROOTSH_CONFIRMATION=true

LOCATION_FOR_DISK2="/data/oracle9/oracle_cd/disk2"
LOCATION_FOR_DISK3="/data/oracle9/oracle_cd/disk3"

#
# Oracle9i Database
#

[oracle.server_9.2.0.1.0]

COMPONENT_LANGUAGES={"en","zh_CN"}

INSTALL_TYPE="EE"

s_cfgtyperet="Customized"

[oracle.rdbms_9.2.0.1.0]

sl_dbaOperGroups={"dba","dba"}

[oracle.assistants.dbca_9.2.0.1.0]

OPTIONAL_CONFIG_TOOLS={"dbca"}

s_responseFileName="/data/oracle9/oracle_cd/disk1/response/my_dbca.rsp"

簡單描述一下主要引數的含義：

FROM_LOCATION引數指出Oracle讀取配置資訊的位置，這裡最好透過絕對路徑指出products.jar檔案的位置。在10g以上版本，這個檔案變為products.xml，從這裡也可以看出Oracle的轉變過程。

ORACLE_HOME和ORACLE_HOME_NAME分別指出ORACLE_HOME的路徑和ORACLE_HOME對應的名稱。

TOPLEVEL_COMPONENT引數為安裝元件和版本資訊。

DEINSTALL_LIST引數為對應的解除安裝資訊和版本。

SHOW_ROOTSH_CONFIRMATION設定顯示執行root指令碼的提示資訊。其他的SHOW_引數都可以忽略。

LOCATION_FOR_DISK2和LOCATION_FOR_DISK3：這兩個引數是9i特有的，10g以後預設都是一個安裝檔案，而9i包括了3個，因此需要這兩個引數指出DISK2和DISK3兩個安裝檔案的位置。

COMPONENT_LANGUAGES引數設定安裝的語句，這裡新增了簡體中文。

INSTALL_TYPE引數設定安裝類似，EE表示企業版。

s_cfgtyperet：選擇定製方式，在安裝結束後透過dbca來建立資料庫。

sl_dbaOperGroups設定SYSDBA和SYSOPER對應的作業系統組資訊。

OPTIONAL_CONFIG_TOOLS設定在安裝結束後啟動DBCA來進行建庫操作。

s_responseFileName引數設定dbca的silent安裝所需的response檔案位置。

下面編輯dbca所需要的response檔案，my_dbca.rsp：

[GENERAL]

RESPONSEFILE_VERSION = "9.2.0"

CREATE_TYPE = "createDatabase"

[CREATEDATABASE]

GDBNAME = "single92.us.oracle.com"

SID = "single92"

TEMPLATENAME = "New Database"

CHARACTERSET = "ZHS16GBK"

NATIONALCHARACTERSET= "AL16UTF16"

DBCA的response檔案中的引數都很容易理解，這裡就不詳細描述了。

需要注意，由於當前環境下已經存在高版本資料庫，因此這裡就不啟用NETCA進行LISTENER和TNSNAMES的設定了。如果需要進行設定可以設定引數OPTIONAL_CONFIG_TOOLS和s_responseFileName，方法與dbca設定類似。

bash-3.00$ ./runInstaller -silent -responseFile /data/oracle9/oracle_cd/disk1/response/my_install.rsp

bash-3.00$
DISPLAY not set. Please set the DISPLAY and try again.
: No such file or directory

bash-3.00$ export DISPLAY=172.0.2.54:1.0
bash-3.00$ ./runInstaller -silent -responseFile /data/oracle9/oracle_cd/disk1/response/my_install.rsp

bash-3.00$ Initializing Java Virtual Machine from /tmp/OraInstall2008-09-25_03-00-28PM/jre/bin/java. Please wait...
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
Font specified in font.properties not found [-urw-itc zapfdingbats-medium-r-normal--*-%d-*-*-p-*-sun-fontspecific]
In UNIX Group Name Page
In Cluster Node Selection Page
In File Locations Page
In Available Products Page
In Installation Types Page
In Component Locations Page
In Title Page
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
In Summary Page
In End of Installation Page
The installation of Oracle9i Database was successful, but some optional configuration tools failed or were canceled.
Please check /data/oracle/oraInventory/logs/silentInstall2008-09-25_03-00-28PM.log for more details.

9i的silent和10g以上還不一樣，必要要求一個可用DISPLAY設定，即使在Silent模式下根本不用這個設定。

下面檢查一下日誌資訊：

bash-3.00$ more /data/oracle/oraInventory/logs/silentInstall2008-09-25_03-00-28PM.log
silentInstall2008-09-25_03-00-28PM.log
Error :*** Alert: A configuration script. needs to be run as root before installation can proceed. Please leave this window up, go run /data/oracle/product/9.2/root.sh as root from another window, then come back here and click OK to continue. ***
Configuration tool Oracle Database Configuration Assistant failed
Look at the log file "/data/oracle/product/9.2/assistants/dbca/logs/orcl.log" for further details.

Error :*** Alert: One or more tools have failed. It is recommended but not required that these tools succeed for this installation.
You can now select these tools, read its details to examine why they failed, fix those problems, and retry them. Or, you can click "
Next" to continue. ***
The installation of Oracle9i Database was successful, but some optional configuration tools failed or were canceled.

問題在於沒有執行root.sh指令碼，下面手工執行root.sh：

root@newtrade1 # /data/oracle/product/9.2/root.sh
Running Oracle9 root.sh script...

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /data/oracle/product/9.2

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:

Adding entry to /var/opt/oracle/oratab file...
Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

下面手工啟動dbca：

bash-3.00$ $ORACLE_HOME/bin/dbca -silent -responseFile /data/oracle9/oracle_cd/disk1/response/my_dbca.rsp
Look at the log file "/data/oracle/admin/single92/create/single92.log" for further details.

居然在安裝全程沒有任何一點的提示，看來10g以上的Silent安裝已經人性化多了。檢查一下日誌檔案：

bash-3.00$ more /data/oracle/admin/single92/create/single92.log
Database creation completed. See logfiles at /data/oracle/admin/single92/create for details.

Database Information:

global database name: single92.us.oracle.com
database system identifier (SID): single92
SYS account password: change_on_install
SYSTEM account password: manager.
Note: All other database accounts have been locked. Oracle highly RECOMMENDS to change the default passwords of all the users.

至此9201的SILENT安裝完成：

bash-3.00$ $ORACLE_HOME/bin/sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on 星期四 9月 25 15:58:41 2008

連線到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

由於Oracle建立資料庫的大部分引數採用了預設的設定，剩下還需要手工進行調整。

Soloaris 10上9201的SILENT安裝

相關文章