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
Install OS level binary Packages
sudo -i
zypper refresh
zypper se e2fsprogs
zypper se keyutils
zypper se libsepol
zypper se libselinux
Proxy 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
