Registering ArcSDE database with ArcGIS Server at 10.1

[MattSimmons]

I've got Server 10.1 Prerelease up and running, and ArcSDE 10.1 up and running on Oracle 11g.  I've got Desktop 10.1 up and I'm trying to publish a service, but apparently I need to register the data with Server first. 
In Server Manager, I'm trying to do this by clicking Site -> Data Stores -> Register Database.  I browse to the local connection  *.sde file for that instance, click Import and I get a window that says

EDIT_PANE

and nothing else...... what the?

[GISGroup]

Hi,

I have installed arcgis server 10.1 and try register oracle 10g database using oracle client 11g (64bit) using .sde file. It shows message "please wait while register geodatabase" . i didnt get any error also.
But when i try to register through arccatelog 10.1 , it works fine.

[StephanieSnider]

I am trying to register an ArcSDE 10.0 SP 4 database (Oracle 11G R2) as a data source in ArcGIS Server 10.1.  Without the Publishing Tools geoprocessing service running, I tried to register, and the process ran overnight - no errors, but it didn't finish.  The database is 5.1 TB.  Does it normally take a long time to register a data source this large?  Or could it be that it is failing to complete because the Publishing Tools service is not running?

[NathanHeick]

I just wanted to state that you don't need two clients to run ArcGIS Server 10.1.  You need two clients if you want to install ArcGIS Desktop and ArcGIS Server on the same machine.  Desktop still requires a 32-bit client and Server requires a 64-bit client.  You can use the instant client if you want to save space.

[KimPeter]

Also note that you do not have to copy data to the server when you publish. See "If the publisher's machine and the server are working with the same database" section of this topic:

http://resources.arcgis.com/en/help/main/10.1/index.html#/About_registering_your_data_with_the_serve...

In regards to needing two clients...you'll need the DBMS (32 bit) client for ArcGIS Desktop to make a direct connection to the database. Whether you need a DBMS client installed for ArcGIS Server to connect depends on whether or not ArcGIS Server is installed on the same machine as your database.  If you have ArcGIS Server on the same server as your Oracle or SQL Server database, the files necessary for ArcGIS Server to connect to the database are already there.  If ArcGIS Server is installed on a different machine than the database, then you will need to install the DBMS client software (64 bit) on the ArcGIS Server machine for ArcGIS Server to connect directly to the database.

[GISGroup]

Hi,

I installed arcgis desktop10.1 and arcgis server 10.1 in windows 2008 64 bit machine. I also installed oracle 11g client 32 bit and 64 bit on same machine. I am able to connect our database which is arcsde 9.3 in oracle 10g.

I registered my database using arccatelog successfully but whenever i try through arcgis server manager panel , It shows message "please wait while register geodatabase" but couldnt register.
Now,when i try to publish it is copying all the data including images in folders which path is registered in server. How can i avoid copying the data to server?

[StephanieSnider]

Like kumarnv, I too was able to register the database through ArcCatalog and not ArcGIS Server Manager.  My initial problem when registering was due to a corrupt ArcGIS Server session.  I restarted the ArcGIS Server service, then registered the database through ArcCatalog - it worked fine.

kumarnv, I wonder if the map document you are trying to publish contains layers that come from a  different database connection than the one that you registered with ArcGIS Server.  For example, I may have registered a data source using an SDE connection setup for a direct connect with the SDE user.  But in my map document, I could be using datasets that are pulling from another SDE connection that is setup using the credentials of a different user account - one that hasn't been registered with ArcGIS Server.

Does that make sense?

[GISGroup]

Dear stindsider,

I used same sde connection only. i created sde connection file using arcgis tools may use 32bit client. that may be the problem, since arcgis server can connect to database through 64bit client. I dont know how make sure that arcgis server connection to sde database through 64bit oracle client

regards
Kumar

[StephanieSnider]

For the correct way to setup the Oracle database client on a computer with ArcGIS Server and ArcGIS Desktop installed, see alassom's post earlier in this thread.  It worked for me...

1) installing both the 64 and 32 bit version of the oracle client
     I recommend choosing the first install option.  Or else make sure to include the Instant Client Package during a custom install.
2) placing the 64 bit path before the 32 bit path in the path system variable
     Open My Computer > Properties > Advanced System Settings
     On the Advanced Tab, Click Environment Variables
     In the System Variables section, scroll down to the "Path" variable, select it and click Edit.  Make sure the directory for the 64 bit client is placed before the 32bit client.
3) creating a system variable TNS_ADMIN that points to the folder containing the tnsnames.ora file.
     From the Environmental Variables window, click New under the System variables section.
     Variable Name = TNS_ADMIN
     Variable value =  The directory location of your tnsnames.ora file

As far as the map service trying to copy your data onto the server when you don't want it to, please see this article.  It might help.  Good Luck! 
http://resources.arcgis.com/en/help/main/10.1/index.html#/Copying_data_to_the_server_automatically_w...

[BrettElliot]

This was bothering me for hours today, but I finally solved it because of your post!

I was getting the error "TNS:listener was not given the SERVICE_NAME in CONNECT_DATA No extended error" because Oracle wasn't being pointed at the proper tnsnames.ora file.

What fixed this for me was step 3 of your answer:

3) creating a system variable TNS_ADMIN that points to the folder containing the tnsnames.ora file.
     From the Environmental Variables window, click New under the System variables section.
     Variable Name = TNS_ADMIN
     Variable value =  The directory location of your tnsnames.ora file

Thanks for posting this!

[GISGroup]

Thanks. It is working fine. after set the path properly

regards
Kumar