ORA-01017: invalid username/password; logon denied

Discussion in 'Java' started by aemi, Feb 7, 2007.

  1. aemi

    aemi Guest

    Exception in thread "main" java.sql.SQLException: ORA-01017: invalid
    username/password; logon denied

    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:
    134)
    at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
    at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:259)
    at
    oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
    at
    oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:
    468)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:
    314)
    at java.sql.DriverManager.getConnection(DriverManager.java:
    525)
    at java.sql.DriverManager.getConnection(DriverManager.java:
    171)
    at
    com.hewitt.mb.common.otl.OTLDatabase.<init>(OTLDatabase.java:51)
    at
    com.hewitt.mb.common.otl.CopyOneTable.main(CopyOneTable.java:38)

    SQL*Loader: Release 9.2.0.6.0 - Production on Wed Feb 7 08:58:05 2007



    the part of OTLDatabase where it is showing error is

    public OTLDatabase(String _url, String _schema, String _user, String
    _password) throws ClassNotFoundException, SQLException {
    url = _url;
    schema = _schema;
    user = _user;
    password = "car27max";

    logger.info("Connecting to " + url);
    logger.info("schema: " + schema);
    logger.info("user: " + user);
    logger.info("password: " + password);
    Class.forName("oracle.jdbc.OracleDriver");
    dbConn = DriverManager.getConnection(_url, _user, _password);
    metaData = dbConn.getMetaData();
    }
    and that of CopyOneTable.java is

    OTLDatabase target = new
    OTLDatabase(AppVariables.get("targetdriver.url"),
    AppVariables.get("targetSchemaPattern"),
    AppVariables.get("targetUser"), AppVariables.get("targetPassword"));
    OTLDatabase source = new
    OTLDatabase(AppVariables.get("sourcedriver.url"),
    AppVariables.get("sourceSchemaPattern"),
    AppVariables.get("sourceUser"), AppVariables.get("sourcePassword"));

    can anybody tell me how to remove this error??
    aemi, Feb 7, 2007
    #1
    1. Advertising

  2. aemi

    Lew Guest

    aemi wrote:
    > Exception in thread "main" java.sql.SQLException: ORA-01017: invalid
    > username/password; logon denied
    >
    > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:
    > 134)
    > at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    > at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
    > at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:259)
    > at
    > oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
    > at
    > oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:
    > 468)
    > at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:
    > 314)
    > at java.sql.DriverManager.getConnection(DriverManager.java:
    > 525)
    > at java.sql.DriverManager.getConnection(DriverManager.java:
    > 171)
    > at
    > com.hewitt.mb.common.otl.OTLDatabase.<init>(OTLDatabase.java:51)
    > at
    > com.hewitt.mb.common.otl.CopyOneTable.main(CopyOneTable.java:38)
    >
    > SQL*Loader: Release 9.2.0.6.0 - Production on Wed Feb 7 08:58:05 2007
    >
    >
    >
    > the part of OTLDatabase where it is showing error is
    >
    > public OTLDatabase(String _url, String _schema, String _user, String
    > _password) throws ClassNotFoundException, SQLException {
    > url = _url;
    > schema = _schema;
    > user = _user;
    > password = "car27max";
    >
    > logger.info("Connecting to " + url);
    > logger.info("schema: " + schema);
    > logger.info("user: " + user);
    > logger.info("password: " + password);
    > Class.forName("oracle.jdbc.OracleDriver");
    > dbConn = DriverManager.getConnection(_url, _user, _password);
    > metaData = dbConn.getMetaData();
    > }
    > and that of CopyOneTable.java is
    >
    > OTLDatabase target = new
    > OTLDatabase(AppVariables.get("targetdriver.url"),
    > AppVariables.get("targetSchemaPattern"),
    > AppVariables.get("targetUser"), AppVariables.get("targetPassword"));
    > OTLDatabase source = new
    > OTLDatabase(AppVariables.get("sourcedriver.url"),
    > AppVariables.get("sourceSchemaPattern"),
    > AppVariables.get("sourceUser"), AppVariables.get("sourcePassword"));
    >
    > can anybody tell me how to remove this error??


    It looks like your AppVariables are not returning the correct username or
    password. You might want to do some value checking there, perhaps in the
    debugger, as to what is passed to the OTLDatabase constructor.

    - Lew
    Lew, Feb 7, 2007
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Kirk
    Replies:
    1
    Views:
    6,360
    jfvilas
    May 27, 2010
  2. Froefel
    Replies:
    3
    Views:
    703
    Froefel
    Jul 12, 2007
  3. AAaron123
    Replies:
    2
    Views:
    2,094
    AAaron123
    Jan 16, 2009
  4. Kjell Kristiansson
    Replies:
    0
    Views:
    279
    Kjell Kristiansson
    Nov 30, 2005
  5. Kyung won Cheon

    ORA-12546: TNS:permission denied

    Kyung won Cheon, Feb 18, 2009, in forum: Ruby
    Replies:
    1
    Views:
    865
    Robert Klemme
    Feb 18, 2009
Loading...

Share This Page