Can multiple TeamCity server instances use one Oracle database but different schemas?

I would like to know if multiple instances of the TeamCity webserver can be configured to use the same Oracle database but different schemas.

Is this configuration sustainable or it is not recommended at all?

Thanks.

1 comment
Comment actions Permalink

Lanre,

Yes, they can. It's absolutely normal way to connect several TC servers with several schemas of one Oracle database.
Just configure different Oracle users (one for every TC server) and specify them in 'database.properties' files.

P.S. TC server cannot switch Oracle schema when logged in, so you have to login every TC server directly to the corresponding Oracle schema.

0

Please sign in to leave a comment.