ORA-01017 error when connecting through Windows XP client
I have installed Oracle 10g release 2 (10.2) (custom installation) sucessfully with all the available options (in fact I tried all other available options). When I connect on the server, everything works, but when I try to connect from Windows XP client using SQL 8 or Forms 6, I get the error "ORA-01017: invalid username/password; logon denied." Please let me know if it is a bug in 10g or if I need to add a patch or any configuration is required. Thanks in advance.
I am not aware of a bug in Oracle 10g release 2 that would cause this error message under these circumstances. There is a bug reported when using the Oracle 10g client to connect to Oracle 8i or 9i when the database and client have different character sets, but that is not the case here.
Are you connecting with the same username/password locally on the server that you are using to connect from the client? Check the tnsnames.ora on the client to ensure that the service name is pointing at the correct SID and server. It's possible that your service name is pointing to another database on another server which you have no access to with the username/password combination you are providing.
A more likely possibility is that you may need to install a newer client. Net8 is quite a few releases behind Oracle 10g so you may need to at least install the 9.2 client to connect to your Oracle 10g database. To confirm this, you can review Doc ID # 207303.1 if you have access to Metalink or open a TAR with Oracle Support.
This was first published in October 2005