oracle集群起不起来,rac 实例启动不起来

最新推荐文章于 2023-02-08 07:38:04 发布
最新推荐文章于 2023-02-08 07:38:04 发布
阅读量520 收藏
点赞数
文章标签： oracle集群起不起来

rac 2个节点 操作系统 linux5.4  数据库：10.2.0.5  存储用的是asm

[oracle@rac1 ~]$ crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora.rac.db     application    OFFLINE   OFFLINE

ora....c1.inst application    ONLINE    OFFLINE

ora....c2.inst application    OFFLINE   OFFLINE

ora....test.cs application    OFFLINE   OFFLINE

ora....ac1.srv application    OFFLINE   OFFLINE

ora....ac2.srv application    OFFLINE   OFFLINE

ora....SM1.asm application    ONLINE    ONLINE    rac1

ora....C1.lsnr application    ONLINE    ONLINE    rac1

ora.rac1.gsd   application    ONLINE    ONLINE    rac1

ora.rac1.ons   application    ONLINE    ONLINE    rac1

ora.rac1.vip   application    ONLINE    ONLINE    rac1

ora....SM2.asm application    ONLINE    ONLINE    rac2

ora....C2.lsnr application    ONLINE    ONLINE    rac2

ora.rac2.gsd   application    ONLINE    ONLINE    rac2

ora.rac2.ons   application    ONLINE    ONLINE    rac2

ora.rac2.vip   application    ONLINE    ONLINE    rac

启动数据库

[oracle@rac1 ~]$ srvctl start database -d rac

PRKP-1001 : Error starting instance rac1 on node rac1

CRS-0215: Could not start resource 'ora.rac.rac1.inst'.

PRKP-1001 : Error starting instance rac2 on node rac2

CRS-0215: Could not start resource 'ora.rac.rac2.inst'.

[oracle@rac1 ~]$ crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora.rac.db     application    OFFLINE   OFFLINE

ora....c1.inst application    ONLINE    OFFLINE

ora....c2.inst application    ONLINE    OFFLINE

ora....test.cs application    OFFLINE   OFFLINE

ora....ac1.srv application    OFFLINE   OFFLINE

ora....ac2.srv application    OFFLINE   OFFLINE

ora....SM1.asm application    ONLINE    ONLINE    rac1

ora....C1.lsnr application    ONLINE    ONLINE    rac1

ora.rac1.gsd   application    ONLINE    ONLINE    rac1

ora.rac1.ons   application    ONLINE    ONLINE    rac1

ora.rac1.vip   application    ONLINE    ONLINE    rac1

ora....SM2.asm application    ONLINE    ONLINE    rac2

ora....C2.lsnr application    ONLINE    ONLINE    rac2

ora.rac2.gsd   application    ONLINE    ONLINE    rac2

ora.rac2.ons   application    ONLINE    ONLINE    rac2

ora.rac2.vip   application    ONLINE    ONLINE    rac2

数据库启动不起来，在sqlplus下启动正常

SQL> startup

ORACLE instance started.

Total System Global Area  327155712 bytes

Fixed Size                  1273516 bytes

Variable Size             104857940 bytes

Database Buffers          218103808 bytes

Redo Buffers                2920448 bytes

Database mounted.

Database opened.

crsd日志

2011-06-20 23:45:29.171: [  CRSRES][2730044304]0Attempting to start `ora.rac.rac2.inst` on member `rac2`

2011-06-20 23:45:29.544: [  CRSRES][2740534160]0startRunnable: setting CLI values

2011-06-20 23:45:29.842: [  CRSRES][2696936336]0startRunnable: setting CLI values

2011-06-20 23:45:29.842: [  CRSRES][2696936336]0Attempting to start `ora.rac.test.cs` on member `rac1`

2011-06-20 23:45:30.183: [  CRSRES][2740534160]0Attempting to start `ora.rac.test.rac1.srv` on member `rac1`

2011-06-20 23:45:31.556: [  CRSRES][2686446480]0startRunnable: setting CLI values

