Question

How can I View my stored data on Oracle with FME Universal Viewer 32 bits

  • 20 November 2012
  • 10 replies
  • 3 views

Hello Im trying to View my stored data on Oracle with FME Universal Viewer 32 bits.

 

 

 

I have installed Oracle_Client 11g 32 bits on my PC.

 

 

Also I have Win 7 64 bits    When Im Trying to did it, it sent this message: 

 

Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8i', serverName=`orcl', userName=`itu', password=`***', dbname=`')

Failed to open database with username='itu', retrying using uppercase username

Environment variable ORACLE_HOME is not set.

 

 

 

 

 

 

 

10 replies

Badge +14
Make sure you have the right client installed:

 

 

http://fmepedia.safe.com/articles/FAQ/Oracle-clients-for-FME-running-on-a-64-bit-OS

 

 

...and you're TNSNAMEs file is setup correctly.

 

 

Assuming all of that is fine consider setting your oracle_home environement variable. My ORACLE_HOME environment variable is set to: C:\\oracle\\product\\11.2.0\\dbhome_1 for example.

 

 

You can also connect to oracle by adding all your credentials to one line in the Service parameter, like this:

 

 

username/password@//hostname:port/sid

 

That can somtimes get around TNS issues.
Thanks for your answer Dave. It doesn´t still works.

 

 

But I have installed Oracle Database on a Server not on my PC.

 

 

I only have installed on my PC the Oracle Client 11g.

 

 

Can I view or migrate my data trought FME here on my workstation?
Badge +14
As long as you have an Oracle client and network access to the actual database and of course FME on your machine then you will be fine. Assuming that in your Readers list in FME you can see the Oracle Spatial Reader and its not greyed out then you are 90% of the way there. That should mean you have the right client, in which case you need to focus on your credentials and also your TNSnames file. I suggest you speak with your IT admin or find someone with SQL Developer to check what credentials they are using to access the database as they will be the same.
Thanks but it doesnt still works.  One question Mr. Dave.  This data that I want to view in Universal Viewer was migrate from Geomedia Pro 6.1 to Oracle .  Could be it the problem?

 

 

Badge +14
I suppose it depends if it was migrated or whether it still maintains the schema it had previously. If so you might try connecting with the 'Oracle Spatial Relational' reader instead as thats typically the Intergraph route I believe.
Userlevel 4
Badge +13
That particular error message is displayed as we do the user/password checking when connecting to the database. Because Oracle used to be case insensitive, most user name/passwords are stored in the database as UPPERCASE but users are used to providing them in LOWERCASE. So we pass the provided username/password through to Oracle and see if it is successful or not. This generally results in the shown error message the first time. Then we Uppershift the provided username/password and test again. You will notice this line

 

 

Failed to open database with username='itu', retrying using uppercase username

 

 

So we try again with uppercase. This generally is successful. So please check the results of this second attempt. I doubt that it is a TNS names issue or you would have received a different error message. 

 

 

Check for any other error messages that are more likely to be the problem. 

 

 

Or, if your data is non-spatial, then nothing will actually show in the FME Universal Viewer canvas. You need to use the "i" button on the toolbar to look for any non-spatial features. These will show in the attribute window on the right.

 

 

If you are still having problems please send some screenshots showing the steps you have taken and the results and a full logfile to support via our webpage at http://www.safe.com/supportrequest

 

 

Regards,

 

Robyn Rennie

 

FME Desktop Support

 

www.safe.com/supportrequest
Thank you robynatsafe, Now in viewing my data on Universal Viewer.  But I only see data that I migrates with FME to Oracle (directly), but the data that I migrate directly to Oracle with Geomedia Pro 6.1 dont appear in Universal Viewer. 

 

 

Can you have a Step by Step manual that explains How can I migrate data (Intergraph Geomedia Warehouses) using FME to Oracle database (Oracle Spatial Object) ? Remember that Intergraph use GOOM Package for storage on Oracle. Have FME an alternative ?

 

 

I appreciate your valious time.

 

 

Regards,

 

Iturbides
Userlevel 4
Badge +13

If you are able to connect with GeoMedia using the TNSNames entry from the same system it likely isn't a TNSNames issue.  

 

 

I believe you did mention early that you have 32bit FME and 32bit Oracle Client installed (it doesn't matter that the OS is 64bit or that the database is 64bit).

 

 

Are you certain you only have one Oracle Client software installed?  FME typically depends on the PATH environment variable being correctly set to the paths of your Oracle client install (it is looking for the oci.dll).   Ensure there is a legitament entry in your PATH variable.  But if GeoMedia is happy FME should be too.

 

 

And as 1SpatialDave has mentioned - the direct connect route can also provide you a solution.  

 

 

If you are using an Oracle Instant client (vs a full Oracle Client) you may want to add the TNS_ADMIN Environment variable. See this article (scroll to bottom for TNS_ADMIN information:

 

http://fmepedia.safe.com/articles/FAQ/How-to-setup-an-Oracle-Instant-Client-for-use-with-FME

 

 

If you continue to suffer you might want to send in a support request to fme.ly/support as Robyn has suggested.
Userlevel 4
Badge +13
Iturbides

 

I've made support case for this issue and you should get an email shortly. We'll be sure to update the group when it's resolved.

 

Thanks

 

Ken
Hello thank you for your excellent support.

 

 

I have many Intergraph (GeoMedia 6.1) warehouses (.mdb). I want to migrate it on batch to my Oracle database using FME 2011 32 bits. On my PC i have Oracle Client 11g 32 bits.

 

I read an article on your website ( http://fmepedia.safe.com/articles/FAQ/Loading-Data-to-Oracle-Spatial-for-GeoMedia-Consumption ) but im novice using FME workbech.

 

 

 

 

 

When I try to migrate it in Workbench its said to me that its succesfully , i saw it on Universal Viewer but when I opened it on GeoMedia Pro 6.1 (Oracle Object Model Read-Write Connection ), I dont saw my data. Its happens the same when I migrate directly with Geomedia to Oracle (Remember I have installed GOOM package on my Oracle Database) and try to open It on FME, I dont saw anything too.

 

 

Do you have a workflow, tutorial, manual or other stuff that explain How can I set the enviroment of my PC, softwares and what can I do for migrate my data to Oracle?

Reply