1. I installed ArcGIS Server, Desktop and SDE 10.1 and Oracle 11g on the same machine (Windows 7 64 bit OS). I go to ArcCatalog-->Database Connections-->Add database Connection, and I can connect to the Oracle database instance by using Oracle users and password. Then I can import some spatial data into the Oracle database and can open the table and layers in ArcMap.
2. I also go to ArcCatalog-->GIS Servers-->Add GIS Server, and I can add the local ArcGIS Server publisher. Then I right-click the added server publisher and choose "Server property" to register the connected Oracle database. I import the Oracle connection file which is created in the first step and copied to the ArcGIS Server installation path, but it failed to register the database. The error message is: The data item is inaccessible. How to solve this problem?
3. However, I go to ArcCatalog-->System Toolboxes-->Data Management Tools-->Workspace-->Create ArcSDE Connection File, and create a connection file to the Oracle database on the local machine, then I repeat the registration in the above second step, the database registration is successful! I am a bit confused.
I just get stuck here for several days. Any of you reply and suggestion is highly appreciated and anticipated.
Thank you in advance!
