ITPUB论坛-中国最专业的IT技术社区

 找回密码
 注册
查看: 2841|回复: 17

[讨论] oracle rac一边实例宕了

[复制链接]
论坛徽章:
0
发表于 2017-10-25 15:59 | 显示全部楼层 |阅读模式
环境 oracle11204 rac for redhat6.6
9月13日发现一边实例宕了
alert日志:
Errors in file /oracle/app/oracle/diag/rdbms/bssoradb/bssoradb2/trace/bssoradb2_lmon_13671.trc  (incident=432089):
ORA-29740: evicted by instance number 1, group incarnation 46
Incident details in: /oracle/app/oracle/diag/rdbms/bssoradb/bssoradb2/incident/incdir_432089/bssoradb2_lmon_13671_i432089.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/app/oracle/diag/rdbms/bssoradb/bssoradb2/trace/bssoradb2_lmon_13671.trc:
ORA-29740: evicted by instance number 1, group incarnation 46
LMON (ospid: 13671): terminating the instance due to error 29740
Wed Sep 13 18:39:49 2017
System state dump requested by (instance=2, osid=13671 (LMON)), summary=[abnormal instance termination].
System State dumped to trace file /oracle/app/oracle/diag/rdbms/bssoradb/bssoradb2/trace/bssoradb2_diag_13661_20170913183949.trc
Instance terminated by LMON, pid = 13671

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
对应的/oracle/app/oracle/diag/rdbms/bssoradb/bssoradb2/trace/bssoradb2_lmon_13671.trc
*** 2017-09-13 18:39:44.093
kjxgrrcfgchk: Initiating reconfig, reason=3
kjxgrrcfgchk: COMM rcfg - Disk Vote Required
kjfmReceiverHealthCB_CheckAll: Recievers are healthy.
2017-09-13 18:39:44.093242 : kjxgrnetchk: start 0x43f2b35f, end 0x43f369a9
2017-09-13 18:39:44.093265 : kjxgrnetchk: Network Validation wait: 46 sec
2017-09-13 18:39:44.093282 : kjxgrnetchk: Sending comm check req to inst 1
kjxgrrcfgchk: prev pstate 6  mapsz 512
kjxgrrcfgchk: new  bmp: 1 2
kjxgrrcfgchk: work bmp: 1 2
kjxgrrcfgchk: rr  bmp: 1 2


*** 2017-09-13 18:39:44.093
kjxgmrcfg: Reconfiguration started, type 3
CGS/IMR TIMEOUTS:
  CSS recovery timeout = 31 sec (Total CSS waittime = 65)
  IMR Reconfig timeout = 75 sec
  CGS rcfg timeout = 85 sec
kjxgmcs: Setting state to 44 0.
kjxgrs0h: disable CGS timeout

017-09-13 18:39:44.537303 : kjxgrcomerr: Suppressed nested communications reconfig: instance 1 (44,44)
kjxgrnetval: all instances have acknowledged
kjxgrrcfgchk: NETVAL: reconfig bitmap chksum 0x317eab92 cnt 2 master 2
SelectVoteMethod: member information
Inst 1, st 0x0017, es 0x0002, cap 0x0
Inst 2, st 0x0107, es 0x0000, cap 0x3
SelectVoteMethod: num mounted 1, unmounted 0
SelectVoteMethod: mounted capatility: nonblocking blocking
SelectVoteMethod: num unmounted nb 0 b 0
SelectVoteMethod: total insts nb 1 b 1
SelectVoteMethod: final capability nonblocking
kjxgrpropmsg: SSVOTE: Master indicates Disk Voting required
2017-09-13 18:39:44.589141 : kjxgrDiskVote: nonblocking method is chosen
2017-09-13 18:39:44.640605 : kjxgrDiskVote: start the disk vote w/ seqno 45
2017-09-13 18:39:44.640658 : kjxgrDiskVote: timeout in 56 sec
Last valid bitmap: 1 2
2017-09-13 18:39:44.640725 : kjxgrDiskVote: active members status:
Inst 1, st 0x0017, es 0x0002, cap 0x0
Inst 2, st 0x0107, es 0x0000, cap 0x3
2017-09-13 18:39:44.692219 : kjxgrDiskVote: voted w/ seq 45 and map: 2
LR trace: *** @ 1-LR1: 2017-09-13 18:39:44.744  01
  - rcnt-idx 2
