When I registered a database data store to ArcGIS Server in ArcCatalog, the following error occurs:
The connection property set was missing a required property or the property value was unrecognized. Underlying DBMS error [Unknown errorNo extended error.]
I set up the ArcGIS Server and Oracle on two computers as follow
192.168.1.51
ArcGIS for Server 10.1 64bit
ArcCatalog 32bit
Oracle Instant Client 11.1.0.7 32bit
Oracle Instant Client 11.1.0.7 64bit
192.168.1.52
Oracle Database 11g Enterprise Edition 11.1.0.7.0 64bit
I have successfully made the Oracle 11g "Enabled Enterprise Geodatabase" through the ArcCatalog, and it seems nothing wrong.
I added the publisher database connection with the following variables
Database Platfrom: Oracle
Instance: 192.168.1.52:1521/orcl
Authentication Type: Database authentication
User name: sde
password: sde
[v] Save user name and password
And I have added the Oracle Instant Client directory to the PATH and environment variable, I am sure that the 64-bit DLL is found before the 32-bit one. But I still get the error message.
I am wondering if there is anything else I have to set up?
Oracle Instant Client 11.1.0.7 64bit
folder directly toC:\Program Files\ArcGIS\Server\bin
since without file name conflicts – Charlie Liu Oct 15 '13 at 7:14