RE: NTS/NONE and ORA-12631

  • From: "Herbener, Martin - KETS Engineering and Management" <Martin.Herbener@xxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 24 Mar 2010 14:43:22 -0400

My challenge is that my developers  have legitimate reasons to sometimes
connect with a personal userid (which I would like to make NTS-based)
and other times as a schema owner or application userid (which would NOT
be NTS-based).   The suggestion that I'm looking at the wrong SQLNET.ORA
file is a good one, I need to verify that.

 

The link you posted mentions a possible value ALL; anybody have
experience using that setting?

 

Thanks!

 

Martin

 

--------------------------------------------
Martin Herbener
502 564 2020 ext 254
Office of Education Technology
Kentucky Department of Education 

From: Allen, Brandon [mailto:Brandon.Allen@xxxxxxxxxxx] 
Sent: Wednesday, March 24, 2010 2:24 PM
To: Herbener, Martin - KETS Engineering and ManagementSubject: RE:
NTS/NONE and ORA-12631

 

I believe it should be set to only one option, either NTS or none, not
both.  They are mutually exclusive.  From the docs:

 

http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.h
tm#sthref443

 

"it is recommended that this parameter be set to either none or to one
of the authentication methods"

 

If it's working that way on some systems, it may be that they're
actually using a different sqlnet.ora file than the one you think
they're using, e.g. in their TNS_ADMIN directory.

 

Regards,

Brandon

 

 

________________________________

Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do
not consent to Internet email for messages of this kind. Opinions,
conclusions and other information in this message that do not relate to
the official business of this company shall be understood as neither
given nor endorsed by it.

Other related posts: