Shulou(Shulou.com)06/01 Report--

1. Environment description:

Oracle 10g RAC, modify db_files parameters online

2. The operation is as follows

SQL > show parameter db_filesNAME TYPE VALUE---db_files integer 200SQL > alter system set db_files=1000 scope=spfile sid='*';System altered.SQL > shutdown immediate Database closed.Database dismounted.ORACLE instance shut down.SQL > startupORACLE instance started.Total System Global Area 536870912 bytesFixed Size 1268508 bytesVariable Size 150996196 bytesDatabase Buffers 381681664 bytesRedo Buffers 2924544 bytesORA-01105: mount is incompatible with mounts by other instancesORA-01174: DB_FILES is 1000 buts needs to be 200to be compatible-- reported an error, indicating that the database Mount is inconsistent with another instance mount, and the modified parameter of 1000 is inconsistent with that of another node. 3. The solution is to close the instance of the second node, so that the instances of both nodes are closed at the same time, or the instances of all nodes need to be closed. It's bound to affect business. Some parameters can be changed online, and some parameters can be scrolled, which do not affect the business. However, the parameter db_files will inevitably affect the business. You can only restart all instances at a point in time that has the least impact on the business. SQL > conn / as sysdbaConnected.SQL > startupORA-01081: cannot start already-running ORACLE-shut it down firstSQL > shutdown abort;ORACLE instance shut down.SQL > startupORACLE instance started.Total System Global Area 536870912 bytesFixed Size 1268508 bytesVariable Size 150996196 bytesDatabase Buffers 381681664 bytesRedo Buffers 2924544 bytesDatabase mounted.Database opened.SQL >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.