When using the Oracle to CSS migration tool, no action happens and the tool disconnects as shown in the following log lines:
2019-01-14 13: 13: 36.776 - Starting database migration for configuration: G: \ temp \ oracle_css3 \ configuration_ORA_CSS3.castmigration like this :
2019-01-14 13: 13: 36.823 - Connecting to origin server: jdbc: oracle: thin: @ x.x.x.x: 1521: SID1 user: user1 ...
2019-01-14 13: 13: 37.307 - Connected to: jdbc: oracle: thin: @ x.x.x.x: 1521: SID1 user: user1
2019-01-14 13: 13: 37.307 - Connected to origin server!
2019-01-14 13: 13: 37.307 - Connecting to target server: jdbc: postgresql: //x.x.x.x: 2282 / postgres user: operator ...
2019-01-14 13: 13: 37.354 - Connected to: jdbc: postgresql: //x.x.x.x: 2282 / postgres user: operator
2019-01-14 13: 13: 37.354 - Connected to target server!
2019-01-14 13: 13: 37.370 - Working folder: C: \ Users \ local_user\ AppData \ Local \ Temp \ CAST \ CAST \ 8.2 \ AIPDatabaseMigrationTool_20190114_131337
2019-01-14 13: 13: 37.385 - Validating the configuration ...
2019-01-14 13: 13: 37.401 - Configuration validated!
2019-01-14 13: 13: 37.401 - Disconnected!
2019-01-14 13: 13: 37.401 - Disconnected!
2019-01-14 13: 13: 37.401 - Database migration completed in 0 ms
Documentation for the tool can be found here: Migrating CAST AIP schemas from Oracle Server and Microsoft SQL Server
Platform or <Sub Platform Version> | Yes/No |
---|---|
CAST Storage Service / PostgreSQL |
- Run the migration tool
- Examine logs
Perform the below actions
- Check whether the value of the host on the CAST Oracle Management Database matches exactly with what is being used in the tool.
Run the following query on the CAST Oracle Management Database
SELECT host FROM cms_inf_store_oracle
The result may look something like this:
Query result exampleserver.domain.com
Make sure that the value returned for the result is EXACTLY what is being used for the value of "originserverurl" in the tool, for example with 'server.domain.com' above, the value should be this for the default port and a sid of ORA:
originServerUrl=
"jdbc:oracle:thin:@server.domain.com:1521:ORA"
- If this does not resolve the issue, then report your problem to CAST Technical Support and provide the 273612934
Relevant input
- CAST Support Tool (CST) - alias Sherlock export with the following options CAST Bases Checker, Export Configuration files, Export Computer Environment, Export CAST Bases with Management Base, Knowledge Base, Central base, Measurement Base
- The log of the migration tool
- Detailed information on the error and the steps done
Ticket # 15863