5 Replies Latest reply on Jun 24, 2013 12:18 PM by prog

    Schema user is getting locked

    prog

      Hi,

      I am facing a problem now that my schema user is getting locked. I went to sql developer and unlocked it but it keeps getting locked again after few minutes.

      how can I resolve this problem??

      http://www.2shared.com/photo/LQTvPOKj/locked.html

        • 1. Re: Schema user is getting locked
          Jens Marre

          May-be somebody is trying to log in who does not know the password?

          Why does Oracle user account get LOCKED?

           

          Jens

          • 2. Re: Schema user is getting locked
            GhanaApexDeveloper

            Hi Try this,

            Hi ,

            I suppose it is your expiry section for your users.Try this

              alter the password expiry policy for a certain user profile in Oracle first check wich profile the user is in using:

            select profile from DBA_USERS where username = <username>

            Then you can change the limit to never expire using:

            alter profile <profile_name> limit password_life_time UNLIMITED;

            If you want to previously check the limit you may use:

            select resource_name,limit from dba_profiles where profile='<profile_name>';
            • 3. Re: Schema user is getting locked
              prog

              I tried the mention but it's still getting locked

              now I think the problem is : Tomcat is trying to access the database or something like that with a wrong pswd because there is an integration between them.

              in tomcat logs I found (pswd has been expired) and since that time I couldn't produce jasper pdf files correctly.

              any idea where is that located in tomcat or anywhere else so I can set the right access to my database and it gives the pdf I am requesting without errors

              • 4. Re: Schema user is getting locked
                GhanaApexDeveloper

                Hi prog,

                navigate to

                If you want to previously check the limit you may use:

                <directory\conf\Catalina\localhost\JasperReportsIntegration.xml>

                In your Resource node,your and change the "schema_user with the appropriate name

                 

                <Resource name="jdbc/<schema_user>" auth="Container" type="javax.sql.DataSource"

                              driverClassName="oracle.jdbc.OracleDriver"

                              maxActive="20" maxIdle="10" maxWait="-1"

                              initialSize="4" minIdle="3" validationQuery="select user from dual"

                              testWhileIdle="true" testOnBorrow="true" timeBetweenEvictionRunsMillis="300000"

                              numTestsPerEvictionRun="100" minEvictableIdleTimeMillis="10000"

                 

                 

                              url="jdbc:oracle:thin:@localhost:1521:o102"

                              username="<schema_user>"

                              password="<schmema_password>"

                              />

                Check to see if your credentials are right.

                Hopet this works

                Thanks

                Benjamin.

                • 5. Re: Schema user is getting locked
                  prog

                  Exactly I changed the password in the file and it's working fine now!

                  Thank you