When using Oracle, sometimes the TNS cannot handle the service name. It is actually very simple.
For example, I will report this error when I log in to the Mecon database with the Workflow.
The first found TNSNames.ora file.
E.g
Gsxydj = (description = (address = (protocol = tcp) (host = 1521))) (connection_data = (SID = gsxydj))))
second:
increase
DatabaseName =
(Description = (address_list = (pecol = TCP) (port = DatabaseIP))) (Connect_Data = (SID = DatabaseSID)))
