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]

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