Re: TOAD and ORA-12154

Hi Richard,

I recently had this same error driving me crazy, but only SOMETIMES. I tried everything, and even consulted with QUEST tech support. (Same setup, TOAD with Oracle 8.1.7, Win2K)

It turned out to be that IF I used a TOAD shortcut on the "Quick Launch" part of the windows taskbar, I got the error. The IDENTICAL shortcut on the Desktop or in an Office Menu Bar worked fine.

Why? I have no idea. But, if you are using the QuickLaunch bar to start TOAD, don't do that. :)

I hope this helps.

Anne Nolan

Richard Shea wrote:

> Hi - I've trying to connect from TOAD to Oracle 8.1.7 both running on
> 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
> (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 - 20:35:23 CET