<acronym id="6ic2k"><wbr id="6ic2k"></wbr></acronym>
<rt id="6ic2k"><optgroup id="6ic2k"></optgroup></rt>
<samp id="6ic2k"></samp>
查看: 480|回复: 13

oracle 11r2 rac centos+asm dbca报错

[复制链接]
论坛徽章:
52
ITPUB 11周年纪念徽章
日期:2012-09-28 17:34:42优秀写手
日期:2014-07-02 06:00:12马上有车
日期:2014-07-31 10:56:20马上有车
日期:2014-08-12 09:40:15马上有车
日期:2014-10-13 09:47:12沸羊羊
日期:2015-03-02 10:51:07慢羊羊
日期:2015-03-04 14:53:332015年新春福章
日期:2015-03-06 11:58:39射手座
日期:2015-07-30 16:00:47巨蟹座
日期:2015-08-11 11:22:47
跳转到指定楼层
1#
发表于 2019-2-22 09:04 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
大家好,最近安装rac遇到一个问题
环境:虚拟机
[[email protected] ~]# lsb_release -a
LSB Version:        :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarchrinting-4.0-amd64rinting-4.0-noarch
Distributor ID:        CentOS
Description:        CentOS release 6.10 (Final)
Release:        6.10
Codename:        Final
[[email protected] ~]# uname -r
2.6.32-754.el6.x86_64

SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 22 09:06:15 2019

在dbca的13%的时候报错
[Thread-149] [ 2019-02-21 16:09:01.836 CST ] [BasicStep.configureSettings:304]  messageHandler being set=null
[Thread-149] [ 2019-02-21 16:09:01.862 CST ] [SQLEngine.setSpool:1967]  old Spool  = null
[Thread-149] [ 2019-02-21 16:09:01.862 CST ] [SQLEngine.setSpool:1968]  Setting Spool  = /u01/app/oracle/cfgtoollogs/dbca/bol/CreateDBCatalog.log
[Thread-149] [ 2019-02-21 16:09:01.862 CST ] [SQLEngine.setSpool:1969]  Is spool appendable? --> true
[Thread-147] [ 2019-02-21 16:09:10.721 CST ] [BasicStep.handleNonIgnorableError:430]  [email protected]:messageHandler
[Thread-147] [ 2019-02-21 16:09:10.721 CST ] [BasicStep.handleNonIgnorableError:431]  ORA-03113: end-of-file on communication channel

alert 日志
[[email protected] bol]# cd /u01/app/oracle/diag/rdbms/bol/bol1/trace/
[[email protected] trace]# tail -n 200 alert_bol1.log
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
Thu Feb 21 16:09:04 2019
Thread 1 advanced to log sequence 2 (LGWR switch)
  Current log# 2 seq# 2 mem# 0: +DATA/bol/onlinelog/group_2.258.1000829323
  Current log# 2 seq# 2 mem# 1: +FRA/bol/onlinelog/group_2.258.1000829323
WARNING: Write Failed. group:3 disk:0 AU:187 offset:914944 size:45568
WARNING: Write Failed. group:2 disk:0 AU:95 offset:914944 size:45568
Errors in file /u01/app/oracle/diag/rdbms/bol/bol1/trace/bol1_lgwr_308.trc:
ORA-15080: synchronous I/O operation to a disk failed
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 45568
WARNING: failed to write mirror side 1 of virtual extent 10 logical extent 0 of file 258 in group 2 on disk 0 allocation unit 95
Errors in file /u01/app/oracle/diag/rdbms/bol/bol1/trace/bol1_lgwr_308.trc:
SandyBrown]ORA-15080: synchronous I/O operation to a disk failed
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 45568
WARNING: failed to write mirror side 1 of virtual extent 10 logical extent 0 of file 258 in group 3 on disk 0 allocation unit 187
Errors in file /u01/app/oracle/diag/rdbms/bol/bol1/trace/bol1_lgwr_308.trc:
ORA-00345: redo log write error block 22267 count 89
ORA-00312: online log 2 thread 1: '+DATA/bol/onlinelog/group_2.258.1000829323'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk
ORA-00345: redo log write error block 22267 count 89
ORA-00312: online log 2 thread 1: '+FRA/bol/onlinelog/group_2.258.1000829323'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk
Errors in file /u01/app/oracle/diag/rdbms/bol/bol1/trace/bol1_lgwr_308.trc:
ORA-00340: IO error processing online log 2 of thread 1
ORA-00345: redo log write error block 22267 count 89
ORA-00312: online log 2 thread 1: '+DATA/bol/onlinelog/group_2.258.1000829323'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk
ORA-00345: redo log write error block 22267 count 89
ORA-00312: online log 2 thread 1: '+FRA/bol/onlinelog/group_2.258.1000829323'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk
LGWR (ospid: 308): terminating the instance due to error 340
Thu Feb 21 16:09:10 2019

