Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008
    Posts
    1

    Unanswered: ORA-12154:TNS:could not resolve the connect identifier specified

    Dear members

    I have oracle 10g and Developer suite installed locally in my system and I have edited my TNSNAMES.ora file and added a entry for VISLINUX(for both Developer suite and oracle DB TNSNAMES.ora files).

    When I use TNSPING comand I get an error for the schemas APPDEV and VISLINUX.

    D:\Documents and Settings\BAR>tnsping appdev

    TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 25-DEC-2
    008 20:22:57

    Copyright (c) 1997, 2003, Oracle. All rights reserved.

    Used parameter files:
    C:\DevSuiteHome_1\network\admin\sqlnet.ora

    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
    (HOST = 70.63.134.203)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = APPDEV)))
    VISLINUX = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 75.
    182.87.181)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = VISLINUX) )
    TNS-12533: TNS:illegal ADDRESS parameters

    D:\Documents and Settings\BAR>tnsping vislinux

    TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 25-DEC-2
    008 20:23:21

    Copyright (c) 1997, 2003, Oracle. All rights reserved.

    Used parameter files:
    C:\DevSuiteHome_1\network\admin\sqlnet.ora

    TNS-03505: Failed to resolve name

    and when I use TOAD to connect the schema's I get the wollowing error
    ORA-12154:TNS:could not resolve the connect identifier specified

    Here are the contents of my TNSNAMES.ora file

    XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = anvesh)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
    (SID = CLRExtProc)
    (PRESENTATION = RO)
    )
    )
    APPDEV =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 70.63.134.203)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = APPDEV)
    )
    )
    VISLINUX =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 75.182.87.181)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = VISLINUX)
    )
    )

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    http://www.orafaq.com/forum/t/138221/74940/

    http://www.orafaq.com/forum/t/88153/0/
    Please read & follow Posting Guidelines as stated in URL above.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •