os authentication

hai friends,
while i try to connect from my client machine through os authentication using the following steps
oracle8.1.6
windows nt
1. in init.ora file i changed remote_login_passwordfile=exclusive
os_authent_prefix="ops$"
1.both in my client and server machine i have the same username and password
2.create user ops$ identified externally
3.grant connect toops$
4.alter user ops$
default tablespace
temporary tablespace
quota 10 m on
quota 10 m on
5. i created a service name from my client machine as dba
6. i sqlnet.ora file sqlnet.authentication_service=(nts)
7. connect /@dba

still i am getting an error
err-01004:default username feature not supported;logon denied

please help me da!!!!!!!!!!!

Hi

Add the following line in ur initialization file

remote_os_authent=true

And you have to create the user as follows

create user OPS$username identified externally;

and make sure your network userid and ops$userid are the same

for example

Network id : amudha

OPS$ account : OPS$amudha


Regards,

hi
i am confused,when you create the external user in your create user clause,need you prefix the username by OPS$.I conceive you could give the username directly.And there is a parameter of os_prefix in v$parameter,what is its usage?
TIA

In oracle 8.1.6 the prefix OPS$ is used only for backward compatibility,if u make the os_auth_prefix as null value,then in OS authentication u can eliminate the prefix while creating the user.
Ex: if u make the OS_AUTH_PREFIX =""
Then u can use the command
create user scott identified externally;

I too having the problem in OS authentication,if iam succesful i will share it on forum
regards
akhadar

Hi

I am running Personal Oracle816 on Win98 M/C.

Can I make use of external authentication in Win98 also.

If yes how ?

The REquired paremeter oin my init file reads OS_AUTH_PREFIX ="OPS$"

After that I created a user

create user OPS$User identified externally

HELP !!

Frankly i didnot used the personal oracle that too on win98. Any how my assumption is OS_AUTH_PREFIX is the concept clearly depends on the base OS.Have a trial by creating a user on Win98,be sure about case sensitivity.It require that both OS user and Oracle user should of same case.As your parameter file consisting of prefix OPS$.
Also it is required to make the following changes in your parameter file i.e,
REMOTE_LOGIN_PASSWORDFILE=NONE
REMOTE_OS_AUTHENT=TRUE
CREATE USER OPS$username IDENTIFIED EXTERNALLY
Now login to OS with the userID created on win98.Try to connect the database as
connect /@connecting string
Any problem let me know
Regards
akhadar

thanks for ur reply,
i tried all possible way even after giving
remote_os_authent=true i am getting the same problem
ora-01004 default username not supported

please help me !!!!

Hi Amudha,

Did you restart your instance after the changes in the initialization file and are you logging on to the netword using your network id.Both of these are a must do.

Regards,

Hi

Did you restart the listener?

If not restart your listener.

Regards

How on earth would restarting the listener have any influence regarding this isue?

Hi Jurij,

I had a similiar type of a problem on a windows NT server yesterday

I tried to restart the database after making all the changes in the iniitalisation file and tried to login with OS authentication I was not successfull.

Then I just restarted the Oracle listener on the Windows NT Server and I was able to login with OS authentication.

Regards,

HI amudha,

Could you successfully implement OS authentication. If not revert at [email protected].

Bye,

Rama