User Guide

11.0
- 10.0

Back Next

Troubleshooting

If you encounter a problem while using Fast Clone, review the following list of previously reported issues and their solutions before contacting Informatica Global Customer Support.

An ORA-942 "table not found" error occurs when I select an Oracle table owner.: The user that connects to the Oracle database lacks the permissions that Fast Clone requires. Use a user ID that has the required permissions. For more information, see "Setting Up an Oracle User for Connecting to Oracle" in the Fast Clone Installation Guide.
When I run Fast Clone, the following error occurs:: The procedure entry point OCILobClose could not be located in the dynamic link library OCI.dll; The most likely cause of this error is that the Oracle Client is not installed on the remote database server where Fast Clone runs. Download the Oracle Instant Client from the following Web site: http://www.oracle.com/technetwork/database/features/oci/index.html.
During Fast Clone Console startup, the following error occurs:: "'java' is not recognized as an internal or external command, operable program or batch file."; The Fast Clone Console is a Java application that requires the
Java Runtime Environment (JRE) 1.8
.
For Hadoop and Hive Targets, the Fast Clone executable requires 64-bit JRE.
If you do not have a supported JRE version installed, download the JRE from the following web site: http://www.oracle.com/technetwork/java/javase/downloads/index.html. If you have a supported JRE version installed, this error might occur because the java.exe or java executable is not specified in the PATH environment variable.
The Fast Clone Console requires X Window on Linux or UNIX, but we are not allowed to install X Window on a Linux or UNIX system in our environment.: Install and run the Fast Clone Console on a Windows system that is remote from your Linux or UNIX server. To run an unload operation from the Windows system, complete the following steps:
Start gui.cmd on the remote Windows system or gui.sh on the remote Linux or UNIX system. Then create the configuration file.
On the
Runtime Settings
tab >
Files Locations
view, ensure that the
Output directory
value points to the Oracle source system where the data unload job will run.
Copy or FTP the configuration file to the Oracle source system where the data unload job will run.
Start unload.sh on the Oracle source machine.
I downloaded Fast Clone for Sun Solaris. When I run unload.sh, the following error occurs:: FastReader: syntax error at line 1: `(' unexpected; The most likely cause of this error is that you have a Fast Clone version for Solaris that is not compatible with the CPU type. For example, you might have Fast Clone for SPARC III but the CPU type is SPARC II. Download the correct Fast Clone version for the CPU type.
To determine your CPU type, execute the following command:
/usr/platform/sun4u/sbin/prtdiag
When I try to connect to Oracle while running the Fast Clone engine, I get an error that indicates the TNS listener could not resolve SERVICE_NAME given in connect descriptor. However, when I connect to Oracle from the Fast Clone Console, I do not get an error.: The Fast Clone Console uses a JDBC connection driver. With this driver, the Fast Clone Console first tries to use the Oracle SID and then the SERVICE_NAME to establish a connection. The Fast Clone executable uses the SERVICE_NAME by default to connect to the database.
The SERVICE_NAME is specified in a tnsnames.ora connection string as follows:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=port)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=instancename
)))
To resolve this issue, try using the Oracle SID value. Select the
Use SID instead of SERVICE_NAME
option on the
Runtime Settings
tab >
Miscellaneous Conditions
view in the Fast Clone Console. Alternatively, specify the following parameter in the configuration file:
use_sid_instead_of_service=true
You can also configure Fast Clone to connect to the database by using the Oracle Bequeth protocol, without a TNS listener. Either set the parameter
instance=/
in the configuration file or select the
Connect Direct in Informatica Fast Clone Console
option on the
Source DB
tab.
During startup of the Fast Clone Console on UNIX, the following error message is issued:: Exception in thread "main" java.lang.InternalError: Can't connect to X11 window server using 'x.y.z.w' as the value of the DISPLAY variable.; The Fast Clone Console requires an X Window environment on Linux and UNIX systems. However, your X Window environment is not properly configured.
Contact your system administrator for assistance. Verify that you can run X Window programs.
The X Window System is a graphics system on UNIX that provides an infrastructure for displaying windowed graphics. It provides a public protocol by which client programs can query and update information on X servers.
Fast Clone freezes when I try to unload data into a pipe instead of a flat file.: Fast Clone can write data to a pipe while a program or script is reading data from the pipe. If no program or script is reading data from the pipe, Fast Clone might appear to hang.
An ORA-12528 error occurs when I run Fast Clone on an Oracle database server that uses Automatic Storage Management (ASM).: Add the ASM instance to your listener.ora configuration file. Use the following syntax:
(SID_DESC = (SID_NAME = +ASM) (ORACLE_HOME = ORACLE_HOME_PATH) )
Then restart the Oracle listener.

Rename Saved Search

Table of Contents

User Guide

User Guide

Troubleshooting

Troubleshooting