No question at this time
DBA Top 10
1 B. Vroman 15700
2 M. Cadot 10200
3 T. Boles 8350
4 J. Schnackenberg 8300
5 A. Kavsek 7800
6 M. Hidayathullah ... 2500
7 P. Wisse 1200
8 G. Lambregts 1100
9 T. P 1000
10 B. Derous 500
10 R. Pattyn 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48277
Total active users1612
Act. users last 24h4
Act. users last hour0
Registered user hits last week185
Registered user hits last month836
Go up

Ora-01031 Insufficient Privileges
Next thread: Oracle11g (11.2.0.4) RAC on Standard Edition 11.2.0.4
Prev thread: IMPDP excluding table

Message Score Author Date
The password of system expired I want to login as ...... Ahmed Quradi May 29, 2018, 12:20
Hello, make sure your personal user is in the O...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Matej Pagac May 29, 2018, 12:30
What are the contents of your %ORACLE_%HOME\networ...... Gareth Graham May 31, 2018, 15:30
open command line and use sqlplus "/ as sysdba"...... javed akhtar Jun 01, 2018, 13:26
When he tries that he gets "Ora-01031 Insufficient...... Gareth Graham Jun 01, 2018, 13:31
hello Gareth, he told that system password is e...... javed akhtar Jun 01, 2018, 13:33
<i>"I want to login as sysdba to reenter the passw...... Gareth Graham Jun 01, 2018, 13:35
Hello Graham, thanks for remind me. yes you ...... javed akhtar Jun 01, 2018, 13:37

Follow up by mail Click here


Subject: Ora-01031 Insufficient Privileges
Author: Ahmed Quradi, Yemen
Date: May 29, 2018, 12:20, 145 days ago
Os info: Win XP
Oracle info: 11g
Error info: ORA-01031
Message: The password of system expired I want to login as sysdba to reenter the password of SYSYTEM but gives me the error Insufficient privileges .
How can I reenter the password of user SYSTEM, and overcome this error

Note: It is personal Oracle ON WIN Xp
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Ora-01031 Insufficient Privileges
Author: Matej Pagac, Slovakia
Date: May 29, 2018, 12:30, 145 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hello,

make sure your personal user is in the ORADBA OS group.

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

Subject: Re: Ora-01031 Insufficient Privileges
Author: Gareth Graham, United Kingdom
Date: May 31, 2018, 15:30, 143 days ago
Message: What are the contents of your %ORACLE_%HOME\network\admin\sqlnet.ora file?
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Ora-01031 Insufficient Privileges
Author: javed akhtar, India
Date: Jun 01, 2018, 13:26, 142 days ago
Message: open command line and use

sqlplus "/ as sysdba"

sqlplus> alter user system identified by "password";
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Ora-01031 Insufficient Privileges
Author: Gareth Graham, United Kingdom
Date: Jun 01, 2018, 13:31, 142 days ago
Message: When he tries that he gets "Ora-01031 Insufficient Privileges".
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Ora-01031 Insufficient Privileges
Author: javed akhtar, India
Date: Jun 01, 2018, 13:33, 142 days ago
Message: hello Gareth,

he told that system password is expired and i am login with sysdba privileges.

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

Subject: Re: Ora-01031 Insufficient Privileges
Author: Gareth Graham, United Kingdom
Date: Jun 01, 2018, 13:35, 142 days ago
Message: "I want to login as sysdba to reenter the password of SYSYTEM but gives me the error"
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Ora-01031 Insufficient Privileges
Author: javed akhtar, India
Date: Jun 01, 2018, 13:37, 142 days ago
Message: Hello Graham,

thanks for remind me.

yes you are rite let us check what is the value for sqlnet.ora

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