HP IT/Operations and Oracle user grant issue

From: Vince Laurent <vincelaurent_at_REMOVETHISsbcglobal.net>
Date: Thu, 07 Apr 2005 17:52:46 GMT
Message-ID: <snsa511m4ji9s2goj5hghm15ljo94nbl0n@4ax.com>

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 Received on Thu Apr 07 2005 - 12:52:46 CDT