Skip to main content
Question

How to change Oracle SID post FME server installation?


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

david_r
Celebrity
  • November 21, 2019

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.


  • Author
  • December 10, 2019
david_r wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings