Migrate the database from 8.1.6 to 8.1.7

Printable View

11-30-2001, 09:41 PM
mike73

I have two Oracle Home on the same box, Oracle 8.1.6 and Oracle 8.1.7 , I have 6 database running on this box and need to be migrated to 8.1.7. Four of them migrate successful and I have the problem with two databases.
here is the message:

The following database options were detected were not upgraded. Refer to migration documentation for details to upgrade them to a newer version. Advanced Replication.

I don't know why I got this message, b/c four of them work fine, the only thing I could see different is the two databases had problems is the two with Services STARTING on status instead of STARTED like tyhe other four.

Please give me some explationation, and how to work around to upgrade these two.

Thanks
11-30-2001, 11:11 PM
marist89

Quote:

Originally posted by mike73

The following database options were detected were not upgraded. Refer to migration documentation for details to upgrade them to a newer version. Advanced Replication.

This usually means you have to run catrep.sql AFTER odma completes...
12-01-2001, 01:14 AM
mike73

Jeff,

thanks for your help as always,

Does it mean that the database already upgrade to 8.1.7 Even the message tell me the database is not upgraded ??? and I just need to to run catrap.sql to finish the migration ???
It's really weird b/c the message said the database is not upgraded but when I look into the V$version and I had the new version 8.1.7.2.1 which I don't understand it seem like it migrated to the new version ok but give me that message. Please explain to me what's going on, Jeff.

Thanks

[Edited by mike73 on 12-01-2001 at 12:45 AM]
12-01-2001, 09:10 AM
marist89

The core database has been upgraded to 8.1.7.2.1. You now have to upgrade any additional options that you have installed. Once your additional options have been upgraded, your db migration is now "complete". Actually, your db is upgraded now, your replication just might not work.
12-01-2001, 10:05 AM
mike73

Hi Jeff,

After I ran the catrep.sql this morning, I had about 27 package body owned by SYS are not valid. I ran the utlrp.sql but still not compile those objects.

What do I need to do to compile those objects for SYS???

Thanks
12-03-2001, 10:22 AM
mike73

Does Jeff or anyone in here have any advise ???

Thanks
12-03-2001, 03:43 PM
mike73

I am still waiting for advise!!!!
12-03-2001, 03:44 PM
marist89

compile them.
12-03-2001, 03:51 PM
sambavan

Quote:

Originally posted by marist89
compile them.

:D

Sam
12-03-2001, 03:52 PM
maachan

Which objects remained invalid after running utlrp.sql?
12-03-2001, 03:58 PM
marist89

Use http://home.adelphia.net/~marist89/s...ow_invalid.htm to find which objects are still invalid. Then,

Code:

ALTER PACKAGE owner.package_name COMPILE BODY;
12-03-2001, 05:30 PM
mike73

Jeff,

Compile those objects is not the solution for it. I did try to compile them before I ask you, but it's still INVALID so that I ask you if we have to run any other scripts to compile them, here are some of the invalid objects.

DBMSOBJG
DBMSOBJG2
DBMSOBJGWRAPPER
DBMS_DEFER
DBMS_DEFER_QUERY_UTL
DBMS_DEFER_SYS
DBMS_DEFER_SYS_PART1
DBMS_IAS_INST_UTL
DBMS_IAS_MT_INST
DBMS_INTERNAL_REPCAT
DBMS_OFFLINE_RGT
DBMS_OFFLINE_SNAPSHOT

it had about 30 of them

Thanks
12-04-2001, 10:59 AM
mike73

I am still waiting for response. Please help !!!
12-04-2001, 03:50 PM
sambavan

Looks like the migration did not go through properly!!! What did you use to migrate the database? Looking at the scenario, I would suggest that you run the utl080106.sql script to first migrate the database and then run the catlog, catproc catrep and other necessary scripts.

Before doing any of these, have a good backup.

Sam
12-04-2001, 04:00 PM
mike73

Sam,

