Home » RDBMS Server » Server Administration » Cannot able to login as OS authentication (Windows,9.2.0.8)
Cannot able to login as OS authentication [message #324615] Tue, 03 June 2008 05:56 Go to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Hi,

I have one database version 9.2.0.8 on windows. I am not able to login by using the OS authentication. The below steps I followed for the same.

1. Rename the password file as old_PWDTEST.ora
2. Change the remote_login_passwordfile=none
3. set ORACLE_SID=TEST
4. sqlplus "/nolog"
5. connect / as sysdba
Then oracle giving the error
ORA-01031 insufficient privilege.

Please help.

Pokhraj

[Updated on: Tue, 03 June 2008 06:00]

Report message to a moderator

Re: Cannot able to login as OS authentication [message #324631 is a reply to message #324615] Tue, 03 June 2008 06:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you in ORA_DBA windows group?

Regards
Michel
Re: Cannot able to login as OS authentication [message #325227 is a reply to message #324615] Thu, 05 June 2008 05:48 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Yes I am at ORA_DBA windows group.

Pokhraj
Re: Cannot able to login as OS authentication [message #325235 is a reply to message #325227] Thu, 05 June 2008 06:12 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Metalink note 114384.1, "Checklist for Resolving CONNECT AS SYSDBA Issues"

Regards
Michel
Previous Topic: How to query for the executed statement?
Next Topic: NLS_DATE_FORMAT
Goto Forum:
  


Current Time: Wed Dec 07 02:54:24 CST 2016

Total time taken to generate the page: 0.05265 seconds