RRC - the version 2.0.0.4 is compatible with ORACLE11g
Hi ! I have a question!
RRC is compatible with ORACLE 11g R1 or R2 ?
This is because I'm trying to generate the TablesSpaces and Schemas (repotools -createTables) using the OJDBC14 (version ORACLE11g) and shows an ERROR about JDBC Driver version 10.2.0.1.0, when I have installed ORACLE 11g
Exist some fix de RRC for this error?
RRC is compatible with ORACLE 11g R1 or R2 ?
This is because I'm trying to generate the TablesSpaces and Schemas (repotools -createTables) using the OJDBC14 (version ORACLE11g) and shows an ERROR about JDBC Driver version 10.2.0.1.0, when I have installed ORACLE 11g
Exist some fix de RRC for this error?
5 answers
Hello,
Official support is for Oracle 10g (as noted here: https://www-304.ibm.com/support/docview.wss?uid=swg27021493#Linux_Databases_sw) though I am aware of users that have used RRC with Oracle 11g. Can you be more specific about the error message you are receiving? What is the exact error?
Also, when using the setup process, there should be no need for you to run repotools -createTables yourself. Please ensure you are configuring the server using https://:9443/rdm/setup (NOT jts/setup).
Official support is for Oracle 10g (as noted here: https://www-304.ibm.com/support/docview.wss?uid=swg27021493#Linux_Databases_sw) though I am aware of users that have used RRC with Oracle 11g. Can you be more specific about the error message you are receiving? What is the exact error?
Also, when using the setup process, there should be no need for you to run repotools -createTables yourself. Please ensure you are configuring the server using https://:9443/rdm/setup (NOT jts/setup).
Thanks...
The ERROR appear when follow the next steps:
1. I installed Oracle 11g
2. I created the data base (RRC), using the script for Oracle
3. I created a new folder "oracle" in C:\...\server\oracle
4. In the folder I pasted the file ojdbc14 (version 11.1.0.0.0)
5. I modified the file teamserver.properties (of Oracle)
6. I opened a Console of windows and type the next sentence: c:\...\ibm\rrcs20\server\repotools -createTables -clean
Then... Appear this ERROR:
http://s3.subirimagenes.com:81/otros/previo/thump_6449157errororacle.jpg
Now, I unistalled ORACLE 11g and I installed ORACLE 10g... I followed the six steps above... and surprise was that there were no error... BUT my client only has ORACLE 11g, with RTC 3.0 no exist any problem but with RRC 2.0.0.4 doesnt work creation of Tables an Schemas!!!
Some idea? Some Fix for RRC 2.0.0.4? or Only wait the new release 3.0.1 de RRC?
The ERROR appear when follow the next steps:
1. I installed Oracle 11g
2. I created the data base (RRC), using the script for Oracle
3. I created a new folder "oracle" in C:\...\server\oracle
4. In the folder I pasted the file ojdbc14 (version 11.1.0.0.0)
5. I modified the file teamserver.properties (of Oracle)
6. I opened a Console of windows and type the next sentence: c:\...\ibm\rrcs20\server\repotools -createTables -clean
Then... Appear this ERROR:
Now, I unistalled ORACLE 11g and I installed ORACLE 10g... I followed the six steps above... and surprise was that there were no error... BUT my client only has ORACLE 11g, with RTC 3.0 no exist any problem but with RRC 2.0.0.4 doesnt work creation of Tables an Schemas!!!
Some idea? Some Fix for RRC 2.0.0.4? or Only wait the new release 3.0.1 de RRC?
Yeah, I can't explain the error you see. Why does it show the JDBC driver as being 10.2? Either you have the wrong one or it's not picking up the version you provided.
I still don't know why you're attempting to create the tables as the setup process does that for you. What happens if you simply follow the rdm/setup web configuration? You shouldn't have to modify the teamserver.properties or run repotools manually if you simply run the setup wizard.
Are you following the instructions from here?
https://publib.boulder.ibm.com/infocenter/rpcmpose/v2r0/index.jsp?topic=/com.ibm.rational.rrc.install_upgrade.doc/topics/t_install_rpc.html
RTC 3.0 is certainly built on a newer version of Jazz Foundation than that used by RRC 2.0.0.4, and repotools is a Jazz Foundation tool, so maybe newer versions of RRC will work better, but I'll keep checking around because I'm still fairly certain people have gotten this to work in 2.x
I still don't know why you're attempting to create the tables as the setup process does that for you. What happens if you simply follow the rdm/setup web configuration? You shouldn't have to modify the teamserver.properties or run repotools manually if you simply run the setup wizard.
Are you following the instructions from here?
https://publib.boulder.ibm.com/infocenter/rpcmpose/v2r0/index.jsp?topic=/com.ibm.rational.rrc.install_upgrade.doc/topics/t_install_rpc.html
RTC 3.0 is certainly built on a newer version of Jazz Foundation than that used by RRC 2.0.0.4, and repotools is a Jazz Foundation tool, so maybe newer versions of RRC will work better, but I'll keep checking around because I'm still fairly certain people have gotten this to work in 2.x
Steve, thanks for you response!
The data modifications I did do in teamserver.propertis were in section of Oracle, I show you (teamserver.properties):
# Oracle configuration
# Comment out above lines, uncomment the following lines and customize example location to use Oracle
# Note: Oracle location URLs can take several forms. The examples here will work under most circumstances.
# Please consult the Oracle JDBC documentation for more details.
# NOTE THAT EVERY APPLICATION INSTANCE AND JAZZ TEAM SERVER REQUIRES ITS OWN UNIQUE ORACLE USER or DATABASE
com.ibm.team.repository.db.vendor = ORACLE
# localhost connection strings should not include preceding //
#com.ibm.team.repository.db.jdbc.location=thin:jazzDBuser/{password}@localhost:1521/ORCL
# non-localhost connection strings MUST include preceding //
com.ibm.team.repository.db.jdbc.location=thin:jazzDBuser/{password}@//oracle.serverMEX.com:1521/RRC
com.ibm.team.repository.db.jdbc.password=jazzDBpswd
The fileojdb14 is of version ORACLE 11g (I reviewed exhaustively that version and is correctly)...
Why I didnt use the process of create Tables from "rdm/setup"?, doesnt exist any reason!. I will try to create the Tables from process "rdm/setup" but I think the problem will appear again... beacuse will execute the file "repotools.batch" and this file contains statements that invoke the component ojdbc14 (it was en folder \...\rrcs20\server\oracle). I think the activites are the same or you do not believe that is so?
REGARDS!
The data modifications I did do in teamserver.propertis were in section of Oracle, I show you (teamserver.properties):
# Comment out above lines, uncomment the following lines and customize example location to use Oracle
# Note: Oracle location URLs can take several forms. The examples here will work under most circumstances.
# Please consult the Oracle JDBC documentation for more details.
# NOTE THAT EVERY APPLICATION INSTANCE AND JAZZ TEAM SERVER REQUIRES ITS OWN UNIQUE ORACLE USER or DATABASE
# localhost connection strings should not include preceding //
#com.ibm.team.repository.db.jdbc.location=thin:jazzDBuser/{password}@localhost:1521/ORCL
# non-localhost connection strings MUST include preceding //
com.ibm.team.repository.db.jdbc.password=jazzDBpswd
The file
Why I didnt use the process of create Tables from "rdm/setup"?, doesnt exist any reason!. I will try to create the Tables from process "rdm/setup" but I think the problem will appear again... beacuse will execute the file "repotools.batch" and this file contains statements that invoke the component ojdbc14 (it was en folder \...\rrcs20\server\oracle). I think the activites are the same or you do not believe that is so?
REGARDS!