asm状态正常,使用udev方式
[[email protected] ~]# ls -l /dev/asm*
brw-rw---- 1 grid asmadmin 8, 16 Feb 21 13:46 /dev/asm-diskb
brw-rw---- 1 grid asmadmin 8, 32 Feb 21 14:09 /dev/asm-diskc
brw-rw---- 1 grid asmadmin 8, 48 Feb 21 14:09 /dev/asm-diskd
brw-rw---- 1 grid asmadmin 8, 64 Feb 21 14:09 /dev/asm-diske
brw-rw---- 1 grid asmadmin 8, 80 Feb 21 14:09 /dev/asm-diskf
brw-rw---- 1 grid asmadmin 8, 96 Feb 21 14:09 /dev/asm-diskg
[[email protected] ~]$ asmcmd
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576    163840   161875                0          161875              0             N  DATA/
MOUNTED  EXTERN  N         512   4096  1048576     81920    81692                0           81692              0             N  FRA/
MOUNTED  EXTERN  N         512   4096  1048576      6144     5744                0            5744              0             Y  OCR/

SQL> select disk_number, mount_status,header_status,mode_status,state,total_mb,free_mb,name,path   
from v$asm_disk  2  ;

DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE            TOTAL_MB        FREE_MB NAME                               PATH
----------- ------- ------------ ------- -------- ---------- ---------- ------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
          1 CACHED  MEMBER         ONLINE  NORMAL        81920          80938 DATA_0001                       /dev/asm-diskf
          1 CACHED  MEMBER         ONLINE  NORMAL         2048           1925 OCR_0001                       /dev/asm-diskc
          0 CACHED  MEMBER         ONLINE  NORMAL        81920          81692 FRA_0000                       /dev/asm-diskg
          0 CACHED  MEMBER         ONLINE  NORMAL        81920          80937 DATA_0000                       /dev/asm-diske
          2 CACHED  MEMBER         ONLINE  NORMAL         2048           1925 OCR_0002                       /dev/asm-diskd
          0 CACHED  MEMBER         ONLINE  NORMAL         2048           1894 OCR_0000                       /dev/asm-diskb

6 rows selected.
论坛徽章:
10
会员2007贡献徽章
日期:2007-09-26 18:42:10秀才
日期:2015-07-06 11:23:302015年新春福章
日期:2015-03-06 11:57:312015年新春福章
日期:2015-03-04 14:51:12马上有房
日期:2014-02-18 16:42:022014年新春福章
日期:2014-02-18 16:42:02优秀写手
日期:2013-12-18 09:29:152010新春纪念徽章
日期:2010-03-01 11:20:05ITPUB新首页上线纪念徽章
日期:2007-10-20 08:38:44秀才
日期:2015-07-14 09:44:30
2#
发表于 2019-2-22 09:50 | 只看该作者
ASM 起来了没?  

使用道具 举报

回复
论坛徽章:
52
ITPUB 11周年纪念徽章
日期:2012-09-28 17:34:42优秀写手
日期:2014-07-02 06:00:12马上有车
日期:2014-07-31 10:56:20马上有车
日期:2014-08-12 09:40:15马上有车
日期:2014-10-13 09:47:12沸羊羊
日期:2015-03-02 10:51:07慢羊羊
日期:2015-03-04 14:53:332015年新春福章
日期:2015-03-06 11:58:39射手座
日期:2015-07-30 16:00:47巨蟹座
日期:2015-08-11 11:22:47
3#
 楼主| 发表于 2019-2-22 12:28 | 只看该作者
[[email protected] ~]$ srvctl status asm -a
ASM is running on rac2,rac1
ASM is enabled.

使用道具 举报

回复
论坛徽章:
122
现任管理团队成员
日期:2011-05-07 01:45:08乌索普
日期:2019-02-14 23:54:04
4#
发表于 2019-2-22 14:57 | 只看该作者
看 asm alert日志

使用道具 举报