2011-06-20 23:45:31.573: [  CRSRES][2686446480]0Attempting to start `ora.rac.db` on member `rac1`

2011-06-20 23:45:32.036: [  CRSRES][2719554448]0Attempting to start `ora.rac.test.rac2.srv` on member `rac2`

2011-06-20 23:45:40.302: [  CRSAPP][2675956624]0StartResource error for ora.rac.rac1.inst error code = 1

2011-06-20 23:45:43.471: [  CRSRES][2675956624]0Start of `ora.rac.rac1.inst` on member `rac1` failed.

2011-06-20 23:45:44.222: [  CRSRES][2644487056]0startRunnable: setting CLI values

2011-06-20 23:45:44.507: [  CRSRES][2644487056]0Attempting to start `ora.rac.rac1.inst` on member `rac1`

2011-06-20 23:45:50.113: [  CRSRES][2730044304]0Start of `ora.rac.rac2.inst` on member `rac2` failed.

2011-06-20 23:45:55.060: [  CRSAPP][2644487056]0StartResource error for ora.rac.rac1.inst error code = 1

2011-06-20 23:45:58.719: [  CRSRES][2644487056]0Start of `ora.rac.rac1.inst` on member `rac1` failed.

2011-06-20 23:45:58.774: [  CRSRES][2644487056]0rac2 : CRS-1019: Resource ora.rac1.LISTENER_RAC1.lsnr (application) cannot run on rac2

2011-06-20 23:45:59.783: [  CRSRES][2644487056]0startRunnable: setting CLI values

2011-06-20 23:45:59.840: [  CRSRES][2644487056]0Attempting to start `ora.rac.rac1.inst` on member `rac1`

2011-06-20 23:46:03.469: [  CRSAPP][2686446480]0StartResource error for ora.rac.db error code = 1

2011-06-20 23:46:04.199: [  CRSRES][2686446480]0Start of `ora.rac.db` on member `rac1` failed.

2011-06-20 23:46:05.186: [  CRSRES][2686446480]0Attempting to start `ora.rac.db` on member `rac2`

2011-06-20 23:46:05.405: [  CRSRES][2719554448]0Start of `ora.rac.test.rac2.srv` on member `rac2` failed.

2011-06-20 23:46:06.980: [  CRSRES][2654976912]0Attempting to start `ora.rac.test.rac2.srv` on member `rac2`

2011-06-20 23:46:08.470: [  CRSRES][2654976912]0Start of `ora.rac.test.rac2.srv` on member `rac2` failed.

2011-06-20 23:46:09.949: [  CRSRES][2654976912]0Attempting to start `ora.rac.test.rac2.srv` on member `rac2`

2011-06-20 23:46:14.273: [  CRSAPP][2644487056]0StartResource error for ora.rac.rac1.inst error code = 1

2011-06-20 23:46:17.276: [  CRSRES][2644487056]0Start of `ora.rac.rac1.inst` on member `rac1` failed.

2011-06-20 23:46:17.423: [  CRSRES][2644487056]0rac2 : CRS-1019: Resource ora.rac1.LISTENER_RAC1.lsnr (application) cannot run on rac2

2011-06-20 23:46:17.507: [  CRSAPP][2740534160]0StartResource error for ora.rac.test.rac1.srv error code = 1

2011-06-20 23:46:18.104: [  CRSRES][2644487056]0startRunnable: setting CLI values

2011-06-20 23:46:18.150: [  CRSRES][2740534160]0Start of `ora.rac.test.rac1.srv` on member `rac1` failed.

2011-06-20 23:46:28.250: [  CRSAPP][2644487056]0StartResource error for ora.rac.rac1.inst error code = 1

2011-06-20 23:46:31.900: [  CRSRES][2686446480]0Start of `ora.rac.db` on member `rac2` failed.

2011-06-20 23:46:36.990: [  CRSRES][2654976912]0Start of `ora.rac.test.rac2.srv` on member `rac2` failed.

