Cloud Talk : How much my IaaS will cost on the cloud ?

When the company will move to the cloud, the biggest question to ask , how much it will cost ? there are different ways to determine your IaaS cost, but at first you need to know that PaaS and IaaS much cheapter than IaaS, Each cloud vendor having their own calculator so at least you can estimate the value for one year or understand how much it will cost ? which is good.

Azure

Let’s Start with Azure for example ( since i post a lot about it recently )

When you are estimate the price for any cloud you should take different factors in your mind such as the following :-

  • Region
  • Tier it’s free , Basic … etc
  • How will the clinet/customer pay ? monthly , Yearly , Pay as you go .. etc
  • Supprot for the cloud which option you will choose
  • The deployement princing for example in Azure Dev/test .. etc

Now Azure provides the client with real pricing calculator that allow people to estimate the cost, From here.

to use the portal you should know what services you will choose, and some esstinal information such as How many VM, Database, networking, after you add all the information the report will be generated depends on the period of paying.

But what if i want to move from On Premis to the cloud , is this tool will work ? Total Cost of Ownership or TCO from here

The TCO Calculator helps you understand the cost areas that affect your applications today, such as server hardware, software licenses, electricity, and labor by Define the following :-

  • Servers : -details of your current on-premises
  • Databases :- on-premises database infrastructure
  • Storage :- on-premises storage infrastructure
  • Networking :- on-premises environment

The Genterated report will be like this :-

Amazon

As i already mentioned each Cloud vendor having different apporach of Cloud Pricing but it’s all the same, in AWS you can access the pricing from here , also they have somthing called SIMPLE MONTHLY CALCULATOR From here.

When you generate an estimate, you can either add services directly to your estimate or create a group and add the services to your group.

The AWS Pricing Calculator is an estimation tool that provides an approximate cost of using AWS services based on the usage parameters that you specify. The AWS Pricing Calculator is not a quote tool, and does not guarantee the cost for your actual use of AWS services. The cost estimated by the AWS Pricing Calculator may vary from your actual costs for a number of reasons. Common reasons the estimate may be different from your actual cost include different thing such as Actual Usage, Region used, Change in price, Taxes ( depends on the Region ) .. etc

Oracle

From Oracle , the portal is very simple to use, you can estimate everything using this portal here from Infrastcure cost, database, Application, … etc .

Cheers

Osama

Monitoring Azure services

Azure provides two primary services to monitor the health of your apps and resources.

  • Azure Monitor
  • Azure Service Health

Azure Monitor

maximizes the availability and performance of your applications by delivering a comprehensive solution for collecting, analyzing, and acting on telemetry from your cloud and on-premises environments. It helps you understand how your applications are performing and proactively identifies issues affecting them and the resources they depend on.

also it can collect data from different source such as application, operating system, and platform .. etc. for example the following will explain what i mean :-

What it’s monitorDescription
Application monitoring datacollect data about performance and functionality of the code you have written, regardless of its platform.
 OS monitoring dataData about the operating system on which your application is running.
resource monitoring dataData about the operation of an Azure resource.

subscription monitoring dataData about the operation and management of an Azure subscription
tenant monitoring dataData about the operation of tenant-level Azure services such azure AD.
Table explain what is the monitor in Azure Monitor

Azure Monitor starts collecting data. Activity Logs record when resources are created or modified and Metrics tell you how the resource is performing and the resources that it’s consuming, You can extend the data you’re collecting into the actual operation of the resources by enabling diagnostics and adding an agent to compute resources, also with Azure Monitor you can extend the monitoring to be for example :-

  • Application Insights is a service that monitors the availability, performance, and usage of your web applications, whether they’re hosted in the cloud or on-premises.
  • Azure Monitor for containers is a service that is designed to monitor the performance of container workload
  • Azure Monitor for VMs is a service that monitors your Azure VMs at scale, by analyzing the performance and health of your Windows and Linux VMs

How it’s works ?

Alert :- from the name it will notify the admin to about the erros or thereshould to take corrective actions,Alert rules based on metrics can provide alerts in almost real-time, based on numeric values. Alert rules based on logs allow for complex logic across data, from multiple sources.

AutoScale :- uses Autoscale to ensure that you have the right amount of resources running to manage the load on your application effectively.

Azure Service Health

provide personalized guidance and support when issues with Azure services affect you. It can notify you, help you understand the impact of issues, and keep you updated as the issue is resolved.

What is the plus about Azure Service health :-

  • Azure Status provides a global view of the health state of Azure services
  • customizable dashboard that tracks the state of your Azure services in the regions where you use them.
  • Helps you diagnose and obtain support when an Azure service issue affects your resources

Cheers

And Enjoy the Cloud

Osama

Configure AWS Command Line Interface

In this lesson i will show you how to configure AWS command line, and how to start working with your AWS account thru command line with very simple and basic steps :-

  • First of i will assume that you don’t have any user or group in your AWS console
  • from the AWS Console :-
  • From IAM ( Identity access management ) Choose Group Create Group with permission Administrator access and then hit create.
  • create user and add that user to the group in my case the group name shown above, save the secret key and access ID as CSV.
  • Now from this link here, Download AWS Command Line Interface depend on your operating system and open cmd , terminal … etc.
  • Now from Dos enter AWS configure and fill the information like the below:-
  • Open the command line and test if it’s connected to AWS now.
