ORA-01017: invalid username/password: Logon denied

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kirankota79
Premium Member
Premium Member
Posts: 315
Joined: Tue Oct 31, 2006 3:38 pm

ORA-01017: invalid username/password: Logon denied

Post by kirankota79 »

hi i am trying to create an ODBC connection from DS server on windows 2003 to an oracle database on win XP. i keep on getting the error ORA-01017: invalid username/password: Logon denied. But with the same id and password i am able to login through sqlplus. Any suggestions here?

Thanks
Krazykoolrohit
Charter Member
Charter Member
Posts: 560
Joined: Wed Jul 13, 2005 5:36 am
Location: Ohio

Post by Krazykoolrohit »

Check if the DSN name you are using actually points to the Database you want to run your SQLS from.
kirankota79
Premium Member
Premium Member
Posts: 315
Joined: Tue Oct 31, 2006 3:38 pm

Post by kirankota79 »

i am not able able to run the test connection. the tns service name is correct and i am giivng the DSN of my wish
sreddy
Participant
Posts: 144
Joined: Sun Oct 21, 2007 9:13 am

Re: ORA-01017: invalid username/password: Logon denied

Post by sreddy »

Hi Kiran

I think you are using downloaded version of Oracle 9i/10G from Oracle website. That makes TNS problems;
you have to correct the TNSname.ora File :idea:

Then you can access your UVrep and load the data.
SReddy
dwpractices@gmail.com
Analyzing Performance
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

if you have oracle client, then why are you doing ODBC?
Minhajuddin
Participant
Posts: 467
Joined: Tue Mar 20, 2007 6:36 am
Location: Chennai
Contact:

Post by Minhajuddin »

Have you added the DSN in your datasources. You can check that in:

start==>control panel==>administrative tools ==>Data sources
Minhajuddin

<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
Post Reply