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)