Have a look at http://www.cryer.co.uk/brian/oracle/ORA12560.htm

Hi:
If possible, share your tnsnames.ora file for further analysis.

check whether you have the following setting in tnsnames.ora file:
service Name=
(Description=
(address_list=
(address=(protocol = tcp)(Host=<server ip address>)(port = 1521))
)
(Connect_data=
(Server=dedicated)
(Service_name = <your actual sid name>

Durai

Hi,
Kig på MetaLink Note:117976.1 offers tips for diagnosing the TNS-12560 error:
check here for more info:
http://www.dba-oracle.com/t_ora_12560_tns_protocol_adapter_error.htm

I tnspinged the servicename which is turfview in this case.

Please find below the SQL.ORA and TNSNAME.ORA

# SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)


# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

TURFVIEW =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = lsb.co.bw)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = turfview)
    )
  )

And what's in ORACLE_SID? Is ORACLE_HOME set correctly ("C:\oracle\ora92" I assume)?

Where do I find the ORACLE_SID AND ORACLE_HOME  setting

Open a CMD window and type  set
 
 

I typed set at the CMD results below

FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\Administrator
lib=C:\Program Files\Microsoft.NET\OracleClient.Net\
LOGONSERVER=\\LSB-ACC
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system
32;C:\WINDOWS;C:\WINDOWS\System32\Wbem
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 6 Stepping 5, GenuineIntel
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=0605
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
USERDOMAIN=LSB-ACC
USERNAME=Administrator
USERPROFILE=C:\Documents and Settings\Administrator
WF_RESOURCES=C:\oracle\ora92\WF\RES\WFus.RES

Well,
in your case it should be enough to set the variable LOCAL to the service name TURFVIEW -
set LOCAL=TURFVIEW
If this works then consider making this setting permanent by specifying it as a system variable.
wmp
 
 

set as above still getting the error

Hi moqolo,
set none in SQLNET.AUTHENTICATION_SERVICES= (NONE)
and open your path (select properties under my computer and advanced then select envirment variables
and double click path )and add path to your tnsnnames.ora

I'd rather suggest setting LOCAL=TURFVIEW as a system variable.

Use

My Computer -> Properties -> Advanced -> Environment Variables -> System Variables -> New/Edit/Delete (to set the variables)