https://support.ispirer.com/ 2026-04-25T10:32:05+0000 https://support.ispirer.com/ https://support.ispirer.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2025-06-03T15:49:59+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/advanced-options?rev=1748965799&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Oracle: Advanced Options At the “Target Options” page of SQLWays you can see the button “Advanced”, which opens the window with additional options for target database: Options on the “Advanced” tab for Oracle as a target database are divided into the following sections: text/html 2026-04-17T13:09:54+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/bin-directory?rev=1776431394&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial Oracle: Bin Directory and Utilities to Perform Import SQLWays is able to execute the import process automatically. To perform it, user should provide target database credentials and Bin Directory. Bin Directory is a path to a folder containing command line utility of the target database, such as psql.exe, sqlcmd.exe, mysql.exe and others. With the help of this utility import process is performed. text/html 2023-10-27T14:54:26+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/data-not-loaded?rev=1698418466&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial Data Was Not Loaded: The Program Can't Start because oranfsodm12.dll is Missing from Your Computer Symptoms After running the import process into the Oracle database in the import log file there was no information about the number of loaded rows, and additional .log files with the information about the data load process were not generated in the export directory. text/html 2025-05-05T12:24:18+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/for-insert-option-table-must-be-empty?rev=1746447858&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial For INSERT option, table must be empty Symptoms If we import only data into existing objects, for example, when we migrate large objects and we divide the import into several parts, as described in the article How to Optimize Migration of Large Tables, then during the import process new data is not added to the existing table because of error appears: text/html 2025-06-03T15:49:59+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/non-ansi-symbols?rev=1748965799&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial Preserving Non-Ansi Symbols in Business Logic and Data Symptoms For example when running a conversion in SQLWays on Japanese locale, it doesn't extract Shift-JIS encoding properly, it corrupts all Japanese characters instead. Cause The Oracle option to extract Japanese characters from the source database and to display correctly the Japanese locale has not been set. text/html 2025-10-30T08:49:06+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/numbers-without-precision?rev=1761814146&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial Handling precision issues for Oracle NUMBER columns without precision Description When extracting data from Oracle tables, columns declared as NUMBER without specified precision and scale (i.e., NUMBER instead of NUMBER(p,s)) can lead to precision loss during data export. text/html 2025-03-17T10:42:44+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/odbc-driver-configuration-linux?rev=1742208164&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial Oracle: ODBC Driver Configuration for Linux Follow the instructions to configure the ODBC connection: Set up the TNS Service Names: - tnsnames.ora: ORACLE12.1_HOST_NAME_ORA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host_name)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = service_name) ) ) text/html 2024-04-22T13:17:03+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/odbc-driver-configuration?rev=1713791823&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial Oracle: ODBC Driver Configuration for Windows Please, follow the following steps to specify the ODBC connection: a. Please go to the “ODBC Administrator” choose the TAB “System DSN” and click “Add”. Choose the appropriate Oracle Driver. See the picture: text/html 2024-04-23T16:11:16+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/odbc-driver-installation-linux?rev=1713888676&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial Oracle: ODBC Driver Installation for Linux To obtain the Oracle ODBC driver, you need to install the Oracle ODBC driver on the machine where you will be running the migration. You can download the Oracle ODBC driver from the Oracle official website. You need to select the appropriate version, download and run it. text/html 2024-04-22T13:16:47+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/odbc-driver-installation?rev=1713791807&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial Oracle: ODBC Driver Installation for Windows To obtain the Oracle ODBC driver, you will have to install the Oracle Client on the machine where you will run the migration. You can download the Oracle client, that includes ODBC Driver, from the text/html 2023-12-15T09:17:33+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/ora-00942?rev=1702631853&do=diff Ispirer Website Ispirer Capabilitie: Oracle Migration Free Trial ORA-00942: Table or View Does Not Exist Symptoms After choosing Oracle ODBC connection on a “Source Options” page and clicking “Next” button, you may see the warning message: Cause When we set an ODBC Connection on a “Source Options text/html 2023-10-27T14:50:07+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/ora-12520?rev=1698418207&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial ORA-12520: TNS:Listener Could Not Find Available Handler for Requested Type of Server Symptoms During the import into the Oracle database it asks you for a password with the following preceding statement: ERROR: ORA-12520: TNS:listener could not find available handler for requested type of server Enter user-name: text/html 2023-12-15T09:17:55+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/ora-12638?rev=1702631875&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial ORA-12638: Credential Retrieval Failed Error Message Symptoms When trying to connect to the Oracle database you may receive the following error message: Cause The authentication service failed to retrieve the credentials of a user. Solution text/html 2023-12-14T14:44:44+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/source-user-privileges?rev=1702565084&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial Oracle: Setting Up Source User Privileges SQLWays utility uses select statements to all_*, dba_* and sys.* tables and views in order to extract information about the source DDL for all the objects that need to be converted. So, the following privileges are required to support the export for Oracle objects: text/html 2023-12-14T14:50:52+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/target-user-privileges?rev=1702565452&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial Oracle: Setting Up Target User Privileges When making import into the target database you need to be sure that the target database and all the required schemas exist on the target server. Also the user, that you utilize to connect to the target database and to load all the objects and data, should have appropriate privileges to be able to do that. text/html 2024-04-22T12:23:46+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle/tns-configuration?rev=1713788626&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial TNS Service Name Configuration TNS Service name is the local name of the remote Oracle service. There are 2 ways to specify the TNS Service name: - using “Net Manager”; - using “Oracle Net Configuration Assistant”. Here we will create TNS Service Name via