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?
Question
How to change Oracle SID post FME server installation?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Is this for the internal FME Server database?
If so, have a look in the configuration file
<FMEServer>\Server\fmeCommonConfig.txtSearch 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.txtSearch 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