TOAD and ORA-12154

From: Richard Shea <richardshea_at_fastmail.fm>
Date: 15 Jan 2002 15:07:26 -0800
Message-ID: <282f826a.0201151507.33eed25a_at_posting.google.com>

[Quoted] [Quoted] Hi - I've trying to connect from TOAD to Oracle 8.1.7 both running on [Quoted] the same W2K box.

The logon details I provide are :

Database : dev
User/Schema : sys
Password : <password for the sys account>

Because I have been having difficulties I have selected the "Use The TOAD Home" option after going into the "SQL*Net Help" dialog and setting Home0 to be the TOAD Home. I've pasted the contents of that Dialog box at the bottom of this post. I've also pasted the contents of D:\bin\installed\Oracle8i\ora\Network\Admin\tnsnames.ora down there too.

Can anyone why when I try to connect I get : "ORA-12154: TNS:could not resolve service name". When I look at the details of the error dialog I get :

• First assume we have a valid install and registry Building Oracle HOMES List HOME Name OraHome81 added to list. HOME Name orahome0 added to list. Oracle_Home set to TOAD home SOFTWARE\ORACLE\HOME0 *** Oracle home is set to D:\bin\installed\Oracle8i\ora Bin path is set to D:\bin\installed\Oracle8i\ora\bin\ oci.dll found Using: D:\BIN\INSTALLED\ORACLE8I\ORA\BIN\oci.dll

Which doesn't seem to have any obvious errors within it. When I do a ...

TNSPING dev

...I get...

Attempting to contact
[Quoted] [Quoted] (ADDRESS=(PROTOCOL=TCP)(HOST=ss11232)(PORT=1521)) OK (60 msec)

... which again looks OK. Can anyone suggest what I should try next ? Any help would be appreciated.

Here's the contents of the "SQL*Net Help" dialog box ...

Oracle Root

  Oracle_Home = D:\BIN\INSTALLED\ORACLE8I\ORA
  D:\BIN\INSTALLED\ORACLE8I\ORA\BIN is in system PATH
  D:\BIN\INSTALLED\ORACLE8I\ORA\BIN does exist

  Client dll found oci.dll
  oci.dll version: 8.1.7.0.0
  D:\bin\installed\Oracle8i\ora\Network\Admin\tnsnames.ora found.   Oracle Root is valid
HOME0
  Home name = OraHome81

  Oracle_Home = D:\BIN\INSTALLED\ORACLE8I\ORA
  D:\BIN\INSTALLED\ORACLE8I\ORA\BIN is in system PATH
  D:\BIN\INSTALLED\ORACLE8I\ORA\BIN does exist

  Client dll found oci.dll
  oci.dll version: 8.1.7.0.0
  D:\bin\installed\Oracle8i\ora\Network\Admin\tnsnames.ora found.   HOME0 is valid
HOME1
  Home name = orahome0

  Oracle_Home = D:\BIN\INSTALLED\ORACLE8ICLIENT
  D:\BIN\INSTALLED\ORACLE8ICLIENT\BIN is in system PATH
  D:\BIN\INSTALLED\ORACLE8ICLIENT\BIN does exist

  Client dll found oci.dll
  oci.dll version: 8.1.7.0.0
  D:\bin\installed\Oracle8iclient\Network\Admin\tnsnames.ora does not exist.
  HOME1 is valid

... and here's what D:\bin\installed\Oracle8i\ora\Network\Admin\tnsnames.ora looks like ...

####################################

# TNSNAMES.ORA Configuration

File:D:\bin\installed\Oracle8i\ora\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Enterprise Manager V2
# Date..........: Fri Aug 10 05:36:43 GMT 2001

####################################

DEV =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ss11232)(PORT = 1521))     )
    (CONNECT_DATA = (SERVICE_NAME =
dev.ss11232.notherealdomainname.com))
  )

TEST0_SS11232 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ss11232)(PORT = 1521))     )
    (CONNECT_DATA = (SID = test0)(SERVER = DEDICATED))   )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ss11232)(PORT = 1521))     )
    (CONNECT_DATA = (SERVER = SHARED)(SERVICE_NAME = dev.ss11232.notherealdomainname.com)(PRESENTATION = http://admin))   )

# TNSNAMES.ORA Network Configuration File:
D:\bin\installed\Oracle8i\ora\network\admin\tnsnames.ora

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))     )
    (CONNECT_DATA = (SID = PLSExtProc)(PRESENTATION = RO))   ) Received on Wed Jan 16 2002 - 00:07:26 CET