Home » RDBMS Server » Server Administration » OS authentication is not working in 11G (Oracle 11.1.0.7.0 on Windows)
OS authentication is not working in 11G [message #503899] Wed, 20 April 2011 04:43 Go to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hello

OS authentication is not working

Does 11g need any different setting?

Following are the settings
1)

SQL> show parameter os_a

NAME                                 TYPE        VALUE
------------------------------------ ----------- --------------
os_authent_prefix                    string      OPS$
remote_os_authent                    boolean     FALSE


2) sqlnet.ora has following setting

SQLNET.AUTHENTICATION_SERVICES = (NTS)

3) I have created user like following

sql> create user OPS$CLASS
  2    identified externally
  3    default tablespace user_data
  4    temporary tablespace temporary_data
  5    profile clas_prof
  6    account unlock;

user created.

sql>   grant connect to OPS$CLASS;

Grant succeeded.



With the same settings it successfully connects from my 9i client to the 9i database
(DB01, below)

C:\Documents and Settings\CLASS_user>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Apr 20 10:18:58 2011

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: /@DB01

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production


However it fails to connect to 11G database (DB02, below)
C:\Documents and Settings\CLASS_user>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Apr 20 10:19:29 2011

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: /@DB02
ERROR:
ORA-01017: invalid username/password; logon denied


Regards,
OraKaran
Re: OS authentication is not working in 11G [message #503904 is a reply to message #503899] Wed, 20 April 2011 04:54 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hello

Please note that I am logging to my machine as CLASS only
(OS login) i.e. such user exists in the domain

Regards,
OraKaran
Re: OS authentication is not working in 11G [message #503906 is a reply to message #503899] Wed, 20 April 2011 05:09 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hello

It seems I must set following

remote_os_authent= TRUE

Trying that and will update soon

Regards,
OraKaran
Re: OS authentication is not working in 11G [message #503908 is a reply to message #503906] Wed, 20 April 2011 05:28 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
When using windows, I always I have to create the DB user as "OPS$WINDOWSDOMAIN\USERNAME"
Re: OS authentication is not working in 11G [message #503912 is a reply to message #503906] Wed, 20 April 2011 06:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OraKaran wrote on Wed, 20 April 2011 12:09
Hello

It seems I must set following

remote_os_authent= TRUE

Trying that and will update soon

Regards,
OraKaran

NEVER EVER set that.
Just admit you can't remotly use OS authentication.
If you don't want to give a password just use Secure Password Store (search for this it has already been talked about it).

Regards
Michel

[Updated on: Wed, 20 April 2011 06:19]

Report message to a moderator

Re: OS authentication is not working in 11G [message #504033 is a reply to message #503912] Thu, 21 April 2011 03:52 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Thanks Michel

It is really an IMP tip

I am reading on it now

Regards,
OraKaran
Re: OS authentication is not working in 11G [message #505972 is a reply to message #504033] Thu, 05 May 2011 15:55 Go to previous message
malalation
Messages: 12
Registered: April 2011
Junior Member
from what I know, the OS auth must be only used by the admin when he's logged in to the server's OS (view remote desktop on windows or ssh on *nix)
Previous Topic: Oracle 11.2.0.2 on AIX
Next Topic: ORA-01031: insufficient privileges
Goto Forum:
  


Current Time: Thu May 09 11:48:29 CDT 2024