LR trace: *** @ 2-LR2: 2017-09-13 18:39:44.744  00
  - rcnt-idx 2

*** 2017-09-13 18:39:44.745
kjxgrf_rr_lock: done - ret = 1  hist 0x12e
2017-09-13 18:39:44.745313 : kjxgrDiskVote: RR lock-get failed w/ status 1
2017-09-13 18:39:44.745350 : kjxgrDiskVote: RR update instance is 1
2017-09-13 18:39:44.849246 : kjxgrDiskVote: detected an inconsistent membership by inst 1 at seq 46
2017-09-13 18:39:44.900729 : kjxgrDiskVote: wait 0 sec for membership resolution
2017-09-13 18:39:44.900806 : kjxgrDiskVote: new membership is from inst 1
2017-09-13 18:39:44.900828 : kjxgrDiskVote: bitmap: 1
2017-09-13 18:39:44.952331 : kjxgrdtrt: Evicted by inst 1, seq (46, 46)
IMR state information
  Inst 2, thread 2, state 0x4:124c, flags 0x12ca9:0x0001
  RR seq commit 44  cur 46
  Propstate 4  prv 3  pending 0
  rcfg rsn 3, rcfg time 1139979104, mem ct 2
  master 2, master rcfg time 1139979104
  evicted memcnt 0, starttm 0 chkcnt 0
  system load 0 (normal)
  nonblocking disk voting method

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[root@bssdb2 ~]# ps -ef|grep grid
root      7804  7628  0 15:43 pts/0    00:00:00 grep grid
root     19240     1  5 Sep20 ?        1-23:44:07 /oracle/app/grid/product/11.2.0/bin/osysmond.bin
grid     19285     1  0 Sep20 ?        03:04:18 /oracle/app/grid/product/11.2.0/bin/ocssd.bin
root     22794     1  0 Oct24 ?        00:06:35 /oracle/app/grid/product/11.2.0/bin/ohasd.bin reboot
root     22887     1  0 Oct24 ?        00:05:20 /oracle/app/grid/product/11.2.0/bin/orarootagent.bin
root     22890     1  0 Oct24 ?        00:01:22 /oracle/app/grid/product/11.2.0/bin/cssdagent
root     22892     1  0 Oct24 ?        00:01:22 /oracle/app/grid/product/11.2.0/bin/cssdmonitor
grid     23000     1  0 Oct24 ?        00:01:10 /oracle/app/grid/product/11.2.0/bin/oraagent.bin
grid     23011     1  0 Oct24 ?        00:00:14 /oracle/app/grid/product/11.2.0/bin/mdnsd.bin
grid     23035     1  0 Oct24 ?        00:01:05 /oracle/app/grid/product/11.2.0/bin/gpnpd.bin
grid     23051     1  0 Oct24 ?        00:05:13 /oracle/app/grid/product/11.2.0/bin/gipcd.bin
root     23140     1  0 Oct24 ?        00:04:34 /oracle/app/grid/product/11.2.0/bin/octssd.bin reboot
grid     23195     1  0 Oct24 ?        00:03:16 /oracle/app/grid/product/11.2.0/bin/evmd.bin

---------------------------------------
ip addr   
link/ether 40:f2:e9:de:53:ac brd ff:ff:ff:ff:ff:ff
    inet 192.168.111.104/24 brd 192.168.113.255 scope global bond1       #oracle心跳ip
    inet 169.254.49.109/16 brd 169.254.255.255 scope global bond1:1      #请问这个 ip会影响oracle rac么
    inet6 fe80::42f2:e9ff:fede:53ac/64 scope link
       valid_lft forever preferred_lft forever


现在数据库宕了,也拉不起来,请各位大神帮忙 zhu
ASMCMD> lsdg
ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run

