Very very urgent - many invalid objects when upgraded from 9.2.0.1

Hi,


I have upgraded from Oracle 9.2.0.1 to 9.2.0.2 by applying the patchset
2632931. I tried to execute streams and it says DBMS_STREAMS_ADM_UTL,
DBMS_LOGMNR_D are invalid. I tried to recompile them but all in vain, they
dont get recompiled. When I executed the query "select
object_name,object_type from dba_objects where status='INVALID' and
owner='SYS';" it gives me a list of invalid objects. Please give me a
solution as its very urgent.

Thanks a lot in advance.
truptipanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

speedkickCommented:
Have you been able to run the @/rdbms/admin/utlrp.sql script ?

This will rebuild all the invalid packages after installing a patch.

Hope this helps

Phil
0
truptipanAuthor Commented:
Hi,
well the problem persisted so i upgraded from 9.2.0.1 to 9.2.0.4
After applying the patch the  packages were compiled.
After that i tried running the script for generation of streams.
Upon executing the package
DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
    privilege    => DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ,
    grantee     => 'STRMADMIN',
    grant_option  => TRUE);

i get the error ORA-03113: end-of-file on communication channel
and most of the packages in the sys user get uncompiled.

Is there a way out. ??
Trupti
0
sudhi022299Commented:
Trupti,

I remember seeing this with grant_system_privilege when running catpatch.sql after upgrading to 9202. The problem was with the mismatch of the env variables with that of the oradim settings. The steps followed was :

-  Shutdown normal the database
-  Set the Oracle related environment variables point to 9.2.0.2.
-  Delete and recreate the service using ORADIM
-  Startup the migration process using Startup Migrate

Thanks,
Sudhi.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Helena Markováprogrammer-analystCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept sudhi's comment as answer.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Henka
EE Cleanup Volunteer
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.