SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
ORA-01031 Error

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
ORA-01031 Error
Author Message
Guest






Post ORA-01031 Error Reply with quote

Hi,

I am auditing an Oracle 9i database.

When I click on Tools-Schedule Periodic Archiving, I get the error:
"Database not available. ORA-01031: insufficient privileges"

I am logged on as 'sys' and my JOB_QUEUE_PROCESSES parameter is 4.
The DB_AUDIT user has select privileges on DBA_JOBS, as well as
execute privileges on DBMS_JOB

Please help.

Thanks,
Liana

Sun Nov 26, 2006 3:38 pm
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: ORA-01031 Error Reply with quote

Did you execute the script that the GUI copied to the clipboard while installing this feature? That script grants DB_AUDIT several privileges required for the processing including EXEC on several SYS.DBMS_xxx packages

: Hi,

: I am auditing an Oracle 9i database.

: When I click on Tools-Schedule Periodic Archiving, I get the error:
: "Database not available. ORA-01031: insufficient privileges"

: I am logged on as 'sys' and my JOB_QUEUE_PROCESSES parameter is 4.
: The DB_AUDIT user has select privileges on DBA_JOBS, as well as
: execute privileges on DBMS_JOB

: Please help.

: Thanks,
: Liana

Sun Nov 26, 2006 4:14 pm View user's profile Send private message
Guest






Post Re: ORA-01031 Error Reply with quote

: Did you execute the script that the GUI copied to the clipboard while
: installing this feature? That script grants DB_AUDIT several privileges
: required for the processing including EXEC on several SYS.DBMS_xxx
: packages

Hi,

Could you send me the script?
I can't remember getting a prompt to execute any script that the GUI copied to
the clipboard.

Thanks,
Liana

Mon Nov 27, 2006 4:50 pm
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: ORA-01031 Error Reply with quote

To avoid reinstalling things, try granting SESSION and RESOURCE privileges to DB_AUDIT user. I think this will fix the problem.

: Hi,

: Could you send me the script?
: I can't remember getting a prompt to execute any script that the GUI copied
: to
: the clipboard.

: Thanks,
: Liana

Mon Nov 27, 2006 5:04 pm View user's profile Send private message
Guest






Post Re: ORA-01031 Error Reply with quote

: To avoid reinstalling things, try granting SESSION and RESOURCE privileges to
: DB_AUDIT user. I think this will fix the problem.

Hi,
I executed the following commands:

grant resource to "DB_AUDIT";
grant create session to "DB_AUDIT";

However, I still get the error.

Liana

Tue Nov 28, 2006 12:30 pm
Guest






Post Re: ORA-01031 Error Reply with quote

Hi again,

Concerning the ORA_01031 error I get when trying to schedule periodic auditing,
do you have any further suggestions I can try since nothing seems to work?

Thanks,
Liana

: Hi,
: I executed the following commands: grant resource to "DB_AUDIT";
: grant create session to "DB_AUDIT";

: However, I still get the error.

: Liana

Fri Dec 01, 2006 10:43 am
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.