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.