DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: comp_name INVALID after migration

  1. #1
    Join Date
    Jun 2006
    Posts
    31

    comp_name INVALID after migration

    Hello all,

    I have the next problem,

    I migrated my 8.1.7 db to 9.2.0.7. Now I execute:
    select comp_name, version, status from dba_registry;
    COMP_NAME STATUS VERSION
    ----------------------------------- ----------- ----------
    Oracle9i Catalog Views INVALID 9.2.0.7.0
    Oracle9i Packages and Types INVALID 9.2.0.7.0


    I executed catalog.sql, catproc, catpatch.sql and i obtain the same.
    What can i to do? Restore the last 8.1.7 and re-migrate, execute other script? ??


    When I execute catpatch i recive this error:
    ...skipping...
    *
    ERROR en linea 1:
    ORA-00604: error producido a nivel 1 de SQL recursivo
    ORA-00904: "CHARSETFORM": identificador no vM-alido

    Thanks in advanced
    Last edited by rnavarrc; 06-13-2007 at 07:00 AM.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I wonder how did you do the upgrade? What tools?

  3. #3
    Join Date
    Jun 2006
    Posts
    31
    I upgraded it manually.

    I obtain the information from metalink note 159657.1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width