Oracle-L: Not able to connect to database

From: Santosh Varma <vsantosh_at_psi.soft.net>
Date: Mon, 21 Apr 2003 02:41:44 -0800
Message-ID: <F001.00585A62.20030421024144@fatcity.com>

i am getting the following error while accessing my application and also TOAD..
anyone can give me how to solve this ?

ORA-12154: TNS:could not resolve service name

Details:
*** First assume we have a valid install and registry ***
Oracle home is set to C:\oracle
Bin path is set to C:\oracle\bin\
Using: C:\ORACLE\BIN\ORA805.DLL

2) Oracle Home Key is SOFTWARE\ORACLE\HOME1 Looking for TNS_ADMIN environmental variable TNS_ADMIN environmental variable doesnt exist, looking for TNS_ADMIN reg key using home key: >SOFTWARE\ORACLE\HOME1< TNS_ADMIN does not exist in SOFTWARE\ORACLE\HOME1 looking for TNS_ADMIN reg key in \Oracle: >SOFTWARE\ORACLE\HOME1< Looking for OracleHomeKey\ORACLE_HOME
Oracle Path is now C:\oracle\Network\Admin Looking for C:\oracle\Network\Admin\tnsnames.ora tnsnames.ora NOT found!

Santosh

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Santosh Varma
INET: vsantosh_at_psi.soft.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Apr 21 2003 - 05:41:44 CDT