Quick one!
# Warnings
cat /var/log/mysqld.log |grep `date +%y%m%d` | grep "\[Warning\]"
# Errors
cat /var/log/mysqld.log |grep `date +%y%m%d` | grep "\[ERROR\]"
And a Bonus!
To get entries from X days ago:
cat /var/log/mysqld.log |grep `date --date="46 days ago" +%y%m%d`
Matheus.
Hi all,
I always forget the command and have to search it again. For further searches, I expect to found in my own posts… 🙂
> To start Service
startsrc -s xntpd
> To stop Service
stopsrc -s xntpd
> Configuration File
/etc/ntpd.conf
Expect it be useful to you too.
See ya!
Matheus.
Hi all!
Quick one to resize swap online:
[root@server-db ~]# swapon -s Filename Type Size Used Priority /dev/mapper/rootvg-lvswap partition 5242872 373624 -1 [root@server-db ~]# vgs VG #PV #LV #SN Attr VSize VFree [...] rootvg 1 6 0 wz--n- 135.69G 5.69G [...] [root@server-db ~]# lvextend -L +2048M /dev/mapper/rootvg-lvswap Extending logical volume lvswap to 7.00 GB Logical volume lvswap successfully resized [root@server-db ~]# vgs VG #PV #LV #SN Attr VSize VFree [...] rootvg 1 6 0 wz--n- 135.69G 3.69G [...] [root@server-db ~]# mkswap /dev/mapper/rootvg-lvswap Setting up swapspace version 1, size = 7516188 kB [root@server-db ~]# swapoff /dev/mapper/rootvg-lvswap [root@server-db ~]# swapon /dev/mapper/rootvg-lvswap [root@server-db ~]# swapon -s Filename Type Size Used Priority /dev/mapper/rootvg-lvswap partition 7516188 373624 -1
See ya!
Matheus.
A quick script to do that:
grep line /sys/devices/system/memory/*/state | while read bla;
do echo online /sys/devices/system/memory/memory${bla}/state; done
Have a nice day!
Matheus.
We all faced that situation when we have to make a logical backup/export and haven’t so much area to do that, right?
We know the export usually compress a lot on zip/gzip… It wouldn’t be great if we can export directly to compressed file?
This situation become much more common because of Datapump, that requires a directory accessible by database server. If you have not possibility to make a mounting point or any other area, this can help…
## BKP with MKNOD BKP_DEST=/just/example DATE=`date +%Y%m%d%H%M` cd $BKP_DEST mknod bkp_$DATE.dmp p gzip bkp_$DATE.dmp.gz & ### Uncomment and Ajust one of: ## MySQL: #mysqldump -u $user -p$password $database > bkp_$DATE.dmp ## Oracle (Datapump or EXP) expdp \"/ as sysdba\" dumpfile=bkp_$DATE.dmp full=y directory=DIRECTORY_EXAMPLE logfile=log_bkpzipped.log compress=y #expdp $user/$password dumpfile=bkp_$DATE.dmp full=y directory=DIRECTORY_EXAMPLE logfile=log_bkpzipped.log #exp \"/ as sysdba\" file=bkp_$DATE.dmp log=log_bkpzipped.log compress=y [tables=owner.table,..] [owner=schema1,..] [...]
Hugs!
Matheus.
From disk to filesystem:
> Rescan on scisi controller to detect the disk (controller id 0, in this example)
echo "- - -" > /sys/class/scsi_host/host0/scan
– List disks
fdisk -l
> Fdisk choosing options n -> new p->partition 1-> partition number
fdisk /dev/sdm
> Create physcal volume
pvcreate /dev/sdm1
> Create Volume Group
vgcreate oracle /dev/sdb1
> Rename Volume Group
vgrename oracle vgoracle
> Create LV
lvcreate -L 19G -n lvoracle vgoracle
> Extend LV
lvextend -L +990M /dev/vgoracle/lvoracle
> Make FileSystem
mkfs.ext3 -m 0 -v /dev/vgoracle/lvoracle
OBS: m 0 is the journal (for recovery in case of crash). “0” because I don’t want it now. So, 100% of disco will be available for using on fs.
> Mount filesystem on Directory
mount -t ext3 /dev/vgoracle/lvoracle /oracle/
> Just to check:
$ df -h /dev/mapper/vgoracle-lvoracle 20G 173M 20G 1% /oracle
Have a nice day!
Matheus.
More than once I forgot to set LD_LIBRARY_PATH in new environments and sometimes I faced awkward errors. The most common is “Segmentation Fault”.
Today a lost almost 15 minutes searching about Segmentation Fault related to Datapump on 11.2, then I realized I forgot the LD_LIBRARY_PATH again…
Other day, in a Upgrade from 11.2.0.3.6 to 11.2.0.4.2 I get stuck in lots of errors on upgrade process. Bullshit again, after a few minutes of errors and searching I founded a post, somewhere, talking about the variables setting.
So, Matheus from the Future: Check if LB_LIBRARY_PATH and other variables are setted for the right Oracle Home.
I expect this post save me from this same pain in the future. 😛
Thanks.
Matheus.
# Problem
myserver:/home/oracle>srvctl start database -d mydb PRCR-1079 : Failed to start resource ora.mydb.db CRS-5017: The resource action "ora.mydb.db start" encountered the following error: ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device . For details refer to "(:CLSN00107:)" in "/grid/product/11.2.0/log/myserver/agent/crsd/oraagent_oracle/oraagent_oracle.log". CRS-2674: Start of 'ora.mydb.db' on 'myserver' failed CRS-5017: The resource action "ora.mydb.db start" encountered the following error: ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device . For details refer to "(:CLSN00107:)" in "/grid/product/11.2.0/log/myserver2/agent/crsd/oraagent_oracle/oraagent_oracle.log". CRS-2674: Start of 'ora.mydb.db' on 'myserver2' failed CRS-2632: There are no more servers to try to place resource 'ora.mydb.db' on that would satisfy its placement policy myserver:/home/oracle>
# Solution
On /etc/sysctl.conf ajust as below and then reload sysctl (“sysctl -p” as root):
#Old #kernel.shmall = 24641536 #New kernel.shmall = 4294967296
Matheus.
Hi all!
I frequently have to search about shellscript syntax (things like conditions and comparatives).
Shellscripting is not a daily routine, but sometimes it’s needed and I never remmember from the last time…
For those kind of people, this link/book shall be very helpful 🙂
(it’s in portguese, but everyone will understand…)
http://aurelio.net/shell/canivete/
Thanks for this tools, Aurelio!
Have a nice week guys!
Quick Post: To mount a directory via NFS from a RHEL7 remote server:
Souce Host:
[root@sourcehost ~]# cat /etc/exports /oracle/sharedir targethost(rw,no_root_squash,insecure) [root@sourcehost ~]# /bin/systemctl restart nfs.service
* Note: The “/bin/systemctl” is the new by RHEL7. For other versions you can just use “service nfs restart”.
Target Host:
[root@targethost ~]# mkdir -p /sourcehost/sharedir [root@targethost ~]# mount -t nfs sourcehost:/oracle/sharedir /sourcehost/sharedir [root@srac-his ~]# df -h /sourcehost/sharedir Filesystem Size Used Avail Use% Mounted on sourcehost:/oracle/sharedir 100G 279M 100G 1% /sourcehost/sharedir
Have a nice weekend!
Matheus.