Tuesday, September 17, 2019

Enable Elastic IP Address for AWS EC2 instance

When we create an EC2 instance, we should get a public IP address(which is dynamic) and one private address which is static in nature. Public ip address is used to broadcast your internet connected device to the internet and private ip address is the address of the machine which uniquely identifies it.

Now the problem here is, when we reboot the instance, the public IP address keeps on changing. Thus it will be a problematic situation for your applications to work. There is a way through which you can make the public IP4 address as static. This is achieved  via Elastic ip address.

Below are the steps through which we can associate an Elastic IP address to an EC2 instance.



now if we reboot the ec2 instance, the public ip address will change. Note:Private ip address remain static.

From the above ip address, once we are connected to instance via public ip address, we should be able to see the address of the machine which is the private address.



In order to prevent the public ip address from changing, associate it with the elastic ip address.












Now associate the elastic address to the ec2 instance





Click on actions:-




Now if we go to the ec2 console, we will have a new public ipv4 address



This ip address will not change even if we reboot the instance.


Happy learning..............




EBS 12.2 and 12.1.3 is now certified with Oracle Database 19.3

Well, Well, Well time to upgrade my EBS Database 12.1.0.2 to 19.3. Finally the time has come just before the OOW 19 and it cannot be more exciting.

Check out the Oracle blog from Elke Phleps EBS 12.2 is now certified with oracle Db 19.3


The main features are as follows:-

EBS 12.2 is now certified for 19.3 on-premise.
- CDB with Single Plugable PDB (single tenant)
- CDB with multiple PDB is not yet certified.
- Non-CDB is not certified in case of 19c
- Supported Platform - Linux, Solaris (SPARC)
- Special Consideration for VPD deployment with EBS DB.
- RAC and TDE certified
- SSO with OAM integrations certified

𝐈𝐧 𝐏𝐫𝐨𝐠𝐫𝐞𝐬𝐬 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧𝐬 : 
- Platforms : IBM , Windows, HP-UX
- Active Data guard, Data guard, Masking, Transportable DB migrations.
- GG integrations
- ISG and AMP certifications


Time to get your hands dirty. You can get the complete step by step on how to upgrade EBS 12c Database to 19c in my blog https://samappsdba.blogspot.com/2020/12/upgrade-EBS-12.2-database-12c12.1.0.2-to-19c19.3-Part-1.html

Sunday, September 15, 2019

How to connect to AWS EC2 instance using putty

During the creation of EC2 instance in AWS, it will prompt us to create a new keypar/use an existing key pair. If we don't have any existing key pair, then in that case, we will create a new one and keep it safe in our repository.

The keypair format will be .pem format. Now putty only intercepts .ppk format. It doesn't recognize .pem format. To convert an .pem format to .ppk format, we will use puttygen.exe.



Click on load and navigate to the repository where .pem keypair is saved.


Now click on "Save Private key" and then "Save Public Key".

Once the keys are saved, open putty and then select the options as mentioned below.




If all goes all, we should get the login screen





Happy learning