Saturday, January 8, 2022

Informatica 10.5 Installation Steps: Part 3 - Pre Requisites Steps

 


Plan what OS you are planning to install (SUSE Linux, Redhat or Windows), also make sure to select instance type (m4, m5…). In below example I have selected m5.x4large with 16 CPUs.

 

Step 1: Login to EC2

Step 2 : Launch Instance
























Create Volume First – in EBS

And Attach to new EC2 Instance created

First Create a Volume and then Attach through Actions à Attach Volume


Login to Linux Servers

Log with EC2 user and ppk file created in step 1


Informatica License Keys

Copy License Keys to S3 Buckets


Install OS level binary Packages

sudo -i

zypper refresh

zypper se e2fsprogs

zypper se keyutils

zypper se libsepol

zypper se libselinux


Proxy Setup

Make sure you have no proxy setups, if you have have your http_proxy variables setup



 Linux Group & User Creation

 

groupadd infaadmin

 

DEV: useradd -G infaadmin -m infausrdevadm

 

useradd -G infaadmin -m nainfadev

 


Uninstall Oracle 12c (if any)

 

ip-10-10-110-10:/home/nainfausrprodadm/software # rpm -e oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64

ip-10-10-110-10:/home/nainfausrprodadm/software # rpm -e oracle-instantclient12.1-jdbc-12.1.0.2.0-1.x86_64

ip-10-10-110-103:/home/nainfausrprodadm/software # rpm -e oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64



Oracle 19c DB Installation on EC2 Server

















Oracle Client Installation

Oracle Client


 

Download Client from -- https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

 

Check for 19c Client Version --

 

-rwxrwxrwx  1 ec2-user        users      702900 Jun 17 19:01 oracle-instantclient19.11-sqlplus-19.11.0.0.0-1.x86_64.rpm

-rwxrwxrwx  1 ec2-user        users     1524732 Jun 17 19:01 oracle-instantclient19.11-jdbc-19.11.0.0.0-1.x86_64.rpm

-rwxrwxrwx  1 ec2-user        users    54477808 Jun 18 07:43 oracle-instantclient19.11-basic-19.11.0.0.0-1.x86_64.rpm

 


 

:/home/nainfausrdevadm/software # rpm -ivh oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm

Preparing...                          ################################# [100%]

Updating / installing...

   1:oracle-instantclient12.1-basic-12################################# [100%]

 

/home/nainfausrdevadm/software # rpm -ivh oracle-instantclient12.1-jdbc-12.1.0.2.0-1.x86_64.rpm

Preparing...                          ################################# [100%]

Updating / installing...

   1:oracle-instantclient12.1-jdbc-12.################################# [100%]

 

:/home/nainfausrdevadm/software # rpm -ivh oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm

Preparing...                          ################################# [100%]

Updating / installing...

   1:oracle-instantclient12.1-sqlplus-################################# [100%]




Update tnsnames.ora file

 

Create and update tnsnames.ora and sqlfile in below location.

/usr/lib/oracle/19.11/client64/lib/network/admin

 

usrdevadm@ip-10-10-100-100:~> echo $TNS_ADMIN/

/usr/lib/oracle/19.11/client64//lib/network/admin/

Update .profile with Oracle Environment Variables

 

Update .profile in home dir - /home/nainfausrdevadm

 

ORACLE_HOME=/usr/lib/oracle/12.1/client64

PATH=$ORACLE_HOME/bin:$PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib

export ORACLE_HOME

export LD_LIBRARY_PATH

export PATH

 

# temp dir for Informatica installation

export IATEMPDIR=/tmp

export INFA_HOME=/infahome/informatica/10.5

 

 

ulimit variables:

update .profile and bashrc

ulimit –u 16000

ulimit -n 4096

 

Command to execute .profile file ---à      . ./.profile



sqlplus domain_dev/domaindev@orcl;



Increase /tmp volume

Make sure to check and add more volume to /tmp

nainfausrdevadm@:/tmp> df -h .

Filesystem      Size  Used Avail Use% Mounted on

/dev/nvme0n1p3  300G   48G  253G  16% /

 

Create /infahome Volume

 

First, Create a Volume of 500 GB and then Attach through Actions à Attach Volume to EC2 Instance created instep 2











