INSTALLATION DOCUMENTS BY RAVI

Friday, December 1, 2017

Step by Sep Apache Ambari installation and configuration on linux

Downloading Apache Ambari :

Connect to linux machine using putty and issue below command to download Apache Ambari

wget -nv http://public-repo-1.hortonworks.com/ambari/centos6/2.x/updates/2.5.2.0/ambari.repo -O /etc/yum.repos.d/ambari.repo





Installing Apache Ambari :

Install Ambari server using yum as below

































Configuring Apache Ambari:

Issue the below command to start configuring Apache Ambari


It will ask for options to choose .
Choose the option you want and click enter.




































Starting Ambari server:

Issue the below command to start the Ambari server as below












Accessing Ambari server Admin console using web UI:

We can access the Ambari server admin console using below url

http://localhost:8080






















Default user name and password is admin / admin























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

MySQL Daemon failed to start

When try to start the mysql database getting the below error:

"MySQL Daemon failed to start"





Try with the command mysql as below and check for the error





Here we get the error " Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' "

To resolve this error check the my.conf file under /etc folder















Here in my case bind address is different from my host ip address so I changed it to my host ip address and tried to start mysql again






Monday, November 20, 2017

Enable Root User on Ubuntu

1. Set password for root user:

Login as user
Open terminal
Issue the below command to set password for root user

$sudo passwd root

Give the password for root user 

2. Open the file 50-ubuntu.conf under the path (/usr/share/lightdm/lightdm.conf.d/)

Add the below line to it.

greeter-show-manual-login=true

Save and close the file.

3. Reboot the machine and now we can login as root user.





Saturday, November 18, 2017

OWB repository seeding failed

When we are working with owb repository assistant for the first time we may get the below error












To resolve this :

1. Connect to the database as sysdba user and run the remote_owb_install.sql and provide the OWB_REMOTE_ADMIN directory as below
















2. Execute the OWB scripting command to seed the repository

Navigate to $ORACLE_HOME/owb/bin/unix and open the shell ombplus by running the command OMBPlus.sh as below





Execute the below command to seed the OWB repository





3. Now relaunch the repository assistant and try to create workspace





Resolution : ORA-01157: cannot identify/lock data file 6 - see DBWR trace file

When we are working with oracle database some times the database may not open with the below errors:

ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'C:\APP\ADMINISTRATOR\ORADATA\ORCL\DEV_SVCTBL.DBF'














Solution:

To resolve this error issue the below sql commands and try to open the database

1. select name from v$datafile where file#=6;
2. alter database datafile 6 OFFLINE DROP;
3.alter database open;







When we try to open the database again we may get data file error






Repeat this step until all the error data files got dropped
Ones this got resolved we can open the database















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