| 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
|
|
|
|
|
|
| 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
|
|
|
|
|
|
| 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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
