因聽到以前同事說到11.2.1版本在進行子查詢時，速度有時會莫名的慢下來。正好有時間，也是測試服務器，
那就把數據庫升級到11.2.3吧。原計劃是升級后可以直接使用數據庫的相關文件就能啟動數據庫。
但看來沒那么簡單了。

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 9 15:04:14 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options


SQL> startup;
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
SQL> exit



查看拷貝出來的spfile
[root@rac1 backup]# strings spfileracdb.ora
racdb1.__db_cache_size=3355443200
racdb2.__db_cache_size=3221225472
racdb2.__java_pool_size=67108864
racdb1.__java_pool_size=67108864
racdb2.__large_pool_size=67108864
racdb1.__large_pool_size=67108864
racdb1.__oracle_base='/opt/app/oracle'#ORACLE_BASE set from environment
racdb2.__oracle_base='/opt/app/oracle'#ORACLE_BASE set from environment
racdb2.__pga_aggregate_target=3019898880
racdb1.__pga_aggregate_target=3019898880
racdb2.__sga_target=4429185024
racdb1.__sga_target=442918502
racdb2.__shared_io_pool_size=0
racdb1.__shared_io_pool_size=0
racdb1.__shared_pool_size=872415232
racdb2.__shared_pool_size=1006632960
racdb2.__streams_pool_size=0
racdb1.__streams_pool_size=0
*.audit_file_dest='/opt/app/oracle/admin/racdb/adump'
*.audit_trail='db'
*.cluster_database=TRUE
*.compatible='11.2.0.0.0'
*.control_files='+DATA/racdb/controlfile/current.256.811264577','+RECOVERY/racdb/controlfile/current.2
*.db_block_size=8192
*.db_create_file_dest='+DATA'
b_domain=''
*.db_name='racdb'
*.db_recovery_file_dest='+RECOVERY'
*.db_recovery_file_dest_size=83886080000
*.diagnostic_dest='/opt/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=racdbXDB)'
racdb1.instance_number=1
racdb2.instance_number=2
racdb1.log_archive_format='arch1_%s_%R_%T.arc'
racdb2.log_archive_format='arch2_%s_%R_%T.arc'
*.memory_target=7448035328
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.processes=150
*.remote_listener='rac-scan:1
521'
*.remote_login_passwordfile='exclusive'
racdb2.thread=2
racdb1.thread=1
racdb1.undo_tablespace='UNDOTBS1'
racdb2.undo_tablespace='UNDOTBS2'

看到這個目錄沒有：'/opt/app/oracle/admin/racdb/adump'
各節點建立





SQL> startup;
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/racdb/spfileracdb.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/racdb/spfileracdb.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +DATA/racdb/spfileracdb.ora
ORA-15173: entry 'spfileracdb.ora' does not exist in directory 'racdb'
ORA-06512: at line 4

SQL> select instance_name, status from v$instance;

INSTANCE_NAME?? ??? ??? ? STATUS
-------------------------------- ------------------------
racdb1?? ??? ??? ??? ? STARTED


ORACLE_BASE from environment = /opt/app/oracle
Tue Apr 09 14:46:35 2013
Could not open audit file: /opt/app/oracle/admin/racdb/adump/racdb1_ora_32435_2.aud
Retry Iteration No: 1?? OS Error: 0
Retry Iteration No: 2?? OS Error: 2
Retry Iteration No: 3?? OS Error: 2
Retry Iteration No: 4?? OS Error: 2
Retry Iteration No: 5?? OS Error: 2
OS Audit file could not be created; failing after 5 retries
Tue Apr 09 15:04:17 2013
NOTE: failed to open SPFILE +DATA/racdb/spfileracdb.ora
[root@rac1 trace]# pwd
/opt/app/oracle/diag/rdbms/racdb/racdb1/trace


[root@rac1 trace]# /opt/app/grid/bin/srvctl config database -d racdb -a
PRCD-1120 : 找不到數據庫 racdb 的資源。
PRCR-1001 : 資源 ora.racdb.db 不存在

