亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標題: linux oracle 10.2 rac 故障 [打印本頁]

作者: zhangmq 時間: 2011-04-01 11:59
標題: linux oracle 10.2 rac 故障
各位好，小弟在rhel5.1下安裝linux oracle_10.2 rac（創(chuàng)建庫時有警告，當時沒留意）。重啟發(fā)現(xiàn)節(jié)點一老是有問題，有些服務起不來
[oracle@node1 bin]$ ./crs_stat -t
Name          Type          Target State    Host
------------------------------------------------------------
ora....B1.inst application ONLINE OFFLINE
ora....B2.inst application ONLINE ONLINE node2
ora.RACDB.db application ONLINE ONLINE node2
ora....SM1.asm application ONLINE OFFLINE
ora....E1.lsnr application ONLINE OFFLINE
ora.node1.gsd  application ONLINE ONLINE node1
ora.node1.ons  application ONLINE ONLINE node1
ora.node1.vip  application ONLINE ONLINE node2
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

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+RAC_DISK/RACDB/spfileRACDB.ora'
ORA-17503: ksfdopn:2 Failed to open file +RAC_DISK/RACDB/spfileRACDB.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL> quit

作者: zhangmq 時間: 2011-04-01 12:01
監(jiān)聽也不正常
[oracle@node1 bin]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 01-APR-2011 19:58:39

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date             01-APR-2011 19:58:03
Uptime                   0 days 0 hr. 0 min. 36 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /opt/ora10g/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File       /opt/ora10g/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@node1 bin]$

節(jié)點2倒是正常的
oracle@node2 admin]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 01-APR-2011 19:59:31

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                   LISTENER_NODE2
Version                TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date             01-APR-2011 18:30:25
Uptime                   0 days 1 hr. 29 min. 6 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /opt/ora10g/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File       /opt/ora10g/product/10.2.0/db_1/network/log/listener_node2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.222)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.212)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "RACDB" has 1 instance(s).
  Instance "RACDB2", status READY, has 1 handler(s) for this service...
Service "RACDBXDB" has 1 instance(s).
  Instance "RACDB2", status READY, has 1 handler(s) for this service...
Service "RACDB_XPT" has 1 instance(s).
  Instance "RACDB2", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@node2 admin]$

作者: renxiao2003 時間: 2011-04-01 12:42

ORA-01565: error in identifying file '+RAC_DISK/RACDB/spfileRACDB.ora'
ORA-17503: ksfdopn:2 Failed to open file +RAC_DISK/RACDB/spfileRACDB.ora

沒做過RAC，但從錯誤看，你這個節(jié)點應該沒有訪問到spfile文件。

作者: duolanshizhe 時間: 2011-04-01 13:03
恩我來談幾點：

1、實例一可能asm實例有問題，請查看�；蛘哔N出相關信息

2、10.2的rac，沒有打上patchset3 那是相當恐怖的一件事情

3、實例一的asm的實例沒有起來導致db實例不能起來，從而監(jiān)聽也沒有注冊的服務，這個很正常！

作者: zhangmq 時間: 2011-04-01 13:40
[oracle@node1 bin]$ srvctl status database -d RACDB
Instance RACDB1 is not running on node node1
Instance RACDB2 is running on node node2

作者: zhangmq 時間: 2011-04-01 13:44
[oracle@node1 bin]$ srvctl status database -d RACDB
Instance RACDB1 is not running on node node1
Instance RACDB2 is running on node node2
[oracle@node1 bin]$ srvctl status instance -d RACDB -i RACDB1,RACDB2
Instance RACDB1 is not running on node node1
Instance RACDB2 is running on node node2
[oracle@node1 bin]$ srvctl status asm -n node1
ASM instance +ASM1 is not running on node node1.
[oracle@node1 bin]$ srvctl status asm -n node2
ASM instance +ASM2 is running on node node2.
[oracle@node1 bin]$ srvctl status nodeapps -n node1
VIP is running on node: node2
GSD is running on node: node1
Listener is not running on node: node1
ONS daemon is running on node: node1
[oracle@node1 bin]$ srvctl status nodeapps -n node2
VIP is running on node: node2
GSD is running on node: node2
Listener is running on node: node2
ONS daemon is running on node: node2
[oracle@node1 bin]$

作者: zhangmq 時間: 2011-04-01 14:33
對啦，跟執(zhí)行/etc/init.d/oracleasm listdisks沒看到東西有沒直接關系，昨天安裝時是能找到vol1/vol2的

作者: zhangmq 時間: 2011-04-01 15:46
頂！

作者: zhangmq 時間: 2011-04-01 16:34
[root@node1 bin]# srvctl start instance -d RACDB -i RACDB1
PRKP-1001 : Error starting instance RACDB1 on node node1
node1

ra.node1.vip:checkIf: Default gateway is not defined (host=node1)
node1

ra.node1.vip:Interface eth0 checked failed (host=node1)
node1

ra.node1.vip:Invalid parameters, or failed to bring up VIP (host=node1)
node1

ra.node1.vip:checkIf: Default gateway is not defined (host=node1)
node1

ra.node1.vip:Interface eth0 checked failed (host=node1)
node1

ra.node1.vip:Invalid parameters, or failed to bring up VIP (host=node1)
CRS-0215: Could not start resource 'ora.RACDB.RACDB1.inst'.

作者: zhangmq 時間: 2011-04-01 16:38
發(fā)現(xiàn)node1網(wǎng)卡1的網(wǎng)關沒配置，重新配置好后執(zhí)行
[root@node1 oracle]# srvctl start instance -d RACDB -i RACDB1
PRKP-1001 : Error starting instance RACDB1 on node node1
node1

ra.node1.vip:IP:192.168.10.221 is already up in the network (host=node1)
node1

ra.node1.vip:IP:192.168.10.221 is already up in the network (host=node1)
CRS-0215: Could not start resource 'ora.RACDB.RACDB1.inst'.

作者: zhangmq 時間: 2011-04-01 16:45
重啟crs,節(jié)點2又啟不來了

[oracle@node1 bin]$ ./crs_stat -t
Name          Type          Target State    Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE node1
ora....B2.inst application ONLINE OFFLINE
ora.RACDB.db application ONLINE ONLINE node1
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 OFFLINE
ora....E2.lsnr application ONLINE OFFLINE
ora.node2.gsd  application ONLINE OFFLINE
ora.node2.ons  application ONLINE OFFLINE
ora.node2.vip  application ONLINE OFFLINE
[oracle@node1 bin]$ exit

作者: zhangmq 時間: 2011-04-01 16:58
搞了大半天，最后是node1的public的網(wǎng)關沒配置，唉！
剛重后ok了。
[oracle@node1 bin]$ ./crs_stat -t
Name          Type          Target State    Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE node1
ora....B2.inst application ONLINE ONLINE node2
ora.RACDB.db application ONLINE ONLINE node1
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
[oracle@node1 bin]$

作者: zhangmq 時間: 2011-04-01 17:25
還有個問題，請問oracleasm listdisks怎么找不到用來安裝clusterware的兩個盤vol1,vol2，昨天安裝數(shù)據(jù)庫的時候還有的？

作者: dodba 時間: 2011-04-02 15:27
安裝前做一下配置的詳細檢查還是很有必要的

作者: 孤獨的雪狐 時間: 2011-04-19 16:16
頂頂樓主:wink: :wink:

來自：武漢網(wǎng)站建設

歡迎光臨 Chinaunix (http://72891.cn/)