JDBC debugging

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

JDBC debugging

French, Shelane
The database team is migrating the one Oracle database that I access to a new server. So, they’ve set me up an account to access the test databases on the new server. I have done all previous connections through JDBC. They sent me the updated account info, passwords, and JDBC connection string.

jdbc:oracle:thin:@ldap://dbserver.llnl.gov:389/pspre,cn=OracleContext,dc=llnl,dc=gov

The error log shows two different errors:

JDBC Error: ORA-28000: the account is locked
JDBC Error: Could not retrieve connection info from pool

How can I do better debugging to find out what's going on? I just did a WebEx with the dba. He said the connection string, username, and password were correct. He was also showing that the account was getting locked from "too many bad" requests.



Shelane French
Workforce Enablement
Livermore Information Technology


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: JDBC debugging

Ke Carlton-3
Google says:

"ORA-28000: the account is locked.

Cause: The user has entered wrong password consequently for maximum number
of times specified by the user"s profile parameter FAILED_LOGIN_ATTEMPTS,
or the DBA has locked the account

Action: Wait for PASSWORD_LOCK_TIME or contact DBA"


Did you receive this error immediately or after several attempts?


On Tue, Mar 6, 2018 at 7:02 AM French, Shelane <[hidden email]> wrote:

> The database team is migrating the one Oracle database that I access to a
> new server. So, they’ve set me up an account to access the test databases
> on the new server. I have done all previous connections through JDBC. They
> sent me the updated account info, passwords, and JDBC connection string.
>
> jdbc:oracle:thin:@ldap://
> dbserver.llnl.gov:389/pspre,cn=OracleContext,dc=llnl,dc=gov
>
> The error log shows two different errors:
>
> JDBC Error: ORA-28000: the account is locked
> JDBC Error: Could not retrieve connection info from pool
>
> How can I do better debugging to find out what's going on? I just did a
> WebEx with the dba. He said the connection string, username, and password
> were correct. He was also showing that the account was getting locked from
> "too many bad" requests.
>
>
>
> Shelane French
> Workforce Enablement
> Livermore Information Technology
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: JDBC debugging

French, Shelane
So, I forgot to disclaim. I am on Lasso 8.6.3. I see the error log in the Lasso Admin and I'm not sure where else to look.

I entered the username and password that the DBA gave me. He verified while looking at Lasso Admin that it was the correct login information. He made sure the account was not locked before I hit the "update" button on the host connection information.



Shelane French
Workforce Enablement
Livermore Information Technology

On 3/5/18, 12:54 PM, "[hidden email] on behalf of Ke Carlton" <[hidden email] on behalf of [hidden email]> wrote:

    Google says:
   
    "ORA-28000: the account is locked.
   
    Cause: The user has entered wrong password consequently for maximum number
    of times specified by the user"s profile parameter FAILED_LOGIN_ATTEMPTS,
    or the DBA has locked the account
   
    Action: Wait for PASSWORD_LOCK_TIME or contact DBA"
   
   
    Did you receive this error immediately or after several attempts?
   
   
    On Tue, Mar 6, 2018 at 7:02 AM French, Shelane <[hidden email]> wrote:
   
    > The database team is migrating the one Oracle database that I access to a
    > new server. So, they’ve set me up an account to access the test databases
    > on the new server. I have done all previous connections through JDBC. They
    > sent me the updated account info, passwords, and JDBC connection string.
    >
    > jdbc:oracle:thin:@ldap://
    > dbserver.llnl.gov:389/pspre,cn=OracleContext,dc=llnl,dc=gov
    >
    > The error log shows two different errors:
    >
    > JDBC Error: ORA-28000: the account is locked
    > JDBC Error: Could not retrieve connection info from pool
    >
    > How can I do better debugging to find out what's going on? I just did a
    > WebEx with the dba. He said the connection string, username, and password
    > were correct. He was also showing that the account was getting locked from
    > "too many bad" requests.
    >
    >
    >
    > Shelane French
    > Workforce Enablement
    > Livermore Information Technology
    >
    >
    > #############################################################
    >
    > This message is sent to you because you are subscribed to
    >   the mailing list Lasso [hidden email]
    > Official list archives available at http://www.lassotalk.com
    > To unsubscribe, E-mail to: <[hidden email]>
    > Send administrative queries to  <[hidden email]>
   
    #############################################################
   
    This message is sent to you because you are subscribed to
      the mailing list Lasso [hidden email]
    Official list archives available at http://www.lassotalk.com
    To unsubscribe, E-mail to: <[hidden email]>
    Send administrative queries to  <[hidden email]>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: JDBC debugging

