ORA-12560: TNS:protocol adapter error

thanks for the reply, I install and create database on drive c:\oracle and developer suite on drive d:\oracle9ids. When I use tnsping <sid> in my case "testdb" it goes to check in drive d: path, instead it shoud go to check in drive c:\oracle\network\admin\sqlnet.ora , the path where database software is installed.

So, when I use tnsping command it gives me the following error. I also checked my parameter file , its okay..cause i can log in using sqlplus sign on window like scott/tiger@testdbnet, it works fine.

waiting for further action....

exhibit of tnsping command :
------------------------------------------------------------------------------------------------------

C:\Documents and Settings\obaid>tnsping testdb

TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 - Production on 11-JUN-2003 01:51:42

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
d:\oracle9ids\network\admin\sqlnet.ora
d:\oracle9ids\network\admin\tnsnames.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = peace.com)(PORT = 1521))) (CONNECT_DA
TA = (SERVICE_NAME = TESTDB)))
TNS-12535: TNS:operation timed out

C:\Documents and Settings\obaid>\

-------------------------------------------------------------------------------------------------------------

thanks
Obaid

yes, it works with

SQL> conn / @testdbnet as sysdba
Connected.
SQL>
SQL>
SQL> show user
USER is "SYS"

but, why its not connecting without host string, more strange to me , when i use  "tnsping testdb", why it goes to check in the developer folder path rather then in the database folder path which is in different logical drive, as i mentioned before in this dicussion.

Please help me to resolve this problem...

thanks
Obaid.

thanks angelIII, you have been so helpful so far for me.. now after making changes in registery to set up TNS_ADMIN then i tried again.. it gives me the following result.. this time of course the path has been changed, but there is one error " TNS-03505: Failed to resolve name ".

Could you please tell me now what is the reason for that error, how can i remove it, where this error could make me a problem.. thanks..

waiting for response

OBaid.


C:\>tnsping testdb

TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 - Production on 12-JUN-2003 13:13:59

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
c:\oracle\network\admin\sqlnet.ora
c:\oracle\network\admin\tnsnames.ora

TNS-03505: Failed to resolve name

C:\>