Printable View
Dear Friends,
We have are able to login to Oracle 9.2.0.4.0 database through a client. This client software is our customised one. We are able to connect to Oracle database. Now, we are trying from another client session to Oracle database. This new session terminates with the following message.
ORA-01005: null password given; logon denied
Can anyone help pls.
Thanks
gandhi
well what does the error says..?!
How is your client configured to connect to the database in the first place? Are you using config file?Quote:
Originally posted by gandhi
We have are able to login to Oracle 9.2.0.4.0 database through a client. [/B]
I'll go way out on a limb and say you passed a null string for the password.:rolleyes:Quote:
Originally posted by gandhi
ORA-01005: null password given; logon denied
Can anyone help pls.
Check out the ORA_NLS33 variable may be its pointing to a non-existent directory or a directory that does not have the character-set files installed or the directory permissions are not set.
If the remote database is set to a character set other than the 'US7ASCII' (default) the client need to be set to the same character set.
If not, the SQL*Net layer will intersperse all characters sent to the server with a 'null' character. For this reason, the server believes a null password has been sent.