Tags: adapter, cmd, connect, cud, database, dos, error, machine, mysql, ora, ora-12560, oracle, prompt, server, sql, thru, tnsprotocol
ORA-12560: TNS:protocol adapter error ?
I have a 9207 on an NT machine.
When trying to connect to db from the server dos cmd prompt, i cud not get thru.
I do have the listener.ora n tnsnames.ora files in place.
listener is also running..
If i DON'T give "set oracle_home =d:\oracle\ora92"
'am able to connect as "sqlplus system/passwd".. but then i wont be able to
connect as sqlplus system.oracle.mscer.com.prod
<<ORA-12154: TNS:could not resolve service name>>
also cannot tnsping too
If i give "set oracle_home =d:\oracle\ora92"
then am able to connect as sqlplus system.oracle.mscer.com.prod and tnsping is OK
but not as "sqlplus system/passwd"
<<ORA-12560: TNS:protocol adapter error>>
Why is it so?
what shoud i do if i want to connect both the ways..??
Leave a comment...
- 2 Comments
- set oracle_sid=SID then login with the host string#1; Sat, 23 Feb 2008 18:13:00 GMT
- i got thru...
i removed oracle_home and set TNS_ADMIN.
Jj#2; Sat, 23 Feb 2008 18:14:00 GMT