Tuesday, July 3, 2018


Installing the Unbreakable Enterprise Kernel

If the installed system is configured to use the Red Hat Compatible Kernel and the Unbreakable Enterprise Kernel (UEK) is not installed, you can use yum to install the kernel-uek package:
# yum install kernel-uek
Installing kernel-uek also installs the kernel-uek-firmware package on which it depends, and configures the UEK as the default kernel in /etc/grub.conf. Reboot the system to use this kernel.

Tuesday, June 26, 2018


Oracle Linux & Red Hat Linux


Get the opened ports with service and port number

# netstat -tulpn
# iptables -L











Enable ports from the fire wall

[root@evis ~]# iptables -I INPUT -p tcp -m tcp --dport 5901 -j ACCEPT

[root@evis ~]# service iptables save






Monday, June 4, 2018


Basics of the crontab ∞

Crontab file controls how and what to run by cron. The crontab line has a format as follows:
.---------------- minute (0-59)
|  .------------- hour (0-23)
|  |  .---------- day of month (1-31)
|  |  |  .------- month (1-12) OR jan,feb,mar,apr ...
|  |  |  |  .---- day of week (0-6) (Sunday=0 or 7) OR sun,mon,tue ...
|  |  |  |  |
*  *  *  *  *  command to be executed
To add a cron job for your current user, run
$ crontab -e

use crontab extensions ∞

crontab provides some extensions to support this: ranges can include “steps” like /2. 1-9/2 is the same as 1,3,5,7,9. This can be the easiest method if the job is intended to be run every two N in a range such as N is “day” and the range is “days in a month”. Check the crontab man page for more details about ranges and steps of crontab.
An example.
To run the command every two months at 1:00 on the first day of the month, the crontab is
0 1 1 */2 * command to be executed

Friday, June 1, 2018


Generating the AWR Report


This chapter focuses on the skills required for reading and interpreting an Automated Workload Repository (AWR) report (awrrpt.sql), which is very similar to the STATSPACK elapsed-time report.  The AWR elapsed-time report (awrrpt.sql)contains valuable information regarding the health of the Oracle instance, but considerable skill is required to fully understand and interpret each section.

The easy way to generate an AWR report from from the SQL*Plus command line:


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

Generating the AWR Report
The procedure for creating a standard report provided by the STATSPACK utility in previous Oracle releases has already been introduced.  The only way to get a final STATSPACK report is to manually run the spreport.sql script in an ad-hoc SQL environment like SQL*Plus. The procedure of report generation in Oracle10g is quite different with AWR. The final AWR report can be built by using the PL/SQL API provided in the dbms_workload_repository package.
Two procedures that generate AWR reports from awrrpt.sql are awr_report_textand awr_report_html .  These procedures generate the AWR report for the specified snapshot range in TEXT or HTML formats, respectively.  The following script shows one way of retrieving the AWR text report for the particular snapshot range:

SELECT
   output 
FROM   
   TABLE
   (dbms_workload_repository.awr_report_text
      (37933856,1,2900,2911 )
   );


You can create snap using the below
EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot;

Below query help to find snaps information
select snap_id,BEGIN_INTERVAL_TIME,END_INTERVAL_TIME from dba_hist_snapshot where BEGIN_INTERVAL_TIME > systimestamp -1 order by BEGIN_INTERVAL_TIME desc;

Friday, May 25, 2018


Removing a package

You can uninstall a package using -e switch along with rpm command

NOTE: Before removing a package make sure you get the complete name of the package using the below command
# rpm -qa | grep cvs
cvs-1.11.23-16.el6.i686

# rpm -e cvs-1.11.23-16.el6.i686

Removing a package without dependencies

Use an extra argument --nodeps along with rpm command to remove/uninstall a package without dependencies
# rpm -e vsftpd-2.2.2-11.el6_4.1.i686 --nodeps

How to install/uninstall/upgrade rpm package with/without dependencies

I have already written an article with 15 practical examples on various rpm based commands which are used in real world of IT on a day to day basis.

Also do you know what every field of rpm name represents? This is one of the most trickiest interview questions asked many times

A RPM package abbreviated as Red Hat Package Manager refers to Red Hat package installed on Fedora, CentOS, OEL and all Red Hat source code derived OS.


Installing from the downloaded rpm package

Use -ivh switch along with rpm command as shown below

# cd /root/rpms
# rpm -ivh cvs-1.11.23-16.el6.i686.rpm
Preparing...                ########################################### [100%]
   1:cvs                    ########################################### [100%]

Installing directly from the package available on web.

But for this you need to have the proper link of the rpm you want to download or install
# rpm -ivh ftp://ftp.pbone.net/mirror/ftp.centos.org/6.5/os/i386/Packages/cvs-1.11.23-16.el6.i686.rpm
Retrieving ftp://ftp.pbone.net/mirror/ftp.centos.org/6.5/os/i386/Packages/cvs-1.11.23-16.el6.i686.rpm
warning: /var/tmp/rpm-tmp.z3VsTc: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Preparing... ########################################### [100%]
1:cvs ########################################### [100%]

Installing a package forcefully without dependencies

Use --force argument along with -ivh switch as shown below to install forcefully without dependencies
# rpm -ivh vsftpd-2.2.2-11.el6_4.1.i686.rpm --force
warning: vsftpd-2.2.2-11.el6_4.1.i686.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Preparing... ########################################### [100%]
1:vsftpd ########################################### [100%]

Upgrading a package

Use -Uvh switch along with rpm command
# rpm -q vsftpd
vsftpd-2.0.5-28.el5.i386

# rpm -Uvh vsftpd-2.2.2-11.el6_4.1.i686.rpm
warning: vsftpd-2.2.2-11.el6_4.1.i686.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Preparing... ########################################### [100%]
1:vsftpd ########################################### [100%]

Wednesday, May 2, 2018


EBS 12.2 Apps Cloning Error in OEL 6.7

Error 

 txkWfClone.sh exited with status 127 ERROR: txkWfClone.sh execution failed, exit code 127

Solution

 yum install glibc-devel.i686

RC-50013 Fatal: Instantiate driver

Error:
Seen the issue during the execution of adcfgclone.
perl adcfgclone.pl dbTechStack
====================
WARNING: [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
      <filename>  <phase>  <return code where appropriate>

  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts: 
    Directory: /u01/vis/visdb/tech_st/11.2.0/perl/bin/perl -I /u01/vis/visdb/tech_st/11.2.0/perl/lib/5.10.0 -I /u01/vis/visdb/tech_st/11.2.0/perl/lib/site_perl/5.10.0 -I /u01/vis/visdb/tech_st/11.2.0/appsutil/perl /u01/vis/visdb/tech_st/11.2.0/appsutil/clone
      ouicli.pl               INSTE8_APPLY       1 



AutoConfig is exiting with status 1

WARNING: RC-50013: Fatal: Instantiate driver did not complete successfully.
/u01/vis/visdb/tech_st/11.2.0/appsutil/driver/regclone.drv

====================

CAUSE:
The script was trying to register the oracle home in inventory but its failing to update it.

SOLUTION:

Edit and set correct path for oraInst.loc file

[root@viz Desktop]# vi /etc/oraInst.loc 

inst_group=dba
inventory_loc=/u01/vis/oraInventory

#inst_group=dba
#inventory_loc=/u01/dbobi/oraInventory

or
delete existing files under oraInventory folder and retry the adcfgclone.

rm -rf oraInventory
mkdir oraInventory
Retry :   perl adcfgclone.pl dbTechStack


 RMAN Recovery Catalog About Recovery Catalog RMAN recovery catalog Is another database which is out of your normal databases or which is o...