Tuesday, November 17, 2020

ITIL Process

ITIL Process


Introduction


In this Blog i am going to explain  ITIL Process,ITIL stands for Information Technology Infrastructure Library, It is the leading IT service management framework recognised globally and delivering impactful and techpowered services customers across the globe

ITIL is the set of guidelines observed ,gathered ,and put together  in ITIL Process IT practioner in best services in a timely limit , ITIL provides direction to the organization and its people  utilizing as a  tool for changing,transforming ,developing the business


Service: Service means delivering value to customers by facilitating outcomes customer want to achieve with out the ownership of risks or costs


Process: Process means a set of activities designed to accomplish a specific objective ,it takes defined inputs and turns them into the defined outputs


Function: Function means A team or group of people and the tools they use to carry out one or more process activities 


ITIL process  5 stages of life cycle 


In each stage ITIL Process consists of a set of processes ,key,Principles Roles,activities and performance measures related to stage of the ISTM


ITIL Process,itil processes list,itil processes and functions,itil process pdf,itil process map,itil process interview questions,itil process full form,itil process flow,itil v4 processes,itil full form,itil lifecycle with example,itil lifecycle diagram,what is itil,itil certification,itil processes list,itil v4 processes,itil v4 service lifecycle,itil v4 processes,itil processes list,itil process flow,itil full form,itil processes and functions,itil process map,itil certification,itil process interview questions,itil 5 steps,itil v4 service lifecycle,itil lifecycle diagram,which of the stages of service lifecycle manage the technology used to deliver and support,itil v4 processes,itil service management processes,explain itil service lifecycle model,what is itil,itil processes list


  1. Service stratgey :which defines the vison and mission of the organization
  2. Service Design: which refers and design the current issue
  3. Service Transition :which is the process of process management new changes and modifications
  4. Service Operations: inorder to complete the process responds the user requests guides them on the usage of the services so that runs smoothly on their end and fix any problems 
  5. Continulal service improvement:quality check standards ,constant feedback and improving their service levels and technology implemented to deliver their services


  • ITIL means helps business evaluate services for required improvement,
  • ITIL helps make the implementation of decisions easy for business,
  • ITIL helps in designing the various steps required to implement the decisions taken,
  • ITIL starts with forming a strategy to take a decision that needs to be implemented


            In all these better service and value to the customers or client requirements,


In any organization or company they should follow the ITIL Process and Ticketing Tools

to smooth flow of the ITIL Life cycle. 




Note: Info on ITIL Process it may be differ in your environment like production,testing,development



THANKS FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME AND SUBSCRIBE ME


Tuesday, November 10, 2020

Ticketing Tools

Ticketing Tools 


Introduction


In this Blog i am going to explainTicketing Tools is the software which provides platform for the users and clients issues in different environments like production,testing,development etc,ticket means a problem or incident


Ticketing Tools ,ticketing tools servicenow,ticketing tools in sap,ticketing tools software free,support ticketing system,ticketing system open source,microsoft ticketing system,simple ticketing system,best ticketing system,itsm ticketing tools,itsm tools,itil process,servicenow ticketing tool,itil framework,itil ticket types,itil incident management,what is ticketing system,incident ticketing tool,service now tool,bmc remedy tool full form,bmc remedy incident management,what is bmc remedy used for,bmc remedy vs servicenow,servicenow ticketing tool,servicenow technology,servicenow login,servicenow jobs,servicenow itsm



Ticketing and monitoring Tool



User Created Ticket: user will create a ticket and raise the incident using the Ticketing Tools  like BMC Remedy ,Services now


Automatic Ticket: integrate with OEM and Ticketing Tools , suppose an incident happen in the morning 2 am database server is down it will automatcally raise the inicident or problem ticket and send a email to that Respective DBA teams


BMC REMEDY: 


