idea Create database connection using a Service Name instead of an SID (Oracle) in ArcGIS Enterprise Ideas

Create database connection using a Service Name instead of an SID (Oracle)

Bud — Thu, 20 Apr 2023 15:53:22 GMT

ArcGIS Pro 3.1.1; Oracle

I can create a database connection to a CDB without issue:

However, I don't see a way to create a database connection to a PDB (pluggable) Service Name.

In SQL Developer, a connection to the default PDB (XEPDB1) looks like this:

That connection uses a Service Name instead of an SID. So the connection to XEPDB1 works as expected.

Could the Create Database Connection tool in ArcGIS Pro be enhanced so that we can use a Service Name instead of an SID?

I'm very green, so let me know if I've misunderstood something.

Background: Create database user in Oracle 18c XE via ArcGIS Pro

Re: Create database connection using a Service Name instead of an SID (Oracle)

DuongHB — Thu, 20 Apr 2023 07:44:01 GMT

Last week I also can't connect throught service name. I need change to SID...

Re: Create database connection using a Service Name instead of an SID (Oracle)

Bud — Thu, 20 Apr 2023 15:54:13 GMT

I figured out my problem.

My TNS wasn't set up correctly. I had to add a TNS entry for XEPDB1. (Previously, it only had an entry for XE.)

 XEPDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = XEPDB1)
    )
  )

Now, I'm able to connect to XEPDB1 in an ArcGIS Pro database connection:

Create database user in Oracle 18c XE via ArcGIS Pro

Notes:

1. If I understand correctly: I didn't need that TNS entry when connecting to XEPDB1 via SQL Developer because SQL Developer using a different connection mechanism -- JDBC, not the database client (ArcGIS Pro uses the database client).

2. Side note: In SQL Developer, I think I can connect to either the SID (XE) or the Service Name (also XE).

Esri staff, feel free to close this idea if appropriate.