Forum Discussion
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.
Thank you Chaintanya for your sugesstions. Howerver,I have checked credentials manager for windows and did not find any oracel credentilas and cleared prermissions and removed all existing oracle connections from desktop app also cleared cached data data from file-> Options. and restarted personal gateway and it is still locking oracle account. I stopped Standard On-Premises Gateway service from server and satandand gateways is offline now. Still oracle account is getting locked in SQL developer. Did traceroute to hotname and it is showing Request timed out after 4 hops.
Also I have few questions regarding steps you recently mentioned.
3)Locate and open the tnsnames.ora file (e.g., C:\oracle\product\<version>\client_1\network\admin\tnsnames.ora):
Q. On my PC tnsnames.ora file is at 2 locations: 1. 1. 1.C:\Users\****username\ODAC122010Xcopy_x64\network\admin\sample location.
2.C:\Program Files\Oracle Client for Microsoft Tools\network\admin\sample
Q: Do I need to fill out those details in tnsnames.ora file and if yes then which folder location file I need to fill out since I have file at 2 locations.
4)Ensure the correct format in tnsnames.ora for the Oracle alias:
MYORACLEDATA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname/IP>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <your_service_name>)
)
Q. 2)Test the TNS alias resolution with tnsping <TNS alias>.
Where I can find TNS alias?
Thanks much for your consistant support!
Community SupportHi 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.