OracleException ORA-1017: invalid username/password; logon denied at Oracle
922134Jan 22 2013 — edited Jan 22 2013Hi,
SYS@EHS06T>select from v$version;*
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for 64-bit Windows: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
I have checked the PWADM and PWSYS account and tried to connect to the DB using sqlplus both. I didn’t got any error while connecting.
Also checked the Event viewer logs and found nothing.
But end user getting below error from application :
Message: Error saving emissions
Oracle.DataAccess.Client.OracleException ORA-1017: invalid username/password; logon denied at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src) at Oracle.DataAccess.Client.OracleConnection.Open() at Ess.Framework.DA.BulkOperations.InsertDataOracle(String tableName, DataTable table, Int32 timeout) at Ess.Framework.DA.BulkOperations.InsertData(String tableName, DataTable table) at Ess.ESuite.Air.BO.Calculator.Controller.SaveEmissions(List`1 list) at Ess.ESuite.Air.BO.Calculator.Controller.SaveCachedEmissions()
Request your assistance in solving this issue. Thanks!