-
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
-
Sam and Jeff,
Do you have any advise on my problem ???
Thanks
-
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.