Can't start RAC database error - CRS-2674, CRS-2632
772262Oct 14 2010 — edited Oct 14 2010Hello All,
Please can I know how to fix this issue. I have created this databse using DBCA and no parameter modifications are done.
[oracle@rs1pre91dvdbaa01 dbs]$ srvctl stop database -d MDM1
[oracle@rs1pre91dvdbaa01 dbs]$ srvctl start database -d MDM1
PRCR-1079 : Failed to start resource ora.mdm1.db
ORA-01105: mount is incompatible with mounts by other instances
ORA-01677: standby file name convert parameters differ from other instance
CRS-2674: Start of 'ora.mdm1.db' on 'rs1pre91dvdbaa01' failed
CRS-2632: There are no more servers to try to place resource 'ora.mdm1.db' on th
at would satisfy its placement policy
[oracle@rs1pre91dvdbaa01 dbs]$
========================ALERT LOG
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/db
home_1/dbs/spfileMDM11.ora
WARNING: spfile modifications are disabled because multiple spfiles were used
System parameters with non-default values:
processes = 500
sessions = 772
spfile = "/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfile
MDM11.ora"
nls_language = "ENGLISH"
nls_territory = "UNITED KINGDOM"
memory_target = 800M
control_files = "+MDMDG1/mdm1/controlfile/current.330.732377567"
control_files = "+MDMDG2/mdm1/controlfile/current.368.732377567"
db_file_name_convert = "MDM1"
db_file_name_convert = "MDM2"
log_file_name_convert = "MDM1"
log_file_name_convert = "MDM2"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=+MDMDG3/MDM1/ARCH VALID_FOR=(ALL_LOGFILES
,ALL_ROLES) DB_UNIQUE_NAME=MDM1"
log_archive_dest_2 = "SERVICE=MDM2 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIM
ARY_ROLE) DB_UNIQUE_NAME=MDM2"
fal_server = "MDM2"
log_archive_format = "MDM_%t_%s_%r.arc"
cluster_database = TRUE
db_create_file_dest = "+MDMDG1"
db_recovery_file_dest = "+MDMDG2"
db_recovery_file_dest_size= 1000M
standby_file_management = "AUTO"
thread = 1
undo_tablespace = "UNDOTBS1"
instance_number = 1
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=MDM1XDB)"
remote_listener = "rs1pre91cl:1521"
audit_file_dest = "/u01/app/oracle/admin/MDM1/adump"
audit_trail = "DB"
db_name = "MDM"
db_unique_name = "MDM1"
open_cursors = 300
dg_broker_config_file1 = "+MDMDG2/mdm/dg_config/dgconfig1_mdm.dat"
dg_broker_config_file2 = "+MDMDG2/mdm/dg_config/dgconfig2_mdm.dat"
diagnostic_dest = "/u01/app/oracle"
Cluster communication is configured to use the following interface(s) for this i
nstance
192.168.21.201
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Thu Oct 14 15:43:43 2010
PMON started with pid=2, OS id=11744
Thu Oct 14 15:43:43 2010
VKTM started with pid=3, OS id=11746 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Oct 14 15:43:43 2010
GEN0 started with pid=4, OS id=11750
Thu Oct 14 15:43:43 2010
DIAG started with pid=5, OS id=11752
Thu Oct 14 15:43:43 2010
DBRM started with pid=6, OS id=11754
Thu Oct 14 15:43:43 2010
PING started with pid=7, OS id=11756
Thu Oct 14 15:43:43 2010
PSP0 started with pid=8, OS id=11758
Thu Oct 14 15:43:43 2010
ACMS started with pid=9, OS id=11760
Thu Oct 14 15:43:43 2010
DIA0 started with pid=10, OS id=11762
Thu Oct 14 15:43:43 2010
LMON started with pid=11, OS id=11764
Thu Oct 14 15:43:46 2010
LMD0 started with pid=12, OS id=11766
Thu Oct 14 15:43:46 2010
LMS0 started with pid=13, OS id=11770 at elevated priority
Thu Oct 14 15:43:46 2010
RMS0 started with pid=14, OS id=11774
Thu Oct 14 15:43:46 2010
LMHB started with pid=15, OS id=11776
Thu Oct 14 15:43:46 2010
MMAN started with pid=16, OS id=11778
Thu Oct 14 15:43:46 2010
DBW0 started with pid=17, OS id=11780
Thu Oct 14 15:43:46 2010
LGWR started with pid=18, OS id=11782
Thu Oct 14 15:43:46 2010
CKPT started with pid=19, OS id=11784
Thu Oct 14 15:43:46 2010
SMON started with pid=20, OS id=11786
Thu Oct 14 15:43:46 2010
RECO started with pid=21, OS id=11788
Thu Oct 14 15:43:46 2010
RBAL started with pid=22, OS id=11790
Thu Oct 14 15:43:46 2010
ASMB started with pid=23, OS id=11792
Thu Oct 14 15:43:46 2010
MMON started with pid=24, OS id=11794
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL
=TCP))'...
Thu Oct 14 15:43:46 2010
MMNL started with pid=25, OS id=11798
NOTE: initiating MARK startup
Starting background process MARK
starting up 1 shared server(s) ...
Thu Oct 14 15:43:46 2010
MARK started with pid=27, OS id=11802
NOTE: MARK has subscribed
lmon registered with NM - instance number 1 (internal mem no 0)
Reconfiguration started (old inc 0, new inc 4)
List of instances:
1 2 (myinst: 1)
Global Resource Directory frozen
* allocate domain 0, invalid = TRUE
Communication channels reestablished
* domain 0 not valid according to instance 2
* domain 0 valid = 0 according to instance 2
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Post SMON to start 1st pass IR
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
Thu Oct 14 15:43:47 2010
LCK0 started with pid=29, OS id=11813
Starting background process RSMN
Thu Oct 14 15:43:47 2010
RSMN started with pid=30, OS id=11815
ORACLE_BASE from environment = /u01/app/oracle
Thu Oct 14 15:43:47 2010
ALTER DATABASE MOUNT
NOTE: Loaded library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
NOTE: Loaded library: System
SUCCESS: diskgroup MDMDG1 was mounted
SUCCESS: diskgroup MDMDG2 was mounted
Thu Oct 14 15:43:53 2010
NOTE: dependency between database MDM1 and diskgroup resource ora.MDMDG1.dg is e
stablished
NOTE: dependency between database MDM1 and diskgroup resource ora.MDMDG2.dg is e
stablished
ORA-1105 signalled during: ALTER DATABASE MOUNT...
Thu Oct 14 15:43:57 2010
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 11892): terminating the instance
Instance terminated by USER, pid = 11892
Thu Oct 14 15:43:57 2010
Instance shutdown complete
Thanks.