Need Help for Comparing schemas via command line

• 
  See the command line documentation:
  https://documentation.red-gate.com/sco5/using-the-command-line/command-line-switches#Commandlineswitches-/source:%3Cvalue%3E
  
  You're current problem is that you're specifying the server's physical IP address which isn't in you TNSNames.ora file (i.e. it thinks the IP is a TNS names entry).
  
  Docs for the direct connection (using host's IP) appear to indicate that you need to specify the service name (DB instance name) after the server host name or IP and before the schema name(s) in the braces {}.
  
  (user/pass|/)@host[:port]/service{SchemaA, SchemaB}
  
  Alternately if you have an entry (DB instance name) that is in your TNSNames.ora file use that instead of the host IP address with your current syntax and that should work just fine:
  
  (user/pass|/)@tns{SchemaA, SchemaB}
  
  

  mbruegel August 14, 2019 08:28

  - 0 +
• 
  See the command line documentation:
  https://documentation.red-gate.com/sco5/using-the-command-line/command-line-switches#Commandlineswitches-/source:%3Cvalue%3E
  
  You're current problem is that you're specifying the server's physical IP address which isn't in you TNSNames.ora file (i.e. it thinks the IP is a TNS names entry).
  
  Docs for the direct connection (using host's IP) appear to indicate that you need to specify the service name (DB instance name) after the server host name or IP and before the schema name(s) in the braces {}.
  
  (user/pass|/)@host[:port]/service{SchemaA, SchemaB}
  
  Alternately if you have an entry (DB instance name) that is in your TNSNames.ora file use that instead of the host IP address with your current syntax and that should work just fine:
  
  (user/pass|/)@tns{SchemaA, SchemaB}
  
  

  mbruegel August 14, 2019 08:28

  - 0 +

Add comment

Please sign in to leave a comment.