OraFAQ Forum: Networking and Gateways » ORA-01031: insufficient privileges

Home » RDBMS Server » Networking and Gateways » ORA-01031: insufficient privileges (oracle 11.2.0 , linux X86)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01031: insufficient privileges [message #530434]

Tue, 08 November 2011 03:28

crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi

Member

Hi All,
Please help me to identify the issue, getting error while login through putty and toad as sysdba.

Getting error while connecting through TOAD or putty like below :-

SQL> conn sys@PREPOS as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges

But it is not giving error when login :-

SQL> conn /as sysdba
Connected.

ID :- uid=500(oracle) gid=502(oinstall) groups=501(dba),502(oinstall) context=user_u:system_r:unconfined_t

Please let me know if i missed to mentioned ..

Regards,
Vimlendu

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #530445 is a reply to message #530434]

Tue, 08 November 2011 04:23

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

"remote_login_passwordfile" parameter and the presence of a password file determine if you are able to connect as sysdba through the network.

Regards
Michel

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #530450 is a reply to message #530445]

Tue, 08 November 2011 04:32

crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi

Member

the following are set as below :-

SQL> show parameter remote_login_passwordfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE

and in the sqlnet.ora file is having below entry :-

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /u01/apps/oracle

and i can also see the password file is there.

not able to solve the issue.

Regards,
Vimlendu

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #530452 is a reply to message #530450]

Tue, 08 November 2011 04:46

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

and i can also see the password file is there

Where there and what is its name and what is your Oracle SID?
Show us what you see: open a DOS box and copy and paste your session here.

Regards
Michel

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #530453 is a reply to message #530452]

Tue, 08 November 2011 05:24

crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi

Member

[oracle@xxxxx dbs]$ pwd
/u01/apps/oracle/product/11.2.0/dbhome/dbs
[oracle@xxxxx dbs]$ ls -ltr orap*
-rw-r----- 1 oracle oinstall 1536 Oct 29 13:21 orapwprepos

the file is there with above name and directory.

but when i created a one more password file with naming convention
like orapwPREPOS.

it is granting me to login.

thanks for your help.

Regards,
Vimlendu

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #530454 is a reply to message #530453]

Tue, 08 November 2011 05:32

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for the feedback.
(I don't know why I thought you were on Windows, the title clearly mentioned linux???)

Regards
Michel

Report message to a moderator

Previous Topic:	Cannot connect to DB
Next Topic:	DB not registered with listener

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 14:42:30 CDT 2025