無圖形界面情況下靜默安裝oracle

1、無圖形界面情況下靜默安裝oracle如果Server段沒有安裝X界面，如何來安裝Oracle呢？我們可以使用Oracle提供的靜默安裝來實現(xiàn)提示符下的Oracle安裝。安裝前的系統(tǒng)環(huán)境變量及內(nèi)核參數(shù)的設置這里就不重復了，可以查看安裝光盤中的安裝文檔。假設Oracle安裝文件已經(jīng)解壓至/u02 。 su - oraclemkdir -p /u01/app/oracle/1. 建立靜默安裝的配置文件cd /u02/database/responsevi enterprise01.rspRESPONSEFILE_VERSION=2. 開始安裝cd /u02/database/./runInstall

2、er -silent -responseFile /u02/database/response/enterprise01.rsp #注意-responseFile參數(shù)后的文件路徑一定是絕對路徑 ，并且enterprise01.rsp oracle用戶可讀。執(zhí)行過程如下：Installation in progress (Mon May 12 20:27:18 CST 2008).11% Done.23% Done.35% Done.47% Done. 55% Done.Install successfulLinking in progress (Mon May 12 20:30:01 CST

3、2008). 55% Done.Link successfulSetup in progress (Mon May 12 20:31:21 CST 2008). 100% Done.Setup successfulEnd of install phases.(Mon May 12 20:31:29 CST 2008)Starting to execute configuration assistantsConfiguration assistant Oracle Net Configuration Assistant succeeded Configuration assistant Orac

4、le Database Configuration Assistant failed SEVERE2008-05-12_08-26-55PM.log for more details.3. 運行安裝所需腳本vi /u01/app/oracle/oraInventory/logs/silentInstall2008-05-124.建立我們所需的目錄。5.建立pfile文件6.啟動數(shù)據(jù)庫到mount狀態(tài)mountORACLE instance started.Total System Global Area117440512 bytesFixed Size 1218004 bytesVariabl

5、e Size 58722860 bytesDatabase Buffers 50331648 bytesRedo Buffers 7168000 bytesDatabase mounted.使用默認的參數(shù)建立spfile SQL create spfile from pfile;重新啟動數(shù)據(jù)庫SQL shutdown immediateSQL startup mount更改sga_max_size，sga_target參數(shù)的值 。SQL alter system set sga_max_size=200M scope=spfile;SQL alter system set sga_target

6、=160M scope=spfile;然后再次重新啟動數(shù)據(jù)庫SQL shutdown immediateSQL startup mount7.用rman連接數(shù)據(jù)庫8.還原數(shù)據(jù)庫run set newname for datafile /ade/aime_10.2_lnx_push/oracle/oradata/seeddata/system01.dbf to /u01/app/oracle/oradata/orcl/system01.dbf;set newname for datafile /ade/aime_10.2_lnx_push/oracle/oradata/seeddata/sysa

7、ux01.dbf to /u01/app/oracle/oradata/orcl/sysaux01.dbf;set newname for datafile /ade/aime_10.2_lnx_push/oracle/oradata/seeddata/undotbs01.dbf to /u01/app/oracle/oradata/orcl/undotbs01.dbf;set newname for datafile /ade/aime_10.2_lnx_push/oracle/oradata/seeddata/users01.dbf to /u01/app/oracle/oradata/o

8、rcl/users01.dbf;restore database;switch datafile all;cd /u01/app/oracle/oradata/orcl oracleman /u01/app/oracle/oradata/orcl$ lsSeed_Database.ctlsysaux01.dbfsystem01.dbfundotbs01.dbfusers01.dbf可以看到我們所需要的數(shù)據(jù)文件都還原回來了，但是現(xiàn)在還缺少log file 。我們現(xiàn)在打開數(shù)據(jù)庫。因為控制文件中記錄的log file路徑為 /ade/aime_10.2_lnx_push/oracle/oradata