BMC Remedy is the customer relationship tool which can be used to log/monitor the issues or problems faced by the customers by the means of incident management tickets.each ticket is an incident (problem) which is created by the help desk and assigned to the relevant support team,concerned support team member take the ownership of the ticket and updates the work log(troubleshooting steps performed during the course of action,also it can be monitored service requests/change management change requests and  problem management


what are the teams Involved in Ticketing Tools 


Database team,unix/linux Team, Application Team,Middleware Team


Different teams will be involved in project will give their working status in this wok log



Tickets Types Incident Management



1.Incident:for example my database server  is not getting connected its down (Abnonmal conditions)so what we have to do is open the ticketing tool  raise an incident to the particlar DBA team


2.Service Requests: for example new employe has joined in the IT team suppose they want access rights of Database server logins and other things etc we raise a service request to the particular team


3.Problem Ticket:for example frequently getting problem in database server while connecting we raise a problem ticket (we will find the root cause of the problemor incident)


4.Change Request: For example change request will be raised when any updates or patching in the database or unix updates so we will raise a change request ticket to the particular unix servers team or Database server team particlar person owner of the server(maintaining the server)



Service Level Agreement : Service level agreement is contract between a service provider either internal or external and the end user defines the level of service expected from the service provider in simple words  contract between client and company that is SLA(Service level agreement)


Response SLA : Responsive SLA means when a ticket will come an start working on it u have to acknowledge that i am working on that particlar ticket  


Resolution SLA: once you acknowledge in progress to resolution  the ticket you have to resolve the particulat time start working on that particlar ticket on specified time limit 


SLA can be like this :


  • For example critical priority ticket Response SLA will be 15 mins and Resolution SLA will be 4 hours 
  • For example high priority ticket Response SLA will be 30 mins and Resolution SLA will be 8 hours 
  • For example Medium priority ticket Response SLA will be 4 Hours and Resolution SLA will be 2days 
  • For example critical priority ticket Response SLA will be 8 Hours and Resolution SLA will be 4 days 

 Basic information of any Ticketing Tools will look like this 


Ticket No:


Summary:


Status:


StartTime


End Time:



Reporting  Person:


Email ID


Phone:





Response SLA


Resolution SLA




Priority Of Tickets


P1--->Critical--> may be 4 hours of time


P2--->High---->may be 8 hours of time


P3--->Medium ---->may be 2 days of time


P4--->Low---->may be 4 days of time




Severities 


  1. First open the ticket
  2. Read the mesaage what the problem is about
  3. Log into targeted servers
  4. Check logs depending on errors
  5. Propagate first hand information to stake holder(duty manager)
  6. fix the issues and close it




Note: Info on  Ticketing Tools  it may be differ in your environment like production,testing,development


Thanks for viewing ,Subsrcibe and follow me my blog for more updates 


Sunday, September 27, 2020

Dba Activities

Dba Activities


Introduction


In this blog i am going to explain Dba Activities in daily ,monthly,quarterly and other activities for database administrators in real time projcets and different domains and environments like production,testing,development etc


Dba Activities,oracle dba tasks checklist,dba tasks and responsibilities,senior oracle dba roles and responsibilities,oracle dba roles and responsibilities resume,oracle dba job description,sql dba roles and responsibilities,oracle dba skills,senior oracle dba job description,database administrator responsibilities,sql dba roles and responsibilities,what is main function of database administrator,what are the main duties of dba,database administrator skills,oracle dba issues and solutions,oracle database troubleshooting scenarios,oracle dba activities,database administrator responsibilities,oracle dba tasks checklist,oracle dba administrator roles and responsibilities,sql dba roles and responsibilities,all dba activities in sql server,sql dba roles and responsibilities,database administrator skills,database administrator job description


Daily Activities


  • Check the Database Availability
  • Check the listener Availability
  • Check Space Availability
  • Check any sessions Blocking the other sessions oracle locks and clear locks
  • Check long running unix process
  • Check the Alert log for an error
  • Check the Top sessions using more physical I/o
  • Deleted Locked Objects
  • Check the SQL query Consuming lot of Resources
  • Monitoring Temp and UndoTablespace
  • Taking Database/Archived Backups
  • Checked Failed backups and retrigger them
  • Health Check of the Database
  • Password lock/expired issues
  • Tuning slow running queries
  • Refresh activities- datapump
  • Check all Crontab house keeping script logs
  • Daily tablespace utilization and growth
  • Rebuilding of Indexes,if bulk load of data is inserted
  • Check the temporary tablespace/Files
  • Check locked and expired user in database and unlock/reset/informto business users
  • Check the user account grace period
  • Check the Undotablespace and retention 
  • Check the unix /tmp and /var location
  • Check the UTL_file location 
  • Check all database filesystem or drive
  • Monitor the archive log location 
  • verify sucess of database archive to tape
  • Monitor the logfiles,bakups,database space usage and the use of system resources
  • Monitoring the production database performance 
  • Find high cpu/memory/physical io consuming process and trace the sql/form/report running behind the database and update to application team/users
  • Check OEM agent is running or not in each node 
  • Verify DBSNMP is running
  • Verify sucess of database backup
  • User management and user profile monitoring on daily basis
  • Check invalid objects and recompile
  • Check and monitor audit log or table for new audit entry
  • Monitor daily failed login attempts in database and update to respective endusers
  • Backup your Crontab or windows jobscheduler
  • Taking incremental backups and monitor the sucess or failure and mail to respective stake holders
  • Check all lastnight backups were sucessful
  • Check your oracle licence and do not run/execute/create anything beyond the oracle licence expiry policy
  • Daily resolving tickets and maintained the SLA's and RPO's
  • Check audit logs for checking unauthorized access  
  • Daily checking of nagios or any ticketing tool alerts and take corrective action
  • Daily checking database reports scheduled in html formats related to both database maintanace and project functionality  



Weekly Activities


  • Growth of the database
  • Database growth Comparsion
  • Identify bad growth projections
  • Database Refresh from Production
  • Cross check weekly report of RMAN full databse backup
  • Analyse database and schema to gather statastics
  • Truncate teh listener.logfile in the $oracle_home/network/log ifthe listener log has increased to a size > 500mb ensure that the space is released,otherwise reload listener
  • Check how much redo generated perweek 
  • Archive or deleted listener log file
  • Archive or delete tracefiles from diagnostioc destination
  • Archive and compress all alertlogs and applications log history location
  • Check i/o of each data file
  • Check open_cursor not reaching the max_limit
  • Check the size of the tables & check whether it need to partition or not
  • check the objcet reload in memory many times
  • Remove audit logs since at present we have oneweek retention policy
  • Weekly checking the ADDM Reports and AWR Reports and OEM Reports if problems any found in Database 
  • Check the objects Fragmented,chaining &migrated rows
  • Check for block corruption
  • Check the free space at o/s level(weekly ,monthly)
  • Check the Invalid Objects of the database
  • Growth of the Database(weekly,monthly)
  • Taking logical backups,incase of physical backup failure



Dba Montly Activities


  • Check Database growth and free space availability at OS level request for next month  disk space to storage team
  • Check and Rebuild indexes if needed
  • Investigate fragmentation(eg rowchaining etc)
  • Check the overall database statastics
  • Trend analysis of objects with tablespace,last analyzed no ofrows,growth indays
  • Restoration of monthly fullbackups
  • Mail of backup stategy to all stake holders
  • Tablespace reorganization
  • Check default tablespace and temporary tablespace of each user



Dba Quarterly Activities


  • Database Patching
  • Bounce most critical database once a month
  • Review common oracle tuning point


Other Dba Activities


  • Install and configure oracle database on server perform database upgrades
  • Add new users to database and assignprivileges
  • Prepare the backup strategy and list all the receovery scenario
  • Perform POC ---proof of concept and show it to the client




What kind of issus will find in daily


  • Backup failure issues
  • Tablespace issues
  • File system Space
  • Alert log and Trace file house keeping
  • Gathering stats---> monitoring
  • Archived log full ---->Free up using RMAN
  • Dataguard -Rebuild if found gap more and missing archives
  • Configure/setup-disatser receovery 
  • Maintanance
  • Patching
  • Listener failure/reason if any maintanance
  • Monitoring Alert log
  • Verify instance up and running




Note : Info on  Dba Activities it may be differ in your environment like production,testing,development etc


THANKS FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME AND SUBSCRIBE ME


Thursday, September 24, 2020

YUM Package Management

YUM Package Management


Introduction:


In this Blog YUM Package Management i am going to explain,Install,Update,Remove,find packages,manage packages and repository in linux systems, YUM(YellowDog Updater Modified) is an open source command line as well as graphical based package management tool for RPM based linux/unix systems.

It is an GPL (General Public Licence) open source means any one can download and acess the code and fix the bugs and develop the customized pacakages ,and you will work only from Centos 5/Red hat and latest versions of fedora,for old release like RHEL 4,you need to use up2date command to update your RPM based packages


YUM PACKAGE MANAGEMENT,yum package manager,yum command,yum install,yum -y centos,yum install package,yum repository,yum install list of packages,what is yum,install yum,yum repository,yum -y centos,yum update,centos package manager,yum install package,download yum package manager,yum package manager,yum centos,yum update,yum install package,yum repository,yum command not found,yum vs rpm


Now Let us start the process :YUM Package Management


YUM uses the configuration file location will be


/etc/yum.conf



1.Install a Package 


To install a package called Firefox ,just run the below command it will automatically detect and install the dependencies for firefox package


[root@chaitanyaoracledba]# yum install firefox


The above command will ask the confirmation before installation any package on your system


If you want to install packages automatically without asking any confirmation ,use the option -y as shown in the below command


[root@chaitanyaoracledba]# yum -y install firefox



2.Remove a Package


To Remove a Package a completely with all  dependencies use below command 



[root@chaitanyaoracledba]# yum remove firefox


If you want to remove a package firefox with out asking confirmation use option -y in the below command


 [root@chaitanyaoracledba]# yum -y remove firefox


3.Update a Package


If your using the outdated version of  MYSQL package and you want to update the latest vesrion of MYSQL package just run the below command it will automatically resolves the all dependencies issues and install the package.


[root@chaitanyaoracledba]#yum update mysql


4.Install a Package Locally from a directory or cd rom


[root@chaitanyaoracledba]# yum localinstall finger -0.16.36.el6.i686.rpm


5.List a Package


Use the list function to search for the specific package with name .For Example if you want to search for a package called openssh use below command  



[root@chaitanyaoracledba]# yum list openssh



If you want to search more accurate specific version like example openssh-4.3p2 of the package,use the below command


 [root@chaitanyaoracledba]# yum list openssh-4.3p2



6.Search for a Package


If you dont rememeber the exact name of the package then use the search function to search all the available packages to match the name of the package you specified


 [root@chaitanyaoracledba]# yum search vsftpd



7. Information of a Package


If you want to know more information like name,arch,version,release,size,repo,summary,url,licence,description, about the package before installing it using the below command



 [root@chaitanyaoracledba]# yum info firefox



8.List All Available Packages


To list all the available packages in the Yum database ,use the below command



 [root@chaitanyaoracledba]# yum list | less



9.List All Installed Packages


To list all the installed packages on a linux systems,just type the below command it will display all the installed packages


 [root@chaitanyaoracledba]# yum list installed | less



10. Yum Provides Function


Yum provides a function is used to find which package a specific file belongs to for example if you would like to know the name of the package that is /etc/httpd/conf/httpd.conf


 [root@chaitanyaoracledba]# yum provides /etc/httpd/conf/httpd.conf



11. Check for all Available Updates


To find how many of installed packages on your system have updates available using the below command


[root@chaitanyaoracledba]# yum check -update



12. Update System


To keep your system up to date with all security and binary packages updates,run the below command it will install all the latest patches and security updates in your linux system


[root@chaitanyaoracledba]# yum update



13. List all Available Group Packages


In linux number of packages are bundled with particular group,Installed groups like  Adminsitration tools,DNS name server,dialup networking support,editors,engineering and scintific,FTP server,graphics,java deevelopment,legacy network server, And Available groups like Authorizing and publishing ,base beagle,cluster storage,clustering,development tools development libraries eclispse,KDE etc,instead of installing individual packages with yum ,you can install particular group that will install all the realted packages that belong to the particular group 


[root@chaitanyaoracledba]# yum grouplist



14. Install a Group Package


To install a particular package group, we use option as groupinstall. for example to install "MYSQL database" just type the below command


[root@chaitanyaoracledba]# yum groupinstall 'MySQL Database'



15. Update a Group Package


To update any existing installed group packages ,just type the below command


[root@chaitanyaoracledba]# yum groupupdate 'DNS Name Server'



16. Remove a Group Package


To Delete or Remove any existing installed group from the system,just type the below command


 [root@chaitanyaoracledba]# yum groupremove  'DNS Name Server'



17. List Enabled Yum Repositories


To list all enabled yum repository in your system ,just type the below command


 [root@chaitanyaoracledba]# yum repolist



18. List All Enabled or Disabled Yum Repositories


The below will display the enable or disable yum repositories in your system 


 [root@chaitanyaoracledba]# yum repolist all



19. Install a Package from Specific Repository


To install a particular package from specific enabled or disabled repository you must use the enablerepo option in your yum command


[root@chaitanyaoracledba]# yum --enablerepo =epel install phpmyadmin



20. Interactive Yum Shell


Yum utility provides a custom shell where you can execute multiple commands


[root@chaitanyaoracledba]# yum shell



21. Clean Yum cache


By default yum keeps all the repository enabled package data in /var/cache/yum/ with each sub directory,To clean all cached files from enabled repository you need to run the following command regularly to clean up all the cache and make sure that there is nothing unnecessary space is using, the below command is used


[root@chaitanyaoracledba]# yum clean all



22. View History of Yum


To view all the past transactions of yum command ,just below type the command


[root@chaitanyaoracledba]# yum history



Note : Info on YUM Package Management it may be differ in your environment like production,testing,development and naming conventions etc,


THANKS FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME AND SUBSCRIBE ME





Tuesday, September 22, 2020

RPM Package Management

RPM Package Management



Introduction:


In this blog i am going to explain RPM Package Management, RPM is a default open source and most popular package management utility for Red Hat based systems like RHEL,CENTOS and FEDORA)

