Informatica 10.4使用指南-安装infa serv

2020-01-08  本文已影响0人  多彩海洋

本文篇幅较长,需做好心里准备:)

1.准备两个用户以存储元数据,配置环境变量及定位日志位置。

domain configuration repository database
Model repository database
PowerCenter repository database

注意:配置环境变量,使用单独的用户安装infa,安装的路径必须非root用户非root组,使用chown 用户 文件夹
chgrp 用户组 文件夹 修改对应的用户和组。

日志查看logs/node01/catalina.out和node.log。

export JAVA_HOME=/usr/java/jdk1.8.0_181
export PATH=$JAVA_HOME/bin:$PATH
export INFA_HOME=/opt/soft/informatica/
export PATH=$INFA_HOME/tomcat/bin:$PATH
export ORACLE_HOME=/opt/ora_client
export LD_LIBRARY_PATH=/opt/ora_client
export LD_LIBRARY_PATH=/opt/soft/informatica/server/bin:$LD_LIBRARY_PATH

注意: powercenter的连接字符串需要使用TNS文件配置之后的dbname。

2.进入安装过程

***************************************************************************
* Welcome to the Informatica 10.4.0 Installer. *
***************************************************************************

Before you continue, read the following documents for version 10.4.0:

Do you want to continue? (Y/N)y
The installer requires Linux kernel version 2.6.32-431 or a later version of the 2.6.32 series or version 3.10.0-0 or a later version of the 3.10.0 series.

Select one of the following options to install or upgrade:

  1. Install and configure Informatica version 10.4.0 products.
    Choose this option if one or more of the following conditions is true:
  1. Upgrade Informatica products to version 10.4.0.
    Choose this option if one of the following conditions is true:
  1. Configure the Enterprise Data Catalog or Enterprise Data Preparation version 10.4.0 services on a node in the domain. Choose this option if you installed the binaries and one of the following conditions is true:
  1. Install or upgrade Data Transformation Engine.

Choose an installation option(1 or 2 or 3 or 4):1


Checking for an Informatica 10.4.0 installation.
To verify whether the machine meets the system requirements for the Informatica installation or upgrade, run the Pre-Installation 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 System Check Tool (i10Pi).
  2. Run the Informatica Kerberos SPN Format Generator.
  3. Run the installer.
    (Default: 3)1
    Preparing to install
    Extracting the installation resources from the installer archive...
    Configuring the installer for this system's environment...

Welcome - Step 1 of 4


[ 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. ]

Informatica Pre-Installation (i10Pi) System Check Tool

The Pre-Installation (i10Pi) System Check Tool verifies the minimum system and database requirements for the Informatica services installation or upgrade.

Copyright (c) 1993-2019 Informatica LLC. All Rights Reserved.
See patents at https://www.informatica.com/legal/patents.html
Press <Enter> to continue ...


System Information - Step 2 of 4


[ 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. ]

Informatica installation directory (default:- /root): /opt/soft/informatica

Informatica starting port number (default:- 6005): 60005


Database and JDBC Connection Information - Step 3 of 4


[ 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
5->PostgreSQL
(Default: 1):

Database user ID (default:- admin): resdb

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): 10.x.x.129:1521

Database service name (default:- ServiceName): bidwtest

Configure JDBC parameters
* 1->Yes
2->No
(Default: 1):

JDBC parameters (default:- MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true):


System Check Summary - Step 4 of 4


[ 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. ]

