GRID下sqlnet.ora 设置错误导致ASM访问不了

最新推荐文章于 2024-02-01 17:46:43 发布
最新推荐文章于 2024-02-01 17:46:43 发布
阅读量847 收藏
点赞数
文章标签： servlet 服务器 java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jnrjian/article/details/126975393
版权

[root@rac2 ~]# crsctl stat res -t -init
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  ONLINE       rac2                     Started,STABLE
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       rac2                     STABLE
ora.crf
      1        ONLINE  ONLINE       rac2                     STABLE
ora.crsd
      1        ONLINE  OFFLINE                               STABLE
ora.cssd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.cssdmonitor
      1        ONLINE  ONLINE       rac2                     STABLE
ora.ctssd
      1        ONLINE  ONLINE       rac2                     OBSERVER,STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.gipcd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.gpnpd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.mdnsd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.storage
      1        ONLINE  OFFLINE      rac2                     STARTING
--------------------------------------------------------------------------------
[root@rac2 ~]# crsctl status res -t
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Status failed, or completed with errors.
[root@rac2 ~]# 
 

[root@rac2 trace]# tail -f al*log
2022-09-21 04:15:59.726 [OCTSSD(22788)]CRS-8500: Oracle Clusterware OCTSSD process is starting with operating system process ID 22788
2022-09-21 04:16:00.284 [OLOGGERD(22808)]CRS-8500: Oracle Clusterware OLOGGERD process is starting with operating system process ID 22808
2022-09-21 04:16:00.415 [OCTSSD(22788)]CRS-2403: The Cluster Time Synchronization Service on host rac2 is in observer mode.
2022-09-21 04:16:02.347 [OCTSSD(22788)]CRS-2401: The Cluster Time Synchronization Service started on host rac2.
2022-09-21 04:16:02.347 [OCTSSD(22788)]CRS-2407: The new Cluster Time Synchronization Service reference node is host rac2.
2022-09-21 04:16:17.939 [ORAROOTAGENT(22218)]CRS-5019: All OCR locations are on ASM disk groups [DATA], and none of these disk groups are mounted. Details are at "(:CLSN00140:)" in "/u01/app/grid/diag/crs/rac2/crs/trace/ohasd_orarootagent_root.trc".
2022-09-21 04:26:13.756 [ORAROOTAGENT(22218)]CRS-5818: Aborted command 'start' for resource 'ora.storage'. Details at (:CRSAGF00113:) {0:5:3} in /u01/app/grid/diag/crs/rac2/crs/trace/ohasd_orarootagent_root.trc.
2022-09-21 04:26:14.699 [ORAROOTAGENT(22218)]CRS-5017: The resource action "ora.storage start" encountered the following error: 
2022-09-21 04:26:14.699+Storage::start action aborted. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/rac2/crs/trace/ohasd_orarootagent_root.trc".
2022-09-21 04:26:14.703 [OHASD(22062)]CRS-2757: Command 'Start' timed out waiting for response from the resource 'ora.storage'. Details at (:CRSPE00221:) {0:5:3} in /u01/app/grid/diag/crs/rac2/crs/trace/ohasd.trc.
q
^C
[root@rac2 trace]# pwd
/u01/app/grid/diag/crs/rac2/crs/trace
[root@rac2 trace]# 
 

[root@rac2 trace]# vi /u01/app/grid/diag/crs/rac2/crs/trace/ohasd_orarootagent_root.trc

