although I set ORA_sid_autostart to true on my oracle 10g server on windows but the database doesn't get started when i restart the related service. I get the ORA-12560: TNS:protocol adapter error, I recreated the service the problem persists. Any ideas?
2006-08-17 04:34:34 · 2 answers · asked by Ramin A 1 in Computers & Internet ➔ Programming & Design
here are some possible suggestions for that error message - http://www.cryer.co.uk/brian/oracle/ORA12560.htm
I haven't personally run into this so I can't vouch for the quality of the tips.
2006-08-17 05:14:39 · answer #1 · answered by John J 6 · 0⤊ 0⤋
You need to start up the TNS listener. This routes messages to the server from a TCP/IP port (1521 by default) the the RDBMS. ORA_sid_autostart will only start the Oracle instance, which I guess you will find is running when you look at your services. However without the listener your screwed.
The command 'lsnrctl start' will start the listener, just not sure how to do that automatically when windows is started.
2006-08-17 15:20:27 · answer #2 · answered by Tim E 1 · 0⤊ 0⤋