OraFAQ Forum: Server Administration » Invalid registry$sys_inv_objs; PRODUCT_USER

Home » RDBMS Server » Server Administration » Invalid registry$sys_inv_objs; PRODUCT_USER_PROFILE (11.2.0.1 redhat 7.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Invalid registry$sys_inv_objs; PRODUCT_USER_PROFILE [message #646931]

Thu, 14 January 2016 21:19

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Dear all,

I was running preupgrade from 11.2.0.1 to 11.2.0.4

I encountered the following

SELECT * FROM registry$sys_inv_objs;

OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
SYS
PRODUCT_USER_PROFILE
SYNONYM

May I know how to resolve this error?

I've read Complete Checklist for Manual Upgrades to 11gR2 (Doc ID 837570.1), but don't seem to find any clue to how to resolve this error?

many thanks in advance!

Report message to a moderator

Re: Invalid registry$sys_inv_objs; PRODUCT_USER_PROFILE [message #646932 is a reply to message #646931]

Thu, 14 January 2016 21:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

  1* select owner, object_type from dba_objects where object_name = 'PRODUCT_USER_PROFILE'
SQL> /

OWNER                          OBJECT_TYPE
------------------------------ -------------------
PUBLIC                         SYNONYM
SYSTEM                         SYNONYM

how did yours get owned by SYS?

Report message to a moderator

Re: Invalid registry$sys_inv_objs; PRODUCT_USER_PROFILE [message #646939 is a reply to message #646932]

Fri, 15 January 2016 01:44

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

I don't know I'm not the one that installed the db?

so what should I do to resolve this error?

thanks

Report message to a moderator

Re: Invalid registry$sys_inv_objs; PRODUCT_USER_PROFILE [message #646941 is a reply to message #646939]

Fri, 15 January 2016 02:11

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

conn / as sysdba
DROP VIEW PRODUCT_PRIVS;
DROP TABLE SQLPLUS_PRODUCT_PROFILE;
DROP TABLE PRODUCT_USER_PROFILE;
DROP TABLE PRODUCT_PROFILE;
DROP SYNONYM PRODUCT_USER_PROFILE;
conn system
@?/sqlplus/admin/pupbld

Ignore the possible errors on DROP.

Report message to a moderator

Re: Invalid registry$sys_inv_objs; PRODUCT_USER_PROFILE [message #646942 is a reply to message #646939]

Fri, 15 January 2016 02:12

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Drop them. You can recreate anytime by running $OH/sqlplus/admin/pupbsd.sql If you look at the srcipt, you'll see how it should have bee created.

Report message to a moderator

Previous Topic:	default optimizer_mode
Next Topic:	Estimator tool that converts oracle data types to disk storage required

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 12:07:47 CST 2025