2022-09-21 04:34:21.173 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check] (:CLSN00140:)StorageAgent::check 300 parsekgforretcodes OCR dgName DATA state 1
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check] (:CLSN00109:) Agent::commonCheck check failed action:0104 retval:1
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check] Agent::doStateDump Default Agent Dump
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check] Agent::doStateDump  last call info:
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:20.989 Tint:{0:5:3} action:104 resname:ora.storage lastCall:Agent::commonCheck call check
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:20.989 Tint:{0:5:3} action:104 resname:ora.storage lastCall:StorageAgent::check 000 entry {
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:20.989 Tint:{0:5:3} action:104 resname:ora.storage lastCall:StorageAgent::check 100 targetcheck
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.132 Tint:{0:5:3} action:104 resname:ora.storage lastCall:Agent::getPrevAction prevAction:104
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.132 Tint:{0:5:3} action:104 resname:ora.storage lastCall:Agent::getPrevAction prevAction:104
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.159 Tint:{0:5:3} action:104 resname:ora.storage lastCall:StorageAgent::check 101 targetcheck target:0
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.159 Tint:{0:5:3} action:104 resname:ora.storage lastCall:StorageAgent::check 160 NODEROLE_HUB getOCRdetails
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.159 Tint:{0:5:3} action:104 resname:ora.storage lastCall:StorageAgent::check 180 storage type:0
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.167 Tint:{0:5:3} action:104 resname:ora.storage lastCall:StorageAgent::parsekgforetcodes Calling kgfoCheckMount DATA
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.173 Tint:{0:5:3} action:104 resname:ora.storage lastCall:StorageAgent::parsekgforetcodes retcode = 6, kgfoCheckMount(DATA), flag 4
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.173 Tint:{0:5:3} action:104 resname:ora.storage lastCall:StorageAgent::check 260 kgfo returncode 1
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.173 Tint:{0:5:3} action:104 resname:ora.storage lastCall:(:CLSN00140:)StorageAgent::check 300 parsekgforretcodes OCR dgName DATA state 1
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.174 Tint:{0:5:3} action:104 resname:ora.storage lastCall:StorageAgent::check 999 exit clsagfw_res_status:1
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.174 Tint:{0:5:3} action:104 resname:ora.storage lastCall:Agent::commonCheck check clsagfw_res_status:1
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.174 Tint:{0:5:3} action:104 resname:ora.storage lastCall:Agent::getPrevAction prevAction:104
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.174 Tint:{0:5:3} action:104 resname:ora.storage lastCall:Agent::getPrevAction prevAction:104
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.174 Tint:{0:5:3} action:104 resname:ora.storage lastCall:Agent::getPrevAction prevAction:104
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.174 Tint:{0:5:3} action:104 resname:ora.storage lastCall:Agent::getPrevAction prevAction:104
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.174 Tint:{0:5:3} action:104 resname:ora.storage lastCall:Agent::getPrevAction prevAction:104
2022-09-21 04:34:21.174 :CLSDYNAM:1470088960: [ora.storage]{0:5:3} [check]  Time:09/21/2022 04:34:21.174 Tint:{0:5:3} action:104 resname:ora.storage lastCall:(:CLSN00109:) Agent::commonCheck check failed action:0104 retval:1
2022-09-21 04:34:32.579 :CLSDYNAM:1470088960: [ora.ctssd]{0:5:3} [check] translateReturnCodes, return = 0, state detail = OBSERVERCheckcb data [0x7f4e500827e0]: mode[0xee] offset[0 ms].
2022-09-21 04:34:32.606 :    AGFW:1467987712: [     INFO] {0:0:2} Agent received the message: AGENT_HB[Engine] ID 12293:4270
2022-09-21 04:34:37.621 : USRTHRD:1470088960: [     INFO] {0:5:3} Thread:[NetHAMain] Check: 0-1
2022-09-21 04:34:46.163 :CLSDYNAM:1470088960: [ ora.crf]{0:5:3} [check] Check return = 0, state detail = NULL


 
[root@rac2 trace]# vi /u01/app/grid/diag/crs/rac2/crs/trace/ohasd.trc

022-09-21 04:34:10.545 :UiServer:3149911808: [     INFO] {0:0:1812} Sending to PE. ctx= 0x7fd3d0204ab0, ClientPID=22808 set Properties (root,1564659)
2022-09-21 04:34:10.545 :   CRSPE:3425507072: [     INFO] {0:0:1812} Processing PE command id=1836 origin:rac2. Description: [Stat Resource : 0x7fd3c82337c0]
2022-09-21 04:34:10.555 :UiServer:3149911808: [     INFO] {0:0:1812} Done for ctx=0x7fd3d0204ab0
2022-09-21 04:34:10.743 :UiServer:3149911808: [     INFO] {0:0:1813} Sending to PE. ctx= 0x7fd3d0205390, ClientPID=22808 set Properties (root,1565155)
2022-09-21 04:34:10.744 :   CRSPE:3425507072: [     INFO] {0:0:1813} Processing PE command id=1837 origin:rac2. Description: [Stat Resource : 0x7fd3c815e1e0]
2022-09-21 04:34:10.747 :UiServer:3149911808: [     INFO] {0:0:1813} Done for ctx=0x7fd3d0205390
2022-09-21 04:34:14.287 :GIPCHTHR:3145709312:  gipchaDaemonWork: DaemonThread heart beat, time interval since last heartBeat 31090loopCount 28
 

2022-09-21 08:08:21.735 [OCSSD(19422)]CRS-1720: Cluster Synchronization Services daemon (CSSD) is ready for operation.
2022-09-21 08:08:22.070 [OCTSSD(19677)]CRS-8500: Oracle Clusterware OCTSSD process is starting with operating system process ID 19677
2022-09-21 08:08:22.616 [OCTSSD(19677)]CRS-2403: The Cluster Time Synchronization Service on host rac2 is in observer mode.
2022-09-21 08:08:24.816 [OCTSSD(19677)]CRS-2401: The Cluster Time Synchronization Service started on host rac2.
2022-09-21 08:08:24.816 [OCTSSD(19677)]CRS-2407: The new Cluster Time Synchronization Service reference node is host rac2.
2022-09-21 08:08:40.250 [ORAROOTAGENT(19094)]CRS-5019: All OCR locations are on ASM disk groups [DATA], and none of these disk groups are mounted. Details are at "(:CLSN00140:)" in "/u01/app/grid/diag/crs/rac2/crs/trace/ohasd_orarootagent_root.trc".
 

vi /u01/app/grid/diag/crs/rac2/crs/trace/ohasd_orarootagent_root.trc

022-09-21 08:13:07.917 : USRTHRD:3035715328: [     INFO] {0:5:3} Thread:kgfoCheckMountExt isRunning is reset to false here
2022-09-21 08:13:07.917 : USRTHRD:3035715328: [     INFO] {0:5:3} Thread:kgfoCheckMountExt isFinished set to true
2022-09-21 08:13:07.917 : USRTHRD:3046221568: [     INFO] {0:5:3} Thread:kgfoCheckMountExt Tasklet::doTask m_cv.timewait returned
2022-09-21 08:13:07.917 : USRTHRD:3046221568: [     INFO] {0:5:3} Thread:kgfoCheckMountExt Tasklet::doTask(kgfoCheckMountExt) executed in  7 seconds
2022-09-21 08:13:07.917 :CLSDYNAM:3046221568: [ora.storage]{0:5:3} [start] StorageAgent::parsekgforetcodes retcode = 7, kgfoCheckMount(DATA), flag 2
2022-09-21 08:13:07.917 :CLSDYNAM:3046221568: [ora.storage]{0:5:3} [start] (null) category: 7, operation: kgfoAl06, loc: kgfokge, OS error: 15077, other: ORA-15077: could not locate ASM instance serving a required diskgroup

2022-09-21 08:13:07.917 :CLSDYNAM:3046221568: [ora.storage]{0:5:3} [start] StorageAgent::check 260 kgfo returncode 1
2022-09-21 08:13:07.917 :CLSDYNAM:3046221568: [ora.storage]{0:5:3} [start] (:CLSN00140:)StorageAgent::check 300 parsekgforretcodes OCR dgName DATA state 1
2022-09-21 08:13:07.918 :CLSDYNAM:3046221568: [ora.storage]{0:5:3} [start] Storage::start waiting for check to not return PARTIAL or UNPLANNED_OFFLINE 1
 

SQL> select *from dual;

ADDR               INDX    INST_ID       CON_ID D
---------------- ---------- ---------- ---------- -
000000001350C49C      0         2        0 X

---sqlnet.ora 错了启动不了，启动后打开也没有用。要重启

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[grid@rac2 trace]$ crsctl stat res -t
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Status failed, or completed with errors.
[grid@rac2 trace]$ crsctl stat res -t
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Status failed, or completed with errors.
[grid@rac2 trace]$ crsctl stat res -t -init
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  ONLINE       rac2                     Started,STABLE
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       rac2                     STABLE
ora.crf
      1        ONLINE  ONLINE       rac2                     STABLE
ora.crsd
      1        ONLINE  OFFLINE                               STABLE
ora.cssd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.cssdmonitor
      1        ONLINE  ONLINE       rac2                     STABLE
ora.ctssd
      1        ONLINE  ONLINE       rac2                     OBSERVER,STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.gipcd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.gpnpd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.mdnsd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.storage
      1        ONLINE  OFFLINE      rac2                     STARTING
--------------------------------------------------------------------------------
[grid@rac2 trace]$ 
 

--------------正常情况

[root@rac2 ~]# su - oracle
Last login: Wed Sep 21 20:05:32 CST 2022 on pts/2
[oracle@rac2 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 21 20:23:43 2022
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@rac2 ~]$ exit
logout
[root@rac2 ~]# su - grid
Last login: Wed Sep 21 20:22:05 CST 2022
[grid@rac2 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 21 20:23:55 2022
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select 8 from dual;

     8
----------
     8

SQL> select *from dual;

ADDR               INDX    INST_ID       CON_ID D
---------------- ---------- ---------- ---------- -
000000001350C49C      0         2        0 X

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[grid@rac2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac2                     STABLE
ora.chad
               ONLINE  ONLINE       rac2                     STABLE
ora.net1.network
               ONLINE  ONLINE       rac2                     STABLE
ora.ons
               ONLINE  ONLINE       rac2                     STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  OFFLINE                               STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        OFFLINE OFFLINE                               STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac2                     STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  OFFLINE                               STABLE
      2        ONLINE  ONLINE       rac2                     Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  OFFLINE                               STABLE
      2        ONLINE  ONLINE       rac2                     STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       rac2                     STABLE
ora.orcl.db
      1        ONLINE  OFFLINE                               STABLE
      2        ONLINE  ONLINE       rac2                     Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             /db_1,STABLE
ora.orcl.srv_single.svc
      1        ONLINE  ONLINE       rac2                     STABLE
ora.qosmserver
      1        ONLINE  OFFLINE                               STABLE
ora.rac1.vip
      1        ONLINE  INTERMEDIATE rac2                     FAILED OVER,STABLE
ora.rac2.vip
      1        ONLINE  ONLINE       rac2                     STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac2                     STABLE
--------------------------------------------------------------------------------
[grid@rac2 ~]$ crsctl stat res -t -init
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  ONLINE       rac2                     Started,STABLE
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       rac2                     STABLE
ora.crf
      1        ONLINE  ONLINE       rac2                     STABLE
ora.crsd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.cssd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.cssdmonitor
      1        ONLINE  ONLINE       rac2                     STABLE
ora.ctssd
      1        ONLINE  ONLINE       rac2                     OBSERVER,STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.gipcd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.gpnpd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.mdnsd
      1        ONLINE  ONLINE       rac2                     STABLE
ora.storage
      1        ONLINE  ONLINE       rac2                     STABLE
--------------------------------------------------------------------------------
 

[grid@rac2 ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 21-SEP-2022 20:24:38

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                21-SEP-2022 08:21:05
Uptime                    0 days 0 hr. 3 min. 33 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/19.0.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/rac2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.110)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.111)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=rac2)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/19.0.0/db_1/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "srv_single" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@rac2 ~]$ 
 

 