Informatica Pre-Installation (i10Pi) System Check Tool Results
[Fail] OPEN_CURSORS Parameter: Cannot determine the number of open cursors in the database. If you are installing or upgrading Informatica, set OPEN_CURSORS to 4000 or higher.
[Pass] Disk Space: Available disk space is 4,761,016 MB. Sufficient for the Informatica installation.
[Pass] Processors: Available number of processors is 56. Sufficient for the Informatica installation.
[Pass] Physical Memory: Available physical memory is 263,576 MB. Sufficient for the Informatica installation.
[Pass] Temporary Space: Available temporary disk space is 162,404 MB. Sufficient for the Informatica installation.
[Pass] Ports: Port range is 60,005 - 60,009. All port numbers within the port range are available for the Informatica installation.
[Pass] Locale Environment Variable: The LANG environment variable is set to language en_US.UTF-8. The LC_ALL environment variable is set to language null. Sufficient for the Informatica installation.
[Pass] JRE_HOME Environment Variable: The JRE_HOME environment variable does not contain a value. Sufficient for the Informatica installation.
[Pass] File Descriptor Limits: The file descriptor limits per process is 65536. Sufficient for the Informatica installation.
[Pass] RESOURCE Privilege: The database user account has the RESOURCE privilege. Sufficient for the Informatica installation.
[Pass] CREATE TABLE Privilege: The database user account has the CREATE TABLE privilege. The installer successfully created a database table.
[Pass] INSERT RECORD Privilege: The installer successfully inserted a record into database table.
[Pass] DELETE RECORD Privilege: The installer successfully deleted a record from database table.
[Pass] CREATE VIEW Privilege: The database user account has the CREATE VIEW privilege. The installer successfully created a database view.
[Pass] DROP VIEW Privilege: The database user account has the DROP VIEW privilege. The installer successfully dropped a database view.
[Pass] DROP TABLE Privilege: The database user account has the DROP TABLE privilege. The installer successfully dropped a database table.
[Information] Informatica installation directory: /opt/soft/informatica
[Information] Informatica Starting Port Number: 60005
[Information] Database Type: oracle
[Information] Database User ID: resdb
[Information] Database Host Name: 10.x.x.129
[Information] Database Port Number: 1521
[Information] Database Service Name: bidwtest
[Information] Operating System: Operating system is Linux. Operating system version is 3.10.0-957.el7.x86_64.
[Information] RAM: The memory module size is 263,576 MB.
[Information] Virtual Memory: Virtual memory is set to unlimited.
[Information] Database Version: Oracle Database 12c
[Information] Verified that the database does not contain any public synonyms.

Press Enter to quit the pre-installation system check...

  1. Run the Informatica Kerberos SPN Format Generator
  2. Run the Informatica services installation
    (Default: 2)
    Preparing to install
    Extracting the installation resources from the installer archive...
    Configuring the installer for this system's environment...

Welcome - Step 1 of 16


