Articles tagged with sqlplus

1. Random Oracle FRA Usage Notes

   Posted on July 09, 2012 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 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 …