回复
论坛徽章:
52
ITPUB 11周年纪念徽章
日期:2012-09-28 17:34:42优秀写手
日期:2014-07-02 06:00:12马上有车
日期:2014-07-31 10:56:20马上有车
日期:2014-08-12 09:40:15马上有车
日期:2014-10-13 09:47:12沸羊羊
日期:2015-03-02 10:51:07慢羊羊
日期:2015-03-04 14:53:332015年新春福章
日期:2015-03-06 11:58:39射手座
日期:2015-07-30 16:00:47巨蟹座
日期:2015-08-11 11:22:47
5#
 楼主| 发表于 2019-2-22 17:39 | 只看该作者
看 asm alert日志


Fri Feb 22 17:32:48 2019
NOTE: client bol1:bol registered, osid 30819, mbr 0x1
Fri Feb 22 17:32:51 2019
NOTE: Advanced to new COD format for group DATA
NOTE: Advanced to new COD format for group FRA
Fri Feb 22 17:34:30 2019
NOTE: ASM client bol1:bol disconnected unexpectedly.
NOTE: check client alert log.
NOTE: Trace records dumped in trace file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_30819.trc

[[email protected] trace]# tail -f -n 500 alert_bol1.log
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
Fri Feb 22 17:33:14 2019
Thread 1 advanced to log sequence 2 (LGWR switch)
  Current log# 2 seq# 2 mem# 0: +DATA/bol/onlinelog/group_2.258.1000920773
  Current log# 2 seq# 2 mem# 1: +FRA/bol/onlinelog/group_2.258.1000920773
Fri Feb 22 17:33:38 2019
Thread 1 cannot allocate new log, sequence 3
Checkpoint not complete
  Current log# 2 seq# 2 mem# 0: +DATA/bol/onlinelog/group_2.258.1000920773
  Current log# 2 seq# 2 mem# 1: +FRA/bol/onlinelog/group_2.258.1000920773
Thread 1 advanced to log sequence 3 (LGWR switch)
  Current log# 1 seq# 3 mem# 0: +DATA/bol/onlinelog/group_1.257.1000920771
  Current log# 1 seq# 3 mem# 1: +FRA/bol/onlinelog/group_1.257.1000920773
Fri Feb 22 17:34:20 2019
WARNING: Write Failed. group:3 disk:0 AU:155 offset:778752 size:2048
Errors in file /u01/app/oracle/diag/rdbms/bol/bol1/trace/bol1_lgwr_30800.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 29 logical extent 0 of file 257 in group 3 on disk 0 allocation unit 155
Errors in file /u01/app/oracle/diag/rdbms/bol/bol1/trace/bol1_lgwr_30800.trc:
ORA-00345: redo log write error block 60913 count 4
ORA-00312: online log 1 thread 1: '+FRA/bol/onlinelog/group_1.257.1000920773'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk
Errors in file /u01/app/oracle/diag/rdbms/bol/bol1/trace/bol1_lgwr_30800.trc:
ORA-00346: log member marked as STALE and closed
ORA-00312: online log 1 thread 1: '+FRA/bol/onlinelog/group_1.257.1000920773'
Thread 1 cannot allocate new log, sequence 4
Checkpoint not complete
  Current log# 1 seq# 3 mem# 0: +DATA/bol/onlinelog/group_1.257.1000920771
Errors in file /u01/app/oracle/diag/rdbms/bol/bol1/trace/bol1_lgwr_30800.trc:
ORA-00321: log 1 of thread 1, cannot update log file header
ORA-00312: online log 1 thread 1: '+FRA/bol/onlinelog/group_1.257.1000920773'
Thread 1 advanced to log sequence 4 (LGWR switch)
  Current log# 2 seq# 4 mem# 0: +DATA/bol/onlinelog/group_2.258.1000920773
  Current log# 2 seq# 4 mem# 1: +FRA/bol/onlinelog/group_2.258.1000920773