thanks for your reply, this objects happened after I ran the catrep.sql. Before I ran this, everything was fine. Even those object are invalid but the database still running ok with no problem, how could I tell or check to see if there are problem with my database ??? I used the migration utilities from Oracle to migrate the database

Any idea ???

thanks
12-04-2001, 04:38 PM
sambavan

To better undestand things, could you tell the scripts that you ran and the order in whcih you ran them.

Sam
12-04-2001, 05:08 PM
mike73

Sam,

if you could please refer back to my original post on this thread, basically, I migrate the database to 8.1.7 and I have some weird message, but all of my objects still fine and valid that time, so Jeff advise me to run the catrep.sql and I ran it, after I ran it I found there are INVALID objects owneed by SYS

thanks
12-04-2001, 05:37 PM
sambavan

Quote:

Originally posted by mike73

Does it mean that the database already upgrade to 8.1.7 Even the message tell me the database is not upgraded ??? and I just need to to run catrap.sql to finish the migration ???
It's really weird b/c the message said the database is not upgraded but when I look into the V$version and I had the new version 8.1.7.2.1 which I don't understand it seem like it migrated to the new version ok but give me that message. Please explain to me what's going on, Jeff.

Fill me in...

1. How did you go up to 8.1.7.2.1?

a) Direct
b) First to 8.1.7 and then the patch

2. On the case of option 1.b did you disable the system triggers at the time of running the scripts ( i.e did you follow the readme for the patch )

More questiones, but no solutions :)

Sam
12-04-2001, 05:38 PM
marist89

Quote:

Originally posted by mike73

DBMSOBJG
DBMSOBJG2
DBMSOBJGWRAPPER
DBMS_DEFER
DBMS_DEFER_QUERY_UTL
DBMS_DEFER_SYS
DBMS_DEFER_SYS_PART1
DBMS_IAS_INST_UTL
DBMS_IAS_MT_INST
DBMS_INTERNAL_REPCAT
DBMS_OFFLINE_RGT
DBMS_OFFLINE_SNAPSHOT

These objects are created by catrep.sql. Are you sure you had replication installed?
12-04-2001, 05:44 PM
sambavan

Quote:

Originally posted by marist89

Quote:

Originally posted by mike73

DBMSOBJG
DBMSOBJG2
DBMSOBJGWRAPPER
DBMS_DEFER
DBMS_DEFER_QUERY_UTL
DBMS_DEFER_SYS
DBMS_DEFER_SYS_PART1
DBMS_IAS_INST_UTL
DBMS_IAS_MT_INST
DBMS_INTERNAL_REPCAT
DBMS_OFFLINE_RGT
DBMS_OFFLINE_SNAPSHOT

These objects are created by catrep.sql. Are you sure you had replication installed?

Good point!!!

Sam
12-05-2001, 10:29 AM
mike73

Jeff and Sam,

thanks so much for all of your help and advise.

Here is what happened, after I did migration from 816 to 817 I got this message.

"The following database options were detected were not upgraded. Refer to migration documentation for details to upgrade them to a newer version. Advanced Replication. "

I am not sure if my migration went well or not so I posted the message in here (refer to the beginning of this thread), Jeff think that the upgrade 817 was successful;however, I need to run the catrep.sql since I got that message. After I ran the catrep.sql, Those objects become invalid.

I have some questions and I need some advise:
1. I look at V$version and it said 8.1.7.2.1,
2. How do I know if my migration went well, if it is what do I need to check for replication per Jeff's advise ??? How do I fix this problem

thanks
12-06-2001, 12:26 PM
mike73

Sam and Jeff,

Do you have any advise on my problem ???

Thanks
12-06-2001, 12:42 PM
marist89

Check v$option to see if replication was installed. Of course, since you ran catrep.sql, it will probably show up as true. My only suggestion would be to re-run catalog, catproc, and catrep (as internal or sys) and see if everything compiles. If not, log a TAR with oracle.