## page was renamed from SetupOracleDatabase
=== Install Oracle database server ===

Make sure that you have at least 1G swap space on your machine.
Install oracle on separate machine if there are not to much memory available. 
Minimum reasonable config for XE: 1G if this machine will be used only as oracle server 
and 1.5 G if we will to run CONTROL on the same machine

{{{
rpm -U /u2/programs/databases_and_odbc/oracle-xe-10.2.0.1-1.0.i386.rpm
}}}
Set password for user oracle. 
Move datafile to somewhere where you have enough space (if there are more than 1 hard drive it is much better to use one for oracle database):
{{{
/etc/init.d stop 
mv /usr/lib/oracle/xe/oradata /u2/somewhere
ln -s /u2/somewhere/oradata /usr/lib/oracle/xe/oradata
/etc/init.d start
}}}

=== Install Oracle database client ===
(if we want to run CONTROL and database on separate machines)

{{{
rpm -U /u2/programs/databases_and_odbc/oracle-xe-client-10.2.0.1-1.0.i386.rpm
}}}


include in .bash_profile for all users who will use sql or control program:
{{{
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh # (if database on the same machine) OR
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh # (if database located on different machine)
}}}



=== Backup database using rman (always make at least one backup even on empty database!) ===
{{{
sqlplus
>connect as sysdba
>SHUTDOWN IMMEDIATE;
>startup nomount;
>quit

rman
>connect target /
>mount database 
>BACKUP DATABASE INCLUDE CURRENT CONTROLFILE;
>quit
cp -f /ccdev/coname/*.idx /backupdir
}}}
=== Recover ===
all the same, then instead of '''BACKUP DATABASE'''
{{{
>recover database;
>quit
cp -f /backupdir/*.idx /ccdev/coname/
}}}


##'''Create Oracle database for Control sql backend (not available in free version)'''


----
CategorySql