Home » RDBMS Server » Networking and Gateways » Not able to connect with database (oracle sql developer)
Not able to connect with database [message #618251] Thu, 10 July 2014 02:01 Go to next message
simplesanju
Messages: 36
Registered: July 2008
Member
Hi all,

previously I was able to connect with database through sql developer. I use citrix and then access client db via sqldeveloper. but client has migrated db into different host and port. after that we are not able to connect database.
it is showing ORA-01017 Invalid user name and password.
even by same user name and password they are able to connect with their machine.
please suggest...

Thanks

Report message to a moderator

Re: Not able to connect with database [message #618252 is a reply to message #618251] Thu, 10 July 2014 02:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So client has migrated the database but not your account or has changed your password or your are not trying to reach the correct database. Did you change your connection string?

Report message to a moderator

Re: Not able to connect with database [message #618253 is a reply to message #618251] Thu, 10 July 2014 02:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Also people has given you solutions in some quite complex questions you posted and you didn't feedback or thank them. If you want to get help for your future problems then do it now. I give your the links:

http://www.orafaq.com/forum/m/608919/#msg_608919
http://www.orafaq.com/forum/m/608427/#msg_608427
http://www.orafaq.com/forum/m/604725/#msg_604725

Report message to a moderator

Re: Not able to connect with database [message #618260 is a reply to message #618253] Thu, 10 July 2014 02:50 Go to previous messageGo to next message
simplesanju
Messages: 36
Registered: July 2008
Member
Yes I have changed connection string and all..but still facing issue..

Report message to a moderator

Re: Not able to connect with database [message #618263 is a reply to message #618260] Thu, 10 July 2014 02:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It appears you have not changed it in the correct way.
Note Oracle is too dumb to lie on this, whatever you think on the database you are trying to connect you have no account or a wrong password.
So check another time you are trying to connect to the correct database.

Report message to a moderator

Re: Not able to connect with database [message #618337 is a reply to message #618263] Fri, 11 July 2014 00:54 Go to previous messageGo to next message
simplesanju
Messages: 36
Registered: July 2008
Member
same user name and password is working if we try to connect their machine by using remotedesktop which is in London but my team is in hyderabad (offshore team) we are not able to connect same database through Citrix.

Report message to a moderator

Re: Not able to connect with database [message #618339 is a reply to message #618337] Fri, 11 July 2014 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You are not trying to connect to the same database or you are not passing the username/password.

Report message to a moderator

Re: Not able to connect with database [message #618341 is a reply to message #618339] Fri, 11 July 2014 01:55 Go to previous messageGo to next message
simplesanju
Messages: 36
Registered: July 2008
Member
I am not able to attach screenshot here so that I can show that we are not able to connect to the same database schemas using Citrix Remote Desktop. I have used instead of Host name to verify if it works, however id didn't.Same connection is working fine through London Physical machine on RDC which is physically in london.

Report message to a moderator

Re: Not able to connect with database [message #618369 is a reply to message #618341] Fri, 11 July 2014 06:03 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
Do you mind posting the connection details i.e. server name, port & service or SID here at least?

And make sure you post for both the locations, one where you getting error and the one where it succeeds.

Report message to a moderator

Re: Not able to connect with database [message #618399 is a reply to message #618369] Fri, 11 July 2014 08:55 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
consider to packet sniff (Ethereal, WireShark, etc.) to observe the actual data content being exchanged.

Report message to a moderator

Previous Topic: ORA-12154 error coming while loading forms in browser
Next Topic: Unable to start listener
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 15:48:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.