Ora-06553: Pls-707

[Arda]

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

[sambavan]

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

[Arda]

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.

[Arda]

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.

[Arda]

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

Thanks.

[adewri]

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.

[SANJAY_G]

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.

[Arda]

Thank you all for your advice.

I'll definitely go with EXPORT/IMPORT.

Regards.