2011-06-20 23:46:37.065: [  CRSRES][2654976912]0rac1 : CRS-1019: Resource ora.rac.test.rac2.srv (application) cannot run on rac1

2011-06-20 23:46:37.104: [  CRSAPP][2696936336]0StartResource error for ora.rac.test.cs error code = 1

2011-06-20 23:46:37.608: [  CRSRES][2696936336]0Start of `ora.rac.test.cs` on member `rac1` failed.

2011-06-20 23:46:37.813: [  CRSRES][2696936336]0Attempting to start `ora.rac.test.cs` on member `rac2`

2011-06-20 23:46:38.757: [  CRSRES][2654976912]0startRunnable: setting CLI values

2011-06-20 23:46:40.073: [  CRSRES][2644487056]0startRunnable: setting CLI values

2011-06-20 23:46:40.132: [  CRSRES][2644487056]0Attempting to start `ora.rac.rac1.inst` on member `rac1`

2011-06-20 23:46:49.746: [  CRSAPP][2644487056]0StartResource error for ora.rac.rac1.inst error code = 1

2011-06-20 23:46:52.272: [  CRSRES][2644487056]0Start of `ora.rac.rac1.inst` on member `rac1` failed.

2011-06-20 23:46:52.363: [  CRSRES][2644487056]0rac2 : CRS-1019: Resource ora.rac1.LISTENER_RAC1.lsnr (application) cannot run on rac2

2011-06-20 23:46:52.398: [  CRSAPP][2654976912]0StartResource error for ora.rac.test.rac1.srv error code = 1

2011-06-20 23:46:53.264: [  CRSRES][2654976912]0startRunnable: setting CLI values

2011-06-20 23:46:53.878: [  CRSAPP][2654976912]0StartResource error for ora.rac.test.rac1.srv error code = 1

2011-06-20 23:46:55.307: [  CRSRES][2696936336]0Start of `ora.rac.test.cs` on member `rac2` failed.

2011-06-21 00:06:15.570: [  CRSRES][2730044304]0startRunnable: setting CLI values

2011-06-21 00:06:16.166: [  CRSRES][2740534160]0Attempting to start `ora.rac.rac2.inst` on member `rac2`

2011-06-21 00:06:16.439: [  CRSRES][2730044304]0Attempting to start `ora.rac.rac1.inst` on member `rac1`

2011-06-21 00:06:30.516: [  CRSAPP][2730044304]0StartResource error for ora.rac.rac1.inst error code = 1

2011-06-21 00:06:33.083: [  CRSRES][2730044304]0Start of `ora.rac.rac1.inst` on member `rac1` failed.

2011-06-21 00:06:37.306: [  CRSRES][2740534160]0Start of `ora.rac.rac2.inst` on member `rac2` failed.

2011-06-21 00:13:28.568: [  CRSRES][2719554448]0startRunnable: setting CLI values

2011-06-21 00:13:29.279: [  CRSRES][2719554448]0Attempting to start `ora.rac.rac1.inst` on member `rac1`

2011-06-21 00:13:29.350: [  CRSRES][2730044304]0Attempting to start `ora.rac.rac2.inst` on member `rac2`

2011-06-21 00:13:34.420: [  CRSRES][2719554448]0Start of `ora.rac.rac1.inst` on member `rac1` succeeded.

2011-06-21 00:13:34.982: [  CRSRES][2719554448]0Attempting to start `ora.rac.db` on member `rac2`

2011-06-21 00:13:35.397: [  CRSRES][2719554448]0Start of `ora.rac.db` on member `rac2` succeeded.

2011-06-21 00:13:39.216: [  CRSRES][2719554448]0startRunnable: setting CLI values

2011-06-21 00:13:39.587: [  CRSRES][2719554448]0Attempting to start `ora.rac.test.rac1.srv` on member `rac1`

2011-06-21 00:13:40.639: [  CRSRES][2719554448]0Start of `ora.rac.test.rac1.srv` on member `rac1` succeeded.

2011-06-21 00:13:41.181: [  CRSRES][2686446480]0startRunnable: setting CLI values

