ora-01034 ora-27101 错误

SQLNET.AUTHENTICATION_SERVICES

Purpose

To enable one or more authentication services. If authentication has been installed, then it is recommended that this parameter be set to eithernoneor to one of the authentication methods.

Default

None

Note:

When installing the database with Database Configuration Assistant (DBCA), this parameter may be set tontsin thesqlnet.orafile.

Values

• Authentication Methods Available with Oracle Net Services:

  • nonefor no authentication methods, including Microsoft Windows native operating system authentication. WhenSQLNET.AUTHENTICATION_SERVICESis set tonone, a valid user name and password can be used to access the database.

  • allfor all authentication methods.

  • ntsfor Microsoft Windows native operating system authentication.

• Authentication Methods Available with Oracle Advanced Security:

  • kerberos5for Kerberos authentication.

  • radiusfor RADIUS authentication.

  • tcpsfor SSL authentication.

Example

SQLNET.AUTHENTICATION_SERVICES=(kerberos5)

默认情况下Unix/Linux下的sqlnet.ora文件是没有SQLNET.AUTHENTICATION_SERVICES参数的，
此时是操作系统验证和Oracle密码验证并存，加上SQLNET.AUTHENTICATION_SERVICES这个参
数后，不管SQLNET.AUTHENTICATION_SERVICES设置为NONE还是NTS还是(NONE,NTS)，都是
基于Oracle密码验证。

设置不当会出现ora-01034 ora-27101 错误；