今天登陆至一个数据库,遇到了ORA-12571,网上很多仁兄们总结过,大部分是关于服务器端参数文件SQLNET.ORA中SQLNET.AUTHENTICATION_SERVICES设置导致,于是把查到的资料稍作了整理。
针对服务器端SQLNET.AUTHENTICATION_SERVICES参数进行修改。
参数使用示例:SQLNET.AUTHENTICATION_SERVICES=(NTS)
Use the parameter SQLNET.AUTHENTICATION_SERVICES to enable one or more authentication services. If authentication has been installed, it is recommended that this parameter be set to either none or to one of the authentication methods.
Authentication Method使用Oracle Net Services可以设置的参数为:none\all\nts
none for no authentication methods, including Windows native operating system authentication (to use Windows native operating system authentication, set this parameter to nts). When SQLNET.AUTHENTICATION_SERVICES is set to none, a valid user name and password can be used to access the database.
all for all authentication methods.
nts for Windows native operating system authentication.
Authentication Method使用Oracle Advanced Security可以设置为的参数为:kerberos5 \ radius \dcegssapi
kerberos5 for Kerberos authentication.
radius for RADIUS authentication.
dcegssapi for DCE GSSAPI authentication.
An authentication method that enables a client single login access to a Windows NT server and a database running on the server.
针对服务器端SQLNET.AUTHENTICATION_SERVICES参数进行修改。
参数使用示例:SQLNET.AUTHENTICATION_SERVICES=(NTS)
Use the parameter SQLNET.AUTHENTICATION_SERVICES to enable one or more authentication services. If authentication has been installed, it is recommended that this parameter be set to either none or to one of the authentication methods.
Note:
When installing the database with Database Configuration Assistant (DBCA), this parameter may be set to nts in the sqlnet.ora file.Authentication Method使用Oracle Net Services可以设置的参数为:none\all\nts
none for no authentication methods, including Windows native operating system authentication (to use Windows native operating system authentication, set this parameter to nts). When SQLNET.AUTHENTICATION_SERVICES is set to none, a valid user name and password can be used to access the database.
all for all authentication methods.
nts for Windows native operating system authentication.
Authentication Method使用Oracle Advanced Security可以设置为的参数为:kerberos5 \ radius \dcegssapi
kerberos5 for Kerberos authentication.
radius for RADIUS authentication.
dcegssapi for DCE GSSAPI authentication.
Note:
Windows NT native authenticationAn authentication method that enables a client single login access to a Windows NT server and a database running on the server.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23513450/viewspace-736617/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23513450/viewspace-736617/