It’s not so pretty and Oracle has the Oracle Restart services for that. But to a temporary and quick need, this script solve the problem:
if ps -fu oracle | grep -v grep | grep ora_smon_orcl >/dev/null then echo "orcl instance is up and running" else echo "orcl instance is down" sqlplus /nolog > /dev/null 2>&1 <<EOF conn / as sysdba startup exit EOF fi
Matheus.
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.
When you haven’t access to SO and just have to alter database date…
# Fix Date:
ALTER SYSTEM SET fixed_date = '2016-04-05-12:00:00';
# Unfix Date:
ALTER SYSTEM SET fixed_date = NONE;
OBS: Just to make it clear: The date will be really “fixed”. The time will “stop”. Seconds, minutes will not advance…
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.
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!
