How to remove UEK (unbreakable enterprise kernel)

Check all the kernel’s installed

Check current kernel in use.

remove uek kernel using yum command

now my kernel is downgraded to 2.6.18-398.el5.

please feel free to write me at sunil@sunilthetechfreak.com

how to restore OCR after complete loss of single OCR diskgroup

crs daemon was not able to start as my ocr diskgroup was not mounted. I logged in to asm instance.

But i was able to mount my other diskgroups

also checked using asmcmd lsdg –discovery command

came to know after checking alertlog CRS diskgroup had corrupted block.

 

referring doc id 1062983.1 i was able to restore ocr to a new disk with same diskgroup name

please feel free to ask me at sunil@sunilthetechfreak.com

 

Generic failure interacting with CRS while using asmca utility to mount diskgroup

While i was mounting diskgroup using asmca utility. I got the below error

ASM configuration utility error while mounting diskgroup

I just logged in  sqlplus / as sysasm and issued the below command

the issue was resolved and i was able to create database.

Hope that helps

How to extend root partition on linux using lvm

Here my partition is on lvm (Logical volume manager)

Check physical volume

Check Volume group

here you can see i have only one disk sda

Now i will add new disk to my virtual machine
right click on the virtual machine and select settings
then click on add select hard disk from the above list
click on next
select scsi and click next
create new disk and click next
specify disk capacity in my case i am adding 15g and click on split virtual disk into multiple files and click next
provide the diskname.vmdk and specify the location where it should be saved and click on finish
click on ok to exit the virtual machine settings

no need to restart the running virtual machine just type the below command so that system scans the new disk

new disk is added /dev/sde

now follow the step to extend the root partition

create physical volume & check /dev/sde1 has 19.99G free space.

we have only one volume group VolGroup00 so we will extend our volume group first

you can see Free PE is 639 / 19.97GB available

we have to extend our root partition which is  /dev/VolGroup00/LogVol00

if you have any doubts or need help please feel free to email me at sunil@sunilthetechfreak.com

 

 

How to move VMware Workstation 11 virtual machine to ESXI 6.0 Server

Step by Step guide download document here

How to Drop Oracle Enterprise Manager 12c repository

[oracle@db11gr2 config]$ $ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Feb 10, 2013 4:59:04 PM

EM Configuration Assistant, Version 11.2.0.0.2 Production

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:

Database SID: DB11G

Listener port number: 1521

Password for SYS user:

Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: y

Feb 10, 2013 4:59:24 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/DB11G/emca_2013_02_10_16_59_04.log.

Feb 10, 2013 4:59:24 PM oracle.sysman.emcp.util.DBControlUtil stopOMS

INFO: Stopping Database Control (this may take a while) …

Feb 10, 2013 4:59:54 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl

WARNING: Error initializing SQL connection. SQL operations cannot be performed

Feb 10, 2013 4:59:54 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Dropping the EM repository (this may take a while) …

Feb 10, 2013 5:15:12 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully dropped

Enterprise Manager configuration completed successfully

FINISHED EMCA at Feb 10, 2013 5:15:18 PM

[oracle@db11gr2 config]$

2014 in review

sunilthetechfreak 2014 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 9,800 times in 2014. If it were a concert at Sydney Opera House, it would take about 4 sold-out performances for that many people to see it.

Click here to see the complete report.

Upgrade non asm oracle database 11.2.0.1 to 11.2.0.4 using dbua

Step by step guide to upgrade non asm database 11.2.0.1 to 11.2.0.4 using dbua Download

ORA-28000 account locked error while creating database using dbca on Grid Infrastructure with ASM on Standalone Server

My environment details
OS : OEL 6.5 64bit
Database version : 11.2.0.4
grid infrastructure with asm on Standalone Server

I had two issues while creating database using dbca

1) I was not able to see the diskgroup at step 6 after selecting Automatic storage management, i selected use oracle-managed files
and at database area after clicking the browse button no diskgroup was shown in that area it was blank

Cause of problem :
oracle user was not part of asmdba group

Solution :
I added oracle user to asmdba group as i missed to add oracle user to asmdba group

usermod -G asmdba oracle

after that i could see the diskgroup after selecting browse button

2) ORA-28000 account locked error after it completes 43% while creating database

Cause of problem :
oracle user was not part of dba group

as you can see from the output

[oracle@oralab1 cfgtoollogs]$ id oracle

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54324(asmdba)

[oracle@oralab1 cfgtoollogs]$ id grid

uid=54322(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(asmadmin),54324(asmdba),54325(asmoper)

Solution :
usermod -a -G dba oracle

after adding oracle user to dba group database creation was successful

How to fix shared folder issue in vmware workstation 10 for Oracle Linux 6.5 guest

[root@asm1 bin]# yum -y install kernel-uek.x86_64
[root@asm1 bin]# yum -y install gcc
[root@asm1 bin]# yum -y install kernel-uek-devel.x86_64

[root@asm1 bin]# ln -s /usr/src/kernels/3.8.13-16.2.1.el6uek.x86_64/include/generated/uapi/linux/version.h /usr/src/kernels/3.8.13-16.2.1.el6uek.x86_64/include/linux/version.h

uninstall vmware-tools

[root@asm1 bin]# cd /tmp/vmware-tools-distrib/bin
[root@asm1 bin]# ./vmware-uninstall-tools.pl

reinstall vmware-tools
[root@asm1 bin]# cd /tmp/vmware-tools-distrib
[root@asm1 bin]# ./vmware-install.pl -default

now you can change your directory to /mnt/hgfs and check your shared folder
[root@asm1 /]# cd /mnt/hgfs/