Error: can not register my instance state - -1

Error: can not register my instance state - -1

实验:节点2上的实例总是起不来:
[root@rac1 crs]# crs_stat -t                   
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....g1.inst application    ONLINE    ONLINE    rac1        
ora....g2.inst application    ONLINE    OFFLINE               
ora.peak.db    application    ONLINE    ONLINE    rac2        
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        
[root@rac1 crs]#

[oracle@rac1 admin]$ crs_start ora.peak.peak2.inst
Attempting to start `ora.peak.peak2.inst` on member `rac2`
Start of `ora.peak.peak2.inst` on member `rac2` failed.
rac1 : CRS-1018: Resource ora.rac2.vip (application) is already running on rac2


CRS-0215: Could not start resource 'ora.peak.peak2.inst'.


查看节点2上的alert文件,有如下报错:

PMON started with pid=2, OS id=7474
DIAG started with pid=3, OS id=7483
PSP0 started with pid=4, OS id=7485
LMON started with pid=5, OS id=7487
LMD0 started with pid=6, OS id=7497
MMAN started with pid=7, OS id=7499
DBW0 started with pid=8, OS id=7518
LGWR started with pid=9, OS id=7520
CKPT started with pid=10, OS id=7522
RECO started with pid=12, OS id=7540
CJQ0 started with pid=13, OS id=7544
SMON started with pid=11, OS id=7532
Sun Jun 10 15:30:56 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=15, OS id=7554
MMON started with pid=14, OS id=7546
Sun Jun 10 15:30:56 2012
starting up 1 shared server(s) ...
Sun Jun 10 15:30:56 2012
lmon registered with NM - instance id 2 (internal mem no 1)
 Warning: cluster_database_instances (1) is <= my node id (1)
 Warning: cluster_database_instances (1) of node 0 is <= my node id (1)
Sun Jun 10 15:30:57 2012
Reconfiguration started (old inc 0, new inc 24)
List of nodes:
 0 1
 Global Resource Directory frozen
* allocate domain 0, invalid = TRUE
 Communication channels reestablished
 * domain 0 valid = 0 according to instance 0
Sun Jun 10 15:30:59 2012
 Master broadcasted resource hash value bitmaps
 Non-local Process blocks cleaned out
 Resources and enqueues cleaned out
 Resources remastered 0
 Set master node info
 Submitted all remote-enqueue requests
 Dwn-cvts replayed, VALBLKs dubious
 All grantable enqueues granted
 Submitted all GCS remote-cache requests
 Fix write in gcs resources
Reconfiguration complete
Sun Jun 10 15:30:59 2012
Error: can not register my instance state - -1
Oracle Data Guard is not available in this edition of Oracle.
Sun Jun 10 15:30:59 2012
ALTER DATABASE   MOUNT
Sun Jun 10 15:31:10 2012
ORA-1102 signalled during: ALTER DATABASE   MOUNT...
Sun Jun 10 15:31:15 2012
Shutting down instance (abort)

忽然想起来之前做实验的时候,将RAC改为了单实例的库,是不是当时没改回来?
[oracle@rac2 ~]$ sqlplus sys/bei@peak as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jun 10 15:34:36 2012

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


Connected to:
Oracle Database 10g Release 10.2.0.1.0 - Production
With the Real Application Clusters option

SQL> show parameter clust                                                                                                                                            

NAME                                                 TYPE        VALUE
------------------------------------ -----------------------    ----------------
cluster_database                              boolean     FALSE
cluster_database_instances           integer      1
cluster_interconnects                       string
SQL>                                                                                                                                                                 
SQL>                                                                                                                                                                 
SQL> select instance_name,status from gv$instance;                                                                                                                   

INSTANCE_NAME    STATUS
----------------                ------------
peak1                        OPEN

果然是没改回RAC哦,赶紧改回来:
SQL>alter  system  set  cluster_database=TRUE  scope=SPFILE;    

System altered.

SQL>alter  system  set  cluster_database_instances=2   scope=SPFILE;      

System altered.


[oracle@rac1 admin]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....g1.inst application    ONLINE    ONLINE    rac1        
ora....g2.inst application    ONLINE    OFFLINE               
ora.peak.db    application    ONLINE    ONLINE    rac2        
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        
[oracle@rac1 admin]$   
[oracle@rac1 admin]$ srvctl  stop  database  -d  peak
[oracle@rac1 admin]$srvctl  start  database  -d  peak
[root@rac1 crs]# crs_stat -t
Name                     Type           Target        State       Host        
----------------------------------------------------------------------------
ora....g1.inst application         ONLINE    ONLINE    rac1        
ora....g2.inst application         ONLINE    ONLINE    rac2        
ora.peak.db    application      ONLINE    ONLINE    rac1        
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        
[root@rac1 crs]#

