OS authentication is not working in 11G [message #503899] |
Wed, 20 April 2011 04:43 |
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 #503912 is a reply to message #503906] |
Wed, 20 April 2011 06:18 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
OraKaran wrote on Wed, 20 April 2011 12:09Hello
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
|
|
|
|
|