topic Cannot register database in Data Management Questions

Cannot register database

XintaoLiu — Mon, 24 Sep 2012 13:48:15 GMT

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!

Re: Cannot register database

JamesM1 — Mon, 24 Sep 2012 15:53:08 GMT

ArcGIS Server 10.1 is a 64bit application so requires a 64bit Oracle client for direct connections.

Check to see if your existing Oracle client is 32bit and switch to the 64bit client as required.

Re: Cannot register database

XintaoLiu — Mon, 24 Sep 2012 16:04:02 GMT

ArcGIS Server 10.1 is a 64bit application so requires a 64bit Oracle client for direct connections.

Check to see if your existing Oracle client is 32bit and switch to the 64bit client as required.

Dear James,

Thanks for you reply. At the beginning, I installed all the 64-bit software, including oracle home and client. However, when I try to connect Oracle in ArcCatalog, it does not work. I Google and find that ArcGIS Desktop 10.1 is still based on 32-bit framework. Therefore, if I want to use functionality in ArcToolboxes, I have to install Oracle 32-bit client without uninstalling Oracle 64-bit client. So, I have both 64 and 32-bit clients.

Well, I will uninstall 32-bit client to have a try. Thank you again.

Re: Cannot register database

XintaoLiu — Mon, 24 Sep 2012 18:01:26 GMT

ArcGIS Server 10.1 is a 64bit application so requires a 64bit Oracle client for direct connections.

Check to see if your existing Oracle client is 32bit and switch to the 64bit client as required.

I uninstalled the Oracle 32-bit client, but now I cannot even connect to the Oracle in ArcCatalog. Any suggestion?

Re: Cannot register database

JamesM1 — Mon, 24 Sep 2012 20:47:31 GMT

I uninstalled the Oracle 32-bit client, but now I cannot even connect to the Oracle in ArcCatalog. Any suggestion?

Sorry I wasn't clearer in my first post, you still need the 32bit client for ArcGIS Desktop to connect to Oracle. Install both the 32bit and 64bit Oracle clients, just make sure the 64bit client is set first in the PATH environment variable. Restart ArcGIS Desktop and Server for the changes to the PATH variable to take effect.

Setting up a connection to Oracle
http://resources.arcgis.com/en/help/main/10.1/index.html#//002n00000038000000

See 1d -
"If both ArcGIS for Server and ArcGIS for Desktop are installed on the same Windows computer, set the PATH variable to read the 64-bit client before the 32-bit client."

Re: Cannot register database

XintaoLiu — Mon, 24 Sep 2012 23:00:55 GMT

Sorry I wasn't clearer in my first post, you still need the 32bit client for ArcGIS Desktop to connect to Oracle. Install both the 32bit and 64bit Oracle clients, just make sure the 64bit client is set first in the PATH environment variable. Restart ArcGIS Desktop and Server for the changes to the PATH variable to take effect.

Setting up a connection to Oracle
http://resources.arcgis.com/en/help/main/10.1/index.html#//002n00000038000000

See 1d -
"If both ArcGIS for Server and ArcGIS for Desktop are installed on the same Windows computer, set the PATH variable to read the 64-bit client before the 32-bit client."

Thanks for your reply. Yes, I did as what you said. Then I go to ArcCatalog-->Database Connections-->Add database Connection, and I can connect to the Oracle database. Then I right-click the connected database and choose "Share as a geodatabase service". When I publish it, an error occurred: "Geodatabase is not registered with the server". Then I clicked to register the connected geodatabase, an error occurred again: "The data item is inaccessible". I really don't know what to do after get stuck several days. Thanks for you help.

Re: Cannot register database

MattSimmons — Thu, 27 Sep 2012 18:30:19 GMT

At Server 10.1 you need to register a database with Server, from Server Manager. It sounds like you've successfully connected to SDE from Catalog, and to your ArcGIS Server from Catalog; but you still need to connect the ArcGIS Server to ArcSDE so that you can publish layers to map services. This means giving the ArcGIS Server account access to the SDE database.

Log in to ArcGIS Server Manager, click on Site, then click on Data Stores. Then Register Database.

Re: Cannot register database

JeffAzevedo — Thu, 27 Sep 2012 18:47:35 GMT

At Server 10.1 you need to register a database with Server, from Server Manager. It sounds like you've successfully connected to SDE from Catalog, and to your ArcGIS Server from Catalog; but you still need to connect the ArcGIS Server to ArcSDE so that you can publish layers to map services. This means giving the ArcGIS Server account access to the SDE database.

Log in to ArcGIS Server Manager, click on Site, then click on Data Stores. Then Register Database.

If the above doesn't work, try making a connection in a UNC Path folder that resides on the ArcGIS Server and register with that connection. (if it only works this way, I believe it has to do the local Admin account that setup AGS)

Re: Cannot register database

XintaoLiu — Fri, 28 Sep 2012 03:12:41 GMT

If the above doesn't work, try making a connection in a UNC Path folder that resides on the ArcGIS Server and register with that connection. (if it only works this way, I believe it has to do the local Admin account that setup AGS)

Thank you guys so much! Yes, I did many times as you suggested. It just did not work. Today this morning, I made a last try, it works! So cute! Thank you again! Have a good day!

Re: Cannot register database

GiuseppeFuschillo — Wed, 10 Oct 2012 08:36:15 GMT

Hi, i have the same problem with sql server 2008.
I tried to make a connection in a UNC Path folder that resides on the ArcGIS Server and it works.
Thanks for your help.

Re: Cannot register database

RachelS — Mon, 29 Oct 2012 12:47:57 GMT

HI,
I'm having the same issue with SQL Server 2008. Can you tell me how I go about making a connection in the UNC path folder on the ArcGIS Server?
Thanks
Rachel

Update: I've discovered what my issue was here. I had to give ArcGIS Server permissions in the SQL database as per the link here.
http://resources.arcgis.com/en/help/main/10.1/index.html#//01540000039r000000
Hope this helps someone.