|
Size: 2697
Comment:
|
← Revision 19 as of 2013-09-18 06:09:33 ⇥
Size: 1891
Comment: converted to 1.6 markup
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| ## page was renamed from SetupOracleDatabase | |
| Line 4: | Line 5: |
| 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 |
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 |
| Line 28: | Line 29: |
| ---- /!\ '''Edit conflict - other version:''' ---- include in .bash_profile following line: {{{ . /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh }}} |
|
| Line 35: | Line 31: |
| . /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/server/bin/oracle_env.sh # (if database on the same machine) OR |
| Line 39: | Line 35: |
| . /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) }}} |
|
| Line 47: | Line 36: |
| ---- /!\ '''Edit conflict - your version:''' ---- 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) }}} ---- /!\ '''End of edit conflict''' ---- |
|
| Line 60: | Line 40: |
| connect as sysdba SHUTDOWN IMMEDIATE; startup nomount; quit |
>connect as sysdba >SHUTDOWN IMMEDIATE; >startup nomount; >quit |
| Line 66: | Line 46: |
| connect target / mount database BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; |
>connect target / >mount database >BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; >quit cp -f /ccdev/coname/*.idx /backupdir |
| Line 71: | Line 53: |
| all the same, then ''recover database;'' |
all the same, then instead of '''BACKUP DATABASE''' {{{ >recover database; >quit cp -f /backupdir/*.idx /ccdev/coname/ }}} |
| Line 74: | Line 60: |
| '''Create Oracle database for Control sql backend (not available in free version)''' | ##'''Create Oracle database for Control sql backend (not available in free version)''' |
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/