2011-06-21 00:13:41.398: [  CRSRES][2686446480]0Attempting to start `ora.rac.test.cs` on member `rac1`

2011-06-21 00:13:41.782: [  CRSRES][2686446480]0Start of `ora.rac.test.cs` on member `rac1` succeeded.

2011-06-21 00:13:43.746: [  CRSRES][2730044304]0Start of `ora.rac.rac2.inst` on member `rac2` failed.

2011-06-21 00:14:37.969: [  CRSRES][2740534160]0ora.rac.rac1.inst target set to OFFLINE before stop action

2011-06-21 00:14:37.970: [  CRSRES][2740534160]0StopResource: setting CLI values

2011-06-21 00:14:38.208: [  CRSRES][2740534160]0Attempting to stop `ora.rac.rac1.inst` on member `rac1`

2011-06-21 00:14:38.548: [  CRSRES][2730044304]0In stateChanged, ora.rac.test.rac1.srv target is ONLINE

2011-06-21 00:14:38.549: [  CRSRES][2730044304]0ora.rac.test.rac1.srv on rac1 went OFFLINE unexpectedly

2011-06-21 00:14:38.549: [  CRSRES][2730044304]0StopResource: setting CLI values

2011-06-21 00:14:39.052: [  CRSRES][2730044304]0Attempting to stop `ora.rac.test.rac1.srv` on member `rac1`

2011-06-21 00:14:39.728: [  CRSRES][2730044304]0Stop of `ora.rac.test.rac1.srv` on member `rac1` succeeded.

2011-06-21 00:14:39.730: [  CRSRES][2730044304]0ora.rac.test.rac1.srv RESTART_COUNT=0 RESTART_ATTEMPTS=0

2011-06-21 00:14:39.763: [  CRSRES][2730044304]0ora.rac.test.rac1.srv failed on rac1 relocating.

2011-06-21 00:14:39.907: [  CRSRES][2730044304]0Cannot relocate ora.rac.test.rac1.srvStopping dependents

2011-06-21 00:14:39.935: [  CRSRES][2730044304]0StopResource: setting CLI values

2011-06-21 00:14:55.667: [  CRSAPP][2730044304]0CheckResource error for ora.rac.test.cs error code = 1

2011-06-21 00:14:55.679: [  CRSRES][2730044304]0In stateChanged, ora.rac.test.cs target is ONLINE

2011-06-21 00:14:55.726: [  CRSRES][2730044304]0ora.rac.test.cs on rac1 went OFFLINE unexpectedly

2011-06-21 00:14:55.727: [  CRSRES][2730044304]0StopResource: setting CLI values

2011-06-21 00:14:56.123: [  CRSRES][2730044304]0Attempting to stop `ora.rac.test.cs` on member `rac1`

2011-06-21 00:14:56.404: [  CRSRES][2730044304]0Stop of `ora.rac.test.cs` on member `rac1` succeeded.

2011-06-21 00:14:56.410: [  CRSRES][2730044304]0ora.rac.test.cs RESTART_COUNT=0 RESTART_ATTEMPTS=0

2011-06-21 00:14:56.459: [  CRSRES][2730044304]0ora.rac.test.cs exceeded it's failure threshold.  Stopping it and its dependents!

2011-06-21 00:14:56.539: [  CRSRES][2730044304]0ora.rac.test.cs target set to OFFLINE before stop action

2011-06-21 00:14:56.539: [  CRSRES][2730044304]0StopResource: setting CLI values

2011-06-21 00:14:56.654: [  CRSRES][2730044304]0Target set to OFFLINE for `ora.rac.test.cs`

2011-06-21 00:15:14.301: [  CRSRES][2719554448]0ora.rac.test.rac1.srv target set to OFFLINE before stop action

2011-06-21 00:15:14.302: [  CRSRES][2719554448]0StopResource: setting CLI values

2011-06-21 00:15:14.898: [  CRSRES][2719554448]0Target set to OFFLINE for `ora.rac.test.rac1.srv`

