Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X
I am looking at hosting Windchill in an Oracle hotel (which would be Oracle 19c). This hotel contains multiple application schemas. The installation guides seem to indicate Windchill is expected to be the only application in the Oracle database. As I run Oracle on the Exadata appliances (Oracle's hardware platform), the most efficient use of the hardware is to have fewer databases with more schemas in them - which contradicts what I am reading. That being said, I wanted to verify: can I run Windchill on an Oracle database that hosts different programs (and schemas) in the same instance? Or, can Windchill can be the only application in the database (as the installation guide alludes)?
Haven't heard of Oracle set up as a hotel - will need to study.
In general, the recommendations are that the production Windchill instance have it's own Oracle instance.
Rehosted / dev / test Windchill systems can all share the same Oracle instance, which can also have other schemas.
Some don't follow these guidelines, and it may be perfectly ok to have a shared instance for production.