Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages
  1. DB Best Documentation
  2. Migration Platform
  3. Connecting to an Oracle database
Migration Platform
  • Overview
  • Product features
    • Release notes
    • Source and target platforms
    • Third-party applications
  • Getting started
    • Creating a new project
    • Ora2Pg installation
    • Tree view filtering
    • Compatible ODAC versions
    • Opening an existing project
    • Connecting to servers
      • Connecting to an Azure SQL Database
      • Connecting to an Oracle database
      • Connecting to a PostgreSQL database
      • Connecting to a Microsoft SQL Server database
    • Command timeout
  • Mapping
    • Object mapping
    • Error mapping rules
    • Data types mapping
  • Schema conversion
  • Schema comparison
  • Data comparison
  • Data migration
    • Migration task
      • Creating migration tasks
      • Templates
      • Migration options
      • Task actions
      • Task statuses
      • Errors or non-standard situations
    • Installing migration agent
      • Installing and uninstalling the data migration agent
      • Registering the migration agents
    • Project settings
  • Test organizer
    • Creating tests
    • Auto-generating tests
    • Groups and tests execution
    • Groups and tests states and execution statuses
    • Tests moving logic
    • Importing and exporting tests
    • Advanced comparison options
    • Creating reports
    • Error handling
  • Data store
  • Development project
  • System requirements
  • Hot keys
  • Known issues
  • Support

Connecting to an Oracle database

  • Share
    • Share via Facebook
    • Share via Twitter
    • Share via Linkedin

In DB Best Migration Platform, you can connect to an Oracle Database as a source database and as a target database (only for upgrade projects). Use the following procedure to connect to your Oracle database.

  1. Press Ctrl+N or click the New button to create a new project.
  2. Select Oracle in the Source Platform or Target Platform drop-down list.
    DB Best Migration Platform connecting to Oracle new project

    • If the Oracle OLE DB Driver is not installed on your PC, you will need to install it.
    • After installing the driver, restart DB Best Migration Platform and get back to item 1.
  3. Select the SID option in the Connection mode drop-down list if you would like to connect to the Oracle database in the standard mode.DB Best Migration Platform connecting to Oracle standard mode
    • Specify the Server name in the appropriate field. You can enter it manually or select it from the drop-down list (if it has been used already).
    • Provide the rest of connection information to the Oracle database: Server Port, Oracle SID, Schema name, and User name. You can manually enter these values or select them from drop-down lists.
    • Enter the Password to complete the information about Oracle database connection.
    • Check the Use SSL option to establish a secure connection to the Oracle database. Make sure that the Oracle wallet is configured and your database server supports the SSL connection.
    • Press the Connect button to establish the connection to your Oracle database. If the connection credentials you specified are wrong, the application will display the error message.
  4. Select the Service name option in the Connection mode drop-down list if you would like to connect to the Oracle database in the standard mode.DB Best Migration Platform connecting to Oracle service name mode
    • Specify the Server name in the appropriate field. You can enter it manually or select it from the drop-down list (if it has been used already).
    • Provide the rest of connection information to the Oracle database: Server Port, Oracle service name, Schema name, and User name. You can manually enter these values or select them from drop-down lists.
    • Enter the Password to complete the information about Oracle database connection.
    • Check the Use SSL option to establish a secure connection to the Oracle database. Make sure that the Oracle wallet is configured and your database server supports the SSL connection.
    • Press the Connect button to establish the connection to your Oracle database. If the connection credentials you specified are wrong, the application will display the error message.
  5. Select the TNS mode option in the Connection mode drop-down list if you would like to connect to the Oracle database in TNS mode.DB Best Migration Platform connecting to Oracle TNS mode
    • Specify the Connection ID in the appropriate field. You can enter it manually, select it from the drop-down list (if it has been used already) or load it from your local TNSNames.ora file.
    • Enter User name (can be selected from the list of previously used usernames).
    • Enter the Password to complete the information about Oracle database connection.
    • Press the Connect button to establish the connection to your Oracle database. If the connection credentials you specified are wrong, the application will display the error message.
  6. Choose the Connection String option in the Connection mode drop-down list if you would like to connect to the Oracle database using a special connection string.DB Best Migration Platform connecting to Oracle Connection string mode
    • Enter the Connection string manually or edit the proposed one.
    • Press the Connect button to establish the connection to your Oracle database. If the connection credentials you specified are wrong, the application will display the error message.

Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].

Did this page help you?

Provide Feedback
PreviousConnecting to an Azure SQL Database
Next Connecting to a PostgreSQL database

Did this page help you? Yes

Thanks for letting us know that we did a great job.

Did this page help you? No

Thanks for letting us know that there is a problem on this page.

Send Feedback

Feel free to share your ideas or occurred issues with us. The DB Best team will be happy to make our documentation better.

Please, specify your email address so that we can reach out to you to clarify your question. Also, we will use this email address to notify you about solving the issue.

* marks the mandatory fields

Dark theme Light theme

© 2002–2021 DB Best Technologies, LLC. All rights reserved.