os authentication

[amudha]

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!!!!!!!!!!!

[santoshym]

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,

[jiang_tian]

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

[akhadar]

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

[vijay8282]

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 !!

[akhadar]

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

[amudha]

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 !!!!

[santoshym]

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,

[santoshym]

Hi

Did you restart the listener?

If not restart your listener.

Regards

[jmodic]

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