The Red Hat Enterprise linux system divided into RPM packages which can be installed ,upgraded or removed,all softwares on a Red Hat Enterprise linux system is divided into RPM packages

The tool allows linux system administrators and users to install,update,uninstall,query,verify and manage system software packages in unix/linux operating systems.RPM package file name will be .rpm

.rpm file that includes compiled software programs and libraries needed by the packages,


RPM Package Management,rpm package,rpm package download,rpm linux command,how to create rpm package in redhat linux,location of rpm packages in linux,how to verify rpm package,rpm file,rpm install,how to check dependencies of rpm package before installing,rpm package manager,redhat package manager


  •    RPM is a free and easily downloaded from rpm sites ,released under the  GPL(General public Licence)    
  •    RPM keeps the information of all the installed packages under this directory /var/lib/rpm database
  •    RPM is the only way to install under the linux/unix systems to update the packages
  •    RPM deals with the .rpm file swhich contains the information about the packages such as dependies info,version info


There are five commands mostly  used in linux/unix for  RPM Package Management


  1. Install : it is used to install any RPM package .rpm file
  2. Remove:it is used to remove or uninstall the RPM packages
  3. Upgrade: it is used to upgrade the existing RPM package in linux/unix systems
  4. Verify : it is used to verify the RPM packages in linux/unix systems
  5. Query:it is used to query any RPM package



