gkaindia.com

Home > > SSMA 6.0 Oracle to SQL Server 2012 Migration

SSMA 6.0 Oracle to SQL Server 2012 Migration

Advertisement
Hi SSMA Team,
We were migrating data from Oracle(Oracle 10.2.0.5.0)
 to SQL server 2012 via SSMA 6.0 and during the migration experiencing  below error
“ORA-03106: fatal two-task communication protocol error”
We are using SSMA on Windows server 2008 R2 standard 64 Bit server, also SSMA is configured to use basic Oracle provider.
Would you also please let us know what Oracle Client provider is used in SSMA 6.0 to migrate the data, additionally can you please confirm that the driver used for connectivity is " System.Data.OracleClient.OracleConnection"?
We have 891 tables to migrate the data from Oracle to SQL server. Out of 891 table we are getting random failures ranging from 3- 9 tables(Failed tables).
We are getting this error in between the data migration of all tables, as we have done the settings to continue the data migration in case of failures. It continues to migrate data for rest of tables.  We are using SSMA console
V 6.0 to migrate the data.
I can assure you that this is not the permission issue at all (since the migration go successful for other tables and failed only for 3-10 random tables only). Following is the Variable file details we using.
<variable-group name="OracleConnection">
    <variable name="$OracleHostName$"  value="SourceHostname"/>
    <variable name="$OracleInstance$"  value="DP"/>
    <variable name="$OraclePort$"  value="1521"/>
    <variable name="$OracleUserName$"  value="User_name "/>
    <variable name="$OraclePassword$"  value="PWD "/>
    <variable name="$OracleSchemaName$" value="$SchemaName$"/>
  </variable-group>
  <variable-group name="SQLServerConnection">
    <variable name="$SQLServerName$"   value="TargetServerHostWith instance  "/>
    <variable name="$SQLServerDb$"     value="$TagetSQLServerDb$"/>
    <variable name="$SQLServerUsrID$"  value=""/>
    <variable name="$SQLServerPwd$"    value=""/>
  </variable-group>
This issue become a bottleneck for our project deliver, would you please help us to solve the issue at the earliest.
Regards,
Nitin Kushwaha
Advertisement
Hello,
Can you try to connect using Connection Strings?
https://msdn.microsoft.com/en-us/library/hh313162(v=sql.110).aspx
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
Read the other 2 answers
We are planning to migrate our existing environment to SQL 2012. Existing Environment: SERVER1 OS: Windows Server 2003 Standard Edition SQL Server 2005 Standard Edition 2 Node Active/Passive Clustering With Transactional Replication Number of Databas
Hi, We are planning to upgrade our SAP. Our environment: Windows Server 2003, ERP ECC 6, Oracle 10g. Am looking for guides to migrate our Oracle database to SQL Server 2012. With new server, may I know how to convert our data from oracle to SQL Serve
I would like to know if there are any plans for SQL Server 2012 Change Data Capture for Oracle by Attunity to support versions of Oracle 12 and if by when.I have asked from the author of http://blogs.msdn.com/b/mattm/archive/2012/03/26/cdc-for-oracle
Hi, We are trying to use the linked server feature with SQL Server 2012 to connect SQL server and Oracle database. We are concerned about the existing memory leak issue.  For more context please refer to the link. http://blogs.msdn.com/b/psssql/archi
Hi all, I have Oracle 10g on an XP machine, and use the 'Oracle in OraDB10g_home1' driver to read the data. I have another Windows Server 2008 R2 machine on the same network, with SQL Server 2012 on it. What is the best way to read Oracle Tables in S
I am setting up a test environment for CDC with an Oracle system.  I have everything set up to the point where logs are being read and data appears to be getting added to the CDC tables in SQL Server.  However, at different times during the day, the
Hi All, I wanted to replicate oracle huge table to sql server and i am using SSMA.its helpful and fast but can we replicate the table to different name using SSMA.for example i have a table TEST and i wanted to replicate it to SQL_TEST.Can it be poss
Post Author: jonathanaramburo CA Forum: Data Integration Hello, I have an application that uses a table named "events" which conflicts the sys.events view in master database in sql server. The error i was encountering is that, whenever i tried t
Symptom: When you install Reporting Service Point role on a Site System Server running SQL Server 2012 SP1, you may encounter an issue that the Reporting Service Point role cannot be installed. The error log "srsrpMSI.log" and "srsrpsetup.l
Hello, I am getting following error while converting schema from oracle to SQL server using SSMA. I get Errors 1-3 while migrating procedures and error 4 while migrating a table. 1- O2SS0050: Conversion of identifier 'SYSDATE' is not supported. 2- O2
I am trying to link an SQL Server 2000 to SQL Server 2012. From the management studio i am giving the configuration below Other data source Provider --> SQL Server Native Client 10.0 Product name: SQLSERVER Data Source: machines_ip/Servername Provide
EM12c: Add Target SQL Server 2012 Fails Configuration: EM12c platform: Oracle Enterprise Linux 6.2(x86_64) Oracle Enterprise Database 11.2.0.3 (x86_64) Enterprise Manager Cloud Control 12c Release 1 (12.1.0.1) (x86_64) Microsoft SQL Server Plug-In 12
Hi, Previously, I had done OGG integrated capture from downstream mining database. In that case SourceDB, Downstream MiningDB and TargetDB, all databases were Oracle. MiningDB was in sync with source for log shipping and OGG extract was hooked with M
Hi every Please help with two questions. 1. - Obi 11g is supported on Windows Server 2012 and SQL Server 2012? There a compatibility matrix which mention compatibility with versions 2012? 2. - is feasible to install Obi 11g in separate server and ins
Hi all, I'm Migrating a database from MySQL to SQL Server 2012, using SSMA for MySQL v5.2.1258.  I've got the schema migrated over and have resolved any migration issues (stored procedures / views), but when it comes to migrating over the data I'm ju
Hello, I'm wondering if anyone is monitoring SQL Server 2012 with Grid Control. We are using Grid Control 11g and I can't get it to work. Oracle Support tell me its not certified with 11g or 12c ... so just wondering if anyone has got it to work anyw
Greetings Everyone, Your expert views are highly appreciable regarding the following. We at work are evaluation different solutions to achieve data synchronization between oracle and sql server data bases. Data sync i mentioned here is for live appli
I am given a task of migrating the Sybase ASE 11.9 server databases to SQL Server 2012/2014. We have Sybase server installed on Windows server 2000. We are going to setup a SQL Server 2012 on another server machine. We are planning the migration usin
I would like to copy over or migrate our Sybase 11.0 database to SQL Server 2012. the database is about 23 gigs, but from my reading, SSMA will not work on a this version of Sybase ( too old) so I'm trying to use SSIS. Is this even possible? if not c