TNS:listener does not currently know of SID

DenisJCilliers

I cant seem to get the sco.exe command line to connect using direct mode

C:\Program Files\Red Gate\Schema Compare for Oracle 6\sco.exe /direct /source:user/password@server.map.ie:1521/xepdb1{schema} /snapshot C:\output\schema_1.0.0.11.onp

I get the error 

Schema Compare for Oracle version:6.0.23.1366: activated, serial number: 389-739-884494-CF6E
Schema Compare for Oracle Command Line - Product version: 6.0.23.1366
Populating database
Error: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
70

What am I doing wrong?

DenisJCilliers

Resolved it seems that my local Tnsnames.ora was missing an environment variable 
 
TNS_ADMIN 
C:\Oracle\product\21c\homes\OraDB21Home2\network\admin