Home » RDBMS Server » Networking and Gateways » ora-01017 (not able to connect the client)
ora-01017 [message #378886] Fri, 02 January 2009 04:45 Go to next message
manoj12
Messages: 210
Registered: March 2008
Location: India
Senior Member
Dear Sir

I am getting the below error while connecting the database through the client ora-01017-invalid username/password;logon denied.I am able to connect the database through the server but not through local machine.After checking the tnsnames.ora as well as sqlnet.ora Still able to get the same error.What must be the cause?

Regards
Re: ora-01017 [message #378887 is a reply to message #378886] Fri, 02 January 2009 04:48 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you check the right TNSNAMES.ORA? If there are more than one Oracle products installed on a client PC, there are more than one TNSNAMES.ORA files (by default, unless you chose to use TNS_ADMIN environment variable, but I'd say you did not. Not yet, that is).
Re: ora-01017 [message #378890 is a reply to message #378887] Fri, 02 January 2009 05:03 Go to previous messageGo to next message
manoj12
Messages: 210
Registered: March 2008
Location: India
Senior Member
Dear Sir..

Thanx for the reply.I have one server and many local machines using the same tnsnames.ora.Let me tell that I have only one oracle product installed into my local machine.I am able to connect the database through another local machine but through this machine I am not able to connect.Also I checked the sqlnet.ora there is no issues?.What could be the issue of not getting connected through our local machine

Regards
Re: ora-01017 [message #379636 is a reply to message #378886] Wed, 07 January 2009 07:17 Go to previous message
swoop1973
Messages: 4
Registered: January 2009
Junior Member
Try using tnsping from both client machines, check for differences.

If you see differences, either correct whats wrong, or copy the tnsnames.ora and sqlnet.ora from the machine that is working to the one that isnt.
Previous Topic: Configure Oracle behind firewall
Next Topic: ora-12170 TNS:connect timeout occured
Goto Forum:
  


Current Time: Sat Nov 23 22:57:03 CST 2024