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