Select to view content in your preferred language

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

736
2
04-19-2023 08:37 PM
Status: Open
Bud
by
Honored Contributor

ArcGIS Pro 3.1.1; Oracle

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

Bud_0-1681961355644.png


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:

Bud_1-1681961503646.png


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

2 Comments
DuongHB

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

Bud
by

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:

Bud_0-1682005876842.png

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

Bud_0-1682006028877.png

 

Bud_1-1682006028819.png

 

 

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