Skip to main content
Solved

Migrate FME server database to Oracle

aguan
Contributor
Forum|alt.badge.img+11
  • aguanContributor
  • Contributor

We are using FME server 2017.0.

 

I am following this article https://s3.amazonaws.com/gitbook/Server-Admin-2017/ServerAdmin4Scalability/4.03.ChangingDatabaseProviderForFMEServerDatabase.html, chapeter 4 exercise 2 to change the FME database provider – from the default to, – not to a PostgreSQL, but to an Oracle12c database. I ran the Oracle scripts to create a FMESERVER user and installed the FME objects. After I changed the fmeCommonConfig.txt (see below) and restarted the FME server, I can not login the web UI using my previous logins. I can login admin/admin, but the contents are pretty much blank. I have no option to import the previously exported fsconfig file. I have to restore the original fmeCommonConfig.txt to go back the working FME server. Feel like I missed something here.

fmeCommonConfig.txt:

 

#-------------------------------------------------------------------------------

 

# Database Connection

 

#-------------------------------------------------------------------------------

 

DB_TYPE=oracle

 

DB_DRIVER=oracle.jdbc.driver.OracleDriver

 

DB_JDBC_URL=jdbc:oracle:thin:@phoupgisdol03:1521:PGIS3

 

DB_USERNAME=fmeserver

 

DB_PASSWORD=mypassword

 

DB_CONNECT_EXPIRY=60

 

DB_SQLSTMTS_PATH=C:/Program Files/FMEServer/Server/database

 

 

Best answer by laurawatsafe

Hi @ag The instructions for running the Post Configuration scripts can be found here (under step 3):

 

https://docs.safe.com/fme/html/FME_Server_Documentation/Content/AdminGuide/Post-Config-Scripts.htm

 

From the description of what you are seeing on your FME Server, I believe running the runPostInstall.bat file mentioned in those instructions as an administrator on your system should fix the problem. Let us know if it doesn't seem to help!
View original
Did this help you find an answer to your question?

7 replies

A
Forum|alt.badge.img+6
Hi @ag,

 

May I ask to confirm have run the post configuration scripts before trying to restart FME Server?

 

 

aguan
Contributor
Forum|alt.badge.img+11
  • aguanContributor
  • Author
  • Contributor
  • July 25, 2017

@Annabelle, what are the post configuration scripts for Oracle?

aguan
Contributor
Forum|alt.badge.img+11
  • aguanContributor
  • Author
  • Contributor
  • July 25, 2017
@Annabelle, what are the post configuration scripts for Oracle?

 

 

erik_jan
Contributor
Forum|alt.badge.img+18
  • erik_janContributor
  • Contributor
  • July 25, 2017

The Oracle scripts can be found in the FME Server folder.

At this location:

First you want to create the user, then the DB (tables, packages etc).

aguan
Contributor
Forum|alt.badge.img+11
  • aguanContributor
  • Author
  • Contributor
  • July 25, 2017
erik_jan wrote:

The Oracle scripts can be found in the FME Server folder.

At this location:

First you want to create the user, then the DB (tables, packages etc).

@erik_jan, I did run those scripts, of cause. Are there any post scripts I need to run?

 

laurawatsafe
Safer
Forum|alt.badge.img+11
  • laurawatsafeSafer
  • Safer
  • Best Answer
  • July 25, 2017

Hi @ag The instructions for running the Post Configuration scripts can be found here (under step 3):

 

https://docs.safe.com/fme/html/FME_Server_Documentation/Content/AdminGuide/Post-Config-Scripts.htm

 

From the description of what you are seeing on your FME Server, I believe running the runPostInstall.bat file mentioned in those instructions as an administrator on your system should fix the problem. Let us know if it doesn't seem to help!
aguan
Contributor
Forum|alt.badge.img+11
  • aguanContributor
  • Author
  • Contributor
  • July 26, 2017

Hi @Laura, yes, running the runPostInstall.bat will make the menu items on the left Panel of the web UI available, including the "Backup & Restore", then I can upload the the fsconfig file. This will load all the previous configurations into Oracle, with a few exceptions such as job history and default schedules being disabled. I have to reset the password for the default users like admin, author, et al. Other than those, look like everything works fine. It is a successful migration to Oracle. Thanks a lot for your help.

Reply


Helpful Members This Week

Community Stats

31,378
Posts
119,005
Replies
39,006
Members

Latest FME

Terms & ConditionsCookie settings

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
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.