[closed] Rational RTC and Oracle on AWS cloud
Our IT department is moving all the Oracle services from in house servers to the cloud. This includes the Oracle Database that serve our Rational Tools applications.
We have been prototyping this change on sandbox servers for Jazz, RTC, RQM, RM and Data Warehouse.
We have been able to move the DB from the in house servers to AWS cloud and all seems to function, however the RTC diagnostic for the Database fails because the performance measurement is 4500 ms, way above the 2500 ms allowed. The performance before the change to AWS cloud was 45 ms.
We have also did a " repotools-rm -reindex all" of the Requirements Management DB indices and what took 10 minutes with the in house DB now takes over 90 with the AWS cloud.
The AWS cloud DBA says that all looks normal on his side and suggests that we move the entire RTC installation, not just the Oracle DB, to the cloud.
My question is, has anybody have this kind of setup, RTC applications running on in house servers with the DB on the cloud?
Thanks
The question has been closed for the following reason: "The question is answered, right answer was accepted" by davidhoney Mar 20 '23, 4:25 a.m.
Accepted answer
>>> The AWS cloud DBA says that all looks normal on his side and suggests that we move the entire RTC installation, not just the Oracle DB, to the cloud.
There needs to be low latency between the jazz applications and the database
This may be helpful:
2 other answers
I would definitely not run this setup for production - there's just too much variability in an external Internet connection to a DB in the Cloud.
I set up and maintained a full CLM set up in the AWS environment for one of my clients for several years. They used the SQL Server RDS as the back end database service, and a series of VMs with each of the Jazz apps deployed and it worked really well.
It wasn't a full enterprise environment - they were focussed on Quality Manager, so I ended up having one VM specifically for the QM application, one VM for the rest of the applications, and one VM for the reporting components (DCC, RB and initially LQE but then we turned that off as they really weren't using it).
We also set up a VM running AD for their LDAP, and had a CLM web proxy defined using the AWS appliances.
It was pretty seamless really, if not expensive. If IBM's SaaS offering was available at that time, I would definitely have recommended that instead.
Thanks for the comments.
We are now looking into other solutions including moving all our Rational tools to the cloud.
Comments
Hi Kent,
I have our entire CLM 6.0.6.1 environment; JTS, RTC, RQM, RDNG, DCC, RS, running in the AWS cloud with the SQL Server RDS as the backend DBMS. To upgrade to 7.0.2, however, I have to migrate off of SQL Server and onto Oracle and I am experiencing connection issues because the databases are secured. We keep seeing these errors:
"The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 08006, SQLCODE: 17002). Verify the connection settings in your teamserver.properties file."
With this connection string:
com.ibm.team.repository.db.jdbc.location=thin:<DBNAME>/{password}@//hostname.rds.amazonaws.com:1521:<SID>
Any insight from your experience would be appreciated. If my experience with running the apps in the cloud can help you, I am glad to share.
Thank you
@Ryan McBryde please post your question as a new question rather than comment on a 2 year already answered question. In this specific case, I recommend you contact Ratioal Technical Support.