diff options
Diffstat (limited to 'rt/README.Oracle')
-rw-r--r-- | rt/README.Oracle | 41 |
1 files changed, 0 insertions, 41 deletions
diff --git a/rt/README.Oracle b/rt/README.Oracle deleted file mode 100644 index 9835b93e6..000000000 --- a/rt/README.Oracle +++ /dev/null @@ -1,41 +0,0 @@ -Since RT 3.8.2 RT deployment on Oracle database has been simplified. - -You don't need to create anything beforehead. During installation -an user is created and all RT's objects are created in his schema. -User is created with the following parameters: - - CREATE USER <DatabaseUser> IDENTIFIED BY <DatabasePassword> - DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP - QUOTA UNLIMITED ON USERS - -And as well granted with 'CONNECT' and 'RESOURCE'. It's up to you -to do decide how to manage users, change quotas, table spaces and -other. - -RT has option DatabaseName which is used to define SID of -the Oracle database. You don't have to setup TWO_TASK environment -variable or other helpers files for connection. - -Example: - - ./configure \ - --with-db-type=Oracle \ - --with-db-database=XE \ - --with-db-host=192.168.0.1 \ - --with-db-dba=system \ - --with-db-rt-user=rtdb1 \ - --with-db-rt-pass=rtdb1secret \ - ... other configure options ... - -This's all specifics of deployment on Oracle you should be aware -of. To complete installation you must follow general instructions -in the README file. - -As with all databases it is important to analyze the schema and get -current statistics after any significant dataset change. Oracle's -cost-based optimizer can provide particularly bad performance when the -schema statistics are significantly inaccurate. To analyze the schema -of a user called rt, execute the following from within sqlplus: - - execute dbms_utility.analyze_schema( 'RT', 'estimate'); - |