1
Prepare Databases for the Informatica Domain
Informatica stores data and
metadata in repositories in the domain. Before you create the domain and the
application services, set up the databases and database user accounts for the
repositories.
Set up a database and user
account for the following repositories:
• Domain configuration repository
• Data object cache repository
To prepare the databases, verify
the database requirements and set up the database. The database requirements
depend on the application services that you create in the domain and the number
of data integration objects that you build and store in the repositories.
2
Domain Configuration Repository
Informatica components store
metadata in relational database repositories. The domain stores configuration
and user information in a domain configuration repository.
You must set up a database and
user account for the domain configuration repository before you run the
installation. The database must be accessible to all gateway nodes in the
Informatica domain.
When you install Informatica, you
provide the database and user account information for the domain configuration
repository. The Informatica installer uses JDBC to communicate with the domain
configuration repository.
The domain configuration
repository supports the following database types:
• IBM DB2 UDB
• Microsoft SQL Server
• Oracle
• Sybase ASE
Allow 200 MB of disk space for
the database.
2.1
Oracle Database
Requirements
Use the following guidelines when
you set up the repository on Oracle:
• Set the open_cursors parameter
to 4000 or higher.
• Set the permissions on the view
$parameter for the database user.
• Set the privileges for the
database user to run show parameter open_cursors in the Oracle
database.
When
you run the pre-installation (i10Pi) system check tool, i10Pi runs the command
against the database to identify the OPEN_CURSORS parameter with the domain
database user credentials.
You can run the following query
to determine the open cursors setting for the domain database user account:
SELECT VALUE OPEN_CURSORS FROM
V$PARAMETER WHERE UPPER(NAME)=UPPER('OPEN_CURSORS')
• Verify that the database user
has the following privileges:
CREATE
SEQUENCE
CREATE SESSION
CREATE SYNONYM
CREATE TABLE
CREATE VIEW
• Informatica does not support
Oracle public synonyms for repository tables. Verify that public synonyms have not been created for any
tables in the database.
3
Data Object Cache Database Requirements
The data object cache database
stores cached logical data objects and virtual tables for the Data Integration
Service. You specify the data object cache database connection when you create
the Data Integration Service.
The data object cache database
supports the following database types:
• IBM DB2 UDB
• Microsoft SQL Server
• Oracle
Allow 200 MB of disk space for
the database.
Note: Ensure that you install the
database client on the machine on which you want to run the Data Integration
Service
3.1
Oracle Database Requirements
Use the following guidelines when
you set up the repository on Oracle:
• Verify that the database user
has the following privileges:
CREATE INDEX
CREATE SESSION
CREATE SYNONYM
CREATE TABLE
CREATE VIEW
DROP TABLE
INSERT INTO
TABLE
UPDATE TABLE
• Informatica does not support
Oracle public synonyms for repository tables. Verify that public synonyms have
not been created for any tables in the database.
4
Prepare Database for Installation.
4.1
Setup Database Parameters, Users &
Tablespaces in Oracle.
Set the
open_cursors parameter to 1000
SQL>
show parameter open_cursor;
NAME TYPE
VALUE
------------------------------
---------- ----------
Open_cursors integer 300
SQL> alter system set
open_cursors=1000 scope=BOTH;
System altered.
SQL> show parameter
open_cursor;
NAME TYPE
VALUE
------------------------------
---------- ----------
Open_cursors integer 10000
Create required DB accounts, Tablespace and
& Assign Privileges.
Create Common tablespace for all
accounts.
SQL> create tablespace
infra_tbs datafile '/home/oracle/oradata/infra_tbs.dbf' size 2g autoextend on;
Tablespace created.
Create Repository DB Account.
SQL> create user user_rep
identified by user_rep default tablespace infra_tbs temporary tablespace temp
quota unlimited on infra_tbs;
User created.
SQL> grant connect,resource, CREATE
SEQUENCE,CREATE SESSION,CREATE SYNONYM,CREATE TABLE,CREATE VIEW to user_rep;
Grant succeeded.
Create Domain Infra DB account.
SQL> create user user_dom
identified by user_dom default tablespace infra_tbs temporary tablespace temp
quota unlimited on infra_tbs;
User created.
SQL> grant connect,resource, CREATE
SEQUENCE,CREATE SESSION,CREATE SYNONYM,CREATE TABLE,CREATE VIEW, CREATE INDEX,
SELECT ANY DISCTIONARY to user_dom;
Grant succeeded.
5
Operating System setup.
5.1
Verify processor matching the downloaded software
installation.
[root@oel7 ~#] uname -p
X86_64
Verify the OS Information,
release and OS version etc.,
[root@oel7 ~#] uname -arv
Linux oel7 4.1.12-124.14.3.el7uek.x86_64 #2 SMP Mon Apr 30 18:03:45 PDT 2018 x86_64 x86_64 GNU/Linux
5.2
Temporary Disk space requirement.
While installation installer
writes temporary files to the hard disk, after installation completes these files
will be deleted automatically.
We need min 2GB space for these
temp files.
To check the space use the
following command.
[root&oel7 ~#] df -h /tmp
5.3
Set the file descriptor Limit.
Verify that the operating system
meets the file descriptor requirement. Informatica service processes can use a
large number of files. To prevent errors that result from the large number of
files and processes, you can change system settings with ulimit command if you
use a Bash shell.
[root@oel7 ~#] ulimit -a
Informatica service processes can
use a large number of files. Set the file descriptor limit per process to
16,000 or higher.
The recommended limit is 32,000
file descriptors per process.
To change system settings, run
the limit or ulimit command with the pertinent flag and value.
For example, to
set the file descriptor limit, run the following command:
[root@oel7 ~#] ulimit -n
<value>
Informatica services use a large
number of user processes. Use the ulimit -u command to adjust the max user
processes setting to a level that is high enough to account for all the
processes required by Blaze. Depending on the number of mappings and
transformations that might run concurrently, set the file descriptor limit per
process to 16,000 or higher. Run the following command to set the max user
processes setting:
[root@oel7 ~#] ulimit -u <value>
5.4
Create Unix account if already exist.
On Unix / Linux, create a user
account specially to run Informatica services/deamon.
This user account should have
group privileges on Oracle and Java Groups.
6
Extract Installation Files & Licence Key
6.1
Extract the installer files.
The installer files are
compressed and distributed as a tar file.
Use a native tar or GNU tar
utility to extract the installer files to a directory on your machine. The user
that runs the installer must have read and write permissions on the installer
files directory and execute permissions on install.sh.
You can extract the installer
files in the following ways:
• Installation DVD. Download the
Informatica tar file from the installation DVD to a directory on your machine
and then extract the installer files, or extract the installer files directly
from the DVD to a directory on your machine.
• FTP download. Download the
Informatica installation tar file from the Informatica Electronic Software
Download site to a directory on your machine and then extract the installer
files.
Note: Make sure that you download
the file to a local directory or a shared network drive that is mapped on your
machine. You can then extract the installer files. However, you ca
6.2
Verify the License Key
Before you install the software,
verify that you have the license key available.
You can get the license key in
the following ways:
• Installation DVD. If you
receive the installation files in a DVD, the license key file is included in
the Informatica License Key CD.
• HTTP download. If you download
the installation files from the Informatica Electronic Software Download (ESD)
site, the license key is in an email message from Informatica. Copy the license
key file to a directory accessible to the user account that installs the
product.
Contact Informatica Global
Customer Support if you do not have a license key or if you have an incremental
license key and you want to create a domain.
7
10.20 Installation steps.
=============================================
[oracle@oel7 informatica]$ ./install.sh
OS detected is Linux
\***************************************************************************
\* Welcome to the Informatica 10.2.0 Server Installer. *\***************************************************************************
Before you continue, read the following documents:
* Informatica 10.2.0 Installation Guide, Informatica Release
Guide and Informatica Release Notes.
* B2B Data Transformation 10.2.0 Installation, Configuration
Guide and Release Notes.
You can find the 10.2.0 documentation in the Product
Documentation section at https://network.informatica.com/.
Configure the LANG and LC_ALL variables to generate the
appropriate code pages and
create and connect to repositories and Repository Services.
Do you want to continue? (Y/N)Y
The installer requires Linux version 2.6.32-431 or later
versions of the 2.6.32 series or version 3.10.0-0 or later versions of the
3.10.0 series.
The current operating system Linux version 4.1.12-112.
Current operating system meets minimum requirements.
Select one of the following options to install or upgrade:
1. Install
Informatica.
.Choose this option
if one of the following conditions is true:
* You want to install Informatica services on
a machine that does not have Informatica version 10.2.0.
* You want to
install Enterprise Information Catalog version 10.2.0.
2. Upgrade Informatica.
.Choose this option
if one of the following conditions is true:
* You want to
upgrade the Informatica services on a machine that has Informatica version
10.1.1 or an earlier version installed.
* You want to
upgrade Enterprise Information Catalog version 10.1.1 or an earlier version
installed.
3. Install or upgrade Data Transformation Engine Only.
Choose this option
to install or upgrade only Data Transformation Engine.
Enter the choice(1 or
2 or 3):1
-----------------------------------------------------------
Checking for an Informatica 10.2.0 installation.
To verify whether the machine meets the system requirements
for the Informatica installation or upgrade, run the Pre-Installation
(i10PreInstallChecker) System Check Tool before you start the installation or
upgrade process. Informatica recommends that you verify the minimum system
requirements.
Select one of the
following options:
1. Run the Pre-Installation (i10PreInstallChecker) System
Check Tool
2. Run the Informatica Kerberos SPN Format Generator
3. Run the Informatica services installation
Select the option to
proceed : (Default : 3) 3
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer
archive...
Configuring the installer for this system's environment...
******************************************************************************************************
Welcome - Step 1 of 9
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check
the help contents for this panel or 'quit' to cancel the installation at any
time. ]
Copyright (c) 1993-2017 Informatica LLC. All Rights
Reserved.
See patents at
https://www.informatica.com/legal/patents.html
WHEN YOU SELECT AGREE AND INSTALL THE INFORMATICA PLATFORM,
YOU AGREE TO BE BOUND BY THE PRODUCT USAGE TOOLKIT END USER LICENSE AGREEMENT,
WHICH IS AVAILABLE AT: http://www.informatica.com/us/eula/en-support-eula.aspx.
AS FURTHER DESCRIBED IN THE EULA, YOUR USE OF THE INFORMATICA PLATFORM WILL
ENABLE THE PRODUCT USAGE TOOLKIT TO COLLECT CERTAIN PRODUCT USAGE AND FAILURE
INFORMATION. YOU MAY DISABLE THIS FEATURE AT ANY TIME. FOR MORE INFORMATION ON
HOW TO DISABLE THIS FEATURE, SEE THE INFORMATICA ADMINISTRATOR GUIDE.
I agree to the terms
and conditions
* 1->No
2->Yes
(Default: 1):2
******************************************************************************************************
Component Selection -
Step 1A of 9
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check
the help contents for this panel or 'quit' to cancel the installation at any
time. ]
Select one of the following options to install Informatica
10.2.0 services or Informatica Enterprise Information Catalog version 10.2.0:
* 1->Install
Informatica Services.
Select this option to install Informatica Services version
10.2.0.
2->Install
Informatica Enterprise Information Catalog.
Select this option install Informatica Enterprise
Information Catalog version 10.2.0.
(Default: 1): 1
Enable Kerberos network authentication for the Informatica
domain.
* 1->No
2->Yes
(Default: 1): 1
******************************************************************************************************
Installation Prerequisites - Step 2 of 9
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check
the help contents for this panel or 'quit' to cancel the installation at any
time. ]
Verify the installation prerequisites and complete the
pre-installation tasks before you continue.
Disk Space: 13 GB
Memory(RAM): 6 GB
Database Requirements
- Verify the Oracle, IBM DB2, Microsoft SQL Server, or
Sybase ASE database version.
- Verify the database user account. The account must have
following permissions on the domain configuration
repository, reference data warehouse, and Sybase ASE(applies
only to the domain connection):
- Create tables and views.
- Drop tables and views.
- Insert, update and delete data.
Pre-installation
Tasks
- Get the Informatica license key.
- Verify the minimum system requirements.
- Set the environment variables.
- Verify the port availability.
- Set up the keystore file.
- On UNIX, set the file descriptor limit.
- On UNIX, configure POSIX asynchronous I/O.
- Download and extract the Informatica installer files.
Press <Enter> to continue ...
******************************************************************************************************
License and
Installation Directory - Step 3 of 9
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check
the help contents for this panel or 'quit' to cancel the installation at any
time. ]
Enter the license key file: (default :-
/home/oracle/Downloads/XXXX_AS_MultiOS_V10_UNL_Development_0119100_121111.key)
:
Enter the installation directory: (default :-
/ext_space/informatica) :/home/oracle/informatica
******************************************************************************************************
Pre-Installation
Summary - Step 4 of 9
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check
the help contents for this panel or 'quit' to cancel the installation at any
time. ]
Product Name
: Informatica 10.2.0
Installation Type
: New Installation
Installation Directory
: /home/oracle/informatica
Disk Space Requirements:
Required Disk Space
: 11,563 MB
Available Disk Space
: 26,864 MB
Press <Enter> to continue ...
******************************************************************************************************
Installing - Step 5
of 9
******************************************************************************************************
Installing... 5%
Installing... 10%
Installing... 15%
Installing... 20%
Installing... 25%
Installing... 30%
Installing... 35%
Installing... 40%
Installing... 45%
Installing... 50%
Installing... 55%
Installing... 60%
Installing... 65%
Installing... 70%
Installing... 75%
Installing... 80%
Installing... 85%
Installing... 90%
Installing... 95%
Installing... 100%
******************************************************************************************************
Domain Selection -
Step 5A of 9
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check
the help contents for this panel or 'quit' to cancel the installation at any
time. ]
* 1->Create a
domain
2->Join a
domain
(Default: 1):1
Enable secure communication for the domain.
* 1->No
2->Yes
(Default: 1): 1
1->Enable
HTTPS for Informatica Administrator
* 2->Disable
HTTPS
(Default: 2): 2
Enable SAML authentication
* 1->No
2->Yes
(Default: 1):1
******************************************************************************************************
Domain Configuration
Repository - Step 5B of 9
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check
the help contents for this panel or 'quit' to cancel the installation at any
time. ]
Configure the database for the domain configuration
repository.
Database type:
* 1->Oracle
2->SQLServer
3->DB2
4->Sybase
(Default: 1):1
Database user ID:
(default :- USER_MAD) :user_dom
User password: :
Configure the
database connection
* 1->JDBC URL
2->Custom
JDBC Connection String
(Default: 1):1
Database address: (default :- host_name:port_no)
:oel7.local.domain:1526
Database service name: (default :- ServiceName) :PTRG
Configure the JDBC
parameters?
* 1->Yes
2->No
(Default: 1):1
JDBC parameters (default :-
MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true) :
******************************************************************************************************
Domain Security -
Encryption Key - Step 5C of 9
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check
the help contents for this panel or 'quit' to cancel the installation at any
time. ]
Keyword: : XXXXXXX
Encryption key directory: (default :-
/home/oracle/informatica/isp/config/keys) :
Information !!! The encryption key will be generated in the
/home/oracle/informatica/isp/config/keys
with the file name siteKey. Save the name of the domain, the
keyword for the encryption key,
and the encryption key file in a secure location. You need
to specify the domain name,
keyword, and encryption key when you change the encryption
key for the domain or move a repository to another domain.
Select a Choice
* 1->OK
(Default: 1):
******************************************************************************************************
Domain and Node
Configuration - Step 6 of 9
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check
the help contents for this panel or 'quit' to cancel the installation at any
time. ]
Enter information for the Informatica domain.
Domain name: (default :- Domain) :domain_test
Node host name: (default :- oel7.local.domain) :
Node name: (default :- node01) :oel7
Node port number: (default :- 6005) :
Domain user name: (default :- Administrator) :
Domain password: (default :- ) :
Confirm password: (default :- ) :
Display the Advanced Port Configuration page.
* 1->No
2->Yes
(Default: 1):1
Configure the Model Repository Service and Data Integration
Service.
* 1->Yes
2->No
(Default: 1):1
Executing the Command...
--------
Defining the domain...
-
Registering the plugins...
-
Starting the service...
-
Pinging the domain...
-
Pinging the domain...
-
Pinging the domain...
-
Pinging the domain...
-
Pinging the domain...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
******************************************************************************************************
Model Repository
Database - Step 7A of 9
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check
the help contents for this panel or 'quit' to cancel the installation at any
time. ]
Configure the Model Repository database.
Database type:
* 1->Oracle
2->SQLServer
3->DB2
(Default: 1):1
Database user ID: (default :- admin) :user_rep
User password: :
Secure database
1->Yes
* 2->No
(Default: 2):
Configure the database connection
* 1->JDBC URL
2->Custom
JDBC Connection String
(Default: 1):
Database address: (default :- host_name:port_no)
:oel7.local.domain:1526
Database service name: (default :- ServiceName) :PTRG
Configure the JDBC parameters?
* 1->Yes
2->No
(Default: 1):1
JDBC parameters (default :-
MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true) :
******************************************************************************************************
Application Service
Parameters - Step 7B of 9
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check
the help contents for this panel or 'quit' to cancel the installation at any
time. ]
Model Repository Service name: (default :-
Model_Repository_Service) :
Data Integration Service name: (default :-
Data_Integration_Service) :
HTTP protocol type:
* 1->http
2->https
3->http&https
(Default: 1):1
HTTP Port: (default :- 8095) :
Creating the Model Repository Service...-
Creating the Model Repository Service...-
Creating the Model Repository Service...
-
Updating the Model Repository Service...
-
Enabling the Model Repository Service...
-
Creating the Model Repository Contents...
-
Updating the Model Repository Service...
-
Creating the Data Integration Service...
-
Creating the Data Integration Service...
-
Updating the Data Integration Service...
-
Enabling the Data Integration Service...
-
******************************************************************************************************
Post-Installation
Summary - Step 9 of 9
******************************************************************************************************
Installation Status: SUCCESS
The Informatica 10.2.0 installation is complete.
The system services are disabled by default after the
installation is complete.
You must configure the services and then enable them in the
Informatica Administrator tool.
For more information, see the debug log file:
/home/oracle/informatica/Informatica_10.2.0_Services_2018_05_01_14_55_28.log
Installation Type :New Installation
Informatica Administrator Home Page:
http://oel7.local.domain:6008
Product Name:
Informatica 10.2.0
Press <Enter> to continue ...
http://oel7.local.domain:6008/administrator/