dbTalk Databases Forums  

HP IT/Operations and Oracle user grant issue

comp.database.oracle comp.database.oracle


Discuss HP IT/Operations and Oracle user grant issue in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vince Laurent
 
Posts: n/a

Default HP IT/Operations and Oracle user grant issue - 04-07-2005 , 12:52 PM






I am running Oracle 9.2.0.4 on HP-UX 11i. We are also trying to use
the HP Product IT/Operations. This one monitor we are having issues
with didn't have issues before I moved the database to locally managed
tablespaces.

Here is the command and the result (I had to hit CTRL+C to end it):

# ./dbspicao -v -c SSM2-DBSPI-Ora-15min -t SSM- -m 16

Instance: 'DEV' @ '/oracle/DEV/920_64'
-------------------------------------------------------------
04/07/05 12:03:06 WARNING dbspicao(20971) DEV
[metric0016:metric0016.pc:1379]:
DBSPI40-22: Error [ORA-01013: user requested cancel of current
operation] occurred executing dbms_space_admin - to fix as SYS do
'grant execute on sys.dbms_space_admin to <dbspiuser>'.

Well, I did grant the right but it still fails. Anyone have an idea?
Thanks
Vince
p.s. We did send this issue to HP but I'd figure I'd ask here
anyway...
-----------------------------------------------------
Come race with us!
http://www.mgpmrc.org

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.