看來是在RAC沒有建立叫RACDB的數據庫
[grid@rac1 ~]$ srvctl add database -d racdb -d racdb -o $ORACLE_HOME
PRKO-2004 : 命令行選項重復: -d
[grid@rac1 ~]$ srvctl add database -d racdb? -o $ORACLE_HOME
[grid@rac1 ~]$ crs_stat -t
Name?????????? Type?????????? Target??? State???? Host?????? ?
------------------------------------------------------------
ora.CRS.dg???? ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora.DATA.dg??? ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora....ER.lsnr ora....er.type ONLINE??? ONLINE??? rac1?????? ?
ora....N1.lsnr ora....er.type ONLINE??? ONLINE??? rac1?????? ?
ora....VERY.dg ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora.asm??????? ora.asm.type?? ONLINE??? ONLINE??? rac1?????? ?
ora.cvu??????? ora.cvu.type?? ONLINE??? ONLINE??? rac1?????? ?
ora.gsd??????? ora.gsd.type?? OFFLINE?? OFFLINE????????????? ?
ora....network ora....rk.type ONLINE??? ONLINE??? rac1?????? ?
ora.oc4j?????? ora.oc4j.type? ONLINE??? ONLINE??? rac1?????? ?
ora.ons??????? ora.ons.type?? ONLINE??? ONLINE??? rac1?????? ?
ora....SM1.asm application??? ONLINE??? ONLINE??? rac1?????? ?
ora....C1.lsnr application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.gsd?? application??? OFFLINE?? OFFLINE????????????? ?
ora.rac1.ons?? application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.vip?? ora....t1.type ONLINE??? ONLINE??? rac1?????? ?
ora....SM2.asm application??? ONLINE??? ONLINE??? rac2?????? ?
ora....C2.lsnr application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.gsd?? application??? OFFLINE?? OFFLINE????????????? ?
ora.rac2.ons?? application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.vip?? ora....t1.type ONLINE??? ONLINE??? rac2?????? ?
ora.racdb.db?? ora....se.type OFFLINE?? OFFLINE????????????? ?
ora....ry.acfs ora....fs.type ONLINE??? ONLINE??? rac1?????? ?
ora.scan1.vip? ora....ip.type ONLINE??? ONLINE??? rac1?????? ?
[grid@rac1 ~]$ srvctl add instance -d racdb -n racdb1 -i rac1
PRKO-2006 : 節點名無效: racdb1
[grid@rac1 ~]$ srvctl add instance -d racdb -n rac1 -i racdb1
[grid@rac1 ~]$ srvctl add instance -d racdb -n rac2 -i racdb2
[grid@rac1 ~]$ srvctl add service -d racdb -s racdbservice -r racdb1 -a racdb2 -P BASIC
[grid@rac1 ~]$ srvctl config service -d racdb -s racdbservice -a
警告: -a 選項已過時, 將忽略該選項。
服務名: racdbservice
服務已啟用
服務器池: racdb_racdbservice
基數: 1
斷開連接: 假
服務角色: PRIMARY
管理策略: AUTOMATIC
DTP 事務處理: 假
AQ HA 通知: 假
故障轉移類型: NONE
故障轉移方法: NONE
TAF 故障轉移重試次數: 0
TAF 故障轉移延遲: 0
連接負載平衡目標: LONG
運行時負載平衡目標: NONE
TAF 策略規范: BASIC
版本:
首選實例: racdb1
可用實例: racdb2
[grid@rac1 ~]$ service enable database -d racdb
-bash: service: command not found
[grid@rac1 ~]$ srvctl? enable database -d racdb
PRCC-1010 : racdb 已啟用
PRCR-1002 : 資源 ora.racdb.db 已啟用
[grid@rac1 ~]$ srvctl config database -d racdb -a
數據庫唯一名稱: racdb
數據庫名:
Oracle 主目錄: /opt/app/grid
Oracle 用戶: grid
Spfile:
域:
啟動選項: open
停止選項: immediate
數據庫角色: PRIMARY
管理策略: AUTOMATIC
服務器池: racdb
數據庫實例: racdb1,racdb2
磁盤組:
裝載點路徑:
服務: racdbservice
類型: RAC
數據庫已啟用
數據庫是管理員管理的
[grid@rac1 ~]$ crs_stat -t
Name?????????? Type?????????? Target??? State???? Host?????? ?
------------------------------------------------------------
ora.CRS.dg???? ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora.DATA.dg??? ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora....ER.lsnr ora....er.type ONLINE??? ONLINE??? rac1?????? ?
ora....N1.lsnr ora....er.type ONLINE??? ONLINE??? rac1?????? ?
ora....VERY.dg ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora.asm??????? ora.asm.type?? ONLINE??? ONLINE??? rac1?????? ?
ora.cvu??????? ora.cvu.type?? ONLINE??? ONLINE??? rac1?????? ?
ora.gsd??????? ora.gsd.type?? OFFLINE?? OFFLINE????????????? ?
ora....network ora....rk.type ONLINE??? ONLINE??? rac1?????? ?
ora.oc4j?????? ora.oc4j.type? ONLINE??? ONLINE??? rac1?????? ?
ora.ons??????? ora.ons.type?? ONLINE??? ONLINE??? rac1?????? ?
ora....SM1.asm application??? ONLINE??? ONLINE??? rac1?????? ?
ora....C1.lsnr application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.gsd?? application??? OFFLINE?? OFFLINE????????????? ?
ora.rac1.ons?? application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.vip?? ora....t1.type ONLINE??? ONLINE??? rac1?????? ?
ora....SM2.asm application??? ONLINE??? ONLINE??? rac2?????? ?
ora....C2.lsnr application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.gsd?? application??? OFFLINE?? OFFLINE????????????? ?
ora.rac2.ons?? application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.vip?? ora....t1.type ONLINE??? ONLINE??? rac2?????? ?
ora.racdb.db?? ora....se.type OFFLINE?? OFFLINE????????????? ?
ora....ice.svc ora....ce.type OFFLINE?? OFFLINE????????????? ?
ora....ry.acfs ora....fs.type ONLINE??? ONLINE??? rac1?????? ?
ora.scan1.vip? ora....ip.type ONLINE??? ONLINE??? rac1?????? ?
[grid@rac1 ~]$ srvctl config database -d racdb -a

總結

以上是生活随笔為你收集整理的数据库升级后，准备使用原有数据文件启动数据库的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。