Below are the websites you can find and download  RPM Package Management


https://rpmfind.net/

https://www.redhat.com/en

https://rpm.org/download.html



Now Let us start the process  RPM Package Management


RPM is a popular utility for installing software on unix/linux systems


Step 1: Log in as root user on which you want to install the software you can manage the RPM commands by using root user privileges


Step 2: Download the RPM package you wish to install the package named some thing like java rpmpackage name  jre-8u111-linux-i586.rpm,the file name include version (1.0,8), release(1,u111) and architecture is (i386,i586)


Step 3: Check the PGP signature of packages before installing them on your linux systems make sure the integerity and origin is correct by using the following command  checksig(check signature)option to check signature of a package called pidgin


[root@chaitanyaoracledba]# rpm --checksig jre-8u111-linux-i586.rpm


jre-8u111-linux-i586.rpm: rsa sha1 (md5) pgp md5 OK



INSTALL A PACKAGE



[root@chaitanyaoracledba]# rpm - Uvh jre-8u111-linux-i586.rpm


Preparing...                ########################################### [100%]

   1:jre1.80_111           ########################################### [100%]


RPM commands and options



  •     -i : install a package
  •     -v : verbose for a nicer display of package
  •     -h: print hash marks as the package archive is unpacked.



If a package with same name and version is already installed below output will show like this


[root@chaitanyaoracledba]# rpm - Uvh jre-8u111-linux-i586.rpm


Preparing...                ########################################### [100%]

           package jre1.8.0_111-1.8.0_111-fcs.i586 is already installed




However if you want to install the package anyway, youcanuse --replacepkgs option 


[root@chaitanyaoracledba]# rpm - ivh --replacepkgs jre-8u111-linux-i586.rpm

Preparing...                ########################################### [100%]

   1:jre1.8.0_111           ########################################### [100%]




 Force, option which tells RPM to ignore the error  


[root@chaitanyaoracledba]# rpm - ivh jre-8u111-linux-i586.rpm -- force

Preparing...                ########################################### [100%]

   1:jre1.8.0_111           ########################################### [100%]



If you attempt to install a package that contains a file which already been installed by another package below output show like this



[root@chaitanyaoracledba]# rpm-Uvh foo-1.0-1.i386.rpm

Preparing... ...               ########################################### [100%]

file   /usr/bin/foo from install of foo-1.0-1 conflicts with file from package bar-2.0.20



To make RPM ignore this error ,use the replacefiles option


[root@chaitanyaoracledba]# rpm-ivh--replacefiles  foo-1.0-1.i386.rpm



RPM packages may sometimes depend on other packages which requires other packages to be installed on the linux/unix system 


if u try to install a package which has an unresolved dependency package the below output shows like this


error : Failed dependencies:

bar.so.2 is needed by foo-1.0-1

suggested resolutions:

bar-2.0.20-.i386.rpm


If you are installing a pacakage ,it usually suggest the package needed to resolve the dependency


Download suggested packages from redhat sites and add it to the command


rpm -ivh foo-1.0-1.i386.rpm bar-2.0.20-3.i386.rpm



if both the packages are installed sucessfully it will show like this 


Preparing... ...               ########################################### [100%]  


                1:foo  ########################################### [100%]  

                2 :bar ########################################### [100%]  


if it does not suggest a package to resolve the dependency ,you cantry the --redhatproviders option to determine which package contains the required file


[root@chaitanyaoracledba]# rpm -q --redhatproviders bar.so.2


you need the rpmdb-redhat package installed to use this option


bar-2.0.20-3.i386.rpm



To force the installtion anyway,use the -nodeps option


[root@chaitanyaoracledba]# rpm-ivh  foo-1.0-1.i386.rpm --nodeps



UNINSTALL  A PACKAGE


To remove the uninstall package use the - erase option


[root@chaitanyaoracledba]# rpm - e jre1.8.0_111



UPGRADE A PACKAGE


To upgarde the package  RPM automatically uninstalls any old versions use the -U option  will install a package when there are no previous versions of the package installed 


[root@chaitanyaoracledba]# rpm - Uvh jre-8u111-linux-i586.rpm



FRESHENING A PACKAGE


Freshning a package similar to upgrading except that only existing packages are upgraded below is the command


[root@chaitanyaoracledba]# rpm - Fvh jre-8u111-linux-i586.rpm



QUERY DATABASE


To query this database use the -q option ,The rpm -q  package name command displays the package name,version,and relese number of the installed package name


 [root@chaitanyaoracledba]# rpm -q jre1.8.0_111

                                                 jre1.8.0_111-1.8.0_111-fcs.i586



