topic Re: SDE (Oracle) error when importing in ArcGIS Server in ArcGIS Enterprise Questions

SDE (Oracle) error when importing in ArcGIS Server

LittleTurtle — Fri, 28 Jun 2024 16:37:48 GMT

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?

Re: SDE (Oracle) error when importing in ArcGIS Server

LittleTurtle — Wed, 05 Jun 2024 10:37:44 GMT

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

Re: SDE (Oracle) error when importing in ArcGIS Server

George_Thompson — Wed, 05 Jun 2024 10:39:37 GMT

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

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

Re: SDE (Oracle) error when importing in ArcGIS Server

LittleTurtle — Fri, 28 Jun 2024 16:34:33 GMT

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

Re: SDE (Oracle) error when importing in ArcGIS Server

George_Thompson — Wed, 05 Jun 2024 10:45:40 GMT

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

What is the version of ArcMap?

Have you tried from ArcGIS Pro client?

Re: SDE (Oracle) error when importing in ArcGIS Server

LittleTurtle — Fri, 28 Jun 2024 16:35:06 GMT

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

Re: SDE (Oracle) error when importing in ArcGIS Server

George_Thompson — Wed, 05 Jun 2024 11:20:56 GMT

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

Re: SDE (Oracle) error when importing in ArcGIS Server

LittleTurtle — Wed, 05 Jun 2024 11:33:01 GMT

AGS 10.8.1 and ArcMap 10.8.1

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

Re: SDE (Oracle) error when importing in ArcGIS Server

LittleTurtle — Wed, 05 Jun 2024 11:42:14 GMT

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):

Re: SDE (Oracle) error when importing in ArcGIS Server

George_Thompson — Wed, 05 Jun 2024 12:23:15 GMT

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?

Re: SDE (Oracle) error when importing in ArcGIS Server

LittleTurtle — Fri, 28 Jun 2024 16:35:46 GMT

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 🙂

Re: SDE (Oracle) error when importing in ArcGIS Server

MattFancher1 — Mon, 10 Jun 2024 15:53:30 GMT

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! 🙂