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.
Hi all!
I’m preparing a material about downloading, configuring using Oracle Database Cloud Backup. My case is about backuping a local database to Cloud.
So, as avant-première for you from the Blog, a quick situation about:
# Error
RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 04/14/2016 13:58:45 ORA-27030: skgfwrt: sbtwrite2 returned error ORA-19511: non RMAN, but media manager or vendor specific failure, error text: KBHS - 01602: backup piece 12p1krsi_1_1 is not encrypted
# Solution (one of)
RMAN> set encryption on identified by "mypassword" only; executing command: SET encryption
Why?
To use Oracle Database Backup to Cloud you need to use at least one encrypting method.
Oracle offers basically 3:
– Password Encryption
– Transparent Data Encryption (TDE)
– Dual-Mode Encryption (a combination of password and TDE).
In this post I refered the easier, by I recommend you to take a look on KB: https://docs.oracle.com/cloud/latest/dbbackup_gs/CSDBB.pdf
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 folks!
Today a friend asked about how to configure disks on VMWare to create a virtualized cluster database. I revisited my old notes and decided to share. Here it goes…
First, I really have some constraints about it:
– Fake “high availability”: To have HA with VM it’s not needed 2 vms, if a host fail VMWare should make a VMotion (if well configured), and no services will be affected. So, one VM is ok.
– Not real “horizontally scallated”: It probably would be better to use one server as physical than have two vms on it. Not make sense to do it…
So, why?
To prove concept, evaluate RAC configuration (caches on sequences, etc) and labs, to learn and practice RAC stuffs…
Ok, now how to make it happen?
1. Add new disk to one of the machines. Some way, one will be the “primary” and share disks with another.
2. Set Mode Thick Eager Zeroed
3. Create a specific controller to this “shared disks”
4. Set controller to virtual sharing
# Other Machine
5. Adding the existent disk to other VM (not primary, but from primary)
6. Select disk from primary
7. Create a new controller, as you made on primary and select it:
8. Set controller to virtual sharing
OBS:
If this error happen, one of your controller is not in sharing mode. Please check it.
And here we are! 🙂
Good lab!
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.
Quick tip:
# Problem:
MySQL: Unable to connect to database 'xxx' on server 'xxx' on port xx with user 'root' - Access denied for user 'root'@'xxxxx'
Solution:
GRANT ALL PRIVILEGES ON *.* TO root@'xxxxx' IDENTIFIED BY '$PASSWORD' WITH GRANT OPTION; FLUSH PRIVILEGES;
Have a nice week!
Matheus.
Hi all!
I’m here to share this is great whitepaper by EMC about Transporting a 12 TB Oracle Database almost 4.000km using Data Domain to Backup and restore.
Take a look:
https://www.emc.com/collateral/software/white-papers/h8238-oracle-remote-recovery-datadomain-wp.pdf
It’s nice to see how deduplication was a key-factor to the success of project.
It’s really a good feature that provides lots of optimization to backup/recover databases, besides diskspace saving, backup window reducing, network interface load reducing, etc.
Have a nice weekend!
Hi all!
As you know, we have some commercial solutions to monitoring/alerting MySQL, like MySQL Enterprise Monitor or Oracle Grid/Cloud Control.
But, regarding we are using MySQL instead of Oracle Database, we can assume it’s probably a decision taken based on cost. So, considering Open Source solutions, we basically have Nagios, Zabbix, OpenNMS…
Thinking on Nagios, in my opinion the “supra sumo” is mysql_health_check.pl.
Below whitepaper and presentation:
White Paper
Presentation
Code
Good one by Sheeri Cabral and posted here!
Any way, with theese two we can make lots of magic:
1. check_mysql.pl
– Check status of MySql server (slow queries, etc)
– Queries per second graph
2. check_db_query.pl
– Allowes to run SQL Queries and setting thresholds for warning e critical. Ex:
check_db_query.pl -d database -q query [-w warn] [-c crit] [-C conn_file] [-p placeholder]
Ex for Nagios call:
define command{
command_name check_db_entries
command_line /usr/local/bin/perl $USER1$/check_db_query.pl -d "$ARG1$" -q "$ARG2$" $ARG3$
}
So, now it’s just make your queries and implement your free monitoring on MySQL! 🙂
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.