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?

[LittleTurtle]

Even if I change datasource and use EZConnect in ArcCatalog it always ask me to add sde:oracle19c:XXX 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]

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]

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
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?