nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Unable register database with arc gis server

DharmenderGupta

Hi All,

I have created an Enterprise Geodatabase in Oracle 11g DB.
When I try to register this DB with Arc GIS Server either from arc gis desktop or arc gis manager it says "The file path does not exist or is too long (> 512 chars) or has invalid characters .]

Can anyone let me know what could be the reason for this.

Thanks in advance..

Trouver plus de publications taguées avec

Accepted answers

All comments

TinaMorgan1

Hello, I see this is an older post, but just wanted to check if you were able to call Esri Support and find a resolution to this issue? If you were able to get around the issue (either with or without support), do you have the details that helped you move forward?

Sincerely,

DharmenderGupta

Thank you William for all the suggestions so far.

WilliamCraft

I'm sorry that I wasn't able to help you. Perhaps your next step could be Esri technical support. Based on all of the information known to dart, a few suspicions on my part would be the use of one or more periods in the host name, the use of numeric characters in the database name, and the use of numeric characters in the SDE connection file name. I'm not sure if any of these suspicions would lead you down the path to a solution but hopefully they will. Good luck!

DharmenderGupta

Hi William,

On trying to edit ,I get back original error.

WilliamCraft

Hi William,

I have followed the manual process and able to see the database registered.
But when I click on "Validate All" it is invalidated,this could be because of wrong password.

But there is no way to edit the password.

Can you try to click the Edit Registered Database button and modify the connection parameters in there? It should be the button right under the X button in the Data Stores UI. Please re-enter the password and then save the changes. See screenshot...

[ATTACH=CONFIG]30105[/ATTACH]

pJaOt.png

DharmenderGupta

Hi William,

I have followed the manual process and able to see the database registered.
But when I click on "Validate All" it is invalidated,this could be because of wrong password.

But there is no way to edit the password.

DharmenderGupta

HI William,

Thanks a lot for your suggestion.
I will try the manual process you mentioned and will let you know how it goes.

FYI:I have tnsnames.ora file already with entry for m12yd223 and I have tried giving m12yd223 in the instance field but it could not
recognize it.

WilliamCraft

After some sleep, I think I'm able to take another stab at this. See the attached arcgis-dataspace.xml file (just change the extension from TXT to XML and view with Notepad++), which is an example file that you can use/modify after backing up your original if you wish. I think to manually register the enterprise geodatabase manually as I suggested earlier, you would need to create an "enterpriseDatabases" item entry as seen in my example file. I've also included a "fileShares" item entry as well for a folder called C:\data\content so that you can see what a registered folder looks like too. Using the info you provided, I substituted your parameters in place of mine to show what the enterprise geodatabase item entry should look like. The only issue would be the password, which AGS encrypts automatically upon successful registration. I'm not entirely sure how you might get past that issue, since neither of us will really know what your encrypted password would look like. I've made it all zeros for now. You could try adding this item entry to your file, then restarting the Windows service for AGS, then going back into ArcCatalog and re-saving your password in the SDE connection file properties, and re-validating your already-registered data store by clicking the Validate button under the Data Store section of Server Properties. That might work as it could re-set the encrypted password to the correct value for your environment. I'm not sure if this will work, but it's possibly worth a shot. If it doesn't validate, click the Edit Registered Database button and modify your connection information from there. Then click OK and try validating again.

As a last suggestion to register your data store using the ArcGIS Desktop tools, I would say to create a TNSNAMES.ora file entry for your database named m12yd223 and then specify m12yd223 as the only value in the Instance field afterwards. If the issue truly is the length of your host name or the inclusion of periods in the string, this may be a good work around.

arcgis-dataspace.txt.zip

WilliamCraft

Hi William,

rws3260455.us.oracle.com is oracle 11g db host name.
1521 is db port
m12yd223 is Oracle SID.

I ahve referred link http://resources.arcgis.com/en/help/main/10.2/index.html#/Database_connections_in_ArcGIS_for_Desktop/019v00000003000000/

and provided Instance as rws3260455.us.oracle.com:1521/m12yd223

With this syntax I am able to succesfully create datbase connection in Desktop but registering the database with gis server fails.

Is there any other setup that we need to do for this .Please suggest.

The only thing I can't think of at this point is that the host name you're using is simply too long for data store registration despite working when connecting in general.