WARNING: Write Failed. group:3 disk:0 AU:182 offset:25600 size:15360
Errors in file /u01/app/oracle/diag/rdbms/bol/bol1/trace/bol1_lgwr_30800.trc:
ORA-15080: synchronous I/O operation to a disk failed
WARNING: failed to write mirror side 1 of virtual extent 5 logical extent 0 of file 258 in group 3 on disk 0 allocation unit 182
Errors in file /u01/app/oracle/diag/rdbms/bol/bol1/trace/bol1_lgwr_30800.trc:
ORA-00345: redo log write error block 10290 count 30
ORA-00312: online log 2 thread 1: '+FRA/bol/onlinelog/group_2.258.1000920773'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk
WARNING: Read Failed. group:2 disk:1 AU:50 offset:16384 size:16384
WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 256 in group [2.3521929058] from disk DATA2  allocation unit 50 reason error; if possible, will try another mirror side
Errors in file /u01/app/oracle/diag/rdbms/bol/bol1/trace/bol1_lgwr_30800.trc:
ORA-00202: control file: '+DATA/bol/controlfile/current.256.1000920771'
ORA-15081: failed to submit an I/O operation to a disk
Errors in file /u01/app/oracle/diag/rdbms/bol/bol1/trace/bol1_lgwr_30800.trc:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: '+DATA/bol/controlfile/current.256.1000920771'
ORA-15081: failed to submit an I/O operation to a disk
LGWR (ospid: 30800): terminating the instance due to error 204
Fri Feb 22 17:34:27 2019
System state dump requested by (instance=1, osid=30800 (LGWR)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/bol/bol1/trace/bol1_diag_30778_20190222173427.trc
Dumping diagnostic data in directory=[cdmp_20190222173427], requested by (instance=1, osid=30800 (LGWR)), summary=[abnormal instance termination].
Instance terminated by LGWR, pid = 30800



使用道具 举报

回复
论坛徽章:
2
蛋疼蛋
日期:2012-04-18 12:33:06布鲁克
日期:2017-02-02 19:03:35
6#
发表于 2019-2-23 23:10 | 只看该作者
注意查一下安装的oracle的权限问题,例如$ORCLE_HOME/bin/oracle

使用道具 举报

回复
论坛徽章:
1
秀才
日期:2017-02-22 15:16:26
7#
发表于 2019-2-25 10:42 | 只看该作者
Fri Feb 22 17:34:30 2019
NOTE: ASM client bol1:bol disconnected unexpectedly.
NOTE: check client alert log.
NOTE: Trace records dumped in trace file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_30819.trc

看看trc日志

使用道具 举报

回复
论坛徽章:
0
8#
发表于 2019-2-25 11:16 | 只看该作者
1、磁盘权限
2、虚拟机本身问题,有时,需要重新创建共享盘。

使用道具 举报

回复
论坛徽章:
52
ITPUB 11周年纪念徽章
日期:2012-09-28 17:34:42优秀写手
日期:2014-07-02 06:00:12马上有车
日期:2014-07-31 10:56:20马上有车
日期:2014-08-12 09:40:15马上有车
日期:2014-10-13 09:47:12沸羊羊
日期:2015-03-02 10:51:07慢羊羊
日期:2015-03-04 14:53:332015年新春福章
日期:2015-03-06 11:58:39射手座
日期:2015-07-30 16:00:47巨蟹座
日期:2015-08-11 11:22:47
9#
 楼主| 发表于 2019-2-25 21:30 | 只看该作者
今天经过人员对磁盘的调整
于是重新进行安装,dbca到50%又报错了
asm alter 日志
SUCCESS: diskgroup FRA was mounted
SUCCESS: CREATE DISKGROUP FRA EXTERNAL REDUNDANCY  DISK '/dev/asm-diskg' SIZE 81920M  ATTRIBUTE 'compatible.asm'='11.2.0.0.0','au_size'='1M' /* ASMCA */
Mon Feb 25 17:29:10 2019
NOTE: diskgroup resource ora.FRA.dg is online
ERROR: failed to update diskgroup resource ora.FRA.dg
NOTE: enlarging ACD to 2 threads for group 3/0x277aeef4 (FRA)
SUCCESS: ACD enlarged for group 3/0x277aeef4 (FRA)
Mon Feb 25 17:58:54 2019
NOTE: client bol1:bol registered, osid 30025, mbr 0x1
Mon Feb 25 17:58:57 2019
NOTE: Advanced to new COD format for group DATA
NOTE: Advanced to new COD format for group FRA
Mon Feb 25 18:15:29 2019
NOTE: ASM client bol1:bol disconnected unexpectedly.
NOTE: check client alert log.
NOTE: Trace records dumped in trace file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_30025.trc

/u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_30025.trc 这个文件的内容看上去看不到信息啊
截取一段
2019-02-25 18:22:28.422962 :80095F81:KFNU:[email protected]:kfnsBackground(): kfnsBackground got targeted message
2019-02-25 18:22:28.422965 :80095F82:db_trace:[email protected]:kfnsFillMapMsg(): [10491:27:175] MAP_ALLOCATE: gn=2 fn=273, mapid=37 size=6
2019-02-25 18:22:28.422980 :80095F83:KFNU:[email protected]:kfnsBackground(): kfnsBackground completed in 0 seconds (KFNPM=2)
2019-02-25 18:22:28.422981 :80095F84:KFNS:[email protected]:kfnDispatch(): completed KFNOP=5 callcnt=3306
2019-02-25 18:22:28.423033 :80095F86:KFNS:[email protected]:kfnDispatch(): calling server stub for KFNOP=5
2019-02-25 18:22:28.423035 :80095F87:KFNS:[email protected]:kfnsNextLockMsg(): kfnsNextLockMsg begins lock iteration gn=2 fn=273
2019-02-25 18:22:28.423038 :80095F88:KFNS:[email protected]:kfnsNextLockMsg(): kfnsNextLockMsg ends lock iteration
2019-02-25 18:22:28.423038 :80095F89:KFNU:[email protected]:kfnsBackground(): kfnsBackground consuming in-progress message typ=13 unread=1 status=0xfffffff1
2019-02-25 18:22:28.423039 :80095F8A:KFNU:[email protected]:kfnsConsume(): kfnsConsume message 0xa2fb5760 status=0xfffffff1 flags=0x1
2019-02-25 18:22:28.423101 :80095F97:KFNU:[email protected]:kfnmsg_Dump(): kfnsBg (kfnmsg) opcode=15 (KFNMS_MAPLOAD) fd 0x9f3bfee0 mid 37, gn [2.863694570], fn [273.1001182949] exts 6, start 0, cnt 6
2019-02-25 18:22:28.423102 :80095F98:KFNU:[email protected]:kfnsBackground(): kfnsBackground got targeted message
2019-02-25 18:22:28.423107 :80095F99:db_trace:[email protected]:kfnsFillMapMsg(): [10491:27:175] MAP_LOAD: gn=2 fn=273, mapid=37 start=0 cnt=6
2019-02-25 18:22:28.423107 :80095F9A:KFNU:[email protected]:kfnsBackground(): kfnsBackground completed in 0 seconds (KFNPM=2)
2019-02-25 18:22:28.423108 :80095F9B:KFNS:[email protected]:kfnDispatch(): completed KFNOP=5 callcnt=3308
2019-02-25 18:22:28.423154 :80095F9C:KFNS:[email protected]:kfnDispatch(): calling server stub for KFNOP=5
2019-02-25 18:22:28.423155 :80095F9D:KFNU:[email protected]:kfnsBackground(): kfnsBackground consuming in-progress message typ=15 unread=1 status=0xfffffff1
2019-02-25 18:22:28.423155 :80095F9E:KFNU:[email protected]:kfnsConsume(): kfnsConsume message 0xa2fb5920 status=0xfffffff1 flags=0x0
2019-02-25 18:22:33.427982 :8009606E:KFNU:[email protected]:kfnsBackground(): kfnsBackground completed in 5 seconds (KFNPM=0)
2019-02-25 18:22:33.427989 :8009606F:KFNS:[email protected]:kfnDispatch(): completed KFNOP=5 callcnt=3311
2019-02-25 18:22:33.428150 :80096072:KFNS:[email protected]:kfnDispatch(): calling server stub for KFNOP=5
2019-02-25 18:22:38.432997 :80096121:KFNU:[email protected]:kfnsBackground(): kfnsBackground completed in 5 seconds (KFNPM=0)
2019-02-25 18:22:38.433008 :80096122:KFNS:[email protected]:kfnDispatch(): completed KFNOP=5 callcnt=3314
2019-02-25 18:22:38.433138 :80096123:KFNS:[email protected]:kfnDispatch(): calling server stub for KFNOP=5
2019-02-25 18:22:43.437974 :80096208:KFNU:[email protected]:kfnsBackground(): kfnsBackground completed in 5 seconds (KFNPM=0)
2019-02-25 18:22:43.437977 :80096209:KFNS:[email protected]:kfnDispatch(): completed KFNOP=5 callcnt=3317
2019-02-25 18:22:43.438062 :8009620A:KFNS:[email protected]:kfnDispatch(): calling server stub for KFNOP=5
2019-02-25 18:22:48.442981 :80096288:KFNU:[email protected]:kfnsBackground(): kfnsBackground completed in 5 seconds (KFNPM=0)
2019-02-25 18:22:48.442989 :80096289:KFNS:[email protected]:kfnDispatch(): completed KFNOP=5 callcnt=3320
2019-02-25 18:22:48.443092 :8009628D:KFNS:[email protected]:kfnDispatch(): calling server stub for KFNOP=5
2019-02-25 18:22:53.447970 :80096346:KFNU:[email protected]:kfnsBackground(): kfnsBackground completed in 5 seconds (KFNPM=0)
2019-02-25 18:22:53.447982 :80096347:KFNS:[email protected]:kfnDispatch(): completed KFNOP=5 callcnt=3324
2019-02-25 18:22:53.448311 :80096348:KFNU:[email protected]:kfnclDelete(): kfnclDelete client=0x9f3a3be0 action=2

oralce aler日志
[Thread-145] [ 2019-02-25 18:14:50.299 EST ] [BasicStep.configureSettings:304]  messageHandler being set=null
[Thread-145] [ 2019-02-25 18:14:50.300 EST ] [BasicStep.execute:202]  Executing Step : ORD_INST
[Thread-145] [ 2019-02-25 18:14:50.300 EST ] [BasicStep.configureSettings:304]  messageHandler being set=null
[Thread-145] [ 2019-02-25 18:14:50.334 EST ] [SQLEngine.setSpool:1967]  old Spool  = null
[Thread-145] [ 2019-02-25 18:14:50.334 EST ] [SQLEngine.setSpool:1968]  Setting Spool  = /u01/app/oracle/cfgtoollogs/dbca/bol/ordinst.log
[Thread-145] [ 2019-02-25 18:14:50.334 EST ] [SQLEngine.setSpool:1969]  Is spool appendable? --> true
[Thread-145] [ 2019-02-25 18:14:50.801 EST ] [SQLEngine.spoolOff:2035]  Setting spool off = /u01/app/oracle/cfgtoollogs/dbca/bol/ordinst.log
[Thread-145] [ 2019-02-25 18:14:50.801 EST ] [BasicStep.configureSettings:304]  messageHandler being [email protected]
[Thread-145] [ 2019-02-25 18:14:50.838 EST ] [SQLEngine.setSpool:1967]  old Spool  = null
[Thread-145] [ 2019-02-25 18:14:50.838 EST ] [SQLEngine.setSpool:1968]  Setting Spool  = /u01/app/oracle/cfgtoollogs/dbca/bol/interMedia.log
[Thread-145] [ 2019-02-25 18:14:50.839 EST ] [SQLEngine.setSpool:1969]  Is spool appendable? --> true
[Thread-143] [ 2019-02-25 18:15:27.553 EST ] [BasicStep.handleNonIgnorableError:430]  [email protected]:messageHandler
[Thread-143] [ 2019-02-25 18:15:27.553 EST ] [BasicStep.handleNonIgnorableError:431]  ORA-03114: not connected to ORACLE

asm 状态都是正常的
[[email protected] ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        
ora.FRA.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    rac1        
ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    rac1        
ora.OCR.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    rac1        
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    rac1        
ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    rac1        
ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    rac1        
ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    rac1        
ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    rac1        
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    0/5    0/0    OFFLINE   OFFLINE               
ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1        
ora.rac1.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac1        
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2        
ora.rac2.gsd   application    0/5    0/0    OFFLINE   OFFLINE               
ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2        
ora.rac2.vip   ora....t1.type 0/0    0/0    ONLINE    ONLINE    rac2        
ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    rac1        
[[email protected] ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 25 21:26:07 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn /as sysasm
Connected.
SQL> select name,state from v$asm_diskgroup;

NAME                               STATE
------------------------------ -----------
OCR                               MOUNTED
DATA                               MOUNTED
FRA                               MOUNTED

存储是鹏云网络公司的存储,。。。没玩过存储的配置

使用道具 举报

回复
论坛徽章:
52
ITPUB 11周年纪念徽章
日期:2012-09-28 17:34:42优秀写手
日期:2014-07-02 06:00:12马上有车
日期:2014-07-31 10:56:20马上有车
日期:2014-08-12 09:40:15马上有车
日期:2014-10-13 09:47:12沸羊羊
日期:2015-03-02 10:51:07慢羊羊
日期:2015-03-04 14:53:332015年新春福章
日期:2015-03-06 11:58:39射手座
日期:2015-07-30 16:00:47巨蟹座
日期:2015-08-11 11:22:47
10#
 楼主| 发表于 2019-2-25 21:51 | 只看该作者
Trace file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_316.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
ORACLE_HOME = /u01/app/11.2.0/grid
System name:    Linux
Node name:      rac1
Release:        2.6.32-754.el6.x86_64
Version:        #1 SMP Tue Jun 19 21:26:04 UTC 2018
Machine:        x86_64
VM name:        VMWare Version: 6
Instance name: +ASM1
Redo thread mounted by this instance: 0 <none>
Oracle process number: 27
Unix process pid: 316, image: [email protected] (TNS V1-V3)


*** 2019-02-25 18:22:53.448
*** SESSION ID175.61) 2019-02-25 18:22:53.448
*** CLIENT ID) 2019-02-25 18:22:53.448
*** SERVICE NAME) 2019-02-25 18:22:53.448
*** MODULE NAME) 2019-02-25 18:22:53.448
*** ACTION NAME) 2019-02-25 18:22:53.448

