haozongcheng
haozongcheng
2017-07-13 04:00
采纳率: 0%
浏览 3.7k

Myeclipse连接远程服务器上的Oracle数据库时连不上,报“用户名/口令无效; 登录被拒绝”

Myeclipse连接远程服务器上的Oracle数据库时连不上,报“用户名/口令无效; 登录被拒绝”,但是用PLsql登陆此账号是可以登录上的,而且其他带电脑上的Myeclipse是可以用这个账号连数据库的

java.sql.SQLException: ORA-01017: 用户名/口令无效; 登录被拒绝

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:785)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:362)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsync

hronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

求大神指点
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

4条回答 默认 最新

  • chenl_
    chenl_ 2017-07-13 04:02

    把你的数据源的配置贴出来看看 啊,光异常看不出什么来啊

    点赞 评论
  • haozongcheng
    haozongcheng 2017-07-13 05:42

    #ATISDB_URL=jdbc:oracle:thin:@tplink20121111.vicp.cc:1521:beatmpdb
    #ATISDB_URL=jdbc:oracle:thin:@localhost:1521:beatmp
    #ATISDB_URL=jdbc:oracle:thin:@192.168.1.31:1521:beatmpdb
    ATISDB_URL=jdbc:oracle:thin:@10.15.0.197:1521:jasdb
    #ATISDB_URL=jdbc:oracle:thin:@192.168.0.7:1521:zb430
    #ATISDB_URL=jdbc:oracle:thin:@nat.nat123.net:41512:itmsdb
    #ATISDB_URL=jdbc:oracle:thin:@tplink20121111.vicp.cc:1521:itmsdb

    #ATISDB_URL=jdbc:mysql://127.0.0.1:3306/itms
    ATISDB_USR=itmszb
    ATISDB_PWD=itms

    JMS_ILGUPLOAD_URL=tcp://localhost:61616
    JMS_ILGUPLOAD_DST=HIATMP.HISENSE.ILLEGAL
    ILGUPLOAD_IMG_ROOT=c:/UploadTest/target
    #GATE_MAPPING_IP=172.25.100.22-10.49.203.4;172.25.100.17-10.49.203.4:9080;172.25.100.31:81-10.49.203.4:10085;172.25.100.31-10.49.203.4:10083;172.25.100.32-10.49.203.4:10082;172.25.100.25-10.49.203.4;172.25.100.18:8088-10.49.203.4:10081;
    GATE_MAPPING_IP=10.49.203.4:10081

    POSTGRESQL_USR=postgres
    POSTGRESQL_PWD=postgres
    POSTGRESQL_DBNAME=wuxi
    POSTGRESQL_SERVERNAME=192.168.1.127
    POSTGRESQL_PORT=5432

    GIS=OPENGIS GIS=PGIS

    GISTYPE=OPENGIS

    IN_MAPS_ERVER_URL=http://10.15.0.197:8000/MapServer/
    EX_MAPS_ERVER_URL=http://10.15.0.197:8000/MapServer/
    MAPS_ERVER_LIST=http://192.168.1.115:8000/MapServer/;http://127.0.0.1:8000/MapServer/;http://192.168.0.115:8000/MapServer/
    IP_SEGMENT_LIST=10.15?192.168.1;192.168.0;127.0.0

    EXTRANET=10.15
    #INTRANET=172.25.100.45:80
    INTRANET=10.15

    ActiveMQ_URL=tcp://192.168.0.222:61616
    FTPIP=172.16.0.217
    FTPPORT=21
    FTPUSER=
    FTPPWD=
    FTPDIR=/
    VIDEOIP=192.168.1.3:8080
    HHXIP=127.0.0.1
    HHXRECEIVEPORT=10096
    HHXSENDPORT=10097
    CITY=wuxi

    dataCollectJob=0 0/5 * * * ?
    data2StatJob=0 0/3 * * * ?
    dayStatJob=0 0/3 * * * ?

    #by leon
    AUTHORCODE=03769880282542245985904106885166
    #by leon for punishment
    ewpro_PUNISH_URL=jdbc:oracle:thin:@localhost:1521:testdb
    ewpro_PUNISH_USR=ewprowf
    ewpro_PUNISH_PWD=ewpro
    username=superm,jc

    连接Oracle的配置文件 连得远程服务器上的,中途改换别的服务器,出的问题,原来没问题
    带#为注释掉的

    点赞 评论
  • u014639382
    叶之秋 2017-07-13 06:51

    ewpro_PUNISH_URL=jdbc:oracle:thin:@localhost:1521:testdb 怎么是localhost

    点赞 评论
  • zhengbingmei
    zhengbingmei 2017-07-14 08:38

    请问你的问题解决了吗?

    点赞 评论

相关推荐