Check all the installed package on the system


[root@chaitanyaoracledba]# rpm -qa




check whether particular package is installed or not


[root@chaitanyaoracledba]# rpm -q jre1.8.0_111

                                                 jre1.8.0_111-1.8.0_111-fcs.i586


Check a package is consistent or not before installing it


[root@chaitanyaoracledba]# rpm -ivh --test jre-8u111-linux-1586.rpm


       Preparing...                ########################################### [100%]



To see the information about the installated package use below command to show


[root@chaitanyaoracledba]# rpm -qi jre1.8.0_111



To see the configuration file of the installed package use below command to show


[root@chaitanyaoracledba]# rpm -qlc jre1.8.0_111



To see the directory with which a particular package is associated


[root@chaitanyaoracledba]# rpm -qld jre1.8.0_111



Note : Info on RPM Package Management it may be differ on your environment like development,testing,production and naming conventions etc



THANKS FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME AND SUBSCRIBE ME


Friday, September 18, 2020

ASH Report in Oracle

 ASH Report in Oracle


Introduction


The ASH Report in Oracle contains recent information on active sessions sampled every second,The AWR and ADDM report will taken every one hour genetates and one hour old report will not generate and will not help in diagnosis issues that are in the current database


The ASH Report in Oracle report is an integral part of the oracle database self-management framework and is extremely useful for diagnosing performance problems


ASH Report in Oracle,difference between awr and ash report,oracle ash report,generate ash report,ash report analysis,awr and ash report in oracle,generate ash report for sql_id,awr addm ash reports,awr ash and addm reports,generate ash report in oem 12c,ash oracle 12c,ash report in oracle 11g,ash report in oracle 12c rac


The ASH Report in Oracle gathers sampled data at the session level rather than at the instance level by capturing statastics for only active sessions ,ASH report collects a manageable set of data


ASH Report in Oracle these are the parameters below are the following


  • SQL identifier of a SQL statement

  • Object number,file number,and block number

  • Wait event identifier and parameters

  • Session identifier and session serial number

  • Module and action name

  • Client identifier of the session


Let us start the process


In this blog i am going to explain ASH Report in Oracle  in single instance database and Rac database and also i am going to tell detailed in ASH report manually 

The AWR and ADDM report will taken every one hour genetates Report

Here i am using  ORCL database and ORCL instance in this example


The ashrpt.sql SQL script generates an HTML or text report that displays ASH information for a specified duration.


To generate an ASH report:


Login to sqlplus / as sysdba


Step 1: At the SQL prompt, enter:


SQL>@$ORACLE_HOME/rdbms/admin/ashrpt.sql


or 


SQL@?/rdbms/admin/ashrpt.sql

ASH Report in Oracle,difference between awr and ash report,oracle ash report,generate ash report,ash report analysis,awr and ash report in oracle,generate ash report for sql_id,awr addm ash reports,awr ash and addm reports,generate ash report in oem 12c,ash oracle 12c,ash report in oracle 11g,ash report in oracle 12c rac

ASH Report in Oracle,difference between awr and ash report,oracle ash report,generate ash report,ash report analysis,awr and ash report in oracle,generate ash report for sql_id,awr addm ash reports,awr ash and addm reports,generate ash report in oem 12c,ash oracle 12c,ash report in oracle 11g,ash report in oracle 12c rac


ASH Report in Oracle,difference between awr and ash report,oracle ash report,generate ash report,ash report analysis,awr and ash report in oracle,generate ash report for sql_id,awr addm ash reports,awr ash and addm reports,generate ash report in oem 12c,ash oracle 12c,ash report in oracle 11g,ash report in oracle 12c rac


Step 2.: Specify whether you want an HTML or a text report:

ASH Report in Oracle,difference between awr and ash report,oracle ash report,generate ash report,ash report analysis,awr and ash report in oracle,generate ash report for sql_id,awr addm ash reports,awr ash and addm reports,generate ash report in oem 12c,ash oracle 12c,ash report in oracle 11g,ash report in oracle 12c rac

ASH Report in Oracle,difference between awr and ash report,oracle ash report,generate ash report,ash report analysis,awr and ash report in oracle,generate ash report for sql_id,awr addm ash reports,awr ash and addm reports,generate ash report in oem 12c,ash oracle 12c,ash report in oracle 11g,ash report in oracle 12c rac

ASH Report in Oracle,difference between awr and ash report,oracle ash report,generate ash report,ash report analysis,awr and ash report in oracle,generate ash report for sql_id,awr addm ash reports,awr ash and addm reports,generate ash report in oem 12c,ash oracle 12c,ash report in oracle 11g,ash report in oracle 12c rac



Enter value for report_type: html


In this example, a html report is chosen.


Step 3:. Specify the begin time in minutes before the system date:

 

ASH Report in Oracle,ash report generation,ash report analysis,ash report for rac,ash report vs awr report,ash_report_analytics,ash report activity over time,ash report for a particular session,what is a ash report,ash report analysis in oracle 11g,generate ash report in oem 12c

ASH Report in Oracle,ash report generation,ash report analysis,ash report for rac,ash report vs awr report,ash_report_analytics,ash report activity over time,ash report for a particular session,what is a ash report,ash report analysis in oracle 11g,generate ash report in oem 12c

ASH Report in Oracle,ash report generation,ash report analysis,ash report for rac,ash report vs awr report,ash_report_analytics,ash report activity over time,ash report for a particular session,what is a ash report,ash report analysis in oracle 11g,generate ash report in oem 12c


Enter value for begin_time: -10


In this example, 10 minutes before the current time is selected.


Step 4.: Enter the duration in minutes that the report for which you want to capture ASH information from the begin time.

ASH Report in Oracle,ash report generation,ash report analysis,ash report for rac,ash report vs awr report,ash_report_analytics,ash report activity over time,ash report for a particular session,what is a ash report,ash report analysis in oracle 11g,generate ash report in oem 12c

