Home » SQL & PL/SQL » Client Tools » ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g (Oracle 10g, SQL Server 2008 R2)
ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g [message #587762] Tue, 18 June 2013 08:32 Go to next message
Devo
Messages: 23
Registered: November 2012
Location: France
Junior Member
I would like to Import data from Oracle 10g using Microsoft Sql Server (2008 R2) Import/Export Wizard, but i get this error when i try too establish the connection :
ora-01017


https://lh5.googleusercontent.com/-mu8IYYsv3WQ/UcBgVYeBUDI/AAAAAAAAAwM/bTNguO3F4Oc/w809-h585-no/mez.jpg

this the step i followed;
1- i filled the server name
2- username & password
3 - test connection ---> success

but when i try to follow pressing next(Suivant) i got the ora-01017 Error

thanks in advance
Re: ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g [message #587763 is a reply to message #587762] Tue, 18 June 2013 08:37 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
[oracle@localhost ~]$ oerr ora 1017
01017, 00000, "invalid username/password; logon denied"
// *Cause:
// *Action:


BELIEVE the error message
Re: ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g [message #587764 is a reply to message #587763] Tue, 18 June 2013 08:40 Go to previous messageGo to next message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member
Wrong username and/or password. Or maybe even the wrong database. BlackSwan is correct.
Re: ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g [message #587768 is a reply to message #587764] Tue, 18 June 2013 09:28 Go to previous messageGo to next message
Devo
Messages: 23
Registered: November 2012
Location: France
Junior Member
Everything is correct, database, server, username and password
maybe it's about another reason
Re: ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g [message #587770 is a reply to message #587768] Tue, 18 June 2013 09:31 Go to previous messageGo to next message
cookiemonster
Messages: 10929
Registered: September 2008
Location: Rainy Manchester
Senior Member
Oracle isn't known to lie about these things
Re: ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g [message #587771 is a reply to message #587768] Tue, 18 June 2013 09:34 Go to previous messageGo to next message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member
Devo wrote on Tue, 18 June 2013 14:28
Everything is correct, database, server, username and password


That cannot be true. Don't look for any other reason.
Re: ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g [message #587772 is a reply to message #587771] Tue, 18 June 2013 09:43 Go to previous messageGo to next message
Devo
Messages: 23
Registered: November 2012
Location: France
Junior Member
because i work with the same information in my Oracle Sql Developer
for the server name i enter my server@ip/oracleSID
user my username and password the password associated to the user
Re: ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g [message #587773 is a reply to message #587771] Tue, 18 June 2013 09:45 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
>Everything is correct, database, server, username and password
I do not believe you.

>maybe it's about another reason
Nope, BELIEVE the error message.

Every remote connection request gets logged by the Oracle listener.
post an excerpt from listener.log file that confirms the connection request from the SQLServer system got to the (correct) listener.
Re: ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g [message #587774 is a reply to message #587773] Tue, 18 June 2013 09:50 Go to previous messageGo to next message
Devo
Messages: 23
Registered: November 2012
Location: France
Junior Member
But how can i connect to the same server with the same username and sid ??
there is any particularity for sql server Import/Export Wizard ?
Re: ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g [message #587775 is a reply to message #587774] Tue, 18 June 2013 09:55 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
Every remote connection request gets logged by the Oracle listener.
post an excerpt from listener.log file that confirms the connection request from the SQLServer system got to the (correct) listener.

>But how can i connect to the same server with the same username and sid ??
same as what?
does Oracle DB & SQL Server DB reside on same physical system?

>there is any particularity for sql server Import/Export Wizard ?
question needs to be asked on a SQL Server forum.

post proof that you are connecting to the "correct" Oracle DB
Re: ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g [message #587776 is a reply to message #587774] Tue, 18 June 2013 10:03 Go to previous messageGo to next message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member
Devo wrote on Tue, 18 June 2013 14:50

there is any particularity for sql server Import/Export Wizard ?


No. I told you: the reason is wrong username, password and/or database. It is nothing else.
Re: ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g [message #587777 is a reply to message #587776] Tue, 18 June 2013 10:07 Go to previous messageGo to next message
Devo
Messages: 23
Registered: November 2012
Location: France
Junior Member
Beleive me, i think it was somethiing internat to SQL Server, because i only checked "Autoriser l'enregistrement du mot de passe" and everything is working fine. (i add also the port number after the ip@)

thanks
Re: ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g [message #587778 is a reply to message #587777] Tue, 18 June 2013 10:09 Go to previous message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member
So you clicked "Save password" and it worked? Shocked
Previous Topic: TNS-03505: Failed to resolve name tips - tnsping orcl
Next Topic: Connect database on unix & win
Goto Forum:
  


Current Time: Sat Aug 30 23:57:08 CDT 2014

Total time taken to generate the page: 0.09436 seconds