Need Help for Comparing schemas via command line

amaranm

Hi,
I am not able to compare my Oracle DB via command line

i am getting with below error while entering the below command

sco /source MSC_DEPOT_DEV/MSC@10.240.14.31:1521{MSC_DEPOT_DEV} /target MSC_DEPOT_DEV/MSC_DEPOT_DEV@10.240.14.31:1521{MSC_DEPOT_DEV}

Error: No TNS Entry for 10.240.14.31 found, trying to connect using Oracle home

OraClient12Home1

Error: No TNS Entry for 10.240.14.31 found, trying to connect using Oracle home

OraClient12Home1

Reading dependency information

Error: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Unexpected error: Comparison failed

Comparison failed

System.Exception

   at RedGate.Oracle.SchemaCompare.CommandLine.Program.RunComparison(IUsageHelpe

r usageHelper, IDataSource source, IDataSource target, SchemaMapping schemaMappi

ng, Options options, IFilteringDataSource filteringDataSource, ISchemaComparison

State& state)

   at RedGate.Oracle.SchemaCompare.CommandLine.Program.Main(String[] cmdLineargs

)

Use /? for help

mbruegel

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

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}