===================================================
PROCESS STATE
-------------
Process global information:
     process: 0xa35b8088, call: 0xa32f17f0, xact: (nil), curses: 0xa326f3c0, usrses: 0xa326f3c0
     in_exception_handler: no
  ----------------------------------------
  SO: 0xa35b8088, type: 2, owner: (nil), flag: INIT/-/-/0x00 if: 0x3 c: 0x3
   proc=0xa35b8088, name=process, file=ksu.h LINE:12721, pg=0
  (process) Oracle pid:27, ser:29, calls cur/top: 0xa32f17f0/0xa32f17f0
            flags : (0x0) -
            flags2: (0x4000),  flags3: (0x10) intr disabled
            intr error: 0, call error: 0, sess error: 0, txn error 0
            intr queue: empty
    ksudlp FALSE at location: 0
  (post info) last post received: 0 0 35
              last post received-location: ksr2.h LINE:629 ID:ksrpublish
              last process to post me: 0xa35ba1f8 4 0
              last post sent: 0 0 36
              last post sent-location: ksr2.h LINE:633 ID:ksrmdone
              last post sent: 0 0 36
              last post sent-location: ksr2.h LINE:633 ID:ksrmdone
              last process posted by me: 0xa35ba1f8 4 0
    (latch info) wait_event=0 bits=0x0
    Process Group: DEFAULT, pseudo proc: 0xa3679f28
    O/S info: user: oracle, term: UNKNOWN, ospid: 316
    OSD pid info: Unix process pid: 316, image: [email protected] (TNS V1-V3)
    ----------------------------------------
    SO: 0xa326f3c0, type: 4, owner: 0xa35b8088, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
     proc=0xa35b8088, name=session, file=ksu.h LINE:12729, pg=0
    (session) sid: 175 ser: 62 trans: (nil), creator: 0xa35b8088
              flags: (0x41) USR/- flags_idl: (0x21) BSY/-/-/DEL/-/-
              flags2: (0x4) -/-/-
              DID: , short-term DID:
              txn branch: (nil)
              edition#: 0              oct: 0, prv: 0, sql: (nil), psql: (nil), user: 0/SYS
    ksuxds FALSE at location: 0
    service name: SYS$USERS
    client details:
      O/S info: user: oracle, term: , ospid: 314
      machine: rac1 program: [email protected] (TNS V1-V3)
    Current Wait Stack:
      Not in wait; last wait ended 0.000981 sec ago
    Wait State:
      fixed_waits=0 flags=0x21 boundary=(nil)/-1
    Session Wait History:
        elapsed time of 0.001024 sec since last wait
     0: waited for 'SQL*Net message from client'
        driver id=0x62657100, #bytes=0x1, =0x0
        wait_id=857 seq_num=1215 snap_id=1
        wait times: snap=0.000037 sec, exc=0.000037 sec, total=0.000037 sec
        wait times: max=infinite
        wait counts: calls=0 os=0
        occurred after 0.000004 sec of elapsed time
     1: waited for 'SQL*Net message to client'
        driver id=0x62657100, #bytes=0x1, =0x0
        wait_id=856 seq_num=1214 snap_id=1
        wait times: snap=0.000002 sec, exc=0.000002 sec, total=0.000002 sec
        wait times: max=infinite
        wait counts: calls=0 os=0
        occurred after 0.000021 sec of elapsed time
     2: waited for 'ASM file metadata operation'
        msgop=0x5, locn=0x1, =0x
