| ORA-12560 TNS:protocol adapter error [message #93492] |
Sat, 02 March 2002 12:00  |
billy stone
Messages: 1
Registered: March 2002
|
Junior Member |
|
|
hello,
I am trying to run the cdemo1 sample on Windows 2000 but I keep getting the ORA-12560: TNS:protocol adapter error. I have set the correct username and password in cdemo1.c before compiling.
I am using Oracle 9i and I have the Oracle Client installed.
I am able to connect to Oracle using the command line with the following command sqlplus qa/tester@TESTSERV and I am also able to connect to Oracle using the Sqlplus Net8 client interface.
I have set ORACLE_HOME on the command line to the path of my oracle home directories. And just for kicks I have also set the ORACLE_SID on the command line to TESTSERV
My tnsnames.ora is configured properly
TESTSERV.COMPANY.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PEPSI)(PORT = 1521))
)
(CONNECT_DATA =
(SID = TESTSERV)
(SERVICE_NAME = TESTSERV.COMPANY.NET)
)
)
None of the methods seem to work.Anyone have any ideas why I can't connect with the cdemo1 but I can connect using command line and SQLPLUS?
-Will
|
|
|
|
|
|
|
|
|
|
| Re: ORA-12560 TNS:protocol adapter error [message #93604 is a reply to message #93492] |
Tue, 30 July 2002 05:52  |
ashok
Messages: 32
Registered: July 2000
|
Member |
|
|
|
in my office lan is there in that one system is oracle dba server is there that is using my client for training purpose suddenly when he connect to sql giving username & password this error is showing, what should i do.reply me soon
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
