Re: Connect failed on oracle 8.1.7

"news libero" <bettati_at_infinito.it> wrote:

>Each client must connect to both instances.
>A strange thing happens: with some AD users i can connect correctly to both
>instances. If i logon with another AD user on a client, i could connect to
>one instance, on the other instance i can complete a TNSPING but if i try to
>connect with SQLPLUS i receive the message:
>ORA-12545 connect failed because the target host or object does not exist.

This sounds to me like a NT user problem. Either the environment for that user is setup incorrectly (e.g. incorrect path for TNSNAMES.ORA), or there is some kind of authorisation/security problem for that NT user.

One thing to always remember - NT users are no different than Unix users. Each user has its own home directory, profile and rwx permissions.

Adding in NT user authentication (i.e. NT domains) on the server, makes matters a bit more complex as not only does the NT user need to be correctly setup on the local machine, but the domain manager also needs to provide that user with the correct access rights to access the domain services (which can be most any service running on the domain servers).

--
Billy