[RAC] Single Node restart report ORA-1105 ORA-01606

Source: Internet
Author: User

Version 11.2.0.1.0
Rac1
Rac2
Linux 5.3U 2.6.18-128. el5
Because we need to fix a bug for testing, modify the implicit parameter on a node, and then restart it! During the test
Modified the parameters on rac1.
Sys @ rac1> alter system set "_ gc_read_mostly_locking" = false scope = spfile sid = 'rac1 ';
Sys @ rac1> shutdown immedate
Database closed.
Database dismounted.
Oracle instance shut down.
The following error is reported during startup:
Sys @ rac1> startup
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2213896 bytes
Variable Size 1275070456 bytes
Database Buffers 369098752 bytes
Redo Buffers 7135232 bytes
ORA-01105: mount is incompatible with mounts by other instances.
ORA-01606: parameter not identical to that of another mounted instance
Alarm log
ALTER DATABASE MOUNT
NOTE: Loaded library:/opt/oracle/extapi/64/asm/orcl/1/libasm. so
NOTE: Loaded library: System
SUCCESS: diskgroup DATA2 was mounted
NOTE: dependency between database rac and diskgroup resource ora. DATA2.dg is established
ORA-1105 signalled during: alter database mount...
Sun Jul 01 19:17:49 2012
Starting ORACLE instance (normal)


The above error occurs because the _ gc_read_mostly_locking parameter on node 1 and node 2 is different.
Solution:
Because Node 2 is not closed, execute
Sys @ rac2> alter system set "_ gc_read_mostly_locking" = false scope = spfile sid = '*';
Start the database of rac1 again!


Extended: If the sid is specified as * When the implicit parameter is modified, it is OK to restart a node!
Sys @ rac1> alter system set "_ gc_read_mostly_locking" = false scope = spfile sid = '*';
System altered.
Sys @ rac1> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
Sys @ rac1> startup
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2213896 bytes
Variable Size 1275070456 bytes
Database Buffers 369098752 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
Sys @ rac1>

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.