French, Shelane
I just asked the DBA to change the password to the one I had for the old server with this user account. After he did, I was able to connect. So even though I created a "new connection," it's as if the password was cached somewhere and the old password was being submitted.




Shelane French
Workforce Enablement
Livermore Information Technology
On 3/5/18, 12:57 PM, "[hidden email] on behalf of French, Shelane" <[hidden email] on behalf of [hidden email]> wrote:

    So, I forgot to disclaim. I am on Lasso 8.6.3. I see the error log in the Lasso Admin and I'm not sure where else to look.
   
    I entered the username and password that the DBA gave me. He verified while looking at Lasso Admin that it was the correct login information. He made sure the account was not locked before I hit the "update" button on the host connection information.
   
   
   
    Shelane French
    Workforce Enablement
    Livermore Information Technology
   
    On 3/5/18, 12:54 PM, "[hidden email] on behalf of Ke Carlton" <[hidden email] on behalf of [hidden email]> wrote:
   
        Google says:
       
        "ORA-28000: the account is locked.
       
        Cause: The user has entered wrong password consequently for maximum number
        of times specified by the user"s profile parameter FAILED_LOGIN_ATTEMPTS,
        or the DBA has locked the account
       
        Action: Wait for PASSWORD_LOCK_TIME or contact DBA"
       
       
        Did you receive this error immediately or after several attempts?
       
       
        On Tue, Mar 6, 2018 at 7:02 AM French, Shelane <[hidden email]> wrote:
       
        > The database team is migrating the one Oracle database that I access to a
        > new server. So, they’ve set me up an account to access the test databases
        > on the new server. I have done all previous connections through JDBC. They
        > sent me the updated account info, passwords, and JDBC connection string.
        >
        > jdbc:oracle:thin:@ldap://
        > dbserver.llnl.gov:389/pspre,cn=OracleContext,dc=llnl,dc=gov
        >
        > The error log shows two different errors:
        >
        > JDBC Error: ORA-28000: the account is locked
        > JDBC Error: Could not retrieve connection info from pool
        >
        > How can I do better debugging to find out what's going on? I just did a
        > WebEx with the dba. He said the connection string, username, and password
        > were correct. He was also showing that the account was getting locked from
        > "too many bad" requests.
        >
        >
        >
        > Shelane French
        > Workforce Enablement
        > Livermore Information Technology
        >
        >
        > #############################################################
        >
        > This message is sent to you because you are subscribed to
        >   the mailing list Lasso [hidden email]
        > Official list archives available at http://www.lassotalk.com
        > To unsubscribe, E-mail to: <[hidden email]>
        > Send administrative queries to  <[hidden email]>
       
        #############################################################
       
        This message is sent to you because you are subscribed to
          the mailing list Lasso [hidden email]
        Official list archives available at http://www.lassotalk.com
        To unsubscribe, E-mail to: <[hidden email]>
        Send administrative queries to  <[hidden email]>
   
   
    #############################################################
   
    This message is sent to you because you are subscribed to
      the mailing list Lasso [hidden email]
    Official list archives available at http://www.lassotalk.com
    To unsubscribe, E-mail to: <[hidden email]>
    Send administrative queries to  <[hidden email]>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>