Re: Right password -> ORA-12154: TNS:Could not resolve service name

Originally posted by John

> Hi
 

>
 

> Right password -> ORA-12154: TNS:Could not resolve service name
 

>
 

> wrong password => ORA-01017: invalid username/password; logon denied
 

>
 

> Tested on a Windows XP client connecting to Oracle on an AIX server.
 

> Using toad and sqlplusw
 

>
 

> Everything working fin connecting to other 8.1.7 Oracle servers
> on windows
 

> serveres.
 

>
 

> If i delete tnsnames.ora i always receives ORA-12154 :-)
 

>
 

> If you get ora 01017 then everything should be in perfectorder,
> except the
 

> password... Right ?

1)

Correct user, correct password, correct service_name

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.3.0 - Production

2)

Correct user, correct password, wrong service_name

ERROR: ORA-12154: TNS:could not resolve service name

3)

Wrong user AND/OR wrong password, wrong service_name

ERROR: ORA-12154: TNS:could not resolve service name

4)

Wrong user AND/OR wrong password, correct service_name

ERROR: ORA-01017: invalid username/password; logon denied

Run netca and check your Net8/9 settings or connect url.

Regards

/Rauf Sarwar

--
Posted via http://dbforums.com