Question

How to change Oracle SID post FME server installation?

  • 21 November 2019
  • 2 replies
  • 3 views

We have FME 2016 installed couple of years ago with an Oracle SID. Now with Oracle migration to cloud, our SID name has changed. post SID name changes, we are not able to login to FME server. Is there any way that SID can be changed and FME can be used again without reinstallation?


2 replies

Userlevel 4

Is this for the internal FME Server database?

If so, have a look in the configuration file 

<FMEServer>\Server\fmeCommonConfig.txt

Search for "DB_TYPE=oracle" to find the relevant section, you probably want to modify the value of DB_JDBC_URL with the new SID.

Is this for the internal FME Server database?

If so, have a look in the configuration file 

<FMEServer>\Server\fmeCommonConfig.txt

Search for "DB_TYPE=oracle" to find the relevant section, you probably want to modify the value of DB_JDBC_URL with the new SID.

Thanks David, It helped

Reply