Options
Need Help for Comparing schemas via command line
amaranm
Posts: 1 New member
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}
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
Comments
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}
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}