Page tree
Skip to end of metadata
Go to start of metadata
Purpose (problem description)

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

Applicable Platform or <Sub Platform Version>

Platform or <Sub Platform Version>

Yes/No

CAST Storage Service / PostgreSQL(tick)
Step by Step scenario
  1. Run the migration tool
  2. Examine logs
Action Plan

Perform the below actions

  1. Check whether the value of the host on the CAST Oracle Management Database matches exactly with what is being used in the tool.
    1. 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 example

      server.domain.com

    2. 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"

  2. 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


Notes/comments

Ticket # 15863

Related Pages


  • No labels