Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Fast Clone 10.0
  • All Products

Table of Contents

Search

  1. Preface
  2. Fast Clone Overview
  3. Configuring and Using the Fast Clone Server
  4. Creating Cloning Configuration Files in the Fast Clone Console
  5. Unloading Data from the Source Database
  6. Loading Data to a Target
  7. Remote Configuration Management
  8. Fast Clone Command Line Interface
  9. Troubleshooting
  10. Fast Clone Configuration File Parameters
  11. Glossary

User Guide

User Guide

Back Next

Source Database Parameters

Source Database Parameters

In the [SOURCE] section of the configuration file, specify parameters for connecting to the Oracle source.
The following parameters are supported:
dba_password
A valid password for the specified
dba_userid
 user. If you set the
dba_userid
 parameter to a forward slash (/), Fast Clone ignores the password and uses operating system authentication to control connection to the source database.
If the
encrypt_database_passwords
 parameter is set to false, specify a clear text password. By default, the Fast Clone Console sets the
encrypt_database_passwords
 parameter to true and writes an encrypted password.
dba_userid
A user name that has the authority to connect to the source database. Fast Clone uses this user connection to get table metadata and perform checkpoints before unloading the source data. If you specify a forward slash (/) in this parameter, Fast Clone ignores the password and uses operating system authentication.
The user must have permissions that allow SELECT ANY DICTIONARY and ALTER SYSTEM operations on the source database. The slower alternative is to scan the system tablespace. For Fast Clone to perform a SELECT from dictionary, the source database must be running.
host
The host name or IP address of the computer where the source database runs.
Default value: localhost
instance
The Oracle instance name that Fast Clone uses to connect to the source database. If this parameter is not defined or specifies a forward slash (/), Fast Clone uses the ORACLE_SID environment variable to connect to an Oracle source with the Bequeath protocol. If the TWO_TASK environment variable is defined, Fast Clone uses the TWO_TASK environment variable.
owner
The name of the source schema owner for the tables to be unloaded. This owner name is also the schema name for the tables.
port
The port number that Fast Clone uses to connect to the source database.
Default value: 1521
protocol
The protocol that Fast Clone uses to connect to the source database. Valid values are:
  • TCP
    . Use the TCP/IP protocol.
  • TCPS
    . Use the TCP/IP protocol with the Secure Sockets Layer (SSL).
Default value: TCP

ASM Connection Settings

Use the following parameters if the source database files are managed by Oracle Automatic Storage Management (ASM). Fast Clone connects to an ASM instance to unload data.
asm_instance_defined
Indicates whether Fast Clone connects to an ASM instance. Valid values are:
  • true
    . Fast Clone connects to an ASM instance.
  • false
    . Fast Clone connects to an Oracle source database without ASM.
Default value: false
asm_instance_host
The host name or IP address of the system with the ASM instance.
Default value: localhost
asm_instance_name
The ASM instance name to which Fast Clone connects to unload data.
Default value: No default value is provided.
asm_instance_port
The port number that is used to connect to the ASM instance that is specified in the
asm_instance_name
 parameter.
Default value: 1521
asm_protocol
The protocol that Fast Clone uses to connect to an ASM instance. Valid values are:
  • TCP
    . Use the TCP/IP protocol.
  • TCPS
    . Use the TCP/IP protocol with the Secure Sockets Layer (SSL).
Default value: TCP
asm_sys_password
A password that is defined for the ASM SYS user.
If the
encrypt_database_passwords
 parameter is set to false, specify a clear text password. By default, the Fast Clone Console sets the
encrypt_database_passwords
 parameter to true and writes an encrypted password.
asm_sys_username
The user name of the default Oracle ASM SYS user that was created at Oracle installation, or another user that you define. This user must have SYSDBA privileges.
Default value: SYS
0 COMMENTS
We’d like to hear from you!