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?

How's this:

http://www.dbmotive.com/oracle_error_codes.php?errcode=12560

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.

Hai click start database in oracle database 10g folder after its started give your queries this error will not come! U should go as an admin and start database!