Saturday, June 16, 2018

Where is the DBA in the DevOps tools ?


  • Database administrator job has been changed and it's not like before any more, In the past The DBA responsibility was limited within database which mean troubleshooting, backup , Performance tuning, high availability .. etc after few years new layer has been added to the responsibility which is application server layer for example weblogic ,Oracle embedded the weblogic with most of their products such as enterprise manager cloud, E-business suits, as i remember after three years another layer added to DBA knowledge which is virtualization and regarding to this virtualization  made the DBA life more easier and not like before, solution providing another layer of backup and server management.


However now everything has been changed and the market working under new term which is CLOUD including different vendor AWS, Azure, and Oracle, As DBA your knowledge shouldn't stop by only Database, within cloud there is new tools that can help the DBA with their daily Job and it's called Devops.

DBA usually review each change request to ensure that it is well thought out,They are in charge of monitoring their databases and keeping them available and high-performing, manage access to and the overall security of the platform.

Database automation frees the DBA from the bottleneck of the past that delayed application releases since there is different environment production, Pre-Production, Development or Testing, the DevOps Automation relieved of the pressures of constantly having to juggle and merge various teams’ database changes, are now free to help their organisations take bigger steps forward in ongoing innovation.

But what is the Devops ? And How can i use to make my Job Easier

DevOps is the combination of cultural philosophies, practices, and tools that increases an organization’s ability to deliver applications and services at high velocity: evolving and improving products at a faster pace than organizations using traditional software development and infrastructure management processes. This speed enables organizations to better serve their customers and compete more effectively in the market.


Benefits of DevOps
  • Speed
  • Rapid Delivery
  • Reliability
  • Scale
  • Security

DevOps Practices
  • Continuous Integration
  • Continuous Delivery
  • Microservices
  • Infrastructure as Code
  • Monitoring and Logging
  • Communication and Collaboration

DevOps practices for DBA and Data Team focus on the Tools, practices and techniques that are useful for the Data team to use for Development activities, Testing setup and execution, Collaboration techniques and Deployment tools and techniques. The aim of this site is to further the practice and help the DBA's and Data team to use these practices to become productive and become part of the delivery team and embrace the devops movement.

DevOps Tools
  • Docker
  • Jenkins
  • Ansible
  • Puppet
  • Nagios
  • Monit
  • Behat
  • Chef

There is more tools for sure each one of these tools having it's own purpose for example Docker is one of the powerful container solutions, A container image is a lightweight, stand-alone, executable package of a piece of software that includes everything needed to run it: code, runtime, system tools, system libraries, settings Available for both Linux and Windows based apps, containerized software will always run the same, regardless of the environment. Containers isolate software from its surroundings, for example differences between development and staging environments and help reduce conflicts between teams running different software on the same infrastructure.


Cheers
Osama Mustafa 

Saturday, October 21, 2017

Error: Server refused our key or No supported authentication methods available

If you use PuTTY to connect to your instance and get either of the following errors, Error: Server refused our key or Error: No supported authentication methods available, verify that you are connecting with the appropriate user name for your AMI. Enter the user name in the User name box in the PuTTY Configuration window.

The appropriate user names are as follows:


  • For an Amazon Linux AMI, the user name is ec2-user.
  • For a RHEL AMI, the user name is ec2-user or root.
  • For an Ubuntu AMI, the user name is ubuntu or root.
  • For a Centos AMI, the user name is centos.
  • For a Fedora AMI, the user name is ec2-user.
  • For SUSE, the user name is ec2-user or root.
  • Otherwise, if ec2-user and root don't work, check with the AMI provider.


Thanks
Osama

Thursday, October 12, 2017

Out Of memory , Not Enough Space Solaris 11

SQL> startup mount ;
ORA-27102: out of memory
SVR4 Error: 12: Not enough space
Additional information: 1671
Additional information: 16106127360
Additional information: 64424509440

The Above error appeared When trying to start Oracle 12c on Solaris 11.3, this is published bug 

Bug:20635316 - 12C DATABASE INSTANCE STARTUP FAILS WITH ORA-27102: OUT OF MEMORY

Solaris using something called OSM , Optimized Shared memory You can know more about it here 

To avoid this error as workaround just set the parameter

_use_osm=FALSE


Thanks
Osama

Monday, October 2, 2017

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




Saturday, September 30, 2017

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

Friday, September 22, 2017

Helping implementer and tester dealing with famous Siebel - based system messages and errors



Upon my colleague Mohammad Altraimat i am publishing this article

 let me gives you a brief  about him , he is currently working with as Siebel Freelance , ensure the functionality of systems, support and train clients to use the systems and collect the requirements from the client and ensure it reflected during his career he developed this document to help people to understand more about Siebel.

You Can Share it But please mention the source of the article or you ask me to share the article with you.

You can find the article here.

Thank you
Cheers
Osama 

Tuesday, August 8, 2017

Weblogic 101 for DBA Webinar

if you want to learn more about web-logic, Register now "Weblogic 101 for DBA"

i will cover different topic during the webinar to give you a better idea about the weblogic concept

Register now here

Thank you
Osama