[oracle@bssdb2 ~]$ crs_stat -t
CRS-0184: Cannot communicate with the CRS daemon.


[root@bssdb2 ~]# /oracle/app/grid/product/11.2.0/bin/crsctl stop crs
CRS-2796: The command may not proceed when Cluster Ready Services is not running
CRS-4687: Shutdown command has completed with errors.
CRS-4000: Command Stop failed, or completed with errors.

[root@bssdb2 ~]# /oracle/app/grid/product/11.2.0/bin/crsctl start crs
CRS-4640: Oracle High Availability Services is already active
CRS-4000: Command Start failed, or completed with errors.



招聘 : 数据库管理员
论坛徽章:
19
2011新春纪念徽章
日期:2011-02-18 11:42:48目光如炬
日期:2017-09-03 22:00:01山治
日期:2016-09-29 21:06:15沸羊羊
日期:2015-06-17 14:02:04射手座
日期:2015-07-19 16:27:41沸羊羊
日期:2015-05-31 14:22:50暖羊羊
日期:2015-03-24 16:20:262015年新春福章
日期:2015-03-06 11:58:18美羊羊
日期:2015-03-04 14:52:28马上有车
日期:2014-10-27 17:10:16
发表于 2017-10-25 16:07 | 显示全部楼层
su - grid
crsctl stat res -t -init
ocrcheck

使用道具 举报

回复
论坛徽章:
0
 楼主| 发表于 2017-10-25 16:14 | 显示全部楼层
1x1xqq_cu 发表于 2017-10-25 16:07
su - grid
crsctl stat res -t -init
ocrcheck

[grid@bssdb2 ~]$ crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  OFFLINE                                                   
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       bssdb2                                       
ora.crf
      1        ONLINE  ONLINE       bssdb2                                       
ora.crsd
      1        ONLINE  OFFLINE                                                   
ora.cssd
      1        ONLINE  ONLINE       bssdb2                                       
ora.cssdmonitor
      1        ONLINE  ONLINE       bssdb2                                       
ora.ctssd
      1        ONLINE  ONLINE       bssdb2                   OBSERVER            
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.drivers.acfs
      1        ONLINE  ONLINE       bssdb2                                       
ora.evmd
      1        ONLINE  INTERMEDIATE bssdb2                                       
ora.gipcd
      1        ONLINE  ONLINE       bssdb2                                       
ora.gpnpd
      1        ONLINE  ONLINE       bssdb2                                       
ora.mdnsd
      1        ONLINE  ONLINE       bssdb2                                       