ASH Report in Oracle,ash report generation,ash report analysis,ash report for rac,ash report vs awr report,ash_report_analytics,ash report activity over time,ash report for a particular session,what is a ash report,ash report analysis in oracle 11g,generate ash report in oem 12c

ASH Report in Oracle,ash report generation,ash report analysis,ash report for rac,ash report vs awr report,ash_report_analytics,ash report activity over time,ash report for a particular session,what is a ash report,ash report analysis in oracle 11g,generate ash report in oem 12c


Enter value for duration:


In this example, the default duration of system date minus begin time is accepted.


Step 5: Specify the Report  name, or accept the default report name:

ASH Report in Oracle,ash report generation,ash report analysis,ash report for rac,ash report vs awr report,ash_report_analytics,ash report activity over time,ash report for a particular session,what is a ash report,ash report analysis in oracle 11g,generate ash report in oem 12c

ASH Report in Oracle,ash report generation,ash report analysis,ash report for rac,ash report vs awr report,ash_report_analytics,ash report activity over time,ash report for a particular session,what is a ash report,ash report analysis in oracle 11g,generate ash report in oem 12c


Enter value for report_name:

Using the report name : / u01/ash.html


In this example, ASH report ash.html is generated. The report will gather ASH information beginning from 10 minutes before the current time and ending at the current time.



To generate an ASH report in an Oracle RAC environment:


Step1: At the SQL prompt, enter:


SQL@$ORACLE_HOME/rdbms/admin/ashrpti.sql


Step2: Specify whether you want an HTML or a text report:


Enter value for report_type: html


In this example, an HTML report is chosen.


Step 3: A list of available database IDs and instance numbers are displayed:


Instances in this Workload Repository schema


DB Id         Inst Num   DB Name      Instance Host

----------- -------- ------------ ------------ ------------

2206262418 2    ORCLorcl localhost1660

2206262418 1    OMALL341 omallt341 cha341

2206262418 2    OMALL341 omallt342 cha342

2206262418 3   OMALL341 omallt343 cha343

2206262418 4    OMALL341 omallt344 cha344


Enter the values for the database identifier (dbid) and instance number (inst_num):


Enter value for dbid: 2206262418

Using database id: 2206262418

Enter instance numbers. Enter 'ALL' for all instances in an Oracle

RAC cluster or explicitly specify list of instances (e.g., 1,2,3).

Defaults to current instance.

Enter value for inst_num: ALL

Using instance number(s): ALL


Step 4: Specify the begin time in minutes before the system date:


Enter value for begin_time: -1:10


In this example, 1 hour and 10 minutes before the current time is selected.


Step 5:. Enter the duration in minutes that the report for which you want to capture ASH information from the begin time:


Enter value for duration: 10


In this example, the duration is set to 10 minutes.


Step 6:. Specify the slot width in seconds that will be used in the Activity Over Time section of the report:


Enter value for slot_width:


In this example, the default value is accepted.


Step 7: Follow the instructions as explained in the subsequent prompts and enter values for the following report targets:


* target_session_id

* target_sql_id

* target_wait_class

* target_service_hash

* target_module_name

* target_action_name

* target_client_id

* target_plsql_entry


Step 8: Enter a report name, or accept the default report name:


Enter value for report_name:

Using the report name ashrpt_rac_0210_0232.txt


In this example, the default name is accepted and an ASH report named ashrpt_rac_0210_0232 is generated. The report will gather ASH information on all instances belonging to the database with a database ID value of 2206262418 beginning from 10 minutes before the current time and ending at the current time.



Note: Info on ASH Report in Oracle itmay be differ in your environment like production,testing,development etc


THANKS FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME OR SUBSCRIBE ME


Saturday, September 12, 2020

Linux Commands Tutorial

 Linux Commands Tutorial


Introduction:In this Blog i am going to explain  Linux Commands Tutorial  Linux is a Unix-Like operating system. All the Linux/Unix commands are run in the terminal provided by the Linux system. This terminal is just like the command prompt of Windows OS. Linux/Unix commands are case-sensitive. The terminal can be used to accomplish all Administrative tasks


Let us Start the Process Linux Commands Tutorial


1)logname: It shows current username


# logname


2)pwd: Present working directory which means current folder in linux


# pwd


3)date: it display system date and time


# date


4)clear: to clear the screen


 # clear


5)cal: current month calendar we can call month and year along with cal command  ex: cal 5 1982  which displays may month 1982


 # cal


6)uname:  it dispalys the present os name.


 # uname


7)uname -r:  displays kernal version

 

# uname -r


8)hostname: displays server name


 # hostname


9)hostname -i: display server ip address


# hostname -i


10)who: it shows list  of connect user in that server

 

# who


11)who am i:  current logged user info


# who am i 


12)su:  switch username from one user into another user   ex:su - username(oracle is the username)


 # su - oracle 


13)exit:  logout from current user logged in


 # exit


14)man command name: help of the given command


# man


WORKING WITH FILES:


1)cat:  which is use to create a new file or open to  view existing files


# cat chaitanya.txt


2)cat>>filename: appending data to these file


# cat >> chaitanya.txt


3)$touch filename: which  create an empty file with zero kb


# touch chaitanya.txt



FILE DELETION:


 1)rm: to delete the file


# rm chaitanya1.txt


 2)rm -rf: delete the files forcibly 


# rm - rf chaitanya2.txt


 3)rm -i: delete the file which asks the  user conformation 


 # rm - i chaitanya.txt


 4)rm file1 file2: deleting multiple files


# rm chaitanya1.txt  chaitanya2.txt



WORKING WITH DIRECTORIES:



1)mkdir: To create a new directory (Directory is  nothing  but a drive or folders like windows) in linux (here i am using  Linux Commands Tutorial chaitanya is the directory name)


 # mkdir chaitanya  


2)cd dirname: to change a directory (one directory to another directory)


# cd orabackup


3)cd .. : to moves from  current directory into previous directory


# cd ..


4)cd: to come out entire directory


#  cd 


5)cd /: it changes the root directory


# cd /



REMOVING DIRECTORIES:



