By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
sqlplus user/passI get an ORA-12560 (TNS protocol adaptor error), even though my tnsnames.ora, sqlnet.ora are correct and my ORACLE_SID is set. If I use the fully qualified user/pass@sid, then it connects OK. If I connect from the other computer as "sys/pass@sid as sysdba" it's good. From there if I "shutdown immediate" it's still good -- I can shut the database down. But, when I then "startup" from the other computer, or exit SQL*Plus and try to reconnect, I get the ORA-12514. Why would that be, and why do I need to give the SID in the connect string? The listener is configured correctly (otherwise I would always get the 12514).
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.