[grid@bssdb2 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3324
         Available space (kbytes) :     258796
         ID                       : 1806684292
         Device/File Name         :       +OCR
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

         Cluster registry integrity check succeeded

         Logical corruption check bypassed due to non-privileged user

使用道具 举报

回复
求职 : 数据库管理员
认证徽章
论坛徽章:
10
授权会员
日期:2005-10-30 17:05:332014年新春福章
日期:2014-02-18 16:41:112013年新春福章
日期:2013-02-25 14:51:24ITPUB 11周年纪念徽章
日期:2012-10-09 18:03:322012新春纪念徽章
日期:2012-01-04 11:49:54ITPUB十周年纪念徽章
日期:2011-11-01 16:19:412010新春纪念徽章
日期:2010-03-01 11:08:37会员2007贡献徽章
日期:2007-09-26 18:42:10会员2006贡献徽章
日期:2006-04-17 13:46:34马上有车
日期:2014-02-18 16:41:11
发表于 2017-10-25 16:38 | 显示全部楼层
169的地址也会影响RAC的,你是不是在主机上有Iptables?

使用道具 举报

回复
论坛徽章:
0
 楼主| 发表于 2017-10-25 16:41 | 显示全部楼层
happyplus 发表于 2017-10-25 16:38
169的地址也会影响RAC的,你是不是在主机上有Iptables?

没有,都检查过,iptables关了   selinux=disabled  NetworkManger  也关了

使用道具 举报

回复
论坛徽章:
3
蒙奇·D·路飞
日期:2017-06-29 11:18:49山治
日期:2017-09-11 10:07:52布鲁克
日期:2017-10-30 10:13:19
发表于 2017-10-25 16:49 | 显示全部楼层
crsctl query css votedisk,再看下asm实例日志。

使用道具 举报

回复
招聘 : 数据库管理员
论坛徽章:
19
2011新春纪念徽章
日期:2011-02-18 11:42:48目光如炬
日期:2017-09-03 22:00:01山治
日期:2016-09-29 21:06:15沸羊羊
日期:2015-06-17 14:02:04射手座
日期:2015-07-19 16:27:41沸羊羊
日期:2015-05-31 14:22:50暖羊羊
日期:2015-03-24 16:20:262015年新春福章
日期:2015-03-06 11:58:18美羊羊
日期:2015-03-04 14:52:28马上有车
日期:2014-10-27 17:10:16
发表于 2017-10-25 17:16 | 显示全部楼层
以下仅供参考:


ora.crsd
      1        ONLINE  OFFLINE   <<<<<<<<<<,

1 启动下crs看是否可以启动,
su - grid
crsctl start res ora.crsd -init

2 如果不能启动,看crsd 日志为啥启动不了
3 看看空间是否足够,
df -h
df -i
4 最近是否做过安全加固,在sqlnet.ora 加了invite_node之类的,没把本地ip加进去

使用道具 举报

回复
论坛徽章:
0
 楼主| 发表于 2017-10-25 17:51 | 显示全部楼层

谢谢你的回复。
空间没问题,最近也没做过什么
[grid@bssdb2 ~]$ crsctl start res ora.crsd -init
CRS-2672: Attempting to start 'ora.asm' on 'bssdb2'
CRS-5017: The resource action "ora.asm start" encountered the following error:
ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 0 Serial number: 0
. For details refer to "(:CLSN00107" in "/oracle/app/grid/product/11.2.0/log/bssdb2/agent/ohasd/oraagent_grid/oraagent_grid.log".
CRS-2674: Start of 'ora.asm' on 'bssdb2' failed
CRS-2679: Attempting to clean 'ora.asm' on 'bssdb2'
CRS-2681: Clean of 'ora.asm' on 'bssdb2' succeeded
CRS-4000: Command Start failed, or completed with errors.
-------------------------------------
17-10-25 17:45:17.681: [ora.asm][1214953216]{0:0:57} [start] InstAgent::check prev clsagfw_res_status 1 current clsagfw_res_status 1
2017-10-25 17:45:17.681: [ora.asm][1214953216]{0:0:57} [start] InstAgent::stop  shutdown mode: 4
2017-10-25 17:45:17.681: [ora.asm][1214953216]{0:0:57} [start] ConnectionPool::getConnection 160 ERROR sid +ASM2 pool status 1
2017-10-25 17:45:17.681: [ora.asm][1214953216]{0:0:57} [start] InstAgent::stop pool pConnxn 00000000
2017-10-25 17:45:17.681: [ora.asm][1214953216]{0:0:57} [start] clsnInstConnection::makeConnectStr UsrOraEnv  m_oracleHome /oracle/app/grid/product/11.2.0 Crshome /oracle/app/grid/product/11.2
.0
2017-10-25 17:45:17.681: [ora.asm][1214953216]{0:0:57} [start] makeConnectStr = (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/app/grid/product/11.2.0/bin/oracle)(ARGV0=oracle+ASM2)(ENV
S='ORACLE_HOME=/oracle/app/grid/product/11.2.0,ORACLE_SID=+ASM2')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=+ASM2)))
2017-10-25 17:45:17.682: [ora.asm][1214953216]{0:0:57} [start] InstAgent::stop non pool pConnxn 1 f0006ce0
2017-10-25 17:45:17.682: [ora.asm][1214953216]{0:0:57} [start] InstConnection::connectInt: server not attached
2017-10-25 17:45:17.707: [ora.asm][1214953216]{0:0:57} [start] ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0

