TNS-Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: TNS-Error

  1. #1
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97

    TNS-Error

    I try to connect an instance in the proper server and I give the following error.

    Enter user-name: oracle@folha
    Enter password:
    ERROR:

    ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

    If I connect of any another place it does not give error and it functions perfectly.
    Why ?
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

  2. #2
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    If you are using tnsnames file, is it configured with correct service name? What is the default domain in sqlnet.ora file. And what do you mean by "connect to other place". List your tnsnames.ora and sqlnet.ora entry.
    -- Dilip

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    That is like the simplest Oracle error in the world to fix. Real good book on explaining Net8/Oracle Net is O'Reilly's Oracle Net8 Configuration and Troubleshooting.

  4. #4
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97
    I possess other instances in the same server and obtain I connect them. But this new instance does not connect.
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by marcio.68
    I possess other instances in the same server and obtain I connect them. But this new instance does not connect.
    Funny things like that happen when you don't have your connections configured correctly.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97
    I found the problem. The service_name was different of the SID and listner pointed with respect to the SID, therefore inside of the same server I did not obtain to consult the base.
    debtor to all
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

Posting Permissions

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



Click Here to Expand Forum to Full Width