Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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

Not able to update credentilas for Oracle SQL data source, accouht is getting locked. I am using  connection  on personal mode gateway and Standard mode gateway. credentials are geeting updated only ...
Dataflow
Need Help
  • v-kathullac's avatar
    v-kathullac
    1 year ago

    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.

v-kathullac's avatar
v-kathullac
Icon for Community Support rankCommunity Support
1 year ago

Hi Anonymous ,

 

It looks like you’re facing multiple issues with the Oracle data source and gateway setup. Here's a step-by-step guide to  resolve your issue

 

  • Make sure the on-premises data gateway is running and up to date on the server.

  • Open the gateway app and confirm it's showing as online.

  • Oracle account may get locked due to incorrect credentials from earlier attempts.

  • Too many failed login attempts can also lock the Oracle account.

  • Reset the Oracle password and test it using SQL Developer.

  • Avoid reusing the old password immediately, as Oracle might still lock it.

  • Work with your DBA to unlock the Oracle account and monitor during setup.

  • Go to Power BI Service  Manage Gateways and select your gateway.

  • Click on "New Data Source" to add a new Oracle connection.

  • Use the exact same Server Name, Port, and Database Name as your dataset.

  • Enter the correct Oracle credentials when adding the data source.

  • Save the new Oracle data source connection in the gateway.

  • Go to Dataset Settings in Power BI Service.

  • Under "Gateway connection", check if the new Oracle data source has a green checkmark.

  • If you see "Add to Gateway", click it and map the dataset to the new connection.

  • The old data source may still show up because the dataset is referencing it.

  • Once the new gateway connection is successful and credentials are validated, the Scheduled Refresh option will be enabled again.

 

Regards,

Chaithanya.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Chaitanya,

Thanks a lot for providing resolution steps. I tried to follow above steps , DBA unlocked oracle account. I tested connection from SQL Delveloper tool and connection was successful. After this I confirmed the Gateway is online and  I tried to add new connection and it locked the account again. Please advise!

Thank you!