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
Last week I also can't connect throught service name. I need change to SID...
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.