By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.