9 Replies Latest reply: Sep 25, 2012 12:24 PM by 954124 RSS

    Two instances are down on four node physical standby.

    954124
      Hi There,

      I am new to oracle.

      I got following errors:

      ORA-01105: mount is incompatible with mounts by other instances
      ORA-01677: standby file name convert parameters differ from other instance


      1) I chnged spfile into pfile for 1st instance which is down.

      2) Than I changed db_file_name_convert parameter by copying its value from 2nd instances pfile (as this instance is up).

      than I converted pfile into spfile.

      3) And than I bounced the 1st instance by using srvctl stop -d database dbname -i instancename

      srvctl start -d database dbname -i instancename

      but it didnt turn on. So I logged into sqlplus and executed startup.

      N I got following errors:

      ORA-01105: mount is incompatible with mounts by other instances
      ORA-01677: standby file name convert parameters differ from other instance

      Please let me know what I am doing wrong.

      Thanks in advance!!
        • 1. Re: Two instances are down on four node physical standby.
          mseberg
          Hello;

          Would check DB_FILE_STANDBY_NAME_CONVERT and LOG_FILE_STANDBY_NAME_CONVERT and make sure they match on all the instances. Spfile.

          Would not stop with these parameters.

          The error indicates that the parameter file does not match with the parameter file of another instance. So, you must verify the list of initialization parameters of one node with the list of initialization parameters on another node.


          Best Regards

          mseberg

          Edited by: mseberg on Sep 25, 2012 10:41 AM
          • 2. Re: Two instances are down on four node physical standby.
            Pjuarez.-Oracle
            Hi,

            Check your resource on grid
            srvctl config database -d dbname

            What spfile are you using?
            • 3. Re: Two instances are down on four node physical standby.
              954124
              **This the Pfile of the instance which is down**

              NDCPVDDS4.__db_cache_size=1157627904
              NDCPVDDS1.__db_cache_size=1224736768
              NDCPVDDS3.__db_cache_size=1258291200
              NDCPVDDS2.__db_cache_size=1442840576
              NDCPVDDS4.__java_pool_size=16777216
              NDCPVDDS1.__java_pool_size=16777216
              NDCPVDDS3.__java_pool_size=16777216
              NDCPVDDS2.__java_pool_size=16777216
              NDCPVDDS4.__large_pool_size=16777216
              NDCPVDDS1.__large_pool_size=16777216
              NDCPVDDS3.__large_pool_size=16777216
              NDCPVDDS2.__large_pool_size=16777216
              NDCPVDDS4.__shared_pool_size=805306368
              NDCPVDDS1.__shared_pool_size=738197504
              NDCPVDDS3.__shared_pool_size=704643072
              NDCPVDDS2.__shared_pool_size=520093696
              NDCPVDDS4.__streams_pool_size=0
              NDCPVDDS1.__streams_pool_size=0
              NDCPVDDS3.__streams_pool_size=0
              NDCPVDDS2.__streams_pool_size=0
              *.archive_lag_target=900
              *.audit_file_dest='/opt/oracle/product/admin/NDCPVDDS/adump'
              *.audit_trail='DB'
              *.background_dump_dest='/opt/oracle/product/admin/NDCPVDDS/bdump'
              *.cluster_database=true
              *.cluster_database_instances=4
              *.compatible='10.2.0.3.0'
              *.control_files='+DG_NDCCLU35_ORA1/ndcpvdds/control01.ctl','+DG_NDCCLU35_ORA2/nd cpvdds/control02.ctl','+DG_NDCCLU35_ORA3/ndcpvdds/control03.ctl'#Restore Control file
              *.core_dump_dest='/opt/oracle/product/admin/NDCPVDDS/cdump'
              *.cursor_sharing='FORCE'
              *.db_block_size=8192
              *.db_domain=''
              *.db_file_multiblock_read_count=16
              *.db_file_name_convert='+DG_PDCCLU17_ORA1/PDCVDDSP','+DG_NDCCLU35_ORA1/NDCPVDDS' ,'+DG_PDCCLU17_ORA2/PDCVDDSP','+DG_NDCCLU35_ORA2/NDCPVDDS','+DG_PDCCLU17_ORA3/PD CVDDSP','+DG_NDCCLU35_ORA3/NDCPVDDS','+DG_PDCCLU17_ORA4/PDCVDDSP','+DG_NDCCLU35_ ORA1/NDCPVDDS','+DG_PDCCLU17_ORA5/PDCVDDSP','+DG_NDCCLU35_ORA2/NDCPVDDS','+DG_PD CCLU17_ORA6/PDCVDDSP','+DG_NDCCLU35_ORA3/NDCPVDDS','+DG_NDCCLU7R05_ORA1/NDCVDDSP ','+DG_NDCCLU35_ORA1/NDCPVDDS','+DG_NDCCLU7R05_ORA2/NDCVDDSP','+DG_NDCCLU35_ORA2 /NDCPVDDS','+DG_NDCCLU7R05_ORA3/NDCVDDSP','+DG_NDCCLU35_ORA3/NDCPVDDS'
              *.db_name='PDCVDDSP'
              *.db_unique_name='NDCPVDDS'
              *.dg_broker_config_file1='+DG_NDCCLU35_ORA2/ndcpvdds/dr1ndcpvdds.dat'
              *.dg_broker_config_file2='+DG_NDCCLU35_ORA2/ndcpvdds/dr2ndcpvdds.dat'
              *.dg_broker_start=TRUE
              *.dispatchers='(PROTOCOL=TCP) (SERVICE=NDCPVDDSXDB)'
              *.fal_client='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ndcgrid36v ip)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ndcpvdds_XPT)(INSTANCE_NAME=NDCPVDDS 2)(SERVER=dedicated)))'
              *.fal_server='pdcvddsp1'
              NDCPVDDS1.instance_number=1
              NDCPVDDS2.instance_number=2
              NDCPVDDS3.instance_number=3
              NDCPVDDS4.instance_number=4
              *.job_queue_processes=10
              NDCPVDDS1.local_listener='LISTENER_NDCPVDDS1'
              NDCPVDDS2.local_listener='LISTENER_NDCPVDDS2'
              NDCPVDDS3.local_listener='LISTENER_NDCPVDDS3'
              NDCPVDDS4.local_listener='LISTENER_NDCPVDDS4'
              *.log_archive_config='dg_config=(PDCVDDSP)'
              *.log_archive_dest_1='location="+DG_NDCCLU35_ARCH/NDCPVDDS/arch", valid_for=(ONL INE_LOGFILES,ALL_ROLES)'
              *.log_archive_dest_2='SERVICE=NDCVDDSP LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRI MARY_ROLE) DB_UNIQUE_NAME=NDCVDDSP'
              *.log_archive_dest_3='service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP )(HOST=pdcgrid17vip)(PORT=1800)))(CONNECT_DATA=(SERVICE_NAME=pdcvddsp_XPT)(INSTA NCE_NAME=PDCVDDSP1)(SERVER=dedicated)))"',' LGWR ASYNC NOAFFIRM delay=0 OPTION AL max_failure=0 max_connections=1 reopen=300 db_unique_name="pdcvddsp" regist er net_timeout=180 valid_for=(online_logfiles,primary_role)'
              NDCPVDDS1.log_archive_dest_4='location="+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/ "',' valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)'
              NDCPVDDS4.log_archive_dest_4='location="+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/ "',' valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)'
              NDCPVDDS2.log_archive_dest_4='location="+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/ "',' valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)'
              NDCPVDDS3.log_archive_dest_4='location="+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/ "',' valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)'
              *.log_archive_dest_state_2='ENABLE'
              *.log_archive_dest_state_3='ENABLE'
              NDCPVDDS1.log_archive_dest_state_4='ENABLE'
              NDCPVDDS4.log_archive_dest_state_4='ENABLE'
              NDCPVDDS2.log_archive_dest_state_4='ENABLE'
              NDCPVDDS3.log_archive_dest_state_4='ENABLE'
              *.log_archive_format='PDCVDDSP_%t_%s_%r.arc'
              NDCPVDDS1.log_archive_format='PDCVDDSP_%t_%s_%r.arc'
              NDCPVDDS4.log_archive_format='PDCVDDSP_%t_%s_%r.arc'
              NDCPVDDS2.log_archive_format='PDCVDDSP_%t_%s_%r.arc'
              NDCPVDDS3.log_archive_format='PDCVDDSP_%t_%s_%r.arc'
              *.log_archive_max_processes=4
              *.log_archive_min_succeed_dest=1
              *.log_archive_trace=0
              NDCPVDDS1.log_archive_trace=0
              NDCPVDDS4.log_archive_trace=0
              NDCPVDDS2.log_archive_trace=0
              NDCPVDDS3.log_archive_trace=0
              *.log_file_name_convert='+DG_PDCCLU17_ORA1/PDCVDDSP','+DG_NDCCLU35_ORA1/NDCPVDDS ','+DG_PDCCLU17_ORA2/PDCVDDSP','+DG_NDCCLU35_ORA2/NDCPVDDS','+DG_PDCCLU17_ORA3/P DCVDDSP','+DG_NDCCLU35_ORA3/NDCPVDDS','+DG_PDCCLU17_ORA4/PDCVDDSP','+DG_NDCCLU35 ORA1/NDCPVDDS','+DGPDCCLU17_ORA5/PDCVDDSP','+DG_NDCCLU35_ORA2/NDCPVDDS','+DG_P DCCLU17_ORA6/PDCVDDSP','+DG_NDCCLU35_ORA3/NDCPVDDS','+DG_NDCCLU7R05_ORA1/NDCVDDS P','+DG_NDCCLU35_ORA1/NDCPVDDS','+DG_NDCCLU7R05_ORA2/NDCVDDSP','+DG_NDCCLU35_ORA 2/NDCPVDDS','+DG_NDCCLU7R05_ORA3/NDCVDDSP','+DG_NDCCLU35_ORA3/NDCPVDDS'
              *.max_dump_file_size='UNLIMITED'
              *.nls_date_format='yyyy-mm-dd hh24:mi:ss'
              *.open_cursors=400
              *.parallel_max_servers=0
              *.pga_aggregate_target=833617920
              *.processes=1500
              *.remote_listener='LISTENERS_NDCPVDDS'
              *.remote_login_passwordfile='EXCLUSIVE'
              *.sessions=1655
              *.sga_max_size=2013265920
              *.sga_target=2013265920
              *.sort_area_retained_size=2097152
              *.sort_area_size=2097152
              *.standby_archive_dest='+DG_NDCCLU35_ARCH/NDCPVDDS/standby_arch/'
              NDCPVDDS1.standby_archive_dest='+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/'
              NDCPVDDS4.standby_archive_dest='+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/'
              NDCPVDDS2.standby_archive_dest='+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/'
              NDCPVDDS3.standby_archive_dest='+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/'
              *.standby_file_management='AUTO'
              NDCPVDDS1.thread=1
              NDCPVDDS2.thread=2
              NDCPVDDS3.thread=3
              NDCPVDDS4.thread=4
              *.undo_management='AUTO'
              NDCPVDDS1.undo_tablespace='UNDOTBS1'
              NDCPVDDS2.undo_tablespace='UNDOTBS2'
              NDCPVDDS3.undo_tablespace='UNDOTBS3'
              NDCPVDDS4.undo_tablespace='UNDOTBS4'
              *.user_dump_dest='/opt/oracle/product/admin/NDCPVDDS/udump'


              This is the parameter file of the instance which is up:


              NDCPVDDS4.__db_cache_size=1157627904
              NDCPVDDS1.__db_cache_size=1224736768
              NDCPVDDS3.__db_cache_size=1258291200
              NDCPVDDS2.__db_cache_size=1442840576
              NDCPVDDS4.__java_pool_size=16777216
              NDCPVDDS1.__java_pool_size=16777216
              NDCPVDDS3.__java_pool_size=16777216
              NDCPVDDS2.__java_pool_size=16777216
              NDCPVDDS4.__large_pool_size=16777216
              NDCPVDDS1.__large_pool_size=16777216
              NDCPVDDS3.__large_pool_size=16777216
              NDCPVDDS2.__large_pool_size=16777216
              NDCPVDDS4.__shared_pool_size=805306368
              NDCPVDDS1.__shared_pool_size=738197504
              NDCPVDDS3.__shared_pool_size=704643072
              NDCPVDDS2.__shared_pool_size=520093696
              NDCPVDDS4.__streams_pool_size=0
              NDCPVDDS1.__streams_pool_size=0
              NDCPVDDS3.__streams_pool_size=0
              NDCPVDDS2.__streams_pool_size=0
              *.archive_lag_target=900
              *.audit_file_dest='/opt/oracle/product/admin/NDCPVDDS/adump'
              *.audit_trail='DB'
              *.background_dump_dest='/opt/oracle/product/admin/NDCPVDDS/bdump'
              *.cluster_database=true
              *.cluster_database_instances=4
              *.compatible='10.2.0.3.0'
              *.control_files='+DG_NDCCLU35_ORA1/ndcpvdds/control01.ctl','+DG_NDCCLU35_ORA2/nd cpvdds/control02.ctl','+DG_NDCCLU35_ORA3/ndcpvdds/control03.ctl'#Restore Control file
              *.core_dump_dest='/opt/oracle/product/admin/NDCPVDDS/cdump'
              *.cursor_sharing='FORCE'
              *.db_block_size=8192
              *.db_domain=''
              *.db_file_multiblock_read_count=16
              *.db_file_name_convert='+DG_PDCCLU17_ORA1/PDCVDDSP','+DG_NDCCLU35_ORA1/NDCPVDDS' ,'+DG_PDCCLU17_ORA2/PDCVDDSP','+DG_NDCCLU35_ORA2/NDCPVDDS','+DG_PDCCLU17_ORA3/PD CVDDSP','+DG_NDCCLU35_ORA3/NDCPVDDS','+DG_PDCCLU17_ORA4/PDCVDDSP','+DG_NDCCLU35_ ORA1/NDCPVDDS','+DG_PDCCLU17_ORA5/PDCVDDSP','+DG_NDCCLU35_ORA2/NDCPVDDS','+DG_PD CCLU17_ORA6/PDCVDDSP','+DG_NDCCLU35_ORA3/NDCPVDDS','+DG_NDCCLU7R05_ORA1/NDCVDDSP ','+DG_NDCCLU35_ORA1/NDCPVDDS','+DG_NDCCLU7R05_ORA2/NDCVDDSP','+DG_NDCCLU35_ORA2 /NDCPVDDS','+DG_NDCCLU7R05_ORA3/NDCVDDSP','+DG_NDCCLU35_ORA3/NDCPVDDS'
              *.db_name='PDCVDDSP'
              *.db_unique_name='NDCPVDDS'
              *.dg_broker_config_file1='+DG_NDCCLU35_ORA2/ndcpvdds/dr1ndcpvdds.dat'
              *.dg_broker_config_file2='+DG_NDCCLU35_ORA2/ndcpvdds/dr2ndcpvdds.dat'
              *.dg_broker_start=TRUE
              *.dispatchers='(PROTOCOL=TCP) (SERVICE=NDCPVDDSXDB)'
              *.fal_client='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ndcgrid36v ip)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ndcpvdds_XPT)(INSTANCE_NAME=NDCPVDDS 2)(SERVER=dedicated)))'
              *.fal_server='pdcvddsp1'
              NDCPVDDS1.instance_number=1
              NDCPVDDS2.instance_number=2
              NDCPVDDS3.instance_number=3
              NDCPVDDS4.instance_number=4
              *.job_queue_processes=10
              NDCPVDDS1.local_listener='LISTENER_NDCPVDDS1'
              NDCPVDDS2.local_listener='LISTENER_NDCPVDDS2'
              NDCPVDDS3.local_listener='LISTENER_NDCPVDDS3'
              NDCPVDDS4.local_listener='LISTENER_NDCPVDDS4'
              *.log_archive_config='dg_config=(PDCVDDSP)'
              *.log_archive_dest_1='location="+DG_NDCCLU35_ARCH/NDCPVDDS/arch", valid_for=(ONL INE_LOGFILES,ALL_ROLES)'
              *.log_archive_dest_2='SERVICE=NDCVDDSP LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRI MARY_ROLE) DB_UNIQUE_NAME=NDCVDDSP'
              *.log_archive_dest_3='service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP )(HOST=pdcgrid17vip)(PORT=1800)))(CONNECT_DATA=(SERVICE_NAME=pdcvddsp_XPT)(INSTA NCE_NAME=PDCVDDSP1)(SERVER=dedicated)))"',' LGWR ASYNC NOAFFIRM delay=0 OPTION AL max_failure=0 max_connections=1 reopen=300 db_unique_name="pdcvddsp" regist er net_timeout=180 valid_for=(online_logfiles,primary_role)'
              NDCPVDDS1.log_archive_dest_4='location="+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/ "',' valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)'
              NDCPVDDS4.log_archive_dest_4='location="+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/ "',' valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)'
              NDCPVDDS2.log_archive_dest_4='location="+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/ "',' valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)'
              NDCPVDDS3.log_archive_dest_4='location="+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/ "',' valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)'
              *.log_archive_dest_state_2='ENABLE'
              *.log_archive_dest_state_3='ENABLE'
              NDCPVDDS1.log_archive_dest_state_4='ENABLE'
              NDCPVDDS4.log_archive_dest_state_4='ENABLE'
              NDCPVDDS2.log_archive_dest_state_4='ENABLE'
              NDCPVDDS3.log_archive_dest_state_4='ENABLE'
              *.log_archive_format='PDCVDDSP_%t_%s_%r.arc'
              NDCPVDDS1.log_archive_format='PDCVDDSP_%t_%s_%r.arc'
              NDCPVDDS4.log_archive_format='PDCVDDSP_%t_%s_%r.arc'
              NDCPVDDS2.log_archive_format='PDCVDDSP_%t_%s_%r.arc'
              NDCPVDDS3.log_archive_format='PDCVDDSP_%t_%s_%r.arc'
              *.log_archive_max_processes=4
              *.log_archive_min_succeed_dest=1
              *.log_archive_trace=0
              NDCPVDDS1.log_archive_trace=0
              NDCPVDDS4.log_archive_trace=0
              NDCPVDDS2.log_archive_trace=0
              NDCPVDDS3.log_archive_trace=0
              *.log_file_name_convert='+DG_PDCCLU17_ORA1/PDCVDDSP','+DG_NDCCLU35_ORA1/NDCPVDDS ','+DG_PDCCLU17_ORA2/PDCVDDSP','+DG_NDCCLU35_ORA2/NDCPVDDS','+DG_PDCCLU17_ORA3/P DCVDDSP','+DG_NDCCLU35_ORA3/NDCPVDDS','+DG_PDCCLU17_ORA4/PDCVDDSP','+DG_NDCCLU35 ORA1/NDCPVDDS','+DGPDCCLU17_ORA5/PDCVDDSP','+DG_NDCCLU35_ORA2/NDCPVDDS','+DG_P DCCLU17_ORA6/PDCVDDSP','+DG_NDCCLU35_ORA3/NDCPVDDS','+DG_NDCCLU7R05_ORA1/NDCVDDS P','+DG_NDCCLU35_ORA1/NDCPVDDS','+DG_NDCCLU7R05_ORA2/NDCVDDSP','+DG_NDCCLU35_ORA 2/NDCPVDDS','+DG_NDCCLU7R05_ORA3/NDCVDDSP','+DG_NDCCLU35_ORA3/NDCPVDDS'
              *.max_dump_file_size='UNLIMITED'
              *.nls_date_format='yyyy-mm-dd hh24:mi:ss'
              *.open_cursors=400
              *.parallel_max_servers=0
              *.pga_aggregate_target=833617920
              *.processes=1500
              *.remote_listener='LISTENERS_NDCPVDDS'
              *.remote_login_passwordfile='EXCLUSIVE'
              *.sessions=1655
              *.sga_max_size=2013265920
              *.sga_target=2013265920
              *.sort_area_retained_size=2097152
              *.sort_area_size=2097152
              *.standby_archive_dest='+DG_NDCCLU35_ARCH/NDCPVDDS/standby_arch/'
              NDCPVDDS1.standby_archive_dest='+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/'
              NDCPVDDS4.standby_archive_dest='+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/'
              NDCPVDDS2.standby_archive_dest='+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/'
              NDCPVDDS3.standby_archive_dest='+DG_NDCCLU35_ARCH/ndcpvdds/standby_arch/'
              *.standby_file_management='AUTO'
              NDCPVDDS1.thread=1
              NDCPVDDS2.thread=2
              NDCPVDDS3.thread=3
              NDCPVDDS4.thread=4
              *.undo_management='AUTO'
              NDCPVDDS1.undo_tablespace='UNDOTBS1'
              NDCPVDDS2.undo_tablespace='UNDOTBS2'
              NDCPVDDS3.undo_tablespace='UNDOTBS3'
              NDCPVDDS4.undo_tablespace='UNDOTBS4'
              *.user_dump_dest='/opt/oracle/product/admin/NDCPVDDS/udump'

              Parameters seems identical to me. Please correct me if I am wrong.

              Thanks.
              • 4. Re: Two instances are down on four node physical standby.
                mseberg
                You are correct. They match.

                I'm thinking you might have an spfile that is not accounted for.

                An ALTER SYSTEM command could cause this too.

                Best Regards

                mseberg
                • 5. Re: Two instances are down on four node physical standby.
                  954124
                  Sorry but I didnt get you. Can you please elaborate what should I do next?

                  Thanks a lot!!!
                  • 6. Re: Two instances are down on four node physical standby.
                    mseberg
                    OK.

                    I'm thinking your system has an SPFILE for each instance. So if an ALTER SYSTEM was performed on one instance and not the others it could cause this error.

                    Or if somehow an instance or two is using a different SPFILE than you expect. A rogue SFILE so to speak, that could also cause the error.

                    Does that make sense?

                    Since you are using Broker ( which will change an SPFILE ) I wonder if there's a conflict between the broker parameters and the spfile(s)?

                    Best Regards

                    mseberg

                    Edited by: mseberg on Sep 25, 2012 11:38 AM
                    • 7. Re: Two instances are down on four node physical standby.
                      954124
                      Thanks for your!

                      Yes its making sense now. And you are correct each instance has different spfile.

                      So should I convert all instances pfile to spfile one by one n than try to bring it on. I think this way it will make all instances parameter files in sync.
                      • 8. Re: Two instances are down on four node physical standby.
                        mseberg
                        Hello again;
                        So should I convert all instances pfile to spfile one by one n than try to bring it on?
                        Yes!

                        Best Regards

                        mseberg
                        • 9. Re: Two instances are down on four node physical standby.
                          954124
                          Thanks a lot for your help. Appreciate It!!:)