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

Can't register Oracle SDE database with ArcServer 10.4 with OS authentication

MarkMcCart

I am trying to register our Oracle 12C SDE database with ArcServer 10.4 using OS authentication so I can publish a REST service. I keep getting a 'Bad User Login' error. No ORA number.

Here is our current configuration:

1. Oracle SDE at 10.4

2. Desktop at 10.4

3. Server for ArcGIS at 10.4

4. Oracle Client 64-bit is installed on the server that hosts ArcServer

If I use a database username and password instead of OS, it works. We've also confirmed that the server can 'tnsping' the database.

Any suggestions?

Thanks,

Mark

Najděte více příspěvků označených jako

Accepted answers

MarkMcCart

We discovered we were using the wrong account to run services on the server. We were using a local account vs. a domain account. Problem solved.

All comments

George_Thompson

Can you log into SQLPlus using OS authentication from the server machine?

Does OS authentication work form the machine that has desktop installed?

MarkMcCart

Yes, I can connect to SQLPLUS in the CMD window with OS authentication from that machine. And yes, OS authentication works from the machine the desktop software is installed.

George_Thompson

Thanks for the previous answers..... I forgot to ask these also.

I assume that the Oracle machine is Windows?

Is the ArcGIS server account running with a domain account also (I would think so...)?

Are you using TNSNAMES or EZConnect for the connection string?

MarkMcCart

Oracle machine is Windows 2012 R2 as is the server for ArcServer. These are brand new VMs that were stood. We did not have this issue in 10.3.1 on different machines.

ArcGIS Server account is running with a domain account and it is a local admin

I am using EZConnect for the connection string.

George_Thompson

Hi Mark,

I have not tested with Server at the 10.4 release. I would recommend that you create a support case with the Server Usage team so they can investigate in more detail.

Esri Technical Support

MarkMcCart

Done. Thanks for the help do some more checks before I submitted the ticket.

MarkMcCart

We discovered we were using the wrong account to run services on the server. We were using a local account vs. a domain account. Problem solved.

George_Thompson

Thanks for the follow up on this........ Glad it started to work!

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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