[ 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-2019 Informatica LLC. All Rights Reserved.
See patents at https://www.informatica.com/legal/patents.html

Subject to your opt-out rights described below, the Software will automatically transmit to Informatica in the USA information about the computing and network environment in which the Software is deployed and the data usage and system statistics of the deployment. This transmission is deemed part of the Services under the Informatica privacy policy and Informatica will use and otherwise process this information in accordance with the Informatica privacy policy available at http://www.informatica.com/privacy-policy.html. You may disable this transmission in the Administrator tool, Help > About Informatica Administrator > Usage Collection Policy > uncheck [ Enable Usage Collection ].

I agree to the terms and conditions.
* 1->No
2->Yes
(Default: 1):2


Component Selection - Step 1A of 16


[ 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 installation options for version 10.4.0:
* 1->Install and configure Informatica domain services. You can install:
-Only traditional products such as PowerCenter and Informatica Data Quality
-Only the Data Engineering products for Integration, Quality, and Streaming
-Traditional products and the aforementioned Data Engineering products

Select this option to install version 10.4.0 domain services and the application service binaries to support Data Engineering Integration and Data Engineering Streaming.
2->Install and configure Enterprise Data Catalog. You can install:
-Enterprise Data Catalog binaries in an existing domain. After you install the binaries, you can run the installer again to configure the services.
-Data Engineering products and Enterprise Data Catalog
3->Install and configure Enterprise Data Preparation. You can install:
-Only Enterprise Data Preparation binaries in an existing domain with Enterprise Data Catalog. After you install the binaries, you can run the installer again to configure the services.
-Enterprise Data Catalog and Enterprise Data Preparation binaries in an existing domain. After you install the binaries, you can run the installer again to configure the services.
-Data Engineering products, Enterprise Data Catalog, and Enterprise Data Preparation.
(Default: 1):1

Do you want to enable Kerberos network authentication for the Informatica domain?
* 1->No
2->Yes
(Default: 1):


Installation Prerequisites - Step 2 of 16


[ 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: 17.5 GB

Memory (RAM): 8 GB

Number of CPU cores: 8

Database requirements for the domain configuration repository:

Pre-installation Tasks

Press <Enter> to continue ...


Deployment Type Tuning - Step 2A of 16


[ 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. ]

If you are installing Data Engineering products or Enterprise Data Catalog, the installer can tune the application services for better performance based on the deployment type in your environment. If you do tune services during installation, you can tune the services later through infacmd.

The installer cannot tune the PowerCenter services. If you are installing PowerCenter, press 1 to continue without tuning.
Do you want the installer to tune the services?
* 1->No
2->Yes
(Default: 1):2

If you are joining the node to existing domain, ensure the deployment type you select here is same deployment type as the gateway nodes.

Select the deployment type associated with the Informatica environment:
1->Sandbox
Choose this option if the environment is used for proof of concepts or as a sandbox environment with minimal users. Sandbox environments are typically configured with 16 cores, 32 GB RAM, and about 50 GB disk space.
* 2->Basic (Default)
Choose this option if the environment is used for low volume processing environments with low levels of concurrency. Basic environments are typically single- or multi-node setups configured with 24 cores, 64 GB RAM, and about 100 GB disk space.
3->Standard
Choose this option if the environment is used for high volume processing but with low levels of concurrency. Standard environments are typically multi-node setups configured with 64 GB RAM, more than 100 GB disk space per node, and 48 cores across nodes.
4->Advanced
Choose this option if the environment is used for high volume processing with high levels of concurrency. Advanced environments are typically multi-node setups configured with 128 GB RAM, more than 100 GB disk space per node, and 96 cores across nodes.
(Default: 2):4

Warning:

Recommended hardware requirements:

Processor speed: 2500 MHz
Number of cores: 96 cores (4 nodes of 24)
Recommended RAM: 128 GB
Recommended disk space: 100 GB
Number of file handles: 64000
Maximum number of user processes: 12000

Do you want to change the deployment type or continue with the current deployment selection?

Select a choice
* 1->Change the deployment type.
2->Continue with the current deployment selection.
(Default: 1):2


License and Installation Directory - Step 3 of 16


[ 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 installation directory (default:- /opt/soft/informatica):

Enter the path to the license key file (default:- /root/license.key): /home/bigdata/Informatica_10.4_trial_20191227.key

Warning: The installer cannot tune PowerCenter services and will skip this step.

Press <Enter> to continue...


Pre-Installation Summary - Step 4 of 16


[ 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.4.0

Installation Type : New Installation

Installation Directory : /opt/soft/informatica

Disk Space Requirements:

Required Disk Space : 16,181 MB

Available Disk Space : 4,761,020 MB

Press <Enter> to continue ...


Installing


Installing... 1%

Installing... 2%

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 5 of 16


[ 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. ]

Do you want to create a domain or join a domain?
* 1->Create a domain.
2->Join a domain.
(Default: 1):

Do you want to enable secure communication for the domain?
* 1->No
2->Yes
(Default: 1):
1->Enable HTTPS for Informatica Administrator.
* 2->Disable HTTPS
(Default: 2):

Do you want to enable Security Assertion Markup Language (SAML) authentication?
* 1->No
2->Yes
(Default: 1):


Domain Configuration Repository - Step 6 of 16


[ 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 database information for the domain configuration repository.

Database type:
* 1->Oracle
2->SQLServer
3->DB2
4->Sybase
5->PostgreSQL
(Default: 1):

Database user ID (default:- resdb):

Database user password:

Configure the database connection:
* 1->Enter the JDBC URL.
2->Enter the JDBC connect string.
(Default: 1):

Database address (default:- 10.3.4.129:1521):

Database service name (default:- bidwtest):

Do you want to configure JDBC parameters?
* 1->Yes
2->No
(Default: 1):

JDBC parameters (default:- MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true):


Domain Security - Encryption Key - Step 7 of 16


[ 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. ]

Provide information to generate an encryption key.

Keyword:

Encryption key directory (default:- /opt/soft/informatica/isp/config/keys):

Information: The encryption key gets generated in a file named siteKey in the following location: /opt/soft/informatica/isp/config/keys .
Save the name of the domain, the keyword for the encryption key, and the encryption key file in a secure location. If you change the encryption key for the domain or move the domain configuration repository to another domain, you must provide the domain name, keyword, and encryption key.

Press <Enter> to continue...


Domain and Node Configuration - Step 8 of 16


[ 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 following information for the Informatica domain.

Domain name: (default:- Domain):

Node host name: (default:- sdw2):

Node name: (default:- node01): node001

Node port number: (default:- 60005):

Domain user name: (default:- Administrator):

You can choose to enable password complexity to secure sensitive data in the domain.

The password must meet the following requirements:
It must be at least eight characters long and contain at least one alpha character, one numeric character, and one special character.

Do you want to enable password complexity?
1->Yes
* 2->No
(Default: 2):

Domain password:

Confirm password:

Do you want to display the advanced port configuration page?
* 1->No
2->Yes
(Default: 1):

Do you want to configure Informatica services and connections? Informatica services include the Model Repository Service, Data Integration Service, Content Management Service, PowerCenter Repository Service, and PowerCenter Integration Service. Informatica connections include profiling warehouse connection and the connections associated with the cluster configuration.
* 1->Yes
2->No
(Default: 1):

Generating encryption key...

Defining the domain...

Registering the plug-in...

Starting the service...

Pinging the domain...

Pinging the domain...

Pinging the domain...

Pinging the domain...

Pinging the domain...

Pinging Informatica Administrator...

Pinging Informatica Administrator...

Pinging Informatica Administrator...

Pinging Informatica Administrator...

Pinging Informatica Administrator...

Pinging Informatica Administrator...

Pinging Informatica Administrator...

Pinging Informatica Administrator...

Pinging Informatica Administrator...

Pinging Informatica Administrator...


Configure Informatica application services - Step 9 of 16


[ 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. ]

Do you want to create the Model Repository Service and Data Integration Service?
* 1->Yes
2->No
(Default: 1):

Do you want to create a monitoring Model Repository Service to monitor domain statistics?
1->Yes
* 2->No
(Default: 2):

Do you want to configure Content Management Service for data domain discovery?
* 1->Yes
2->No
(Default: 1):

Do you want to configure the profiling warehouse connection?
* 1->Yes
2->No
(Default: 1):

Do you want to create a PowerCenter Repository Service and a PowerCenter Integration Service?
* 1->Yes
2->No
(Default: 1):


Model Repository Database - Step 9A of 16


[ 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 Model Repository Service name (default:- Model_Repository_Service):

Enter repository database information for the Model Repository Service:

Database type:
* 1->Oracle
2->SQLServer
3->DB2
4->PostgreSQL
(Default: 1):

Database user ID (default:- admin): RESDB1

Database user password:

Is the database secure?
1->Yes
* 2->No
(Default: 2):

Configure the database connection:
* 1->Enter the JDBC URL.
2->Enter the JDBC connect string.
(Default: 1):

Database address (default:- 10.x.x.129:1521):

Database service name (default:- bidwtest):

Do you want to configure JDBC parameters?
* 1->Yes
2->No
(Default: 1):

JDBC parameters (default:- MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true):

Validating the service name...

Creating the Model Repository Service...

Assigning the license to Model Repository Service...

Tuning the Model_Repository_Service...

Enabling the Model Repository Service...

Creating content for the Model repository...


Data Integration Service - Step 9C of 16


[ 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 Data Integration Service name (default:- Data_Integration_Service):

Select the HTTP protocol to use for the Data Integration Service:
* 1->http
2->https
3->http&https
(Default: 1):

Enter the HTTP Port (default:- 8095):

Do you want to enable data engineering recovery for the Data Integration Service?
1->Yes
* 2->No
(Default: 2):

Validating the service name...

Creating the Data Integration Service...

Assigning the license to Data Integration Service...

Tuning the Data_Integration_Service...

Enabling the Data Integration Service...


Content Management Service Parameters and Database - Step 9D of 16


[ 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 configuration parameters for the Content Management Service.

Content Management Service name (default:- Content_Management_Service):

Enter protocol for the Content Management Service:
* 1->http
2->https
(Default: 1):

Enter the HTTP Port (default:- 8105):

Enter reference data warehouse database information for the Content Management Service:

Database type:
* 1->Oracle
2->SQLServer
3->DB2
(Default: 1):

Database user ID (default:- admin): RESDB1

Database user password:

Configure the database connection:
* 1->Enter the JDBC URL.
2->Enter the JDBC connect string.
(Default: 1):

Database address (default:- 10.3.4.129:1521):

Database service name (default:- bidwtest):

Do you want to configure JDBC parameters?
* 1->Yes
2->No
(Default: 1):

JDBC parameters (default:- MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true):

Data access connection string: bidwtest

Validating the service name...

Warning: The database already contains a model repository.
The recommended approach is to use different database details for all the services.
Select Continue to use the same database.
Select OK to provide a different database.

Select a choice
* 1->OK
2->Continue
(Default: 1):2

Creating the Content Management Service...

Creating the Content Management Service...

Tuning the Content_Management_Service...

Creating the Content Management Service...

Enabling the Content Management Service...

Creating content for the audit tables...


Profiling Warehouse Connection Database - Step 9E of 16


[ 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 database information for the profiling warehouse:

Database type:
* 1->Oracle
2->SQLServer
3->DB2
(Default: 1):

Database user ID (default:- admin): RESDB1

Database user password:

Configure the database connection:
* 1->Enter the JDBC URL.
2->Enter the JDBC connect string.
(Default: 1):

Database address (default:- 10.x.x.129:1521):

Database service name (default:- bidwtest):

Do you want to configure JDBC parameters?
* 1->Yes
2->No
(Default: 1):

JDBC parameters (default:- MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true):

Data access connection string: bidwtest

Warning: The database already contains a model repository.
The recommended approach is to use different database details for all the services.
Select Continue to use the same database.
Select OK to provide a different database.

Select a choice
* 1->OK
2->Continue
(Default: 1):2

Creating the data profiling warehouse...

Creating the data profiling warehouse...

Creating the data profiling warehouse...


PowerCenter Repository Service and the PowerCenter Integration Service - Step 11 of 16


[ 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 database information for the PowerCenter repository:

Database type:
* 1->Oracle
2->SQLServer
3->PostgreSQL
(Default: 1):

Database user ID: RESDB1

Database user password:

Database service name for PowerCenter (default:- bidwtest):

PowerCenter Repository Service name (default:- PCRS):

PowerCenter Integration Service name (default:- IS):
/opt/soft/informatica/server/bin
Warning: /opt/soft/informatica/server/bin value is missing from the PATH environment variable and it
might fail to enable the PowerCenter Repository Service.
To enable the service from Informatica Administrator, set the required environment variable and restart the domain.

Select a choice
* 1->OK
2->Continue
(Default: 1):2

Creating the PowerCenter Repository Service...

Warning: The installation encountered one or more of the following application service errors:

If there is a code page mismatch issue in the PowerCenter Repository Service in your locale,
you can create the PowerCenter Repository Service in the Administrator tool later.
When the installation finishes, check the installation log files to verify the errors and resolve the problem.

Press <Enter> to continue...


Post-Installation Summary - Step 16 of 16


Installation Status: SUCCESS

The Informatica 10.4.0 installation is complete.

For more information, see the debug log file:
/opt/soft/informatica/Informatica_10.4.0_Services_2019_12_31_10_32_15.log

Installation Type: New Installation

Informatica Administrator Home Page:
http://sdw2:60008

Product Name: Informatica 10.4.0

Press <Enter> to continue ...

==========================================

之后进入infa Admisitrator web页面进行配置即可。
统一配置:域,数据集成服务,元数据访问服务,模型存储库。

上一篇下一篇

猜你喜欢

热点阅读