You can learn more about the command line from AWS documentation , if you recive the following error 
“Could not connect to the endpoint URL: “https://s3.london.amazonaws.com/”
Then make sure you are on the right Region.
Thanks
Osama

failed to associate the token : AWS

Once you create AWS you should activate “Activate MFA on your root account” 

and do that you should use your phone (Iphone, Android) download google authenticator app from the app store/Google Play once the installation is done Scan the QR and Enter the code, the code will be change automatically, if the first try not working and you receive this error ” failed to associate the token” uninstall the app and try again.

Thank you
Osama

Plug and unplug PDB on the Cloud

You can use DBaaS Monitor to plug/Unplug in a pluggable database.

  • Open Dbaas Monitor like usual 

  • Once you did this the, you will redirected to new page, in my case i have 2 PDB let’s choose one of them and try to unplug it then Plug it again.
  • From the Right Panel press on the Unplug new screen will be open, As you see from the below picture you should the XML path in your mind in case you need to Plug the database again , put the password same as you use it when you create PDB.

The output should be “PDB unplugged successfully”..
Let’s Plug again.
  • Press on Plug PDB on the right new screen will be opened.

Enter the following ;-
    • Name of the new PDB You want.
    • The XML file should be saved under directory you choose it
Output should be successfully done.
Cheers
Osama Mustafa

Access Apex On the Cloud Using DBaas

Oracle Database Cloud Service include Oracle Application Express, which you manage using the Oracle Application Express administration console. You access this administration console by going to the Oracle Application Express.

To access the Apex Application on the cloud;-

  • From the Dbaas you want, press on the tool panel and choose Apex.
  • To use the Apex you need to enable https on your cloud, to do this you have to access to compute services –> network and choose https
  • After doing this you will be able to access to Apex Page enter the following information:-
    • In the Workspace box, enter INTERNAL.
    • In the Username box, enter ADMIN.
    • In the password box, enter your password.
Enjoy the cloud
Cheers
Osama mustafa

Enable master key Encryption Key for a PDB on the cloud

SELECT wrl_parameter, status, wallet_type FROM v$encryption_wallet;Master Key Encryption allow you to encrypt sensitive data, such as credit card numbers, stored in table columns. Encrypted data is transparently decrypted for a database user who has access to the data. Transparent data encryption helps protect data stored on media in the event that the storage media or data file gets stolen for more information about it here.

After creating Database on the cloud ( Dbaas ) you can enable the master key by using the below steps :-

  • First of all you need to check the name of the container that you want to enable master key.
    • select con_id, dbid, name from v$pdbs;
  • as you see my container name is PDB1 set the session to this.
    • ALTER SESSION SET CONTAINER = PDB1;
  • Check the location for the wallet by running the below query :-
    • SELECT wrl_parameter, status, wallet_type FROM v$encryption_wallet;
  • Back to Root Container run the below query to see the wallet parameter type there is two value autologin or password each one of them having it’s own usage, in my case the value set to password.
  • Now i should close the wallet depend on the wallet type in my case it’s set as password then i will use the below  for more information about ADMINISTER KEY MANAGEMENT here
    • ADMINISTER KEY MANAGEMENT SET KEYSTORE close IDENTIFIED BY Mypassword;
  • When i tried to open the wallet using the same password i set it before. 
    • ADMINISTER KEY MANAGEMENT SET KEYSTORE open IDENTIFIED BY MyPassword CONTAINER=all
But my wallet is closed, i found oracle support document here Document number 1944507.1 which discuss this error and provide a solution for this error you can back to this document.
Once you apply the solution you will be able to open the wallet as below.
Welcome to TDE on the cloud.

Thank you
Osama Mustafa

Enable-Disable Database Vault on the Cloud

Oracle Database Vault restricts access to specific areas in an Oracle database from any user, including users who have administrative access. For example, you can restrict administrative access to employee salaries, customer medical records, or other sensitive information. for more information about it here

Now to enable DBV on the cloud it’s very simple all you have to do is the following :-

  • Connect to the compute node as oracle user using putty i post about this before.
  • To enable DBV Run the below command :-
    • dbaascli dv on
  • After this the output should like this “Successfully configured DV”
Congratulation DBV is enabled now.
And to Disable DBV All you have to do is Run :-
  • dbaascli dv off
Enjoy the Cloud , Cheers,
Osama Mustafa
Notes :-
  1. For the username i put C## because i am using database 12cR1 and enable pluggable..

Deleting a Backup On The Cloud

In this post i will show you how to delete backup on the cloud using the command line :-

  • Connect to the compute node as the opc user.
  • Start a root-user command shell using sudo command 
    • sudo su –
  • List the backup
    • # /var/opt/oracle/bkup_api/bkup_api recover_list –keep
  • Delete the backup 
    • # /var/opt/oracle/bkup_api/bkup_api bkup_delete –bkup=backup-tag
      • where backup-tag is the tag of the backup you want to delete.
Thank you
Osama Mustafa