2017-10-25 17:45:17.707: [ora.asm][1214953216]{0:0:57} [start] InstConnection::connectInt (2) Exception OCIException
2017-10-25 17:45:17.707: [ora.asm][1214953216]{0:0:57} [start] InstConnection:connect:excp OCIException OCI error 1034
2017-10-25 17:45:17.707: [ora.asm][1214953216]{0:0:57} [start] InstAgent::stop: connect1 errcode 1034
2017-10-25 17:45:17.707: [ora.asm][1214953216]{0:0:57} [start] InstAgent::stop: connect2 oracleHome /oracle/app/grid/product/11.2.0 oracleSid +ASM2
2017-10-25 17:45:17.707: [ora.asm][1214953216]{0:0:57} [start] InstConnection::connectInt: server not attached
2017-10-25 17:45:17.729: [ora.asm][1214953216]{0:0:57} [start] InstConnection:connectInt connected
2017-10-25 17:45:17.729: [ora.asm][1214953216]{0:0:57} [start] InstConnection::shutdown mode 4
2017-10-25 17:45:17.730: [ora.asm][1214953216]{0:0:57} [start] ConnectionPool::removeConnection connection count 1
2017-10-25 17:45:17.730: [ora.asm][1214953216]{0:0:57} [start] ConnectionPool::removeConnection sid  +ASM2, InstConnection f0006ce0
2017-10-25 17:45:17.730: [ USRTHRD][1214953216]{0:0:57} InstConnection::breakCall pConnxn:f0006ce0  DetachLock:00ae3228 m_pSvcH:f0068450
2017-10-25 17:45:17.730: [ USRTHRD][1214953216]{0:0:57} InstConnection:~InstConnection: this f0006ce0
2017-10-25 17:45:17.730: [ora.asm][1214953216]{0:0:57} [start] ConnectionPool::removeConnection delete InstConnection f0006ce0
2017-10-25 17:45:17.730: [ora.asm][1214953216]{0:0:57} [start] ConnectionPool::removeConnection freed 1
2017-10-25 17:45:17.730: [ora.asm][1214953216]{0:0:57} [start] ConnectionPool::stopConnection
2017-10-25 17:45:17.730: [ora.asm][1214953216]{0:0:57} [start] ConnectionPool::removeConnection connection count 0
2017-10-25 17:45:17.730: [ora.asm][1214953216]{0:0:57} [start] ConnectionPool::removeConnection freed 0
2017-10-25 17:45:17.731: [ora.asm][1214953216]{0:0:57} [start] ConnectionPool::stopConnection sid +ASM2 status  1
2017-10-25 17:45:17.731: [ora.asm][1214953216]{0:0:57} [start] InstAgent::stop db/asm
2017-10-25 17:45:17.731: [ora.asm][1214953216]{0:0:57} [start] ConnectionPool::stopConnection
2017-10-25 17:45:17.731: [ora.asm][1214953216]{0:0:57} [start] ConnectionPool::removeConnection connection count 0
2017-10-25 17:45:17.731: [ora.asm][1214953216]{0:0:57} [start] ConnectionPool::removeConnection freed 0
2017-10-25 17:45:17.731: [ora.asm][1214953216]{0:0:57} [start] ConnectionPool::stopConnection sid +ASM2 status  1
2017-10-25 17:45:17.731: [ora.asm][1214953216]{0:0:57} [start] getResAttrib: attrib name USR_ORA_OPI value false len 5
2017-10-25 17:45:17.731: [ora.asm][1214953216]{0:0:57} [start] InstAgent::stop Container->stop, isShutdown = 0
2017-10-25 17:45:17.731: [ora.asm][1214953216]{0:0:57} [start] InstAgent::stop: }
2017-10-25 17:45:17.731: [ora.asm][1214953216]{0:0:57} [start] clean  }
2017-10-25 17:45:17.731: [ora.asm][1214953216]{0:0:57} [start] InstAgent::start exception }
2017-10-25 17:45:17.731: [ora.asm][1214953216]{0:0:57} [start] clsnUtils::error Exception type=2 string=
CRS-5017: The resource action "ora.asm start" encountered the following error:
ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 0 Serial number: 0
. For details refer to "(:CLSN00107" in "/oracle/app/grid/product/11.2.0/log/bssdb2/agent/ohasd/oraagent_grid/oraagent_grid.log".

