jazz configuratuion
2 answers
Hi -
When I configure Oracle for Jazz, I typically have the dbf file location be under the database storage directory. For example, if I create a database GDBFVT3014 with storage at:
C:\app\Administrator\oradata\GDBFVT3014
then my sqlplus tablespace creation statement for the JTS tablespace looks like this:
CREATE TABLESPACE JTS_TBS DATAFILE 'C:\app\Administrator\oradata\GDBFVT301\JTS_TBS.DBF'
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
This way, all the storage for the database is in one directory structure.
Let me know if that was the information you were looking for. There is additional information on setting up an Oracle database for Jazz applications here:
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m1/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Ft_s_server_installation_setup_oracle.html
Sincerely,
Gail
When I configure Oracle for Jazz, I typically have the dbf file location be under the database storage directory. For example, if I create a database GDBFVT3014 with storage at:
C:\app\Administrator\oradata\GDBFVT3014
then my sqlplus tablespace creation statement for the JTS tablespace looks like this:
CREATE TABLESPACE JTS_TBS DATAFILE 'C:\app\Administrator\oradata\GDBFVT301\JTS_TBS.DBF'
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
This way, all the storage for the database is in one directory structure.
Let me know if that was the information you were looking for. There is additional information on setting up an Oracle database for Jazz applications here:
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m1/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Ft_s_server_installation_setup_oracle.html
Sincerely,
Gail
Hi,
Please refer to the below link where the ORACLE configuration is explained in detail.
http://www.ibm.com/developerworks/rational/library/09/oracledatabasewithrationalqualitymanager/index.html
Please refer to the below link where the ORACLE configuration is explained in detail.
http://www.ibm.com/developerworks/rational/library/09/oracledatabasewithrationalqualitymanager/index.html
Comments
Note that this DeveloperWorks article contains some details that are specific to the 2.X version of RQM and RTC.
For example, note that rather than a fixed <installDir>/server/oracle directory, for 3.X and 4.X versions of RQM and RTC, you should set the environment variable ORACLE_JDBC_DRIVER_FILE to the full path of your ojdbc driver jar file.
Note also that the ojdbc driver files for RQM and RTC 3.X releases is: ojdbc5.jar
and for RQM and RTC 4.X releases: ojdbc6.jar.