OraFAQ Forum: Client Tools » ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g

Home » Other » Client Tools » ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g (Oracle 10g, SQL Server 2008 R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g [message #587762]

Tue, 18 June 2013 08:32

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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

[oracle@localhost ~]$ oerr ora 1017
01017, 00000, "invalid username/password; logon denied"
// *Cause:
// *Action:

BELIEVE the error message

Report message to a moderator

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

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Wrong username and/or password. Or maybe even the wrong database. BlackSwan is correct.

Report message to a moderator

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

Devo
Messages: 23
Registered: November 2012
Location: France

Junior Member

Everything is correct, database, server, username and password
maybe it's about another reason

Report message to a moderator

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

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Oracle isn't known to lie about these things

Report message to a moderator

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

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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.

Report message to a moderator

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

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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

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

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 ?

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

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

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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.

Report message to a moderator

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

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

Report message to a moderator

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

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

So you clicked "Save password" and it worked? Shocked

Report message to a moderator

Previous Topic:	TNS-03505: Failed to resolve name tips - tnsping orcl
Next Topic:	Connect database on unix & win

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 11:19:48 CST 2025