Menu ▾ ▴

Failed to connect to Oracle, but no problem accessing it with other tools

Help
crazyhty
2015-03-19
2016-02-23

  • crazyhty

    crazyhty - 2015-03-19

    Hi Guys,

    I have no problem accessing oracle DB using PLSQL, SQLplus,etc. My enviornment: win8, oracle 11 client. But I got TNS error like below when I'm trying to use schemaSpy,

    D:\schemaSpyGUI>java -jar schemaSpy.jar -t ora -db EasyTMS_11g -host 10.132.0.87
    -port 1521 -u easytms_dba -p easytms_dba_qa -o D:\ -dp D:\app\Sheena.Heng\produ
    ct\11.2.0\dbhome_1\instantclient\ojdbc14.jar
    Using database properties:
    [schemaSpy.jar]/net/sourceforge/schemaspy/dbTypes/ora.properties

    Failed to connect to database URL [jdbc:oracle:oci8:@EasyTMS_11g]

    java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier s
    pecified

    Appreicate if I could get help from you guys.

    Thank you,
    Crazyhty

     

  • posaunenbaer

    posaunenbaer - 2016-02-23

    do you have configured the connection details for this database in tnsnames.ora?

     

Log in to post a comment.