Yogi – Page 4

DB Admin: Database size in GBs

Posted on by

 
 SET SERVEROUTPUT ON
declare
total_size_b number;
tfree_size_b number;
tused_size_b number;
begin
dbms_output.enable(100000);
select Sum(bytes) into total_size_b
from dba_data_files;
select Sum(bytes) into tfree_size_b
from dba_free_space;
select Sum(bytes) into tused_size_b
from dba_segments;
dbms_output.put_line('Total:' || TO_CHAR(Round(total_size_b/1024/1024/1024, 2), '999,999.00') || ' GB');
dbms_output.put_line('Free: ' || TO_CHAR(Round(tfree_size_b/1024/1024/1024, 2), '999,999.00') || ' GB');
dbms_output.put_line('Used: ' || TO_CHAR(Round(tused_size_b/1024/1024/1024, 2), '999,999.00') || ' GB');
end;
/
SET SERVEROUTPUT ON

Sample output:

How to install Docker on AWS EC2 machine

Posted on by

Docker is a very useful tool when it comes to create your applications, deploy and run them by using containers. In SDLC its utilization comes in the Deployment stage. Please follow the steps below to install and use Docker on your AWS EC2 machine.

Launch an EC2 instance in your AWS account. Please remember the region you are launching the instance as the services of the tool installed will be available in this region only.

2. Connect to the SSH client where we can run the commands to configure Docker and use it.

Please follow the below steps to install docker on your AWS AMI machine.

3. Update the installed packages and package cache on your ec2 instance by running below command.

sudo yum update -y

4. Then to Install the latest Docker Community Edition package. Execute below command in your AWS Linux instance.

sudo amazon-linux-extras install docker or sudo yum install docker

5. To start the docker services execute the command below in your AWS Linux instance.

sudo service docker start

6. If you want to use the docker commands without using Sudo then Add the ec2-user to the docker group. Execute below command.

sudo usermod -a -G docker ec2-user

7. Now as docker is installed to use the Docker services, please once disconnect from your SSH client and connect again, to activate all the required Docker permissions.

8. To Verify If we can run the docker command without use of Sudo keyword, run the below command.

docker info

Now the Docker tool is ready to create Images and Containers. For more information on how to create Images and containers in Docker please refer our article “To create images and containers using Docker on AWS”.

AWS Email Set up

Posted on by

Email configuration is an important service for a website. But it will be easy if you are hosting your website on AWS and following below steps to set up your email address.

Go to “Workmail” Service.

2. Click on add organization.

3. Click on Quick setup on next page.

4. Give the domain name in organization.

5. You can see it as below after the organization is created. It can take few min to be active.

Here click on name under “Alias”

6. Click on Domain in Left side pane as below.

7. Click on Add domain.

8. Give your registered domain name and click add domain.

9.You can see the next screen as below, click on the domain name you have added. To verify the domain name, follow next 3 steps. It can take few min in the verification of the domain name after completion of the next 3 steps.

10. To Verify the domain name, From below screen under Domain ownership, copy the Record Type, Hostname without the domain name we added and the value. and use them in screen of Route 53 in step 14.