Articles tagged with oracle

Random Oracle FRA Usage Notes

Posted on July 09, 2012 in System Administration

Practical Oracle 11g SQL*Plus and RMAN commands for inspecting Fast Recovery Area usage and backup history.

vCloud Director Install - ORA-00972 Error During Oracle Setup

Posted on June 14, 2012 in System Administration

If you are unfamiliar with Oracle and setting up your vCloud Director Oracle database, don't make the same mistake I made:

SQL> CREATE TABLESPACE "CLOUD_DATA" DATAFILE "/home/oracle/app/oracle/oradata/orcl/cloud_data01.dbf" SIZE 1000M AUTOEXTEND ON ;
CREATE TABLESPACE "CLOUD_DATA" DATAFILE "/home/oracle/app/oracle/oradata/orcl/cloud_data01.dbf …

MySQL: Disable DNS Lookups

Posted on June 27, 2011 in Software

In a small environment, there's very little reason to rely on DNS resolution inside MySQL. You can disable it by adding skip-name-resolve to your my.cnf or by using the --skip-name-resolve command line argument.

Remember that if you disable DNS lookups, you will need to set permissions using IP addresses …
MySQL Multiple-Column Indexes: Order Matters

Posted on May 18, 2011 in Programming

This will just be a short reminder. If you're planning to create multiple-column indexes in MySQL, remember that the order of the columns matters. As the MySQL documentation points out, any "leftmost prefix of the index can be used." This means that the index can be used for any number …
MySQL + SELinux: Can't change dir (Errcode: 13)

Posted on October 21, 2010 in System Administration

If you're using a non-standard MySQL data directory on your Red Hat Enterprise Linux (RHEL) server, you may have seen an error like /usr/libexec/mysqld: Can't change dir to '/mysql_data/' (Errcode: 13). The key to fixing this problem is to ensure the new MySQL data directory has the proper …
Cisco Access Registrar ODBC Remote Server KeepAliveTimerInterval

Posted on August 27, 2010 in Software
In a test lab, we ran into a situation where the connection between our Cisco Access Registrar (AAA) server and MySQL server was timing out. This forced the server to reconnect and resulted in the following errors:
```
 name/radius/1 Error Server 0 ODBC client (DataSource 'my_odbc', Connection 8): SQLExecute …
```

MySQL: Query caused different errors on master and slave

Posted on August 14, 2010 in System Administration

We ran across the following error on a MySQL slave server recent:

mysql> SHOW SLAVE STATUS \G
<snip>
Last_Error: Query caused different errors on master and slave. Error on master: 'Deadlock found when trying to get lock; try restarting transaction' (1213), Error on slave: 'no error' (0). Default database: '<database_name …

Two Random Asterisk-Related SQL Queries

Posted on July 15, 2010 in voice

I hate losing useful SQL queries, so I tend to save them. Ever so often, I stumble across a file of queries from some work I was doing months ago. The following two queries are just such a case. I was analyzing some call data for a call center that …