DB error [message #323362] |
Wed, 28 May 2008 05:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #323905 is a reply to message #323840] |
Fri, 30 May 2008 00:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #323934 is a reply to message #323928] |
Fri, 30 May 2008 01:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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.
|
|
|