Oracle Database Release 18c New Features for RAC & Grid


ASM and ACFS

Storage Conversion for Member Clusters

You can use ASMCMD commands to administer the configuration of member clusters. For example, you can change the storage method from direct Oracle ASM to indirect Oracle ASM, or change from indirect Oracle ASM to direct Oracle ASM.

ASM Data Reliability Enhancements

This enhancements represents two changes. The first extends the default disk failure timeout interval (DISK_REPAIR_TIME) from 3.6 hours to 12 hours. In many environments, 12 hours is better suited for safe guarding against data loss because of multiple disk failures, and at the same time, reducing unnecessary overhead from prematurely dropping a disk during a transient failure. The second enhancement provides a new Disk Group Attribute called CONTENT_HARDCHECK.ENABLED that allows optionally enabling or disabling Hardware Assisted Redundancy Data (HARD) checking in Exatadata environments. 
These two enhancements provide Exadata customers greater control for how ASM provides essential data protection. Specifically Hardware Assisted Redundancy Data checking and automatic dropping of failed disks from an ASM Disk Group.

ASM Database Cloning

ASM database cloning provides cloning of Multitenant databases (PDBs). This feature works by leveraging ASM redundancy. Previously, as a protection against data loss during hardware failure, ASM provided up to two additional redundant copies of a file’s extents. Flex Disk Groups now can provide up to five redundant copies, in which one or more of the copies can be split off to provide a near instantaneous replica.
The advantage of ASM database cloning, when compared with storage array-based replication, is that ASM database clones replicate complete databases (PDBs) rather than files or blocks of physical storage. Storage array or file system-based replication, in a database environment, requires coordination between database objects being replicated with the underlying technology doing the replication. With ASM database clones, the administrator does not need to understand the physical storage layout. This is another aspect of database-oriented storage management provided with ASM Flex Disk Groups.

Dropping Oracle ASM File Groups With a Cascade Option

You can drop a file group and its associated files (drop including content) using the CASCADE keyword with ALTER DISKGROUP ... DROP FILEGROUP SQL statement.

Converting Normal or High Redundancy Disk Groups to Flex Disk Groups without Restricted Mount

You can convert a conventional disk group (disk group created before Oracle Database18c) to an Oracle ASM flex disk group without using the restrictive mount (MOUNTED RESTRICTED) option.
ASM Flex Disk Groups provides several new capabilities such as quota management and database cloning. In Oracle 18c customers migrating from a Normal or High Redundancy Disk Group environments will benefit by having a seamless means for converting existing Disks Groups to Flex Disk Groups. Before 18c, customers migrating Disk Groups had to have the Disk Groups mounted in a restricted mode that prevented any configuration change during the transition.

Oracle ACFS Remote Service for Member Clusters

In addition to support for Oracle member clusters with attached local storage, Oracle ACFS provides Oracle ACFS remote service for native Oracle ACFS functionality on member clusters with no attached local storage (indirect storage member clusters). Utilizing an Oracle ACFS deployment on the Oracle Domain Services Cluster (DSC), Oracle ACFS remote service can be used for both Oracle Application Clusters and database member clusters to enable a flexible and file system-based deployment of applications and databases. Unlike NFS-based exports, Oracle ACFS remote service fully supports advanced Oracle ACFS features; such as replication, snapshots, and tagging; on the destination member cluster.

Cluster Health Advisor

Cluster Health Advisor Cross Database Analysis Support

In consolidated and DBaaS private cloud deployments multiple databases are sharing the same physical server and its resources. In its previous release Cluster Health Advisor analyzed each hosted database instance individually and could only detect whether the cause of a performance or availability issue was within itself or external. Which its new cross database analysis support, external issues can be targeted to a specific database resulting in higher confidence diagnosis and improved corrective actions.
Early warnings, targeted diagnosis and corrective actions are critical capabilities for modern database deployments designed to be available and performant 24x7. Consolidated and DBaaS private clouds are particularly difficult due to interactions between databases sharing the same physical resources and the one to many DBA to DB staffing within these deployments. Oracle Cluster Health Advisor now supports  analyzing these complex multi-database environments. By surfacing early warning notifications with specific database cause and corrective action speeds triage and allows admins to proactively maintain availability and performance saving IT staffing and downtime dollars.

