Ora-06553: Pls-707
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Ora-06553: Pls-707

  1. #1
    Join Date
    Feb 2002
    Posts
    41

    Question Ora-06553: Pls-707

    Hi fellows.
    I'v performed a "cold cloning" from NT 8.0.5 to Linux 8.1.7.
    Everything went off well, but every time I connect using sqlplus I get the following error:

    ----------
    ERROR:
    ORA-06553: PLS-707: unsupported construct or internal error [2603]

    Error accessing package DBMS_APPLICATION_INFO
    ERROR:
    ORA-06553: PLS-707: unsupported construct or internal error [2603]
    ----------

    It then connects normally.
    Second error seems to be a missing package, whereas I don't know the reason for the first one.

    I've already executed standard.sql as SYS, but am getting the same error.

    What should I do??
    Would it be better to do a full Export and Import instead of a "cold cloning".... ??
    TIA

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You are trying to reap orange from an apple tree? You first neet to perform the migration and then do the cloning. Or just perform the logical move.

    One try I would first give on the clone would be that of running the u0800050.SQL and see. You must run it as INTERNAL or SYS user.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Feb 2002
    Posts
    41

    Unhappy

    Oh My.. This is Bad news....
    As this was only a test for the real migration.

    I'm about to migrate a production database from Solaris to Linux, Solaris is using 8.0.5 and Linux 8.1.7. For what I've read from Sam, it is crystal clear that the procedure I've chosen is wrong.

    Where can I get information about either of the methods you suggested:

    a) migration and then do the cloning.
    b) perform the logical move.


    Anyhow, I'll execute u0800050.SQL and see what happens.

    Thanks in Advance and Best Regards.

  4. #4
    Join Date
    Feb 2002
    Posts
    41

    Post

    Sam..
    u0800050.SQL worked !!! I see no more errors.

    Can I say the databse is now "correct"??

    Shall I do the same to migrate from Solaris, or should I better istall 8.0.5 instead??

    Many Thanks.

  5. #5
    Join Date
    Feb 2002
    Posts
    41

    Question

    Sam.
    I managed to get 805ship_tar.gz
    Shall I go with this and perform a "cold cloning" as I first did?

    Thanks.

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Two things are involved here, migrating from one platform to another and migrating the database from 8.0.5 to 8.1.7

    o For migrating the database across platform use export/import.
    o For migration the database from Oracle8 to Oracle 8i use the migration script u0800050.sql (manually) or use the ODMA.

    First way.

    o Install Oracle8i on Solaris Box and do the migration of database.
    o Here you can use ODMA or the upgrade script.
    o Then Install Oracle8i on Linux Box and perform export/import from Solaris to Linux.

    Second Way.

    o Install Oracle8i on Linux Box.
    o Export from Solaris Oracle8 using Oracle8 exp utility and import directly into Linux Oracle8i using Oracle8i imp utility.
    o Here you dont need the upgrade script or ODMA as the database is being imported directly into Oracle8i.

    I would go for the second one.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    I doubt moving database from WinNT to Linux using coldbackup will work, *unless* you have put all files on FAT filesystem in NT and in Linux also you are putting those files on FAT filesystem.
    The only method Oracle recoomends for cross-platform migration is EXPORT/IMPORT.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  8. #8
    Join Date
    Feb 2002
    Posts
    41

    Thumbs up

    Thank you all for your advice.

    I'll definitely go with EXPORT/IMPORT.

    Regards.

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