【正文】 情況 ................................................................................................................... 20 6 安裝產(chǎn)品測(cè)試結(jié)果 ............................................................................................................ 22 7 產(chǎn)品安裝驗(yàn)收 方法 ............................................................................................................ 23 RDBMS啟動(dòng)和關(guān)閉 .................................................................................................. 23 確認(rèn)產(chǎn)品版本 ............................................................................................................ 24 RAC安裝確認(rèn) .......................................................................................................... 25 數(shù)據(jù)庫(kù)歸檔狀態(tài) ........................................................................................................ 26 SQL*NET 狀態(tài) ......................................................................................................... 26 SQL*PLUS ............................................................................................................... 27 PROC*C .................................................................................................................... 28 RAC測(cè)試 ................................................................................................................. 28 8 ORACLE數(shù)據(jù)庫(kù)結(jié)構(gòu)檢查 ............................................................................................... 29 初始化參數(shù)文件 ........................................................................................................ 29 控制文件 ................................................................................................................... 30 日志文件 ................................................................................................................... 30 數(shù)據(jù)庫(kù)歸檔模式 ........................................................................................................ 30 排序區(qū) ...................................................................................................................... 31 表空間 ...................................................................................................................... 31 數(shù)據(jù)文件 ................................................................................................................... 33 回退段 ...................................................................................................................... 33 錯(cuò)誤日志文件 ............................................................................................................ 34 9 附錄 ................................................................................................................................. 34 附 1 建庫(kù)腳本 ........................................................................................................... 34 附 2 建表空間腳本 .................................................................................................... 37 空間使用情況 ............................................................................................................ 47 ORACLE9i數(shù)據(jù)庫(kù)安裝手冊(cè) 4 1 概述 本報(bào)告的目的是為了提供福建地稅詳盡的 ORACLE 數(shù)據(jù)庫(kù)軟件安裝過(guò)程，同時(shí)檢驗(yàn)Oracle 產(chǎn)品的安裝是否合格并描述所安裝的 Oracle 產(chǎn)品的驗(yàn)收方法。建議 /tmp 空間剩余空間大約100MB。s Password: ./ Creating Oracle Inventory pointer file (/etc/) Changing groupname of /test/app/oracle/oraInventory to dba. 否則安裝界面將會(huì)出現(xiàn)如下的錯(cuò)誤提示： ORACLE9i數(shù)據(jù)庫(kù)安裝手冊(cè) 7 修改 unix group 名為 DBA ORACLE9i數(shù)據(jù)庫(kù)安裝手冊(cè) 8 選擇安裝 ORACLE9i 數(shù)據(jù)庫(kù)，進(jìn)入如下界面： ORACLE9i數(shù)據(jù)庫(kù)安裝手冊(cè) 9 選擇 custom安裝方式： 選擇需要安裝的產(chǎn)品，其中 RAC、分區(qū)等必須安裝以滿足地稅征管信息系統(tǒng)的需要。s Password: ./ Running Oracle9 script... The following environment variables are set as: ORACLE9i數(shù)據(jù)庫(kù)安裝手冊(cè) 14 ORACLE_OWNER= oracle ORACLE_HOME= /oracle/app/oracle/product/ ORACLE_SID= fzlt Enter the full pathname of the local bin directory: [/usr/local/bin]: Creating /usr/local/bin directory... Entry will be added to the /etc/oratab file by Database Configuration Assistant when a database is created Finished running generic part of script. Now productspecific root actions will be performed. IMPORTANT NOTE: Please delete any log and trace files previously created by the Oracle Enterprise Manager Intelligent Agent. These files may be found in the directories you use for storing other Net8 log and trace files. If such files exist, the OEM IA may not restart. 數(shù)據(jù)庫(kù)安裝完畢后，可以繼續(xù)以后的工作，諸如配置監(jiān)聽進(jìn)程、創(chuàng)建數(shù)據(jù)庫(kù)等工作。因此，我們需要生成建庫(kù)腳本而不使用該界面進(jìn)行數(shù)據(jù)庫(kù)的創(chuàng)建工作，建庫(kù)腳本參見附件。 *.cluster_database_instances=2 *.cluster_database=true *.patible=39。,39。 *.core_dump_dest=39。 *.db_file_multiblock_read_count=64 *.db_files=2020 *.db_name=39。 =39。 =39。 *.remote_listener=39。 *.shared_pool_size=1048576000 *.sort_area_size=10485760 *.star_transformation_enabled=39。 *.undo_retention=108000 =39。 *.user_dump_dest=39。 ORACLE9i數(shù)據(jù)庫(kù)安裝手冊(cè) 23 Sql*Net 以 oracle 用戶執(zhí)行 : $lsnrctl start $sqlplus scott/tigeralias 說(shuō)明：檢查 $ORACLE_HOME/work/admin目 錄 下 是 否 配 置 了 和 文件以及配置是否正確。 7 產(chǎn)品安裝驗(yàn)收方法 RDBMS啟動(dòng)和關(guān)閉 1. 啟動(dòng) 以 oracle 用戶執(zhí)行： $ sqlplus /nolog SQL connect / as sysdba SQL startup 正確結(jié)果：