|
Size: 465
Comment:
|
Size: 2195
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| '''Backup database using rman (always make at least one backup even on empty database!)''' | === Install Oracle database server === |
| Line 3: | Line 3: |
| '''''sqlplus''''' | 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 |
| Line 5: | Line 8: |
| ''connect as sysdba'' '' startup nomount'' |
{{{ 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 {{{ /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 }}} |
| Line 8: | Line 20: |
| '''rman''' '' connect tearget / mount BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; '' |
=== Install Oracle database client === (if we want to run CONTROL and database on separate machines) |
| Line 13: | Line 23: |
| '''recover ''' all the same, then ''recover database;'' |
{{{ rpm -U /u2/programs/databases_and_odbc/oracle-xe-client-10.2.0.1-1.0.i386.rpm }}} |
| Line 17: | Line 27: |
| '''Create Oracle database for Control sql backend''' __start sqlplus:__ | include in .bash_profile following line: {{{ . /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh }}} include in .bash_profile for all users who will use sql or control program: {{{ . /usr/lib/oracle/????/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) }}} |
| Line 19: | Line 37: |
| ''sqlplus /nolog'' '' | . /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh }}} 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) . /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 startup nomount rman connect target / mount database BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; recover }}} . all the same, then ''recover database;'' '''Create Oracle database for Control sql backend (not available in free version)''' __ __ __start sqlplus:__ {{{ sqlplus /nolog |
| Line 21: | Line 66: |
| startup nomount '' | startup nomount }}} ---- CategorySql |
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
/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 following line:
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh
include in .bash_profile for all users who will use sql or control program:
. /usr/lib/oracle/????/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)
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh }}} 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) . /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 startup nomount rman connect target / mount database BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; recover
- all the same,
then recover database;
Create Oracle database for Control sql backend (not available in free version)
start sqlplus:
sqlplus /nolog connect sysadmin/sql as sysdba startup nomount