9、/seeddata 所以要先創(chuàng)建相應的目錄。SQL alter database open resetlogs;此時，在目錄/ade/aime_10.2_lnx_push/oracle/oradata/seeddata 下創(chuàng)建了redo01.log，redo02.log，redo03.log,temp01.dbf文件。我們要更改這幾個文件的路徑，所以先將數(shù)據(jù)庫關閉，然后cp /ade/aime_10.2_lnx_push/oracle/oradata/seeddata/ /u01/app/oracle/oradata/orcl/啟動數(shù)據(jù)庫到mount狀態(tài)，并更改日志和臨時文件的路徑SQL al

10、ter database rename file /ade/aime_10.2_lnx_push/oracle/oradata/seeddata/redo01.log to /u01/app/oracle/oradata/orcl/redo01.log;Database altered.SQL alter database rename file /ade/aime_10.2_lnx_push/oracle/oradata/seeddata/redo02.log to /u01/app/oracle/oradata/orcl/redo02.log;Database altered.SQL al

11、ter database rename file /ade/aime_10.2_lnx_push/oracle/oradata/seeddata/redo03.log to /u01/app/oracle/oradata/orcl/redo03.log;Database altered.SQL alter database rename file /ade/aime_10.2_lnx_push/oracle/oradata/seeddata/temp01.dbf to /u01/app/oracle/oradata/orcl/temp01.dbf;Database altered.SQL al

12、ter database open;到此數(shù)據(jù)庫已經(jīng)建立，并且數(shù)據(jù)文件也放到了我們期待的地方。但是還有一個問題，就是數(shù)據(jù)庫名稱不是我們事先期待的。SQL show parameter nameNAME TYPE VALUE- - -db_file_name_convert stringdb_name string SEEDDATAdb_unique_name string SEEDDATAglobal_names boolean FALSEinstance_name string orcllock_name_space stringlog_file_name_convert stringserv

13、ice_names string SEEDDATA下面我們將數(shù)據(jù)庫名稱SEEDDATA改成我們需要的orcl 。注意此時僅僅更改參數(shù)文件的值是不行的，因為控制文件中同樣也記錄著數(shù)據(jù)庫的名稱。9.更改數(shù)據(jù)庫名稱備份控制文件腳本SQL alter database backup controlfile to trace as /tmp/ctl.txt;SQL create pfile from spfile;將spfile刪除，編輯pfile將db_name=SEEDDATA 改成 db_name=rcl 。vi /tmp/ctl.txt 將其中如下一段CREATE CONTROLFILE REU

14、SE DATABASE SEEDDATA NORESETLOGSNOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILEGROUP 1 /u01/app/oracle/oradata/orcl/redo01.logSIZE 50M,GROUP 2 /u01/app/oracle/oradata/orcl/redo02.logSIZE 50M,GROUP 3 /u01/app/oracle/oradata/orcl/redo03.logSIZE 50M-

15、 STANDBY LOGFILEDATAFILE/u01/app/oracle/oradata/orcl/system01.dbf,/u01/app/oracle/oradata/orcl/undotbs01.dbf,/u01/app/oracle/oradata/orcl/sysaux01.dbf,/u01/app/oracle/oradata/orcl/users01.dbf,/u01/app/oracle/oradata/orcl/tt.dbfCHARACTER SET US7ASCII;修改為CREATE CONTROLFILE REUSE DATABASE SEEDDATA set

16、database ORCLRESETLOGSNOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILEGROUP 1 /u01/app/oracle/oradata/orcl/redo01.logSIZE 50M,GROUP 2 /u01/app/oracle/oradata/orcl/redo02.logSIZE 50M,GROUP 3 /u01/app/oracle/oradata/orcl/redo03.logSIZE 50MDATAFILE/u0

17、1/app/oracle/oradata/orcl/system01.dbf,/u01/app/oracle/oradata/orcl/undotbs01.dbf,/u01/app/oracle/oradata/orcl/sysaux01.dbf,/u01/app/oracle/oradata/orcl/users01.dbf,/u01/app/oracle/oradata/orcl/tt.dbfCHARACTER SET US7ASCII;重新啟動數(shù)據(jù)庫到nomount狀態(tài) 。運行上面的建立控制文件的腳本，然后打開數(shù)據(jù)庫 。SQL alter database open resetlogs; 10.控制文件更名并實現(xiàn)冗余。修改參數(shù)文件initorcl.ora*.control_file