No question at this time
DBA Top 10
1 M. Cadot 6500
2 B. Vroman 2700
3 J. PĂ©ran 1600
4 P. Tsongayinwe 1500
5 P. Wisse 1200
6 A. Kavsek 1100
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48695
Total active users1320
Act. users last 24h0
Act. users last hour0
Registered user hits last week12
Registered user hits last month347
Go up

Unable to switch logfile
Next thread: ASM for RAC
Prev thread: Doubt related to join

Message Score Author Date
Hi All, I am unable to switch logfile from sys ...... Nabi Abdul Jan 18, 2014, 16:15
<b><i>Note: Database Vault is configured.</i></b...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Michel Cadot Jan 18, 2014, 18:31
Michel, can we know more on how sys is restri...... Ramesh Kumar Jan 20, 2014, 14:21
This is explained in details in Database Vault d...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Michel Cadot Jan 20, 2014, 14:23

Follow up by mail Click here


Subject: Unable to switch logfile
Author: Nabi Abdul, India
Date: Jan 18, 2014, 16:15, 3181 days ago
Os info: Linux
Oracle info: 11.2.0.2
Error info: ORA-01031: insufficient privileges
Message: Hi All,

I am unable to switch logfile from sys but from sytem. While trying to switch logfile from sys getting the below error.

sqlplus '/as sysdba'
SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-01031: insufficient privileges

Could not find the cause of the issue. Please help on this.
Note: Database Vault is configured.

Thanks,
Nabi
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Unable to switch logfile
Author: Michel Cadot, France
Date: Jan 18, 2014, 18:31, 3181 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message:
Note: Database Vault is configured.

This is not a note this is a the main point.
SYSDBA can't do this, this is a key point of database vault: separation of duties.

Note: you should not do it with SYS in normal database.

Regards
Michel

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Unable to switch logfile
Author: Ramesh Kumar, India
Date: Jan 20, 2014, 14:21, 3179 days ago
Message: Michel,

can we know more on how sys is restrict here.

Regards
Ramesh.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Unable to switch logfile
Author: Michel Cadot, France
Date: Jan 20, 2014, 14:23, 3179 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message:
This is explained in details in Database Vault documentation.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here