3 Replies Latest reply: Apr 11, 2012 6:20 AM by Adil Rathore RSS

    Getting Error while updating Patch Repository

    Shoumo NameToUpdate

      The following error "Patch Source channel update failed. Reason : ORA-01775: looping chain of synonyms for WindowsPatchSource"

      while updating Patch Repository.

        • 1. Getting Error while updating Patch Repository
          Adil Rathore

          Has the patch management schema been installed on the database server?

          • 2. Getting Error while updating Patch Repository
            Shoumo NameToUpdate

            While installing that I am getting 82 alerts.

            like

             

            installation/oracle/uninstall_patch_schema.sql line: 148

            DROP TABLESPACE patch_data INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS

            ORA-00959: tablespace 'PATCH_DATA' does not exist

             

            installation/oracle/uninstall_patch_schema.sql line: 150

            DROP TABLESPACE patch_index INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS

            ORA-00959: tablespace 'PATCH_INDEX' does not exist

             

            installation/oracle/create_patch_tablespace.sql line: 13

            CREATE TABLESPACE patch_data DATAFILE '$(MRBA_patch_data_path)' SIZE $(MRBA_patch_data_size) REUSE AUTOEXTEND ON NEXT $(MRBA_patch_data_next) MAXSIZE $(MRBA_patch_data_maxsize) EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO

            ORA-00210: cannot open the specified control file ORA-00202: control file: '/backup/oracle/recovery_area/bmc/control02.ctl' ORA-27041: unable to open file SVR4 Error: 2: No such file or directory Additional information: 3

             

            installation/oracle/create_patch_tablespace.sql line: 20

            CREATE TABLESPACE patch_index DATAFILE '$(MRBA_patch_index_path)' SIZE $(MRBA_patch_index_size) REUSE AUTOEXTEND ON NEXT $(MRBA_patch_index_next) MAXSIZE $(MRBA_patch_index_maxsize) EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO

            ORA-00210: cannot open the specified control file ORA-00202: control file: '/backup/oracle/recovery_area/bmc/control02.ctl' ORA-27041: unable to open file SVR4 Error: 2: No such file or directory Additional information: 3

            • 3. Getting Error while updating Patch Repository
              Adil Rathore

              The script is not able to create tablespaces and indexes for patch management related tables. So, you need to fix the database issue first and then use the Windows Patch Repository.