Home » RDBMS Server » Server Administration » DB error (10.2.0.3)
DB error [message #323362] Wed, 28 May 2008 05:29 Go to next message
appukambha
Messages: 12
Registered: May 2008
Junior Member
We are facing the following error when we start the our application:



ERROR at line 1:

ORA-06564: object SYS.DBMS_REGISTRY does not exist

ORA-06512: at "SYS.DBMS_UTILITY", line 114

ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45

ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53

ORA-06512: at line 13



I have analysed and found that this issue is due to permission not granted to the user on the object DBMS_REGISTRY.

But when I grant permission to the user on this object (DBMS_REGISTRY), we are getting the same error on another object.



ERROR at line 1:

ORA-06564: object SYS.DBMS_REGISTRY_SERVER does not exist

ORA-06512: at "SYS.DBMS_UTILITY", line 114

ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45

ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53

ORA-06512: at line 13



Could you please help us on this and provide us with an optimal solution .

Please reply


Thank you

Re: DB error [message #323840 is a reply to message #323362] Thu, 29 May 2008 12:50 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
hi,

what are grants user has now?
Re: DB error [message #323905 is a reply to message #323840] Fri, 30 May 2008 00:31 Go to previous messageGo to next message
appukambha
Messages: 12
Registered: May 2008
Junior Member


It has EXECUTE_CATALOG_ROLE granted to it.In adition to this it has select and delete_catalog_role ,DBA,RESOURCE,CONNECT .


Please reply.
Re: DB error [message #323907 is a reply to message #323905] Fri, 30 May 2008 00:38 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member

try recompling the database objects with @?/rdbms/admin/utlrp

you have given enough privs to the user to be able to execute those functiions. Did you revoke anything from public role?
Re: DB error [message #323915 is a reply to message #323907] Fri, 30 May 2008 00:55 Go to previous messageGo to next message
appukambha
Messages: 12
Registered: May 2008
Junior Member
Thanks for prompt reply...

Will der be any side effects of running @?/rdbms/admin/utlrp again.

I didnt revoke any public roles....
Re: DB error [message #323918 is a reply to message #323915] Fri, 30 May 2008 00:58 Go to previous messageGo to next message
appukambha
Messages: 12
Registered: May 2008
Junior Member


Please check this

select * from dba_role_privs where GRANTEE='FM';

GRANTEE GRANTED_ROLE ADM DEF
-------------------------- ------------------------------ --- ---
FM EXECUTE_CATALOG_ROLE NO YES
FM DELETE_CATALOG_ROLE NO YES
FM IMP_FULL_DATABASE NO YES
FM DBA NO YES
FM CONNECT NO YES
FM SELECT_CATALOG_ROLE NO YES
FM RESOURCE NO YES
FM EXP_FULL_DATABASE NO YES

Re: DB error [message #323921 is a reply to message #323915] Fri, 30 May 2008 01:08 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
there are no side effects of runing the utlrp script. it will compile the invalid objects and if an object doesn't compile that means it need additional work to make it compile and run.
Re: DB error [message #323928 is a reply to message #323918] Fri, 30 May 2008 01:20 Go to previous messageGo to next message
appukambha
Messages: 12
Registered: May 2008
Junior Member


But I ve a doubt....

When I give permission on one object I am not getting error on that again....I am getting error on other object....

Here is the list of objects on which I have granted permission so far manually:



DBMS_REGISTRY

DBMS_REGISTRY_SERVER

XML_SCHEMA_NAME_PRESENT

SYS_STUB_FOR_PURITY_ANALYSIS

UTL_SYS_COMPRESS

DBMS_SPACE_ADMIN

DBMS_TRANSACTION_INTERNAL_SYS

DBMS_INTERNAL_LOGSTDBY




please comment...
Re: DB error [message #323929 is a reply to message #323928] Fri, 30 May 2008 01:23 Go to previous messageGo to next message
appukambha
Messages: 12
Registered: May 2008
Junior Member


I found that these object's STATUS is VALID......
Do u suggest even then that I ve to run tht script...
Re: DB error [message #323934 is a reply to message #323928] Fri, 30 May 2008 01:38 Go to previous message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
as far as i know you don't have to explicitly grant permission to those objects. with the role grants you should be able to run without any issue. you can run the utlrp even if the status is valid would cause no harm, they will get compiled to valid status again.
Previous Topic: Problem in applying CPU patch of April 2007
Next Topic: Exchange Partition dude
Goto Forum:
  


Current Time: Thu Dec 08 14:19:13 CST 2016

Total time taken to generate the page: 0.11995 seconds