Home » Infrastructure » Windows » tnsnames.ora (database 19C)
tnsnames.ora [message #686569] Thu, 13 October 2022 12:26 Go to next message
gladiator511
Messages: 8
Registered: October 2022
Junior Member
About 6 months ago, I installed the Oracle database 19C and have been using it with no problems.
I created several tables in the database with no problems.
This morning, when I went Sqlplus, I got the ORA-12560: TNS:protocol adapter error.
I did not change anything from last night till this morning.
See attached for the errors and files.
Re: tnsnames.ora [message #686570 is a reply to message #686569] Thu, 13 October 2022 13:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68343
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Most likely this means your Oracle service (OracleServiveORCL) is not started or your ORACLE_SID environment parameter is not correctly set (must be ORCL).

[Updated on: Thu, 13 October 2022 13:31]

Report message to a moderator

Re: tnsnames.ora [message #686571 is a reply to message #686570] Thu, 13 October 2022 16:38 Go to previous messageGo to next message
gladiator511
Messages: 8
Registered: October 2022
Junior Member
I had to start the OracleServiveORCL.
My system is back up and running.
Thanks for the quick response and the help.
Re: tnsnames.ora [message #686573 is a reply to message #686571] Fri, 14 October 2022 04:16 Go to previous message
Michel Cadot
Messages: 68343
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thanks for the feedback.

Previous Topic: Reinstall DATABASE 12C
Goto Forum:
  


Current Time: Wed Feb 01 13:47:09 CST 2023