Using AWS RDS for Oracle

[ML_10694804]

Hello all,

I'm very familiar with having Windchill severs on AWS for many years now, but just getting into using RDS for Oracle. There are VERY few postings on this, and almost no specific info from PTC.

Requesting any procedures that can be posted / provided please.

I've been successful installing Windchill multiple times now using RDS (WC 12.1, Oracle 19c and 21c).  Can do most needed actions from a Windchill EC2 server with SQL Developer installed, including exporting a database (WC schema) and dropping the WC user.  But, have not yet figure out how to use S3 for storing and accessing the exported .DMP files, in order to import.

thanks in advance for any posted procedure documents.

[TomU]

@ML_10694804,

Did you ever figure this out?  I need to do something similar and would love to talk to someone else about the process.

[MikeLockwood]

Attached are two rough documents that I created, doing this a couple of times.  Actually got it to work on another test that I didn't document at all, and now we've pretty much abandoned this until PTC really understands it enough to fully support.

[MikeLockwood]

Note: I never got very far on using S3 or other storage. Just didn't invest much time / effort in these areas (yet).

[TomU]

Thanks Mike.  What I really need to figure out is how to get an existing Windchill Oracle database back out of RDS.  It's apparently much more complicated since there's no access to the server (filesystem, etc.)