Perhaps manually registering the data store might work. Locate the xml configuration file: ...\config-store\data\arcgis-dataspace.xml under the ArcGIS Server set of folders and add an entry manually under the /fileShares section; then save and restart the ArcGIS Server service.

DharmenderGupta

Hi William,

rws3260455.us.oracle.com is oracle 11g db host name.
1521 is db port
m12yd223 is Oracle SID.

I ahve referred link http://resources.arcgis.com/en/help/main/10.2/index.html#/Database_connections_in_ArcGIS_for_Desktop/019v00000003000000/

and provided Instance as rws3260455.us.oracle.com:1521/m12yd223

With this syntax I am able to succesfully create datbase connection in Desktop but registering the database with gis server fails.

Is there any other setup that we need to do for this .Please suggest.

WilliamCraft

HI William,

I don't see service parameter,but I see "Instance" and the value I provided is rws3260455.us.oracle.com:1521/m12yd223.

This is Oracle 11g db host,port and sid.

Do you think there is something wrong in this.

Is m12yd223 the name of the server? Is rws3260455.us.oracle.com the exact name of your Oracle service? Perhaps I have them reversed; not sure. In any case, I've not seen a connection string syntax like that before when configuring geodatabase connections. Can you try the following combinations in the Instance field?

If rws3260455.us.oracle.com is the Oracle service name... then try rws3260455.us.oracle.com or rws3260455 in the instance line.

If m12yd223 is the Oracle service name... then try m12yd223 in the instance line.

Are you using the TNSNAMES.ora file to store your various database connections by chance? If not, you may need to create an entry for your Oracle service name in that file on the client machine and on the server (also, don't forget your LISTENER.ORA file too) and then try again with the options I specified above. If you modify the LISTENER.ora file, restart the listener service before attempting to reconnect.

DharmenderGupta

HI William,

I don't see service parameter,but I see "Instance" and the value I provided is rws3260455.us.oracle.com:1521/m12yd223.

This is Oracle 11g db host,port and sid.

Do you think there is something wrong in this.

WilliamCraft

So for the "Service" parameter in the Geodatabase Connections properties of your SDE connection file, what is the value you're putting in? Is it only the TNSNAME or is it sde : oracle11g:TNSNAME or could it be sde : oracle11g:TNSNAME;port_number ? If your service value has a colon or semi-colon then try to remove it and just use TNSNAME to see if it connects without an error.

DharmenderGupta

HI William,

Yes I have both 32 bit and 64 bit clients installed on the machine where I installed arcgis desktop and server.
and also PATH env variable has 64 bit path first and then 32 bit.

DharmenderGupta

Hi William,

I have verified that my database and client are of same version 11.2.0.3.0

I have not installed Arc SDE ,I just have Arc GIS Server and desktop.

WilliamCraft

If ArcGIS for Desktop 10.2 and ArcGIS for Server 10.2 are installed on the same server, you will need to make sure that both the 32-bit and 64-bit Oracle clients are also installed on the server. Is that the case? The PATH environment variable must have the 64-bit client listed first before the 32-bit client. Please verify this.

DharmenderGupta

Hi William,

I have verified that my database and client are of same version 11.2.0.3.0

I have not installed Arc SDE ,I just have Arc GIS Server and desktop.

DharmenderGupta

Hi ,

Path of SDE connection file is /Users/lroot/AppData/Roaming/ESRI/Desktop10.2/ArcCatalog/m12yd223.sde

WilliamCraft

Can you please verify that the version of your Oracle client matches that of your database? You say that you have an Oracle 11g database, but you need to first make sure that your client is of the same of later version. If your database is 11g R2 (as an example, 11.2.0.2) but your client is 11g R1 (as an example, 11.1.0.9) or 10g (as an example, 10.2.0.1) then you could run into issues. Also, have you installed the full version (administrator) of the client or a different version?

If the above doesn't help, then refer to the following...

Which versions of ArcGIS Server and ArcSDE are you using?

Is SDEHOME correctly defined in the environment variables? (From command prompt, type echo %SDEHOME%)

For the SDE connection file you're using to register your enterprise GDB as a data store, does it use an ArcSDE application service or does it use EZCONNECT? (If EZCONNECT, is your Oracle instance configured for EZCONNECT?)

jskinner

Hello,

Can you provide the path to your SDE connection file?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.