jnrjian
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle asm 日志,oracle 11g RAC 下ASM实例的alert日志告诉我们什么
weixin_42369343的博客
04-03 1967
首先我们必须知道ASM实例的alert日志位置，ASM实例的alert日志默认路径为：/u01/app/grid/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log，在该日志里面告诉了我们非常重要的信息，以下几个实际应用场景。1、ASM的alert日志作为ASM实例的晴雨表，向我们展示了ASM实例的“健康状态”。2、ASM的alert日志告诉了我们创建磁盘组时候的操...
Linux ora28040,【故障处理】ORA-28040: No matching authentication protocol
weixin_34161139的博客
05-25 1782
【故障处理】ORA-28040: No matching authentication protocol1.1BLOG文档结构图1.2前言部分1.2.1导读和注意事项各位技术爱好者，看完本文后，你可以掌握如下的技能，也可以学到一些其它你所不知道的知识，~O(∩_∩)O~：① 告警日志中频繁出现Using deprecated SQLNET.ALLOWED_LOGON_VERSION p...
Oracle 监听SQLNET.EXPIRE_TIME
小楼一夜听春雨，深巷明朝卖杏花
08-01 2万+
在这边数据库加固有如下一个加固项，使用SQLNET.EXPIRE_TIME可以来断开在session里面超时的状态为inactive的连接。 检查是否设置超时时间 注意事项及影响： 作用：非活动会话超过10分钟，连接断开 该项需要与业务侧确认是否可以操作 对于11g （如果有grid）只加固ORACLE用户下的sqlnet.ora ，如果没有则创建  该项加固后，可能在alert 文件...
VSS在签出工程时老提示"network not found"或者''Invalid handle"的解决办法
weixin_30810583的博客
11-28 418
解决办法：需要修改服务器的网卡相关参数 大量传输减负关闭 网络唤醒和关机链接速度的值设为100Mbps 转载于:https://www.cnblogs.com/yuxiuting/archive/2011/11/28/2266023.html...
oracle网络概要配置文件 -- sqlnet.ora
sinat_39619040的博客
12-02 845
不需要客户端进行任何配置。SQLNET.AUTHENTICATION_SERVICES 值等于NTS 时，表示当用户登录到操作系统后，允许该用户以sysdba 身份直接登录数据库系统；值为NONE 时，则不允许用户以sysdba 身份直接登录数据库。当作一个主机名，然后通过网络途径去解析它的IP 地址，接着去连接这个IP 上的global_dbname = myoracle 实例。时，系统会先去找sqlnet.ora 中的配置信息。如上文中的配置信息，客户端会先去找tnsnames.ora 文件中的。
一次RAC无法启动的处理
阿丽
11-28 6884
上次去客户现场处理RAC无法启动的问题。大概情况是这样的：安装nbu的工程师在配置服务器连接磁带机的过程中，其中节点1识别不到。为识别磁带机，工程师要求重启系统。于是先关闭Oracle RAC集群。但是系统重启后，集群无法启动。经排查无法发现问题原因所在，于是打算将节点2集群关闭后再一起重新启动。最终两个节点都无法启动。 其实集群无法启动的原因有很多，比如空间不足、磁盘心跳等。查看grid的al
oracle 19c rac 修改私网、公网网络IP
热海鲜橙
03-05 1589
RAC 19C 修改IP
informatica 抛出ora-12592 :包错误 排查过程和解决办法
热门推荐
LiangHC
08-11 2万+
作者：lianghc 1.环境说明 informatica server 版本：9.6.1 informatica server上的oracle客户端：11.2.0.3 informatica server安装的操作系统：win server 2008 X64 oralce server :Oracle Database 11g Release 11.2.0.4.0 (oracle 环境
ORA-12547: TNS:lost contact导致数据库无法启动
Enmotech的博客
06-30 3146
墨墨导读：一个诡异的案例：ORA-12547: TNS:lost contact导致数据库无法启动，甚至sqlplus都无法登录，让我们一一来解开这个案例的真面目。1. 背景概述某客户出...
Oracle 11g与112c中ORA-28040 错误解决
Rango
05-24 1万+
今天遇到一个连接192.168.44.129这个库报错 java.sql.SQLException: ORA-28040: No matching authentication protocolOracle 12C下查询此报错oralce:/oracle/db/app/12.1.0/db/network/admin> oerr ora 28040 28040, 0000, "No match...
rac备库备库修改db_unique_name的问题ORA-65500: could not modify DB_UNIQUE_NAME, resource exists
sqlora的专栏
11-20 1776
oracle19c rac+linux7.6 注意：备库如果不修改db_unique_name，将无法实现实时日志应用，实践结果是这种情况下只有切换日志才会触发日志的应用。 修改的过程： 删除备库群集中的原db_unique_name 添加备库群集中的相关资源 修改备库spfile参数中的db_unique_name 修改主备库的LOG_ARCHIVE_CONFIG、LOG_ARCHI...
Oracle RAC 11G(11.2.0.4) 升级 12C(12.1.0.2)
loveLAxin的博客
09-09 1372
Linux环境 Oracle RAC 11.2.0.4升级12.1.0.2，保姆级教程.........
rac 12c以后看到的asm实例有3个
dsc1245的博客
12-29 1522
文档来源： Third ASM resource(ora.asm) listed in "crsctl stat res -t" for two node RAC in 12c (文档 ID 2132715.1) [grid@rac2 ~]$ crsctl stat res -t --------------------------------------------------------...
数据库学习案例20240201-oracle 19c rac 修改私网、公网网络IP
最新发布
oradbm的博客
02-01 265
oracle 19c修改私网/公网/虚拟IP/scanip 的网段和ip版本：oracle 19C。
从11.2开始错误的修改IP导致crs启动不了的解决方法
lunar的小铺
12-18 9977
使用RAC的时候，经常有朋友问如何修改IP，10.2的我就不说了，修改方法成熟的很，出了问题也很好解决。 从11.2开始，修改IP方法和以前差不多，但是出了问题，有些人不知道如何处理，这里介绍一个使用gpnp修复的方法（还可以用重建crs的方法），该方法已经在11.2和12c上都实施成功了。 模拟错误： 使用oifcfg故意设置错误的内部互联网段（其他使用oficfg错误的修
oracle ora-48108,安装Oracle RAC出现的问题
weixin_34324082的博客
04-03 552
CRS-2672: Attempting to start 'ora.ctssd' on'alvis'CRS-2676: Start of 'ora.ctssd' on 'alvis'succeededCRS-2672: Attempting to start 'ora.asm' on 'alvis'CRS-5011: Check of resource "+ASM" failed: detail...
Oracle12,1,2,0版本中遇到bug25211209
cucany584825的博客
10-12 612
现象描述： 12.1.0.2 集群进程 ocssd.bin 占用较高的 CPU ： PIDUSERPRN...
[RAC Clusterware] 启动crs时报错CRS-5011:检查资源 "+ASM" 失败
数据库
04-03 1744
环境，数据库：双节点rac11.2.0.1 操作系统：Red Hat Enterprise Linux Server release 5.6现象，节点B重启后无法连接[grid@ora11b ~]$ crs_stat -v -tCRS-0184: Cannot communicate with the CRS daemon.尝试启动 crs[root@ora11b ~]# /opt/...
Datanode heartbeat timeout
weixin_34293141的博客
09-26 141
早晨看到报警发现2个dead Datanode，查看系统日志发现当时的负载持续高位导致datanode超时没有发送心跳被DatanodeManager摘除，进一步发现高负载是因为一个Job的小文件太多而没有进行map file合并导致在这2台节点上同时起的MAP太多导致的，解决方法参考：http://boylook.blog.51cto.com/7934327/1298651...
oracle sqlnet.ora限制访问IP地址
06-09
是的，你可以通过在oracle sqlnet.ora文件中配置参数来限制访问IP地址。具体来说，你可以使用以下参数： 1. TCP.VALIDNODE_CHECKING：设置为YES以启用IP地址验证。如果客户端IP地址不在sqlnet.ora文件中指定的地址...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值