[oracle@rac2 ~]$ sqlplus sys/bei@peak as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jun 10 16:02:55 2012

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


Connected to:
Oracle Database 10g Release 10.2.0.1.0 - Production
With the Real Application Clusters option

SQL>
SQL> show  parameter  clust                                                                                                                                            

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cluster_database                     boolean     TRUE
cluster_database_instances           integer     2
cluster_interconnects                string
SQL>
SQL> select  instance_name, status  from  gv$instance;                                                                                                                   

INSTANCE_NAME    STATUS
---------------- ------------
peak2            OPEN
peak1            OPEN

SQL>

做实验呀!




更多参考:


the specified nodes are not clusterable

根据rowid删除表中重复的行

Agent process exited abnormally during initialization

一次字符乱码的解决过程

rman实验(一)

rman实验(二)

ORA-00600: internal error code, arguments: [keltnf

ORA-00600: ORA-12012 ORA-08102解决

linux下完全删除oracle

INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory

centos4.8_64上安装oracle10201建库报ORA-12547

EM乱码解决

ORA-31613 Master process DM00 failed during startup

ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []

ORA-24324 ORA-01041 ORA-03113

centos5.3升级oracle

pdksh-5.2.14-36.el5.i386.rpm

使用rman进行数据库迁移

oracle10.2.0.1升级到10.2.0.4报错

Upgrade Oracle 10g from 10.2.0.1 to 10.2.0.4 (Single Instance)

改oracle的name和dbid

修改oracle实例名

Solaris8上迁移oracle8i---上

Solaris8上迁移oracle8i---下

未备份归档日志导致数据丢失的实验

使用NBU进行数据库迁移

catalog备份数据库

RMAN FORMAT字符串格式化

Error: can not register my instance state - -1

not all alterations performed

The ASM instance configured on the local node is a single-instance ASM

/u01/crs102/bin/crsctl.bin: error while loading shared libraries: libstdc++.so.5: cannot open shared

Initializing the Oracle ASMLib driver: [FAILED]

ORA-00245: control file backup operation failed

WARNING: failed to read mirror side 1 of virtual extent 229 logical extent

模拟恢复参数文件

Interface eth0 checked failed

import server uses ZHS16GBK character set (possible charset conversion)




怎么使用这个函数初始化串口3HAL_StatusTypeDef HAL_UART_Init(UART_HandleTypeDef huart) { / Check the UART handle allocation / if (huart == NULL) { return HAL_ERROR; } / Check the parameters / if (huart->Init.HwFlowCtl != UART_HWCONTROL_NONE) { / The hardware flow control is available only for USART1, USART2, USART3 and USART6. Except for STM32F446xx devices, that is available for USART1, USART2, USART3, USART6, UART4 and UART5. / assert_param(IS_UART_HWFLOW_INSTANCE(huart->Instance)); assert_param(IS_UART_HARDWARE_FLOW_CONTROL(huart->Init.HwFlowCtl)); } else { assert_param(IS_UART_INSTANCE(huart->Instance)); } assert_param(IS_UART_WORD_LENGTH(huart->Init.WordLength)); assert_param(IS_UART_OVERSAMPLING(huart->Init.OverSampling)); if (huart->gState == HAL_UART_STATE_RESET) { / Allocate lock resource and initialize it / huart->Lock = HAL_UNLOCKED; #if (USE_HAL_UART_REGISTER_CALLBACKS == 1) UART_InitCallbacksToDefault(huart); if (huart->MspInitCallback == NULL) { huart->MspInitCallback = HAL_UART_MspInit; } / Init the low level hardware / huart->MspInitCallback(huart); #else / Init the low level hardware : GPIO, CLOCK / HAL_UART_MspInit(huart); #endif / (USE_HAL_UART_REGISTER_CALLBACKS) / } huart->gState = HAL_UART_STATE_BUSY; / Disable the peripheral / __HAL_UART_DISABLE(huart); / Set the UART Communication parameters / UART_SetConfig(huart); / In asynchronous mode, the following bits must be kept cleared: - LINEN and CLKEN bits in the USART_CR2 register, - SCEN, HDSEL and IREN bits in the USART_CR3 register./ CLEAR_BIT(huart->Instance->CR2, (USART_CR2_LINEN | USART_CR2_CLKEN)); CLEAR_BIT(huart->Instance->CR3, (USART_CR3_SCEN | USART_CR3_HDSEL | USART_CR3_IREN)); / Enable the peripheral / __HAL_UART_ENABLE(huart); / Initialize the UART state */ huart->ErrorCode = HAL_UART_ERROR_NONE; huart->gState = HAL_UART_STATE_READY; huart->RxState = HAL_UART_STATE_READY; return HAL_OK; }
05-24
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值