2011-06-21 00:15:15.260: [  CRSRES][2719554448]0ora.rac.test.rac2.srv target set to OFFLINE before stop action

2011-06-21 00:15:15.298: [  CRSRES][2719554448]0StopResource: setting CLI values

2011-06-21 00:15:15.511: [  CRSRES][2719554448]0Target set to OFFLINE for `ora.rac.test.rac2.srv`

2011-06-21 00:15:15.792: [  CRSRES][2719554448]0ora.rac.db target set to OFFLINE before stop action

2011-06-21 00:15:15.792: [  CRSRES][2719554448]0StopResource: setting CLI values

2011-06-21 00:15:15.854: [  CRSRES][2719554448]0Attempting to stop `ora.rac.db` on member `rac2`

2011-06-21 00:15:16.116: [  CRSRES][2719554448]0Stop of `ora.rac.db` on member `rac2` succeeded.

2011-06-21 00:15:16.611: [  CRSRES][2740534160]0Stop of `ora.rac.rac1.inst` on member `rac1` succeeded.

2011-06-21 00:17:39.168: [  CRSRES][2730044304]0startRunnable: setting CLI values

2011-06-21 00:17:39.532: [  CRSRES][2719554448]0Attempting to start `ora.rac.rac2.inst` on member `rac2`

2011-06-21 00:17:39.705: [  CRSRES][2730044304]0Attempting to start `ora.rac.rac1.inst` on member `rac1`

2011-06-21 00:17:44.805: [  CRSRES][2719554448]0Start of `ora.rac.rac2.inst` on member `rac2` succeeded.

2011-06-21 00:17:56.256: [  CRSRES][2740534160]0startRunnable: setting CLI values

2011-06-21 00:17:56.788: [  CRSAPP][2730044304]0StartResource error for ora.rac.rac1.inst error code = 1

2011-06-21 00:17:59.919: [  CRSRES][2730044304]0Start of `ora.rac.rac1.inst` on member `rac1` failed.

2011-06-21 00:23:34.895: [  CRSRES][2686446480]0ora.rac.db target set to OFFLINE before stop action

2011-06-21 00:23:34.896: [  CRSRES][2686446480]0StopResource: setting CLI values

2011-06-21 00:24:51.015: [  CRSRES][2686446480]0startRunnable: setting CLI values

2011-06-21 00:24:51.747: [  CRSRES][2686446480]0Attempting to start `ora.rac.rac1.inst` on member `rac1`

2011-06-21 00:24:52.234: [  CRSRES][2719554448]0Attempting to start `ora.rac.rac2.inst` on member `rac2`

2011-06-21 00:24:55.934: [  CRSRES][2686446480]0Start of `ora.rac.rac1.inst` on member `rac1` succeeded.

2011-06-21 00:24:56.636: [  CRSRES][2686446480]0Attempting to start `ora.rac.db` on member `rac2`

2011-06-21 00:24:56.984: [  CRSRES][2686446480]0Start of `ora.rac.db` on member `rac2` succeeded.

2011-06-21 00:25:03.987: [  CRSRES][2719554448]0Start of `ora.rac.rac2.inst` on member `rac2` failed.

2011-06-21 00:32:05.979: [  CRSRES][2719554448]0Attempting to start `ora.rac.rac2.inst` on member `rac2`

2011-06-21 00:32:15.086: [ COMMCRS][2719554448]clscsendx: (0xa702c40) Physical connection (0xa6cdd40) not active

2011-06-21 00:32:15.086: [ CRSCOMM][2719554448]0Sending message size 124clscsend ret 11

2011-06-21 00:32:15.109: [  CRSEVT][2719554448]0Error sending orders to command IOException : CRS sending message error