wait_id=850 seq_num=1213 snap_id=6
        wait times: snap=0.000007 sec, exc=0.000041 sec, total=5.004879 sec
        wait times: max=infinite
        wait counts: calls=0 os=0
        occurred after 0.000000 sec of elapsed time
     3: waited for 'wait for unread message on broadcast channel'
        channel context=0xa2f818c8, channel handle=0xa2beb288, =0x0
        wait_id=855 seq_num=1212 snap_id=1
        wait times: snap=1.000989 sec, exc=1.000989 sec, total=1.000989 sec
        wait times: max=1.000000 sec
        wait counts: calls=1 os=1
        occurred after 0.000000 sec of elapsed time
     4: waited for 'ASM file metadata operation'
        msgop=0x5, locn=0x1, =0x0
        wait_id=850 seq_num=1211 snap_id=5
        wait times: snap=0.000011 sec, exc=0.000034 sec, total=4.003883 sec
        wait times: max=infinite
        wait counts: calls=0 os=0
        occurred after 0.000000 sec of elapsed time
     5: waited for 'wait for unread message on broadcast channel'
        channel context=0xa2f818c8, channel handle=0xa2beb288, =0x0
        wait_id=854 seq_num=1210 snap_id=1
        wait times: snap=1.000995 sec, exc=1.000995 sec, total=1.000995 sec
        wait_id=854 seq_num=1210 snap_id=1
        wait times: snap=1.000995 sec, exc=1.000995 sec, total=1.000995 sec
        wait times: max=1.000000 sec
        wait counts: calls=1 os=1
        occurred after 0.000000 sec of elapsed time
     6: waited for 'ASM file metadata operation'
        msgop=0x5, locn=0x1, =0x0
        wait_id=850 seq_num=1209 snap_id=4
        wait times: snap=0.000003 sec, exc=0.000023 sec, total=3.002877 sec
        wait times: max=infinite
        wait counts: calls=0 os=0
        occurred after 0.000000 sec of elapsed time
     7: waited for 'wait for unread message on broadcast channel'
        channel context=0xa2f818c8, channel handle=0xa2beb288, =0x0
        wait_id=853 seq_num=1208 snap_id=1
        wait times: snap=1.000980 sec, exc=1.000980 sec, total=1.000980 sec
        wait times: max=1.000000 sec
        wait counts: calls=1 os=1
        occurred after 0.000000 sec of elapsed time
     8: waited for 'ASM file metadata operation'
        msgop=0x5, locn=0x1, =0x0
        wait_id=850 seq_num=1207 snap_id=3
        wait times: snap=0.000011 sec, exc=0.000020 sec, total=2.001894 sec
        wait times: max=infinite
        wait counts: calls=0 os=0
        occurred after 0.000000 sec of elapsed time
     9: waited for 'wait for unread message on broadcast channel'
        channel context=0xa2f818c8, channel handle=0xa2beb288, =0x0
        wait_id=852 seq_num=1206 snap_id=1
        wait times: snap=1.000999 sec, exc=1.000999 sec, total=1.000999 sec
        wait times: max=1.000000 sec
        wait counts: calls=1 os=1
        occurred after 0.000000 sec of elapsed time
    Sampled Session History of session 175 serial 62

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

基于案例的 SQL 优化实战训练营

讲师:中电福富特级专家梁敬彬,参与本次课程培训,你将收获:
1. 能编写出较为高效的 SQL;
2. 能解决70%以上的数据库常见优化问题;
3. 能得到老师提供的高效的相关工具和解决方?#31119;?
4. 能举一反三,收获不仅仅是 SQL 优化。
现在购票享受8.8折优惠!
----------------------------------------
优惠时间:2019年3月20日前

大会官网>>
新快三开奖结果
<acronym id="6ic2k"><wbr id="6ic2k"></wbr></acronym>
<rt id="6ic2k"><optgroup id="6ic2k"></optgroup></rt>
<samp id="6ic2k"></samp>
<acronym id="6ic2k"><wbr id="6ic2k"></wbr></acronym>
<rt id="6ic2k"><optgroup id="6ic2k"></optgroup></rt>
<samp id="6ic2k"></samp>
TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分?#21495;?/a> 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. ?#26412;?#30427;拓优讯信息技术有限公司版权所有 联系我们 
京ICP备09055130号-4  ?#26412;?#24066;公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表