How to update oracle data source credentials for on-premises gateway ?

Hi Anonymous ,

Thank you for reaching out to Microsoft Fabric Community Forum.

can you check this below mentioned points.

1)Normally, Oracle uses the tnsnames.ora based on which Oracle Client the application is using.

2)If your SQL Developer is installed separately, it usually does not read these files. But if any Power BI / Gateway / ODBC connection uses Oracle Client, then it depends on which client path is referenced in the PATH Environment Variable.

3)Check your Environment Variable PATH and see if any of these paths (ODAC or Oracle Client for Microsoft Tools) is mentioned. Whichever client path is first in the PATH variable, that's the one the system will use.

Q2)
MYORACLEDATA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = your_oracle_server_hostname_or_ip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = your_service_name_from_DBA)
)
)
HOST = the Oracle server's hostname or IP
SERVICE_NAME = your Oracle Database's service name (like orcl.example.com or whatever your DBA provides).

3)Ask your DBA to check the Oracle sessions to find which machine/program is locking the account.

Regards,

Chaithanya.