Oracle only recognized special characters are # (pound), $ (dollar sign) and _ (underscore), any other special characters in passwords are not supported in Oracle. However in the Toad GUI, in the Navigation Manager, I go to the active connection I'm logged into and right-click the connect and select 'Change Password'. I enter in the ordinal password, but accidently entered in special character not supported. However Toad accepted the new password and did not throw an error.
The next time I go to log in, I get the following error:
**********************************************************************
Exception Information
**********************************************************************
Exception: System.ArgumentException
Message : Invalid character in non-quoted parameter value
Stack Trace:
at Devart.Common.i.a(Hashtable A_0)
at Devart.Common.i..ctor(String A_0, Hashtable A_1, Boolean A_2)
at Devart.Data.Oracle.af..ctor(String A_0)
at Devart.Data.Oracle.cq.a(String A_0, i A_1)
at Devart.Common.DbConnectionFactory.a(String A_0, i& A_1)
at Devart.Common.DbConnectionBase.set_ConnectionString(String value)
at Devart.Data.Oracle.OracleConnection.set_ConnectionString(String value)
at Devart.Data.Oracle.OracleConnection..ctor(String connectionString)
at Quest.Toad.Oracle.OracleToadConnection.CreateConnection()
at Quest.Toad.Db.Connection.AllocConnection()
at Quest.Toad.Db.Connection.Connect(Boolean notify)
at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()
WORKAROUND:
Have an Oracle DBA change the password to a supported format.
STATUS:
Waiting for a fix in a future release of Toad for Data Analysts.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center