Re: ora:01017 invalid username/password

"Mick cooke" <michael.cooke_at_tinyworld.co.uk> wrote in message news:9346ca52.0212031356.10e3fc29_at_posting.google.com...

svrmgrl> create user \\abc_win\fred identified externally
> this produced an error (sorry forgot to write it down. will do so tomorrow
> Tried again
> svrmgrl> create user fred identified externally
> svrmgrl> statment processed
> (granted connect and dba to fred)
> created network account and gave domain admin privs
>
> logged onto the server as fred
> svrmgrl> connect /@db
> svrmgrl> ora:01017 invalid username/password blah ..........
> I am getting really frustrated
> am I missing something here?

If you are using os authentication then you need to

1. create the user as create user \\domain\username identified externally. This is because you are now logging in as domain\username not just username
2. set sqlnet.authentication_services=(NTS) in sqlnet.ora on both the server and the client.

You may also get problems if your username or domain name contain illegal identifiers.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************