DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: TNS error - service not found

  1. 06-10-2005, 03:41 PM #11
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    temporarily move the sqlnet.ora and try then

    sqlplus xxx@DQMDB
    Reply With Quote Reply With Quote
  2. 06-10-2005, 04:59 PM #12
    roadwarriorDBA
    roadwarriorDBA is offline Member
    Join Date
    May 2005
    Posts
    129
    Originally posted by davey23uk
    temporarily move the sqlnet.ora and try then

    sqlplus xxx@DQMDB

    Tried that yesterday too.

    Here it is again:

    $ rm sqlnet.ora
    $ sqlplus sysshep@DQMDB

    SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jun 10 16:40:41 2005

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Enter password:
    ERROR:
    ORA-12154: TNS:could not resolve service name
    Reply With Quote Reply With Quote
  3. 06-10-2005, 05:17 PM #13
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    is TNS_ADMIN env variable set and pointing elsewhere?
    Reply With Quote Reply With Quote
  4. 06-10-2005, 05:27 PM #14
    roadwarriorDBA
    roadwarriorDBA is offline Member
    Join Date
    May 2005
    Posts
    129
    Originally posted by davey23uk
    is TNS_ADMIN env variable set and pointing elsewhere?
    Sure feels like it but its not..its how I nav to the dir to work on the files..

    echo $TNS_ADMIN
    /usr/ora92/OraHome/network/admin


    Feels like something is wrong with the binaries or something. Which is why I tried to couch the Thread in, when have you had a 12154 error that was NOT related to the listener.ora/sqlnet.ora/tnsnames.ora.

    Its a weird one and they have not given me the clients Metalink ID yet so I cannot throw it over the wall to Oracle.

    Why the trace does not show a problem is frustrating, 2000 pages of nothing useful.
    Reply With Quote Reply With Quote
  5. 06-10-2005, 05:39 PM #15
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    last suggestion from me then im out of ideas

    try this, you are basically supplying the connect info directo to sqlplus so bypassing the tnsnames file (make sure you have no spaces anywhere, its all on one line and the details are correct)
    Code:
    sqlplus system/manager@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.x)(PORT=1530)))(CONNECT_DATA=(SERVER=DEDICATED)(SID=dqmdb)))
    If that doesnt work id start questioning the listener
    Reply With Quote Reply With Quote
  6. 06-10-2005, 07:08 PM #16
    roadwarriorDBA
    roadwarriorDBA is offline Member
    Join Date
    May 2005
    Posts
    129
    You betcha - that worked ( I had to alter it a bit )

    so that means the TNS file is whack. Funny we retyped it in yesterday.
    Reply With Quote Reply With Quote
  7. 06-10-2005, 07:40 PM #17
    roadwarriorDBA
    roadwarriorDBA is offline Member
    Join Date
    May 2005
    Posts
    129
    Thanks Davey!

    I will use that approach in the future.

    This worked and was then ported into the TNS file and its working for everyone now.

    sqlplus
    'dqm/dqm@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=123.123.123.123)(PORT=1530)))(CONNECT_DA TA=(SERVICE_NAME=dqmdb)))'


    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width