View Full Version : HP IT/Operations and Oracle user grant issue
Vince Laurent
04-07-2005, 09:52 AM
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
MyLounge.com Site Map
Forum:
Cars,
Cell Phone,
Database,
Games,
Home Improvement,
IT,
Music,
School,
Sports,
Web Design,
Web Server,
Weight Loss
The MyLounge.com forum is intended for informational use only and should not
be relied upon and is not a substitute for any advice. The information contained
on MyLounge.com are opinions and suggestions of members and is not a representation
of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for
the accuracy, completeness or usefulness of any postings or the qualifications
of any person responding. Please consult a expert or seek the services of an
attorney in your area for more accuracy on your specific situation. Please note
that our forums also serve as mirrors to Usenet newsgroups. Many posts you see
on our forums are made by newsgroup users who may not be members of MyLounge.com
Term of Service
vBulletin v3.0.7, Copyright ©2000-2009, Jelsoft Enterprises Ltd.