Home » RDBMS Server » Server Administration » Invalid registry$sys_inv_objs; PRODUCT_USER_PROFILE (11.2.0.1 redhat 7.1)
Invalid registry$sys_inv_objs; PRODUCT_USER_PROFILE [message #646931] Thu, 14 January 2016 21:19 Go to next message
juniordbanewbie
Messages: 201
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!
Re: Invalid registry$sys_inv_objs; PRODUCT_USER_PROFILE [message #646932 is a reply to message #646931] Thu, 14 January 2016 21:42 Go to previous messageGo to next message
BlackSwan
Messages: 25856
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?
Re: Invalid registry$sys_inv_objs; PRODUCT_USER_PROFILE [message #646939 is a reply to message #646932] Fri, 15 January 2016 01:44 Go to previous messageGo to next message
juniordbanewbie
Messages: 201
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
Re: Invalid registry$sys_inv_objs; PRODUCT_USER_PROFILE [message #646941 is a reply to message #646939] Fri, 15 January 2016 02:11 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
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.
Re: Invalid registry$sys_inv_objs; PRODUCT_USER_PROFILE [message #646942 is a reply to message #646939] Fri, 15 January 2016 02:12 Go to previous message
John Watson
Messages: 7262
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.
Previous Topic: default optimizer_mode
Next Topic: Estimator tool that converts oracle data types to disk storage required
Goto Forum:
  


Current Time: Thu Feb 22 07:32:33 CST 2018

Total time taken to generate the page: 0.02743 seconds