Tag: Osama mustafa ACE

Extend LVM Disk Linux

Posted on by Osama Mustafa in Operating system
This Article Will Describe step by step how to extend LVM Disk On Linux :-

1- After adding New Harddisk to the server you have to ReScan The Scsi using 

echo “- – -” > /sys/class/scsi_host/host?/scan

? :- Depend on you host number. 

2-  Use Fdisk to create new partition.

>fdisk -l
Disk /dev/sda: 107.3 GB, 107374182400 bytes
255 heads, 63 sectors/track, 13054 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          13      104391   83  Linux
/dev/sda2              14       13054   104751832+  8e  Linux LVM
Disk /dev/sdb: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk /dev/sdb doesn’t contain a valid partition table

 Check the below :-

#fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklab el
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won’t be recoverable.

The number of cylinders for this disk is set to 1305.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-1305, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-1305, default 1305):
Using default value 1305

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.

WARNING: Re-reading the partition table failed with error 16: Device or resource busy.
The kernel still uses the old table.
The new table will be used at the next reboot.
Syncing disks.

3-  Lets start increasing :-

pvcreate /dev/sdb1
Writing physical volume data to disk “/dev/sdb1”
Physical volume “/dev/sdb1” successfully created

vgdisplay
— Volume group —
VG Name Oracle
System ID
Format lvm2
Metadata Areas 1
Metadata Sequence No 4
VG Access read/write
VG Status resizable
MAX LV 0
Cur LV 3
Open LV 3
Max PV 0
Cur PV 1
Act PV 1
VG Size 99.88 GB
PE Size 32.00 MB
Total PE 3196
Alloc PE / Size 3196 / 99.88 GB
Free PE / Size 0 / 0
VG UUID MZ04D3-jZLy-0BWi-2WSP-oi9E-hBkl-e3a08d

vgextend Oracle /dev/sdb1  Volume group “Oracle” successfully extended

 pvscan
  PV /dev/sda2   VG Oracle   lvm2 [99.88 GB / 0    free]
  PV /dev/sdb1   VG Oracle   lvm2 [9.97 GB / 9.97 GB free]
  Total: 2 [109.84 GB] / in use: 2 [109.84 GB] / in no VG: 0 [0   ]

###

lvdisplay
— Logical volume —
LV Name /dev/Oracle/LogVol00
VG Name Oracle
LV UUID wKMZ16-LHsc-ktsc-3dTT-ieiq-pEfT-tODhqc
LV Write Access read/write
LV Status available
# open 1
LV Size 9.75 GB
Current LE 312
Segments 1
Allocation inherit
Read ahead sectors auto
– currently set to 256
Block device 253:0

— Logical volume —
LV Name /dev/Oracle/LogVol02
VG Name Oracle
LV UUID UabZCO-G8ID-dh1a-xv6t-Ss4O-QqEx-fnIy5g
LV Write Access read/write
LV Status available
# open 1
LV Size 82.34 GB
Current LE 2635
Segments 1
Allocation inherit
Read ahead sectors auto
– currently set to 256
Block device 253:1

— Logical volume —
LV Name /dev/Oracle/LogVol01
VG Name Oracle
LV UUID 78Y3bv-UZZI-Iu2w-gAyD-HXe1-Fx25-gmGuKn
LV Write Access read/write
LV Status available
# open 1
LV Size 7.78 GB
Current LE 249
Segments 1
Allocation inherit
Read ahead sectors auto
– currently set to 256
Block device 253:2

Now Let’s Extend :-

lvextend /dev/Oracle/LogVol00 /dev/sdb1 Extending logical volume LogVol00 to 19.72 GB
Logical volume LogVol00 successfully resized

 Finally :-

resize2fs /dev/Oracle/LogVol00resize2fs 1.39 (29-May-2006)
Filesystem at /dev/Oracle/LogVol00 is mounted on /; on-line resizing required
Performing an on-line resize of /dev/Oracle/LogVol00 to 5169152 (4k) blocks.

Notes :

  1. The Red Color for Command Line.
  2. The Brown Color For necessary Output. 
  3. /dev/Oracle/LogVol00 it’s the name for LVM Disk.
  4. /dev/sdb1 disk that we created using fdisk.

Thank you
Osama Mustafa

ORA-01031: insufficient privileges On ASM – Grid Infrastructure 11gR2

Posted on by Osama Mustafa in Database
Today like any other day started with customer call , Telling me There is problem on Grid infrastructure after restarting both node, They change heartbeat from cables to connected on switch after i told them to do this.

The Error in the logs like the  below :-
CRS-5011:Check of resource “+ASM” failed: details at “(:CLSN00006:)”

Node #2 was running without any problem , the issue was with node #1 and nothing changed recently.

The Error in Node #1 :-

crsctl start cluster

