Oracle undo_management參數不一致錯誤建站知識
導讀:1建站知識因RAC的undo_management參數不一致導致Oracle數據庫mount報ORA-01105 ORA-01606錯誤，本文就這個問題seo網站排名優化軟件seo網站優化培訓。
環境Linux 5.8 10.2.0.5 RAC,兩個節點只能一個節點mount,如果嘗試mount另外節點就報ORA-01105和ORA-01606錯誤數據庫版本
復制代碼 代碼如下:
SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi PL/SQL Release 10.2.0.5.0 - Production CORE 10.2.0.5.0 Production TNS for Linux: Version 10.2.0.5.0 - Production NLSRTL Version 10.2.0.5.0 - Production
crs資源情況復制代碼 代碼如下:
[oracle@node1 dbs]$ $ORA_CRS_HOME/bin/crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....D1.inst application OFFLINE OFFLINE ora....D2.inst application ONLINE ONLINE node2 ora.PROD.db application ONLINE ONLIseo網站優化軟件NE node2 ora....SM1.asm application ONLINE ONLINE node1 ora....E1.lsnr application ONLINE ONLINE node1 ora.node1.gsd application ONLINE ONLINE node1 ora.node1.ons application ONLINE ONLINE node1 ora.node1.vip application ONLINE ONLINE node1 ora....SM2.asm application ONLINE ONLINE node2 ora....E2.lsnr application ONLINE ONLINE node2 ora.node2.gsd application ONLINE ONLINE node2 ora.node2.ons application ONLINE ONLINE node2 ora.node2.vip application ONLINE ONLINE node2
聲明: 本文由我的SEOUC技術文章主頁發布于:2023-05-22 ，文章Oracle undo_management參數不一致錯誤建站知識主要講述錯誤,參數,Oracle undo_management參數網站建設源碼以及服務器配置搭建相關技術文章。轉載請保留鏈接: http://www.bifwcx.com/article/web_5038.html