1)rmdir: to removing directory it must be empty( here i am using Linux Commands Tutorial chaitanya is the directory in that chaitanya directory it should be empty then only it will be deleted)


# rmdir chaitanya


2)rm -r direcname: it deletes recursively to entire structure


# rm - r chaitanya


3)rm -ri direcname: it deletes recursively to entire structure it will ask the user confirmation (here iam using  Linux Commands Tutorial chaitanya is the directory)

 

 # rm - ri


4)rm -rf direcname: it deletes recursively to entire structure with forcibly


# rm -rf


COPY COMMANDS


1)cp sourcefile targetfile: copying file from existing location into  new location


# cp chaitanya1.txt   chaitanya3.txt


# cp chaitanya3.doc  chaitanya03new.doc


# ls - l * .doc( it will displays all doc related files)


# ls - l *.txt (it will displays all text related files)


COPY MULTIPLE FILES SIMULTANEUOSLY INTO ANOTHER DIRECTORY


# cp main.txt demo.txt libc.txt     backup


If backup is located in /home/project, enter:


#  cp main.txt demo.txt libc.txt     /home/project backup


COPY A FILE TO ANOTHER DIRECTORY  


To copy a file from your current directory into another directory called /tmp/, 



# cp filename /tmp

# ls /tmp/filename

# cd /tmp

# ls


COPYING ALL FILES


The star wildcard represents anything i.e. all files. To copy all the files in a directory to a new directory, enter:


# cp *  /u01/oracle/backup


The star wildcard represents anything whose name ends with the .doc extension. So, to copy all the document files (*.doc) in a directory to a new directory, enter:


# cp *.doc  /u01/oracle/backup


To copy a directory, including all its files and subdirectories, to another directory, enter (copy directories recursively):


# cp -R *  /u01/oracle/backup


To copy a file to a new file and preserve the modification date, time, and access control list associated with the source file, enter:


# cp -p chaitanya.txt  /dir1/dir2/

$ cp -p filename /path/to/new/location/myfile


MOVING COMMANDS


1)mv old file newlocation: using these command we can move a file from one folder into  another  folder or we can rename file also


Move mainc.txt defh.txt  files to /u01/oracle/oracbackup/ directory:


# mv mainc.txt defh.txt   /u01/oracle/orabackup/


Move all C files in current directory to subdirectory orabackup :


# mv *.c orabackup



Move all files in subdirectory orabackup to current directory :


# mv orabackup/* .



Rename file main.c to main.backup:


# mv main.c main.backup



Rename directory bak to bak3:


# mv bak bak3


 

Update - move when main.c is newer:


# mv -u main.c bak

#



Move main.c and prompt before overwrite bak/main.c:


# mv -v main.c bak

'bak/main.c' -> 'bak/main.c'

#



VIEWING FILE COMMANDS


1)ls : it's listing files which are in that directory with  ascending order


# ls


2)ls -a: listed all files including  hidden files also


# ls -a 


3)ls -l: listed all files in long list  format i.e 9 field


# ls -1


4)ls -t: listed all files based on date and time of creation


# ls -t


5)ls -r: listed all files on descending order or sin reverse


# ls -r


6)ls -R: listed all files recursively


# ls -R


CREATING HIDDEN FILES


1)cat>.filename


# cat > .chaitanya9.txt


2)mv filename .filename


# mv chaitanya1.txt  .chaitanya6.txt


3)mkdir .dirname


# mkdir  .chaitanya


UNHIDE FILES


1)mv .chaitanya chaitanya


# mv  .chaitanya chaitanya


2)mv .dirname dirname


# mv . chaitanya chaitanya




Note: Info on  Linux Commands Tutorial it may be differ in your environment like production,testing development and naming conventions etc



THANKS FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME OR SUBSCRIBE ME

Friday, September 11, 2020

Oracle 18c New Features

 Oracle 18c New Features


Introduction


In this blog i am going to explain three new Oracle 18c New Features which is useful for oracle database administrators 

SET ROWLIMIT 

ORAVERSION UTILITY

SET FEEDBACK OPTION


SET ROWLIMIT command enables users to set a limit for the number of rows displayed for a query.


for limiting number  of rows to 5 in Oracle 18c New Features


SQL> set rowlimit 5

SQL> select username from dba_users;



USERNAME

—————————

SYS

SYSTEM

ABHIRAM

CHAITANYA

MANASA


5 rows selected. (rowlimit reached)


for limiting number  of rows to 3

SQL> set rowlimit 3

SQL> select username from dba_users;



USERNAME

————————

SYS

SYSTEM

CHAITANYA


3 rows selected. (rowlimit reached)



Oraversion Utility in Oracle 18c New Features


A new utility Oraversion has been introduced in Oracle 18c New Features Which provides Oracle database version/release related information.


oraversion -help


This program prints release version information.


These are its possible arguments:


-compositeVersion: Print the full version number: a.b.c.d.e.

-baseVersion: Print the base version number: a.0.0.0.0.

-majorVersion: Print the major version number: a.

-buildStamp: Print the date/time associated with the build.

-buildDescription: Print a description of the build.

-help: Print this message.


$ oraversion -compositeVersion

18.3.0.0.0

 

$ oraversion -baseVersion

18.0.0.0.0

 

$ oraversion -majorVersion

18

 

$ oraversion -buildStamp

180628094320

 

$ oraversion -buildDescription

Release_Update



In Oracle 18c New Features, we can display the sql_id of the sql queries we are running using set feedback option.


By default it will be OFF.


SQL> set feedback ON SQL_ID

SQL> select name from v$database;


NAME

———

ORA18C


1 row selected.


SQL_ID: 0btb065ytg2v0 –  > This is the sql_id of the query . 



Note : Info on  Oracle 18c New Features it maybe differ in your environment like production,testing,development etc and naming conventions


THANKS FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME OR SUBSCRIBE ME 

Thursday, September 10, 2020

Crontab Linux

Crontab Linux


Introduction:

