we have an application that check the tablespaces size every time interval. in one check we are executing for every tablespace one statement. the problem is by every check for some of the tablespaces we get ORA-01017: invalid username/password; logon denied' when executing the statement.
statements are executed with the sysdba user.
the version of the database is 220.127.116.11, OS is Microsoft Windows x64 (64-bit).
could some one help?
Oracle is too dumb to lie about that error. At some point, you have some process that is trying to connect with an invalid username/password. But no one here is looking over your shoulder to see your code or the configuration of the process that is making these connections.
When you say "statement" do you mean "script", so you are running more than one script file?
What are you using to run the script or scripts?
How have scheduled the script or scripts to run "every interval"?
Are you setting ORACLE_HOME, ORACLE_SID, PATH consistently?
Are you always running the script or scripts as the same OS user?