Oracle Error 12560:tns Protocol Adapter Error

praveen_369 · #1 Oct 8, 2006, 09:43 PM

Hi,

Whenever I try to log in using SCOTT/TIGER userid, I get the error "ORA ERROR 12560:TNS PROTOCOL ADAPTER ERROR".

I tried starting the listener from administration-> services, but still the problem persists.

can you please suggest a solution?

LTheobald · Oct 10, 2006, 03:48 AM

How's this:

http://www.dbmotive.com/oracle_error...?errcode=12560

tikitime · Mar 27, 2007, 06:49 PM

and this doesn't happen when logging in as any other user?

are you using the correct connect string?

more info needed.. sqlplus at command prompt, tnsnames.ora file ..etc

I presume you are logging in from a different machine than your server, eh?

on the database server, start a command prompt and run
lsnrctl status and see if the listener is up and running.

try lsnrctl stop and lsnrctl start to restart the listener.

let us know what you get from the status command.



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!