Got the following error from alert log.
Wed Apr 8 03:41:38 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=23, OS id=26761
Wed Apr 8 03:41:38 2009
starting up 1 shared server(s) ...
Wed Apr 8 03:41:38 2009
lmon registered with NM - instance id 2 (internal mem no 1)
Warning: cluster_database_instances (1) of node 0 is <= my node id (1)
cluster_database_instances parameter mismatch!
Instance 0 = 1, mine = 2
This instance has not mounted yet. Exiting!
Wed Apr 8 03:41:39 2009
USER: terminating instance due to error 29707
Instance terminated by USER, pid = 26601
I took the following action from first node.
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 8 03:42:05 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP
and Data Mining options
SQL> show parameter instance
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 1
instance_groups string
instance_name string RTST1
instance_number integer 1
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 1
SQL> show parameter cluster
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean FALSE
cluster_database_instances integer 1
cluster_interconnects string
SQL> create pfile='/export/home/oracle/henry/pfile.txt' from spfile;
File created.
SQL> alter system set cluster_database=true scope=spfile;
System altered.
SQL> alter system set cluster_database_instances=2 scope=spfile;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP
and Data Mining options
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....ST1.srv application OFFLINE OFFLINE
ora....TST1.cs application OFFLINE OFFLINE
ora....T1.inst application OFFLINE OFFLINE
ora....ST2.srv application OFFLINE OFFLINE
ora....TST2.cs application OFFLINE OFFLINE
ora....T2.inst application ONLINE OFFLINE
ora.RTST.db application OFFLINE OFFLINE
ora....QX.lsnr application ONLINE ONLINE tst-...-eqx
ora....eqx.ons application ONLINE ONLINE tst-...-eqx
ora....eqx.vip application ONLINE ONLINE tst-...-eqx
ora....QX.lsnr application ONLINE ONLINE tst-...-eqx
ora....eqx.ons application ONLINE ONLINE tst-...-eqx
ora....eqx.vip application ONLINE ONLINE tst-...-eqx
$ crs_start
Usage: crs_start resource_name [...] [-c cluster_member] [-f] [-q] ["attrib=value ..."]
crs_start -all [-q]
$ crs_start -all
Attempting to start `ora.RTST.RTST1.inst` on member `tst-rac01-ud-us-eqx`
Attempting to start `ora.RTST.RTST2.inst` on member `tst-rac02-ud-us-eqx`
Start of `ora.RTST.RTST2.inst` on member `tst-rac02-ud-us-eqx` succeeded.
Start of `ora.RTST.RTST1.inst` on member `tst-rac01-ud-us-eqx` succeeded.
Attempting to start `ora.RTST.RTST1.cs` on member `tst-rac01-ud-us-eqx`
Attempting to start `ora.RTST.RTST1.RTST1.srv` on member `tst-rac01-ud-us-eqx`
Attempting to start `ora.RTST.db` on member `tst-rac01-ud-us-eqx`
Attempting to start `ora.RTST.RTST2.RTST2.srv` on member `tst-rac02-ud-us-eqx`
Attempting to start `ora.RTST.RTST2.cs` on member `tst-rac02-ud-us-eqx`
Start of `ora.RTST.RTST1.cs` on member `tst-rac01-ud-us-eqx` succeeded.
Start of `ora.RTST.RTST2.cs` on member `tst-rac02-ud-us-eqx` succeeded.
Start of `ora.RTST.RTST1.RTST1.srv` on member `tst-rac01-ud-us-eqx` succeeded.
Start of `ora.RTST.RTST2.RTST2.srv` on member `tst-rac02-ud-us-eqx` succeeded.
Start of `ora.RTST.db` on member `tst-rac01-ud-us-eqx` succeeded.
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....ST1.srv application ONLINE ONLINE tst-...-eqx
ora....TST1.cs application ONLINE ONLINE tst-...-eqx
ora....T1.inst application ONLINE ONLINE tst-...-eqx
ora....ST2.srv application ONLINE ONLINE tst-...-eqx
ora....TST2.cs application ONLINE ONLINE tst-...-eqx
ora....T2.inst application ONLINE ONLINE tst-...-eqx
ora.RTST.db application ONLINE ONLINE tst-...-eqx
ora....QX.lsnr application ONLINE ONLINE tst-...-eqx
ora....eqx.ons application ONLINE ONLINE tst-...-eqx
ora....eqx.vip application ONLINE ONLINE tst-...-eqx
ora....QX.lsnr application ONLINE ONLINE tst-...-eqx
ora....eqx.ons application ONLINE ONLINE tst-...-eqx
ora....eqx.vip application ONLINE ONLINE tst-...-eqx
$ srvctl status database -d RTST
sInstance RTST1 is running on node tst-rac01-ud-us-eqx
Instance RTST2 is running on node tst-rac02-ud-us-eqx
分享到:
相关推荐
startup_stm32f4xx.s文件,配合我的学习笔记STM32F4启动文件http://blog.csdn.net/a5130599/article/details/8227591
Filled with insightful case studies, The Startup Equation is a vibrant, practical guide to creating a winning business model for any startup. By following the accessible visual roadmap within, you'll ...
startup_stm32f103xb.s
startup_MIMXRT1052.S.s
Vector SLP4用户手册,版本v16.0.0,包括工程启动、工程设置、确认、开始BSW设置、软件组件设计、映射、代码生成、添加可运行编码、编译、链接和测试工程等
佳天下 Startup Delayer V2.5.0.138绿色汉化单文件版
windows下直接点击startup.bat启动tomcat服务.docx
每个人都想创业,这是一本指导你如何在当前的web 2.0/3.0的浪潮中成功创业的书,
The ARM C library provides multiple implementations of the function __user_setup_stackheap(), and can select the correct one for you automatically from information given in a scatter file. To select ...
ARM通用启动文件STARTUP.S源代码,资源共享!!! 通用 , 源代码 , 资源共享
Appendix D: System Startup ...... . . 1223 Appendix E: The ELF Binary Format ..... . . . . 1241 Appendix F: The Kernel Development Process .... . . 1267 Bibliography ........ . 1289 Index ........1293
2010-11-11 22:52:05 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deploying web application directory blog 2010-11-11 22:52:06 org.apache.catalina.core.StandardContext listenerStart ...
本压缩包讲述了如何使用Vector工具,从无到有搭建工程和工具配置,包括(BSW配置和RTE配置)
如果你的canal在windows启动报错。只需要将我的startup.bat替换一下。不过替换前记得更新哈。 - JVM6
startup.sh
DaVinci Configur官方帮助文档,配置使用手册。 一步一步教你怎么使用工具 User Manual startup with Vector SLP3
the more aware entrepreneurs are of this pattern, the better able they will be to capitalize on it. Author Howard Love calls this pattern the start-up J Curve: The toughest part of the endeavor is ...
stm32f427启动文件