Home
Trouble shooting
 

Cry about...
Oracle Troubleshooting

ORA-01004: default username feature not supported

Symptom:

When attempting to log in without supplying a password (i.e. intending to use operating system authentication) the following error is encountered:

ORA-01004: default username feature not supported; logon denied

Possible Causes and Remedies:

  1. Operating system authentication has not been enabled for the system.

  • Check ‘{ORACLE_HOME} \ NET80 \ ADMIN \ SQLNET.ORA’ on both client and server. To enable operating system authentication it should contain the line:

SQLNET.AUTHENTICATION_SERVICES = (NTS)

  1. If the registry key ‘HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \ OSAUTH_ENFORCE_STRICT’ is set (true) then verify that the user is a member of one of the following NT groups: ORA_<SID>_USER, ORA_<SID>_DBA, ORA_<SID>_OPER, ORA_USER, ORA_DBA or ORA_OPER.

  2. If the Oracle database is in a different domain from the logon domain then a trust relationship must be set-up between the two domains for operating system authentication to work.

  3. The system does not support operating system authentication. The error may in this case be accompanied by the error ‘ORA-01988: remote os login is not allowed’. Log on supplying password and username.