Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. 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.