If you are to connect a Creo Elements/Direct Database Server Windows to a remote Oracle instance running on a different host (e.g. a Linux server), and the Oracle server host is not running its TNS on default port 1521, you need to specify a system environment variable ORACLE_TNS_PORT on your windows server (running the CED Database Server).
All other Database Server service options (e.g. regarding the Oracle server and Oracle SID) are specified as registry keys in the service properties.
This system environment variable ORACLE_TNS_PORT now applies to all services and programs running on the windows server, causing trouble for other services.
Example:
I'd like to run two different Database Server services on one single development server.
One Server service shall connect to a remote Oracle instance on a Linux machine running TNS on port 1521.
The other Server service shall connect to a different Oracle instance on a second Linux machine running on port 1528.
But using only one general system environment variable ORACLE_TNS_PORT, this can't be achieved.
If the TNS_PORT could be specified as a registry key, I'd be fine.
Note:
CED Database Server Windows is not using a local tnsnames.ora to connect to the remote Oracle instance. It is calling Oracle OLEDB, with it's own generated connect string.
