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; } } }

SDE (Oracle) error when importing in ArcGIS Server

LittleTurtle

Hello,

I have this error when trying to publish my SDE to ArcGIS Server :

Underlying DBMS error[ORA-12154: TNS:could not resolve the connect identifier specifiedNo extended error.]

I have tried different things :

- SDE with EZconnect: works in ArcCatalog and AGS

- SDE with connection like sde:oracle11g:xyz: works in ArcCatalog and AGS

- SDE with connection like sde:oracle19c:xyz: works in ArcCatalog but fails in AGS

The instantclient installed on AGS is 19.23

The db is 19.3.0.0.0

I've updated the init_user_param.sh: export LD_LIBRARY_PATH=/usr/lib/oracle/19.23/client64/lib:$LD_LIBRARY_PATH

I would be fine if I could use SDE with 11g but with an old mxd I can't publish it, it always asks me to publish oracle19c SDE

Does anyone can help me?

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

LittleTurtle

Even if I change datasource and use EZConnect in ArcCatalog it always ask me to add sde:oracle19c:xyz SDE to AGS which fails

George_Thompson

Are you using TNS or EZConnect in the connection window in Pro?

Did you restart the ArcGIS Server service after the Oracle client install?

LittleTurtle

I have tried with both (in ArcMap) and when I try to publish to my AGS it says that the source is not defined and I have to use sde:oracle19c:xyz

Yes I have restarted it, I can publish SDE on AGS (EZCOnnect or sde:oracle11g:xyz) but not the one the mxd asks (sde:oracle19c:xyz) which is weird because I can open it in ArcCatalog

George_Thompson

What version of ArcGIS Server (or Enterprise) are you publishing to?

What is the version of ArcMap?

Have you tried from ArcGIS Pro client?

LittleTurtle

this is what I see, I don't have the usual 'Set datasource...' just 'Update request...'
I've tried to recreate a new mxd and 'Set datasource...' to sde:oracle11g:xyz and I can publish my service but I can't really do that because I have a lot of mxd with symbologies... so I would rather prefer use the original mxd

George_Thompson

So it looks like you are trying to publish a query layer.

What is the version Server are you publishing to (this is important)?

What is the version of ArcMap that you are using?

Can you provide a screenshot of your connection properties to your Oracle DB? you can mark out the UN / PW part

LittleTurtle

AGS 10.8.1 and ArcMap 10.8.1

I've tried publishing sde from ArcMap or directly to AGS but does not work

LittleTurtle

AGS 10.8.1 and ArcMap 10.8.1
so this SDE is working in ArcCatalog and I can publish it in AGS:

and this one is working on ArcCatalog but cannot be published in AGS (same login/password):

George_Thompson

OK, thanks. This may need a little more detailed troubleshooting and would recommend technical support to work with you on this.

It seems there is something that is not correct with the connection string or the configuration.

On the Server, can you open sqlplus and connect to TEST with TNSNAME?

LittleTurtle

Ok I'm sorry I've been able to make it work, I thought I had changed the datasource but I don't think it worked, I've done it again in ArcCatalog (right click on the mxd > Change datasource after renaming my SDE file > Choose SDE with sde:oracle11g:xyz) and saved it in another mxd
It seems to publish well (referenced data)

I still can't publish sde:oracle19c:xyz and I don't really know why but that's not blocking anymore, tell me if you have any idea though

Thank you for your help 🙂

MattFancher1

It sounds like the issue is with the 64x version of the 19c client on your AGS machine. I'd recommend working with your DBA to verify EZCONNECT is enabled and/or TNS is properly configured for that specific client. Sounds like you have a number of Oracle clients on your AGS machine and that can definitely get confusing. Good luck! 🙂

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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