Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Posts
    53

    Unanswered: connection problem to database instance

    Hi,

    I am very confuse for this situation.

    I have server with two db instance runing and also even one instance running.

    I am trying to connect to server or db with OEM or any third party tool. but it fails with following error: but it works fine when i physically log in to server with putty or ther unix server. Oracle 9i and 10g on Unix

    TNS-03505 Failed to resolve name

    ORA-12154: TNS:could not resolve service name

    I checked the tnsnames.ora is fine here is the following:

    log =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (HOST = Servername)
    (PORT = 1521)
    )
    )
    (CONNECT_DATA =
    (SID = log)
    )
    )

    here is the SQLnet.ora:


    NAMES.DEFAULT_DOMAIN = domainname

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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
  •