Crontab Linux system has a useful task scheduler named crontab, to automate the scheduled to run the process as a Root, the Unix Scheduling tool, The Cron tab commands opens the cron table for editing.The cron table is the list of tasks scheduled to run at regulartime intervals on the system

The Daemon which reads the crontab and executes the commands at the right time is called Crontab Linux for instance you can automate like backup,schedule updates andsynchroniztion files and many more


In Crontab Linux Oracle DBA jobs to be managed


Analyze Database


Rman backups


Datapump jobs


Hot/cold backups


Archive log backups


House keeping jobs --Cleaning alert log/Trace files


Gathering stats


Delete old log files


Send out any notification email such as newsletter,passwords,expiration mail


Regular cleaned up of cached data


Crontab Linux is used to automate sytem mainatanace




Let us Start the process


Crontab Linux Format


MIN   HOUR   DOM  MON   DOW   CMD




Field Description     Allowed Value


MIN Minute field      0 to 59

HOUR Hour field       0 to 23

DOM Day of Month       1-31

MON Month field        1-12

DOW Day Of Week          0-6

CMD Command       Any command to be executed.


 

chaitanyaoracledba blog


Asterics(*) : use for matching


Define Range : Allows you to define range with the help of hypen like 1-10 or 30 -40 or jan-mar,mon-wed


Define Multiple Ranges: Alows you to define various ranges with command separated like apr-jun,oct-dec



Crontab Linux Commands



How to Add /Modify crontab job  with the help of cron tab command


$ crontab -u -e 



To List the Crontab jobs 


$ crontab -l



To Remove the Crontab tasks 


$ crontab -r


To add or update job in crontab 


$ crontab -e


Command to edit others users crontab


$ crontab -u username -e


Command to view crontab entries of current user


$ crontab -l


Command to view crontab entries of a specific user


crontab -u username -l



Here Some of the Crontab Examples



Crontab Linux to do the various scheduling jobs. Below given command execute at 7 AM and 5 PM daily.


0 7,17 * * * /orabackup/scripts/scriptjob.sh



Command to execute a cron after every 5 minutes.


*/5* * * * * /orabackup/scripts/scriptjob.sh



Cron scheduler command helps you to execute the task on every Monday at 5 AM. This command is helpful for doing weekly tasks like system clean-up.


0 5 * * mon  /orabackup/scripts/scriptjob.sh


Command run your script on 3 minutes interval.


*/3 * * * * /orabackup/scripts/scriptjob.sh



Command to schedule a cron to which executes for a specific month. This command to run tasks run in Feb, June and September months. Sometimes we need to schedule a task to execute a select monthly task.


* * * feb,jun,sep * /orabackup/scripts/scriptjob.sh


Command to execute on selected days. This example will run each Monday and Wednesday at 5 PM.


0 17 * * mon,wed  /orabackup/scripts/scriptjob.sh


This command allows cron to execute on first Saturday of every month.


0 2 * * sat  [ $(date +%d) -le 06 ] && /orabackup/scripts/scriptjob.sh



Command to run a script for 6 hours interval so it can be configured like below.


0 */6 * * * /orabackup/scripts/scriptjob.sh



This command schedule a task to execute twice on Monday and Tuesday. Use the following settings to do it.


0 4,17 * * mon,tue /orabackup/scripts/scriptjob.sh



Command schedule a cron to execute after every 15 Seconds.


* * * * * /orabackup/scripts/scriptjob.sh

* * * * *  sleep 15; /orabackup/scripts/scriptjob.sh



Command to schedule tasks on a yearly basis.

@yearly timestamp is= to "0 0 5 1 *". This executes the task in the fifth minute of every year. You can use it to send for new year greetings.



@yearly /orabackup/scripts/scriptjob.sh



Command tasks to execute on a monthly basis.

@monthly timestamp is similar to "0 0 1 * *". This command expression allows the execution of a task in the first minute of the month.


@monthly /orabackup/scripts/scriptjob.sh



Command to execute multiple tasks using a single cron.


* * * * * /orabackup/scripts/scriptjob.sh; /orabackup/scripts/scriptjob2.sh



Command to schedule tasks to execute on a weekly basis.

@weekly timestamp is similar to "0 0 4 * sun". This is used to perform the weekly tasks like the system cleanup etc.


@weekly /bin/orabackup/scripts/scriptjob.sh



Task will be scheduled to execute on a daily basis.

@daily timestamp is similar to "0 2 * * *". It executes the task in the second minute of every day.


@daily /orabackup/scripts/scriptjob.sh



Allows tasks to execute on an hourly.

@hourly timestamp is similar to "0 * * * *". This command executes a task in the first minute of every hour.


@hourly /orabackup/scripts/scriptjob.sh


Allows tasks to execute on system reboot.

@reboot expression is useful for those tasks that the system wants to run on your system startup. This is helpful to begin tasks background automatically.


@reboot /orabackup/scripts/scriptjob.sh



we use shell scripts to create jobs


.sh /.ksh (types of shell are korn(IBM-AIX) / bash (linux c shell)


scripts in /orabackup/scripts


Sample Scenario



32  11  *  *  */orabackups/script/scriptjob.sh


create the script


$ vi scriptjob.sh


#!/bin/sh


find /archives/prod-name " *.arc" -mtime +1-exec gzip{ }\;


find /archives/prod-name " *.gz"  mtime +7 -exec rm-rf{ }\;


now save  :wq!



Give execution permission


$ chmod +x scriptjob.sh


edit the crontab


$ crontab -e


# give an entry as follows 


30  11  4  6  *  / orabackup/script/scriptjob.sh


then save it




*   *  *  *  *  * command to executed


Min  (0-59)


  Hour      (0-23)


     Day of Month  (1-31)


               month        (1-12)


       Day of the week   (0-6)  (0/7 is sunday  sunday =0 or7)



Note : Info on Crontab Linux it may be differ in yourenvironment like production,testing,development and naming conventions etc



THANKS FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME OR SUBSCRIBE ME


ITIL Process

ITIL Process Introduction In this Blog i am going to explain  ITIL Process, ITIL stands for Information Technology Infrastructure Library ...