X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=rt%2FREADME.Oracle;h=9835b93e68b1cf0f6927e18026c0e7d280f0a09b;hp=41bec822cc28fd7091df23e7779fe58d62b58f9d;hb=666bacbcbeab98606a59a9a540c8e247f6203331;hpb=eb9668a6f3181ee02cb335272c5ee4616e61fd09

diff --git a/rt/README.Oracle b/rt/README.Oracle
index 41bec822c..9835b93e6 100644
--- a/rt/README.Oracle
+++ b/rt/README.Oracle
@@ -1,37 +1,41 @@
-In order to install RT with Oracle, the database must first be
-prepared.  Ports of RT to other databases will automatically create
-the RT schema.  This is not done for Oracle because most sites wishing
-to deploy RT on Oracle will have choose to make specific configuration
-of the RT user, for example to select the appropriate tablespace or to
-set up a resource profile.  The RT user must have appropriate
-privileges similar to the resource and connect roles and must have the
-"query rewrite" system privilege.
-  Here is an example of commands to create an RT user called "RT" with
-a password of "rt".
-
-  create user rt identified by rt default tablespace users temporary
-    tablespace temp;
-  grant resource, connect, query rewrite to rt;
-
-
-RT should not run its schema creation as the Oracle DBA; instead the
-schema creation should be run as the RT user.  To accomplish this set
-the --with-rt-dba configuration parameter to the RT user, not to the
-Oracle DBA.  As an example, the following might be appropriate to
-configure RT for the example.com Oracle database.
-
-  ./configure --prefix /usr/local/rt --with-db-type=Oracle \
-        --with-db-dba=rt --with-db-database=example.com \
-    --with-db-rt-user=rt \
-        --with-db-rt-pass=rt 
-
-
-As with all databases it is important to analyze the Schema and get
+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 withing Sqlplus.
+of a user called rt, execute the following from within sqlplus:
 
   execute dbms_utility.analyze_schema( 'RT', 'estimate');
 
-