| regarding passwordfile authentication [message #163818] |
Mon, 20 March 2006 03:32  |
frank.svs
Messages: 162
Registered: February 2006
|
Senior Member |
|
|
Hi all,
I am working on Windows 2003 server Os. My Oracale Database version is 9.2.0.1.0. I've created a passwordfile for database called "testdb" using ORAPWD utility. before this i've changed the following parameter at intance level i.e
remote_login_passwordfile=exclusive
and try to connect to the database as sys user.
And now i am getting an Error as
ORA-01031: insufficient privileges
??
why it is coming so. Sometimes it s also showing TNS adaptor protocol error and also invalid username/password error eventhough i am supplying the correct credentials. Why such an error is coming.Later i've deleted the password file and modified the
remote_login_passwordfile=none
and tried to connect once again but still its not connecting.
What could be the reason.
Thank Q in advance.
|
|
|
|
|
|
|
|
| Re: regarding passwordfile authentication [message #163894 is a reply to message #163818] |
Mon, 20 March 2006 10:24  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
On windows there is an operating system group that can override the passwordfile settings in determining who can log in with sysdba privs. Check the os user and group that you are trying to log onto the database as. And also confirm you can log in as other users using the same command (test/test@service) to make sure that it is only a sysdba thing and not some other database or service problem.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