Mount /infahome to Linux Server

 

Check Mount Name

:~ # lsblk

NAME        MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT

nvme1n1     259:0    0  500G  0 disk

nvme0n1     259:2    0   50G  0 disk

nvme0n1p1 259:3    0    2M  0 part

nvme0n1p2 259:4    0   20M  0 part /boot/efi

└─nvme0n1p3 259:5    0   50G  0 part /

 

New disk attached is nvme1n1

 

:~ # sudo mkfs -t ext4 /dev/nvme1n1

mke2fs 1.43.8 (1-Jan-2018)

/dev/nvme2n1 contains a ext4 file system

        last mounted on /infadatafiles on Tue Apr 13 12:51:06 2021

Proceed anyway? (y,N) y

Creating filesystem with 131072000 4k blocks and 32768000 inodes

Filesystem UUID: xxxxx

Superblock backups stored on blocks:

        32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,

        4096000, 7962624, 11239424, 20480000, 23887872, 71663616, 78675968,

        102400000

 

Allocating group tables: done

Writing inode tables: done

Creating journal (262144 blocks): done

Writing superblocks and filesystem accounting information: done

 

ip-10-81-182-213:~ # sudo mkdir /infahome

ip-10-81-182-213:~ # sudo mount /dev/nvme2n1 /infahome

 

Change mount owner to Informatica admin user

cd /

chmown usrdevadm /infahome

sudo su – usrdevadm

cd /infahome

mkdir test1



Update /etc/sudoers file..

 

Command to edit -- sudo visudo

 

tmp_admin ALL=(ALL) NOPASSWD: ALL

nspnainfadev ALL=(ALL) NOPASSWD: ALL

nainfausrdevadm ALL=(ALL) NOPASSWD: ALL

 

Oracle Users Creation:

 

Select * from dba_users;

DOMAIN

DROP TABLESPACE domain_dev_ts INCLUDING CONTENTS;

CREATE TABLESPACE domain_dev_ts DATAFILE SIZE 50 M AUTOEXTEND ON NEXT 10 M MAXSIZE UNLIMITED FORCE LOGGING ONLINE FLASHBACK OFF;

DROP USER domain_dev CASCADE;

CREATE USER domain_dev IDENTIFIED BY domaindev DEFAULT TABLESPACE domain_dev_ts TEMPORARY TABLESPACE temp QUOTA 0 ON USERS QUOTA 0 ON SYSTEM QUOTA 0 ON SYSAUX QUOTA UNLIMITED ON domain_dev_ts;

GRANT CONNECT, RESOURCE TO domain_dev;

GRANT CREATE TABLE TO domain_dev;

GRANT CREATE VIEW TO domain_dev;

GRANT CREATE SEQUENCE TO domain_dev;

GRANT CREATE SESSION TO domain_dev;

GRANT CREATE SYNONYM TO domain_dev;

REPO

 

--Create  a new tablespace:

DROP TABLESPACE repo_dev_ts INCLUDING CONTENTS;

CREATE TABLESPACE repo_dev_ts DATAFILE SIZE 50 M AUTOEXTEND ON NEXT 10 M MAXSIZE UNLIMITED FORCE LOGGING ONLINE FLASHBACK OFF;

--Create the repo_dev database user:

DROP USER repo_dev CASCADE;

CREATE USER repo_dev IDENTIFIED BY repodev DEFAULT TABLESPACE repo_dev_ts TEMPORARY TABLESPACE temp QUOTA 0 ON USERS QUOTA 0 ON SYSTEM QUOTA 0 ON SYSAUX QUOTA UNLIMITED ON repo_dev_ts;

 

--Grant necessary privileges and roles to your repo_dev database user:

GRANT CONNECT, RESOURCE TO repo_dev;

GRANT CREATE TABLE TO repo_dev;

GRANT CREATE VIEW TO repo_dev;

GRANT CREATE SEQUENCE TO repo_dev;

GRANT CREATE SESSION TO repo_dev;

GRANT CREATE SYNONYM TO repo_dev





Review default ulimit parameters






1 comment:

  1. I found one successful example of this truth through this blog. I am going to use such information now.
    Starlink Australia

    ReplyDelete