2 Replies Latest reply on Dec 11, 2019 8:53 AM by Gaz in Oz

    Random ORA-01017: invalid username/password; logon denied'

    user11978805

      Hello Together

       

      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 12.2.0.1, OS is Microsoft Windows x64 (64-bit).

      could some one help?

       

       

      Regards

        • 1. Re: Random ORA-01017: invalid username/password; logon denied'
          EdStevens

          user11978805 wrote:

           

          Hello Together

           

          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 12.2.0.1, OS is Microsoft Windows x64 (64-bit).

          could some one help?

           

           

          Regards

          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.

          • 2. Re: Random ORA-01017: invalid username/password; logon denied'
            Gaz in Oz

            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?

            etc...