Sudo User: Steps To Add and Grant Sudo Privileges to Users in Linux

In order to add the user to sudoers file please find the steps below:

Logged in as root run the visudo command:

When we type this command, we will be taken into a text editor session with the file that defines sudo privileges pre-loaded. We will have to add our user to this file to grant our desired access rights.

Save and close the file

Now, when you are logged in as your oracle user, you can execute a certain command with root privileges by typing:

sudo "command"

Steps for preventing Oracle SQL Developer sessions from being killed

In general when we leave the database connection opened for a while in oracle sql developer, It will throw a "connection timeout" message when we tried to run a query next time.
We have to reconnect the connection for running the query.

To keep the database connection alive in sql developer please follow the below steps:

For Oracle SQL Developer 3 Versions:

1. Download oracle.sqldeveloper.keepalive.jar from this link " https://454e35d1-a-62cb3a1a-s-sites.googlegroups.com/site/keepaliveext/oracle.sqldeveloper.keepalive.jar?attachauth=ANoY7cp8U9ULxrRvTu3b-96lNNGvQAyh_LQ_kRfPmskJS0-qDvLfvoEeyd1jVFkbTRsso4wMuH65pMFVrXECLpUsFXj7D9wxGbYZrBffFy6FNAVRpCVy-j5vJ9h84DdMl_tCBGHaI3_GJzjx2OwutMk2b-bdCvOV_lgSy7_Kb3J2T2CjCR9hg9o_Bk_3f5roc86Vr6XxkncVkpZ87XsphHtEmZveLTVzdHcqf1_a9QEKY77koOcbkKU%3D&attredirects=0"

2. Copy the downloaded jar file to the below location

%SQLDEVELOPER_HOME%\sqldeveloper\extensions

3. Open sql developer and right click on a connection and go to Keep-Alive and select Active

4. Enter the user and password details of the connection if it is not already connected

5. We will get a success keep alive message

6. Now check again for the session time out issue.

For Oracle SQL Developer 4 Versions:

1. Navigate to %SQLDEVELOPER_HOME%\sqldeveloper\bin

2. Open sqldeveloper.conf file

3. Add " AddVMOption -Doracle.net.disableOob=true" to the file and save it.

4. Open sqldeveloper-nondebug.conf file

5. Add " AddVMOption -Doracle.net.disableOob=true" to the file and save it.

6. Open sql developer and connect to the database and check for session time out

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

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