Articles tagged with oracle

  1. Random Oracle FRA Usage Notes

    Posted on in System Administration

    While researching a problem with our Oracle Fast Recovery Area (FRA), I took note of the more useful commands I used. This is from Oracle 11g R2 with the Real Application Clusters (RAC) and Automatic Storage Management (ASM) options.

    SQL*Plus

    Show how much of the FRA is in use …

  2. vCloud Director Install - ORA-00972 Error During Oracle Setup

    Posted on 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 …
  3. MySQL: Disable DNS Lookups

    Posted on in Software

    Powered By MySQLIn 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 …

  4. MySQL Multiple-Column Indexes: Order Matters

    Posted on in Programming

    Powered By MySQLThis 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 …

  5. VirtualBox 4.0.4 Has Arrived

    Posted on in Software

    VirtualBox 4.0.4Oracle announced the release of VirtualBox 4.0.4 today. This maintenance release addresses many bugs experienced by hosts of all operating systems. You can find a full list of fixes and additions in the Changelog.

    I use VirtualBox on both my Macs for my various testing needs. If you've …

  6. MySQL + SELinux: Can't change dir (Errcode: 13)

    Posted on in System Administration

    Powered By MySQLIf 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 …

  7. VirtualBox 3.2.10 Released

    Posted on in Software

    VirtualBox 3.2.10Oracle's VirtualBox 3.2.10 was released today. This another maintenance release for 3.2 that includes a wide variety of bug fixes. Check out the Changelog for more details.

    I use VirtualBox on both my Macs for my various testing needs. If you've got a favorite desktop virtualization program …

  8. Cisco Access Registrar ODBC Remote Server KeepAliveTimerInterval

    Posted on 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 …
  9. VirtualBox 3.2.8 Released

    Posted on in Software

    VirtualBox LogoOracle's VirtualBox 3.2.8 has been released. This is a maintenance release that mainly focuses on bug fixes rather than new features. Although I don't think the changes in this release are as prolific as the fixes in 3.2.6, it's definitely worth downloading.

    One key feature buried …

My Bookshelf

Reading Now

Other Stuff