INSTALLATION DOCUMENTS BY RAVI

Showing posts with label INFORMATICA AND DAC. Show all posts
Showing posts with label INFORMATICA AND DAC. Show all posts

Saturday, May 25, 2019

Code page mismatch Error While creating Informatica Integration Service


When trying to create informatica integration service, getting failed with below error:


Code page mismatch. Service process is running in code page [UTF-8 encoding of Unicode] whereas the service is configured in the Admin Console to run in code page [MS Windows Latin 1 (ANSI), superset of Latin1]















Click on View logs to check the error
















Check for the Error message










Resolution:
To resolve this issue under Domain Navigator
Click on Integration Service
And then click on Processes















Select General Properties and click on Edit symbol















Change Code page value to Unicode as below and click on OK




















Click on Properties














Restart the service















Click on OK





















Issue resolved













Monday, November 27, 2017

Steps for backup and restore informatica power center repository

Backup Informatica Power Center Repository:

1. Login to admin console and select repository service























2. Under Actions menu select Repository Contents and then click on Back Up




















3.  Give user name and password and specify the backup file name and click ok























4. After completing we can see the backup file in below location.


















Restore Informatica Power Center Repository:

1. Login to admin console and select repository service
2. Change the repository service operating mode to Exclusive and click ok ok and ok








































3. Under Actions menu select Repository Contents and then click on delete and give user name and password and click ok























4. Now Under Actions menu select Repository Contents and then click on restore.
5. Select the backup repository file to restore and click ok
6. Change the repository service operating mode from Exclusive to Normal

Steps for Restoring Informatica Power Center Repository on new machine:

1. Create a new schema for the new repository.
2. Create a new Repository Service (referencing the new database schema).
3. Select the Do not create content option.
4. Enable the new Repository Service. 
5. It will display a message stating that the repository does not have any content.
6. Restore the backup using this new Repository Service.
7. Enable the new Repository Service to confirm that the restore is successful. 
8. If the Repository Service will display a message indicating that an upgrade is required.
9. Select Action > Repository Contents > Upgrade. 
10. This will start the upgrade of the repository contents.
11. Change the repository mode from Exclusive to Normal.


Steps for backup and restore informatica domain

Backup Informatica Domain:

1. Stop all the informatica services and server








2. Backup the domain using infasetup BackupDomain command utility

Syntax:


infasetup.(bat | sh) BackupDomain -da <database_hostname:database_port> -du<database_user_name> -dp <database_password> -dt <database_type> -ds<database_service_name> -bf <backup_file_name> -dn <domain_name>










Check for the backup file
















Restoring Informatica Domain:

1. Copy the backup file to the new machine
2. Create a database schema and a user account in a supported database
3.  Install informatica on the new machine but do not configure 
4. Copy the files in the <INFA_HOME>/server/infa_shared directories on the original machine to the new machine.
5. Restore the domain configuration backup to the database schema.

Run the infasetup RestoreDomain command to restore the domain configuration in the backup file to the
specified database schema.

Syntax:

infasetup.(bat | sh) RestoreDomain -da <database_hostname:database_port> -du<database_user_name> -dp <database_password> -dt <database_type> -ds<database_service_name> -bf <backup_file_name>

6. Update the database connection information for each gateway node.Gateway nodes must have a connection to the domain configuration database to retrieve and update domain configuration. Run the infasetup Update Gateway Node command on each gateway node to update the database connection information for each gateway node.

Syntax:


infasetup.(bat | sh) UpdateGatewayNode -da <database_hostname:database_port> -du<database_user_name> -dp <database_password> -dt <database_type> -ds<database_service_name> -dn <domain_name>

7. Start all the nodes and enable all application services in domain

Saturday, May 20, 2017

INFORMATICA 9.1.0 INSTALLATION IN WINDOWS

Create a schema for informatica repository










Increasing the parameter open_cursors to 1000










Go to the software folder and double click on setup file


















In the installation type screen select install informatica with hot fix 2
and click next



















In the prerequisite screen verify the prerequisites
 and complete the pending tasks if any and click next



















In the license and directory screen provide the license key file path
 and installation directory path and then click next



















In the pre-installation summary screen check the summary and click install



















In the installing screen check the progress of installation





































In the domain selection screen select create domain

Check the option enable https and click next



















In the configuration repository screen

Provide the repository and database details and click test connection



















If the test connection was successful click ok and click next

In the domain configuration screen provide password and click next


In windows service screen uncheck the option and click next



















In the post installation summary screen click done




















Saturday, May 6, 2017

Dac 11g Preinstallation Requirements

Prerequisites for installing the DAC Client and Server:
1. Installaton of informatica
2. Download the file Oracle Business Intelligence Data Warehouse Administration Console
3. Create a repository user which will store the dac object

Informatica 9.1 Pre-installation Requirements on linux

1. Minimum P-4 processor or higher is required
2. Minimum 4gb ram or higher is required
3. Minimum 20gb hard disk is required
4. Linux distribution and version which supports the informatica installation
5. At least one database has to be installed
6. Temporary disk space is minimum 1gb for installer and minimum 2gb for informatica services
7. Create a system user account for installing informatica
8. We have to set up the Domain configuration repository
9. We have to determine the available ports for informatica
10. Set the environment variables
11. We have to set up a key stroke and file descriptor settings
12. We have to set up database parameters, users and table spaces before installing informatica.

Tuesday, April 18, 2017

INSTALLING DAC CLIENT IN WINDOWS

Navigate to the software folder and double click on the dac 11g install file






























































click next


















Give the informatica root path and click next


















Give the informatica domain file path and click next


















Choose the destination folder for installation and click next


















Select your choice and click next and click install



































Click done to finish the installation

INSTALLING INFORMATICA 9.1 CLIENT IN WINDOWS MACHINE

Navigate to the software location folder and double click on install.bat file


















Select install or upgrade informatica option and click start































Select install informatica clients with hotFix2. And click next



















Now it will verify for the prerequisites



















Click next for continuing installation



















Select the required client tools and click next



















Give the software installation path and click next



















It checks for the disk space



















Select first option and click next



















It will give the pre installation summary check it and click install to install the software
























































Click done to finish the installation


  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...