2017-10-25 17:45:17.732: [    AGFW][1214953216]{0:0:57} sending status msg [CRS-5017: The resource action "ora.asm start" encountered the following error:
ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 0 Serial number: 0
. For details refer to "(:CLSN00107" in "/oracle/app/grid/product/11.2.0/log/bssdb2/agent/ohasd/oraagent_grid/oraagent_grid.log".
] for start for resource: ora.asm 1 1
2017-10-25 17:45:17.732: [ora.asm][1214953216]{0:0:57} [start] (:CLSN00107 clsn_agent::start }
2017-10-25 17:45:17.732: [    AGFW][1214953216]{0:0:57} Command: start for resource: ora.asm 1 1 completed with status: FAIL
2017-10-25 17:45:17.732: [ora.asm][1214953216]{0:0:57} [check] ConnectionPool::resetConnection  s_statusOfConnectionMap 00ae9760
2017-10-25 17:45:17.732: [ora.asm][1214953216]{0:0:57} [check] ConnectionPool::resetConnection sid +ASM2 status  2
2017-10-25 17:45:17.732: [ora.asm][1214953216]{0:0:57} [check] Gimh::check OH /oracle/app/grid/product/11.2.0 SID +ASM2
2017-10-25 17:45:17.732: [    AGFW][1255352064]{0:0:57} Agent sending reply for: RESOURCE_START[ora.asm 1 1] ID 4098:30263
2017-10-25 17:45:17.733: [ora.asm][1214953216]{0:0:57} [check] Gimh::check condition changes to (GIMH_NEXT_NUM) 0,7 exists

使用道具 举报

回复
论坛徽章:
0
 楼主| 发表于 2017-10-25 18:23 | 显示全部楼层
Error with dbgriap_init_adr_pga: 48178
ORA-48178: error encountered while reading an ADR block file during ADR initialization [/oracle/app/oracle/diag/asm/+asm/+ASM2/metadata/ADR_INTERNAL.mif]
ORA-48122: error with opening the ADR block file [/oracle/app/oracle/diag/asm/+asm/+ASM2/metadata/ADR_INTERNAL.mif] [0]
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
Wed Oct 25 17:43:13 2017
ERROR: The process is unable to create the ADR schema in the diagnostic_dest directory
ERROR: because of a disk issue or OS platform issue
Wed Oct 25 17:43:13 2017
ERROR: Reverting back to using the user_dump_dest and background_dump_dest
ERROR: as the location for the traces and logs
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 32
Number of processor cores in the system is 16
Number of processor sockets in the system is 2
Private Interface 'bond1:1' configured from GPnP for use as a private interconnect.
  [name='bond1:1', type=1, ip=169.254.49.109, mac=40-f2-e9-de-53-ac, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interconnect/62]
Public Interface 'bond0' configured from GPnP for use as a public interface.

使用道具 举报

回复
招聘 : 数据库管理员
论坛徽章:
19
2011新春纪念徽章
日期:2011-02-18 11:42:48目光如炬
日期:2017-09-03 22:00:01山治
日期:2016-09-29 21:06:15沸羊羊
日期:2015-06-17 14:02:04射手座
日期:2015-07-19 16:27:41沸羊羊
日期:2015-05-31 14:22:50暖羊羊
日期:2015-03-24 16:20:262015年新春福章
日期:2015-03-06 11:58:18美羊羊
日期:2015-03-04 14:52:28马上有车
日期:2014-10-27 17:10:16
发表于 2017-10-25 18:45 | 显示全部楼层
su - grid
crsctl stat res -t -init

手动启动 asm实例看看

su - grid
sqlplus / as sysasm
startup

使用道具 举报

回复

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

本版积分规则

TOP技术积分榜 社区积分榜 徽章 电子杂志 团队 统计 虎吧 老博客 知识索引树 读书频道 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档 | IT博客
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛 | SAP ERP系统
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 网站律师 隐私政策 知识产权声明
京ICP备16024965号 北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表