Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "Msg:ORA-03114: not connected to ORACLE" when running InitialSync for the first time after installing the Oracle database in IDR
Problem Description
In Informatica Data Replication (IDR), when running InitialSync for the first time after installing the Oracle database, the following error is seen:
 
Msg:ORA-03114: not connected to ORACLE
 
The complete log for the Initial Sync process is as follows:
 
* Informatica Data Replication Initial Sync, Version 9.1.1 HF3
* Evaluation Version (This version will expire in 299 days)
* Copyright (c) 2012 Informatica Corporation
* All rights reserved
* Contact support at support@informatica.com
* Informatica Data Replication is running on host [XXXXX] system [Win32]
* Release [Windows NT 6.1] version [Build 7600 ]
* Machine [XXXXX]
 
 
Sync using a database link.
Transferring: SRC.TAB1 -> TGT.TAB1
Error:otl_exception Code:3114
Msg:ORA-03114: not connected to ORACLE
 
Var:
Sql:
Total duration is 10 seconds
​​​​
Cause

​This issue could be caused due to the following reasons:

  • The Listener process is not running.
  • There is a missing entry to the tnsnames.ora.
  • There are network issues.
  • There are problems with connection pooling (shared servers, MTS)
Solution

​To resolve this issue, ensure that the Oracle Listener is started and also that the tnsnames.ora contains the entry. Then perform the InitialSync process.

More Information
Applies To
Product: Universal Data Replication
Problem Type: Configuration
User Type: Administrator
Project Phase: Configure
Product Version:
Database: Oracle
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:1/1/2020 9:36 PMID:145030
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)