PRCR-1079 : Failed to start resource ora.asm
ORA-01031: insufficient privileges
CRS-5017: The resource action “ora.asm start” encountered the following error:
ORA-01031: insufficient privileges
. For details refer to “(:CLSN00107:)” in “/u01/app/grid/11.2.0.4/log/lux335/agent/ohasd/oraagent_oracle/oraagent_oracle.log”.

as you see from the above error “ORA-01031: insufficient privileges” i was running this command as root.
After check node #1 the solution so simple :-

Under $GRID_HOME/network/admin
vi sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES = (NONE)

which is wrong and to be changed to the following value :-

SQLNET.AUTHENTICATION_SERVICES = (NTS)

Reboot Node #1 and everything running successfully.

Thank you
Osama mustafa

OTN MENA Tour Experience – Dubai

Posted on by Osama Mustafa in News
Don’t be dismayed by good-byes. A farewell is necessary before you can meet again. And meeting again, after moments or lifetimes, is certain for those who are friends.


I Thought it will be nice to share this quotation before start talking about Oracle OTN Tour – MENA TOUR 2014. 
Fir the people who dosen’t know anything about this Tour it’s happened for the first time in middle-east, 
“Courtesy of the Oracle Technology Network (OTN) and the ARABOUG, the inaugural 2014 OTN MENA Tour brings a star-studded cast, consisting of some of the world’s best Oracle ACEs, ACE Directors and Rock Star Speakers to the region. The tour aims at sharing cutting edge knowledge and independent research in the MENA region, by accomplished Oracle experts from all over the world”
Covered the following countries :-
  • Tunisia
  • KSA- Saudi Arabia
  • Dubai.
Link Here.
Picture for the speaker getting ready for the event :-
Introduction about the Speaker :-
I will talking about Dubai, The event location was In Habtoor Grand Beach Resort & Spa. started at 8 Am – 5 pm During this time Oracle experts start sharing their knowledge and  chatting with them.
Different Topics , Different Speaker But it’s Only About Oracle, Performance tips, I/O , 12c , Fusion middleware , RAC 12c …
I spoke about Oracle Fusion middleware high Availability and crowd was really amazing.

 

I will do it again for sure Enshalla.

Thank you
Osama mustafa.

Enable Samba to Share from Linux to Windows

Posted on by Osama Mustafa in Operating system
To Setup and configure Shared Folder From Linux to Windows Follow the Below Steps :-

  • Install Samba Package on OS using the below command.
    • rpm -ivh samba Or yum install samba
  • After Install The Package configure   Username and password using the below command :-
    • smbpasswd -a oracle ( Or Any other user you want to share folder with )
  • On Linux Side –> Create Directory using mkdir /u01/share.
  • edit vi /etc/samba/smb.conf and configure the file to allow share to the above folder.

[Folder-name]
path = Folder_path
available = yes
valid users = User_will_user_folder.
read only = no
browsable = yes
public = yes
writable = yes

  • Restart Samba Services –> service smb restart
  • On Windows you can access the folder using Run –> \\Linux-Ip and enter the username and password.

Thank you
Osama Mustafa

Download Agent in EM12C manually

Posted on by Osama Mustafa in Application
Adding target to EM12C needs to install agent to the Target Host Depend on Operating system, the agent is now always available which mean install Agent for this operating system is necessary, the below picture describe the above case :-

Enterprise manager cloud 12c contains two different type of Connection mode online and offline, this blog describe how to install manually :-

From Setup –> extensibility –> Self Update

Press On Agent Software., The below screen will appear :-

By pressing any of those agent new pop up will open included with link to download, copy the link and upload the file to OMS Host and run the below command :-

[oracle@EM12C emcli]$ ./emcli import_update -omslocal -file=….

File Path should be provided in the above command.

The output :-

Processing update: Agent Software – Agent Software (12.1.0.1.0) for Microsoft Windows x64 (64-bit)
Successfully uploaded the update to Enterprise Manager. Use the Self Update Console to manage this update.

After Run the above command Successfully, Back to Self Update screen –> Agent Software and Apply the Download Catalog by press apply.

Thank you
Osama mustafa

OUG Ireland 2014

Posted on by Osama Mustafa in News
11/03 it’s Date For Oracle User Group Ireland.
Location : Dublin Convention Center.

Like any other Flights it’s took me 10 hours to be in Dublin,After Checked in the hotel First thing I did is attending Oracle ACE dinner and meet some Folks.

There was lot of Oracle Experts Speaker, Once the conference started I spent most of my day in RAC ATTACK Location and I would thank Mina Zadeh for this amazing Arrangement. it was really nice to meet her in person.

 Presentations was really amazing and useful, I would thank Oracle User Group Ireland for organizing and running this event so well.

Thank you
Osama Mustafa

soft limit maximum user processes/Oracle Linux

Posted on by Osama Mustafa in Operating system

As Root User access to
[root@EM12C Packages]# vi /etc/security/limits.conf

Then add the below line or modify it :

oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  4096
oracle              hard    nofile  65536
oracle              soft    stack   10240

Thank you
Osama Mustafa