Results 1 to 6 of 6
  1. #1
    Join Date
    May 2006
    Posts
    3

    Unanswered: Unable to create Service name in tnsnames.ora

    I am unable to create service name through Oracle netmanager.
    Due to this, I directly entered my entries in tnsnames.ora.

    But when I tried to log in through SQLplus, I got error "TNS could not resolve the connect identifier specified."

    Please help me...Its urgen t....

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Can we see a copy of your TNSNames.ora file so we can tell you what's wrong?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jan 2004
    Posts
    99
    on the command line run tnsping [service name] , if this results in the same message it seems like a minor config issue with your tnsnames.ora post your tnsnames file.

  4. #4
    Join Date
    May 2006
    Posts
    3
    Hi Thanks for replying.

    My tnsnames.ora is as follows.

    NIRAV =
    (DESCRIPTION =
    (ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = TCP)(HOST = SILICON)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = nss)
    )
    )

    For your information---
    1.nssservice is the instance which was created while installing database server.

    2.SILICON is the HOST name. I have also added entry in sys32 host file.

    3.When I fired command "tnsping SILICON", I succeed.
    Got folllowing success message

    "Used EZCONNECT adapter to resolve the alias
    Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=nss))(ADD RESS=(PROTOCOL=TCP)(HOST=SILICON)(PORT=1521)))
    OK (30 msec)"

    But when I fired "tnsping nss", I received following error message.

    "TNS-03505: Failed to resolve name"

    I dont know the difference between two....Can you please explain and the solution too...:-)
    Last edited by niravshah777; 05-05-06 at 04:29.

  5. #5
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    You may need to stop & restart the listener service for the change that you've made to take effect.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  6. #6
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    When you use TNSPING, you need to use the alias you set up for your connection...

    Code:
    NIRAV =
    (DESCRIPTION =
    (ADDRESS_LIST =
    
    (ADDRESS = (PROTOCOL = TCP)(HOST = SILICON)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = nss)
    )
    )
    Your ALIAS for this connection is "NIRAV", your SID is "NSS"... so the proper command line for TNSPING would be: tnsping nirav

    Just so you know, the "tnsping silicon" worked because in your sqlnet.ora file you specified that connections to databases can be specified by using tnsnames entries or hostname -- check for a line similar to this: NAMES.DIRECTORY_PATH = (TNSNAMES,HOSTNAME)
    JoeB
    save disk space, use smaller fonts

Posting Permissions

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