topic Data interoperability connection failes with Oracle spatial relational format in Geodatabase Questions

Data interoperability connection failes with Oracle spatial relational format

RoxanaUrdea — Mon, 14 Sep 2015 09:18:59 GMT

Hi!

I'm trying to add an Interoperability Connection to an Oracle database(Oracle Locator) using Oracle Spatial Relational Format and I get this error:Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8', serverName=`instance/database', userName=`user', password=`***', dbname=`')

Otherwise, if I choose Oracle Spatial format, I manage to connect with the same user and password but the data I retreive is incomplete.

Does anyone encountered this problem?There is something that I'm missing?

Thank you!

Re: Data interoperability connection failes with Oracle spatial relational format

George_Thompson — Mon, 14 Sep 2015 12:37:28 GMT

HI Roxana,

Can you provide a little more information for this issue:

-What version of Data Interop is being used? Is ArcGIS Desktop at the same version?

-What version is the Oracle database? Is it a geodatabase (with and SDE schema)?

-Are you using the Oracle full client or Oracle Instant Client?

-Are you able to connect to the Oracle database with SQLPlus or SQLDeveloper?

-Are you able to make a connection in ArcCatalog (outside of the Data Interop extension) and see the expected data?

This will help shed some light on the possible issue.

George

GIS GIS GIS