(File: caa_Message.cpp, line: 660

2011-06-21 00:32:15.109: [  CRSRES][2719554448]0Start of `ora.rac.rac2.inst` on member `rac2` failed.

2011-06-21 00:32:15.139: [ COMMCRS][2740534160]clscsendx: (0xa702c40) Connection not active

2011-06-21 00:32:15.139: [ CRSCOMM][2740534160]0CLSC connection invalid, possible remote node failure, send failed

2011-06-21 00:32:15.191: [  CRSEVT][2740534160]0Error writing response: command=UI_START, response=UI_DATA

2011-06-21 00:32:15.191: [  CRSEVT][2740534160]0IOException : CRS sending message error

(File: caa_Message.cpp, line: 656

2011-06-21 00:35:19.860: [  CRSRES][2740534160]0ora.rac.rac1.inst target set to OFFLINE before stop action

2011-06-21 00:35:19.860: [  CRSRES][2740534160]0StopResource: setting CLI values

2011-06-21 00:35:20.149: [  CRSRES][2740534160]0Attempting to stop `ora.rac.rac1.inst` on member `rac1`

2011-06-21 00:35:58.211: [  CRSRES][2696936336]0ora.rac.db target set to OFFLINE before stop action

2011-06-21 00:35:58.212: [  CRSRES][2696936336]0StopResource: setting CLI values

2011-06-21 00:35:58.420: [  CRSRES][2696936336]0Attempting to stop `ora.rac.db` on member `rac2`

2011-06-21 00:35:58.618: [  CRSRES][2696936336]0Stop of `ora.rac.db` on member `rac2` succeeded.

2011-06-21 00:35:59.266: [  CRSRES][2740534160]0Stop of `ora.rac.rac1.inst` on member `rac1` succeeded.

2011-06-21 00:36:55.423: [  CRSRES][2740534160]0startRunnable: setting CLI values

2011-06-21 00:36:55.829: [  CRSRES][2740534160]0Attempting to start `ora.rac.rac1.inst` on member `rac1`

2011-06-21 00:36:56.091: [  CRSRES][2696936336]0Attempting to start `ora.rac.rac2.inst` on member `rac2`

2011-06-21 00:37:14.610: [  CRSRES][2696936336]0Start of `ora.rac.rac2.inst` on member `rac2` failed.

2011-06-21 00:37:18.069: [  CRSAPP][2740534160]0StartResource error for ora.rac.rac1.inst error code = 1

2011-06-21 00:37:21.082: [  CRSRES][2740534160]0Start of `ora.rac.rac1.inst` on member `rac1` failed.

用sqlplus启动2个节点的数据库，数据库正常启动

在用srvctl启动数据库状态显示正常，重启后自动起不来

[oracle@rac1 ~]$ srvctl start database -d rac

[oracle@rac1 ~]$ crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora.rac.db     application    ONLINE    ONLINE    rac2

ora....c1.inst application    ONLINE    ONLINE    rac1

ora....c2.inst application    ONLINE    ONLINE    rac2

ora....test.cs application    OFFLINE   OFFLINE

ora....ac1.srv application    OFFLINE   OFFLINE

ora....ac2.srv application    OFFLINE   OFFLINE

ora....SM1.asm application    ONLINE    ONLINE    rac1

ora....C1.lsnr application    ONLINE    ONLINE    rac1

ora.rac1.gsd   application    ONLINE    ONLINE    rac1

ora.rac1.ons   application    ONLINE    ONLINE    rac1

ora.rac1.vip   application    ONLINE    ONLINE    rac1

ora....SM2.asm application    ONLINE    ONLINE    rac2

ora....C2.lsnr application    ONLINE    ONLINE    rac2

ora.rac2.gsd   application    ONLINE    ONLINE    rac2

ora.rac2.ons   application    ONLINE    ONLINE    rac2

ora.rac2.vip   application    ONLINE    ONLINE    rac2

[本帖最后由 ksly1227 于 2011-6-20 21:09 编辑]

不开飞机的贝塔
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle 19c 集群及数据库的启停步骤
11-19 1538
方法三：停止本节点HAS(High Availability Services)，必须以root用户。#方法三：启动本节点HAS(High Availability Services)，必须以root用户。#方法四：停止本节点CRS，必须以root用户。#方法四：启动本节点CRS，必须以root用户。#方法二：停止本节点服务，必须以root用户。#方法二：启动本节点服务，必须以root用户。# 方法一：停止所有集群上的节点服务。# 方法一：启动所有集群上的节点服务。一、停止集群及数据库。
oracle11grac集群的重启
qq_16203649的博客
04-24 1980
集群路径 /oracle/app/11.2.0/grid/bin/crsctl stop crs 关闭数据库和集群 1）、 oracle用户 停止数据库 $srvctl stop database -d rac -o immediate 2）、停止集群服务 关闭集群需要root运行 #/u01/app/11.2.0/grid/bin/crsctl stop has -f 两个节...
Oracle11g RAC集群重启操作
tttt0611的博客
04-26 2575
Oracle11g RAC集群重启操作 1.关闭数据库 1.1关闭前查看数据库状态 [oracle@fanxin01 ~]$ srvctl status database -d FXDB 实例 fxdb1 正在节点 fanxin01 上运行 实例 fxdb2 正在节点 fanxin02 上运行 1.2关闭数据库 [oracle@fanxin01 ~]$ srvc...
oracle重启集群命令,Oracle 11gR2 RAC集群服务启动与关闭命令汇总
weixin_42308335的博客
04-03 331
网上好多帖子都是启动和关闭相关服务的命令# su – oracle$ crs_start–all --启动所有的crs服务$ crs_stop–all --停止所有的crs服务$ crsctl start crs --启动crs服务$ crsctl stop crs --停止crs服务$ srvctl start nodeapps -n db01(db02) --启动某节点上所有的应用$ srvc...
ORACLE集群配置（注：根据网上资料自行搭建成功步奏总结）
热门推荐
Otaku love travel
07-02 1万+
一、   安装前准备1.     2台或多台linux服务器 2.     每台服务器一个公用ip一个私有ip 3.     公有ip：其他主机访问  2台主机最好同一ip段 4.     私有ip：2台或多台虚拟机互访  2台主机最好同一ip段 5.     注意：网卡名称相同。 6.     Oracle安装包，grid安装包，相关插件安装包（已准备）。 7.   ...
oracle rac启动报错,oracle 11g RAC asm无法启动
weixin_33239386的博客
04-03 1892
oracle 11g RACasm无法启动，报错：ASMCMD-8102: no connection to ASM; command requires ASM to run环境变量如下：[grid@rac1 ~]$ cat .bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then....
Oracle-RAC添加节点ASM实例没有启动问题分析
sinat_36757755的博客
02-08 954
在Oracle RAC19c的三节点集群进行第四个节点的添加，完成节点添加之后，集群状态正常但新节点的ASM实例没有启动
Oracle-在ASM无法正常启动下，修改ASM实例参数
sinat_36757755的博客
08-14 1496
在对ASM实例参数进行配置时，可能会遇到参数修改之后无法正常启动ASM实例的情况，这时候需要我们人为的对参数文件配置进行修正乃至回退，但ASM实例的参数文件通常是存放在ASM磁盘的OCR投票盘里面，在ASM实例没有启动的情况下，是无法正常去读取修改的，这时候就需要我们通过一个临时的参数文件启动ASM实例，再去读取修改参数文件。 本文主要讲述如何通过一个临时的参数文件启动ASM实例并读取修改ASM参数文件。...
oracle安装rac起不来,RAC安装asm死活起不来
weixin_35034831的博客
04-09 257
本帖最后由 last_day_1983 于 2012-4-6 21:11 编辑vmwareOS：Linux4.7 64bit ORACLE10204还没有创建实例：[oracle@rac1 ~]$ crs_stat -tName Type Target State Host----------------------------------...
rac某节点asm磁盘启动失败故障定位及恢复
weixin_34332905的博客
12-22 373
RAC环境：oracle数据库：oracle11gr2操作系统：rhel6.4_x86_64故障现象：　　1、rac其一个节点的oracle与asm相关的进程和实例启动失败；　　　　查看方法：ps -ef|grep ora_ ps -ef|grep asm_ crsctl stat res -t　（只能看到节...
创建oracle数据库(RAC)实例过程说明.doc
06-09
记一次部署oracle的集群RAC实例的过程，以满足项目在数据安全方面的考虑，推荐部署rac集群环境
Oracle Rac 集群数据文件改变目录操作
07-27
1. 从集群的任意一个实例登录，查看spfile信息 2. 重新创建新的spfile 3. 通过ASM命令行，查看spfile，并赋予别名。 4. 修改注册新的spfile文件： 5. 重启数据库 6. 查看结果 7. 查看参数文件 二、控制文件路径修改 ...
Oracle RAC集群转单实例/RMAN异机恢复/RMAN迁移/RMAN备份恢复操作概要
12-14
说明：本文为Oracle RAC集群转单实例/RMAN异机恢复/RMAN迁移/RMAN备份恢复操作概要方便用户查阅 温馨提示：如果您发现本文哪里写的有问题或者有更好的写法请留言或私信我进行修改优化 步骤 –全库备份（最好停止业务...
ORACLE 11gR2 RAC集群+单实例DG安装部署配置RAC+DG
03-16
oracle 11gr2在linux下的安装配置，包括1.集群规划；2.RAC主库安装实施；3.RAC共享存储安装配置；4.安装GRID集群；5.ASM磁盘安装；6.安装数据库软件；7.安装数据库实例；8.备库安装配置。
oracle 11g rac 虚拟机搭建集群
09-10
RAC是一个完整的集群应用环境，它不仅实现了集群的功能，而且提供了运行在集群之上的应用程序，即Oracle数据库。无论与普通的集群相比，还是与普通的oracle数据库相比，RAC都有一些独特之处。 RAC由至少两个节点组成...
电信塔施工方案.doc
04-27
5G通信行业、网络优化、通信工程建设资料。
29-【智慧城市与政府治理分会场】10亿大数据助推都市治理-30页.pdf
04-27
29-【智慧城市与政府治理分会场】10亿大数据助推都市治理-30页.pdf
ABB IRC5 Compact 机器人产品手册
最新发布
04-27
ABB IRC5 Compact 机器人产品手册
LTE容量优化高负荷小区优化指导书.docx
04-27
5G通信行业、网络优化、通信工程建设资料
oracle单实例迁移rac
10-04
Oracle单实例迁移为RAC（Real Application Cluster）是将原本运行在单个Oracle实例上的数据库，迁移到具有高可用性和可伸缩性的Oracle RAC集群上的过程。 在进行单实例迁移到RAC之前，需要进行一些准备工作。首先，确保已经创建了适当的RAC集群，这意味着至少要有两个或更多节点可以支持集群。其次，需要为RAC集群配置共享存储，这可以是使用共享磁盘的SAN（存储区域网络）或NAS（网络附加存储）。 在迁移过程中，需要执行以下步骤： 1. 验证单实例数据库的完整性和一致性，确保数据库可以顺利迁移。 2. 使用Oracle Database软件安装程序将Oracle RAC软件安装在RAC节点上。确保在每个节点上安装相同的软件版本和补丁程度。 3. 使用RAC节点上的Oracle DBCA（数据库配置助手）工具创建一个新的RAC数据库。在创建新数据库时，需要指定共享存储以及其他相关参数。 4. 在新的RAC数据库上执行数据迁移。可以使用Oracle Data Pump或RMAN（恢复管理器）来导出和导入数据。 5. 完成数据迁移后，需要更新应用程序连接信息和配置文件，以便连接到新的RAC数据库。 6. 进行充分的测试，包括验证在RAC集群上的数据库与原始单实例数据库的功能和性能。 7. 一旦测试成功，可以切换应用程序到新的RAC数据库上，并关闭原始的单实例数据库。 总的来说，将Oracle单实例迁移到RAC集群是一项复杂的任务，涉及到多个步骤和考虑因素。需要提前做好策划和准备工作，并确保在迁移过程中保持数据库的完整性和一致性。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值