Cluster Health Advisor Cross Cluster Analysis Support

In its previous release, Oracle Cluster Health Advisor analyzed each cluster node individually. Oracle Cluster Health Advisor could only detect whether the cause of a performance or availability issue was within itself, or external. With the new cross-cluster analysis support, Oracle Cluster Health Advisor can target external issues to a specific cluster node resulting in higher confidence diagnosis and improved corrective actions.
Oracle Cluster Health Advisor's support for targeting the cause of database or cluster performance degradation or impending problems to a specific root cause on a specific node, greatly improves the response time to apply corrective actions and prevent loss of databases availability or violations of SLAs.

General

Shared Single Client Access Names

A shared single client access name (SCAN) enables the sharing of one set of SCAN virtual IPs (VIPs) and Listeners (referred to as the SCAN setup) on one dedicated cluster in the data center with other clusters to avoid the deployment of one SCAN setup per cluster, which not only reduces the number of SCAN-related DNS entries, but also the number of VIPs that need to be deployed for a cluster configuration. 
A shared SCAN simplifies the deployment and management of groups of clusters in the data center by providing a shared SCAN setup that can be used by multiple systems at the same time. 

NodeVIP-Less Cluster

NodeVIP-Less Cluster enables the configuration of a cluster without the need to explicitly configure nodevips on the public network. While the VIP resources on Clusterware level will still be maintained, there is no need to provision additional IPs for each node in the cluster, which in larger cluster estates can potentially save hundreds of IPs per subnet. 
NodeVIP-Less Cluster simplifies cluster deployments and management by eliminating the need for additional IPs per node in the cluster.

Cluster Domain Proxies

Cluster domain proxies provide resource state change notifications from one cluster to another, and enable resources in one cluster to act on behalf of dependencies on resources in another cluster. You can use cluster domain proxies, for example, to ensure that an application in an Oracle Application Member Cluster only starts if its associated database hosted in an Oracle Database Member Cluster is available. Similarly, you can use cluster domain proxies to ensure that a database in an Oracle Database Member Cluster only starts if at least one Oracle Automatic Storage Management (Oracle ASM) instance on the Domain Services Cluster is available.
Cluster Dependency Proxies simplify manageability and increase availability for applications running on distributed infrastructures spanning multiple clusters. 

gridSetup-based Management

Gold image-based installation, using gridSetup.sh or gridSetup.bat, replaces the method of using Oracle Universal Installer for installing Oracle Grid Infrastructure. You can use gridSetup-based management to perform management tasks such as cloning, addNode operations, deleteNode operations, and downgrade using the gridSetup.sh or the gridSetup.bat command.
gridSetup-based management simplifies deployment and deployment-related management tasks with a unified and simple tool.

Reader Nodes Performance Isolation

In the Reader Nodes architecture, the updates made on the read-write instances on the Hub nodes are immediately propagated to the read-only instances on the Leaf nodes, where they can be used for online reporting or instant queries. Reader Nodes Performance Isolation enables OLTP workload on Hub nodes to continue although the associated database instances on the Leaf nodes fail to process the updates.
Horizontal scaling using Reader Nodes is further improved by Reader Nodes Performance Isolation as slow Leaf node-based instances will neither slow down OLTP workload nor otherwise impact it. 

UCP Support for RAC Affinity Sharding

RAC affinity sharding ensures that a group of related cache entries is contained within a single cache partition. When Data Affinity is enabled on the Oracle RAC database, then data on the affinitized tables are partitioned in such a way that a particular partition, or subset of rows for a table, is affinitized to a particular Oracle RAC database instance.
The improved cache locality and reduced internode synchronization with Data Affinity leads to higher application performance and scalability.


Informatica 10.20 Server Installation on OEL7



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/