I m using ORACLE 9i on linux 9, the oracle is running fine and authenticating users using OS authentication method by providing command "sqlplus /". But when i m going to connect through remote client it is giving the...

error: ORA-01004 Default username feature not supported; logon denied

Following are the parameters settings"

# SQLNET.ORA Network Configuration File: /oracle/u01/app/oracle/product/9.2.0/n
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = ssuet.edu.pk

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

# sqlnet.authentication_services = (NTS)

# REMOTE_OS_AUTHENT = TRUE

# SQLNET.AUTHENTICATION_SERVICES=(NTS)


# in initSID.ora
remote_os_authent = true
os_authent_prefix = ""

hi,

decomment the line :

# sqlnet.authentication_services = (NTS)

to

sqlnet.authentication_services = (NTS)

hope this helps.

Hi

Thank you for your reply.

I've uncommented that statement but the problem occured on hosted machine (Oracle Server) and still there the problem on client as well

Kindly help


Jawed

what linux do u use? Suse, redhat, debian ?

greetz

I am using Redhat Linux 9


Regards

Jawed

I am using Redhat Linux 9


Regards

Jawed

Hi

I m using Redhat linux 9.0


Regards

Jawed

What is the value of the init parameter REMOTE_LOGIN_PASSWORDFILE ?

If it is set to NONE, set to EXCLUSIVE and then try to connect from the remote client

HTH
Arvind

Parameter remote_login_passwordfile already set to exclusive in init file but it is not working why?


Jawed

hi,

did u bounce the database ?

greetz