Home » RDBMS Server » Networking and Gateways » ORA-01031: insufficient privileges (oracle 11.2.0 , linux X86)
ORA-01031: insufficient privileges [message #530434] Tue, 08 November 2011 03:28 Go to next message
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

Re: ORA-01031: insufficient privileges [message #530445 is a reply to message #530434] Tue, 08 November 2011 04:23 Go to previous messageGo to next message
Michel Cadot
Messages: 59062
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-01031: insufficient privileges [message #530450 is a reply to message #530445] Tue, 08 November 2011 04:32 Go to previous messageGo to next message
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
Re: ORA-01031: insufficient privileges [message #530452 is a reply to message #530450] Tue, 08 November 2011 04:46 Go to previous messageGo to next message
Michel Cadot
Messages: 59062
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-01031: insufficient privileges [message #530453 is a reply to message #530452] Tue, 08 November 2011 05:24 Go to previous messageGo to next message
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
Re: ORA-01031: insufficient privileges [message #530454 is a reply to message #530453] Tue, 08 November 2011 05:32 Go to previous message
Michel Cadot
Messages: 59062
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Cannot connect to DB
Next Topic: DB not registered with listener
Goto Forum:
  


Current Time: Sun Sep 14 21:44:43 CDT 2014

Total time taken to generate the page: 0.08819 seconds