Gateway configured incorrectly error when creating new oracle connection in on premises gateway

[srivp07]

I am tyimg to create new oracle Db connection  in on premises gateway and it is showing error in on gateway configured incorrectly error when creating new oracle connection. also it is locking oracle DB account. Please help!

Thank you!

[srivp07]

Hello,

I am trying to update password for Oracle DB and it shows  Gateway configured incorrectly error in on premises gateway. Also it is locking the account immidiately. Please help!

Thank you!

[lbendlin]

Are you using TNSNAMES.ORA ?  Are you able to successfully log in to that TNS entry via sqlplus ?

[srivp07]

Hi

Could you please elabrate more on TNSNAMES.ORA  configuration?

currently file has contents as below, please let me know do I need to fill out these details. Also how I can make sure my passowrd got updated to new one?

<data source alias> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname or IP>)(PORT = <port>))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <database service name>)
)
)

Thank you!

[srivp07]

I am using ORA 28000 and able to login successfully via Oracle SQL develeoper.

[lbendlin]

I am using ORA 28000

?  That's the lockout error message ? 

[srivp07]

yes that is error message, I am not much aware of Oracle specific settings, I need to check with DBA , Also I am able to connect to database from Oracle SQL Developer and getting ORA 28000 account locked error message when configuring in On premises gateway. Also I checked gateway logs and it is showing Int32 timeout error.Please suggest!

Thanks!

[V-yubandi-msft · Accepted solution]

Hi @srivp07 ,

1. ORA-28000 means that the account that you tried to use is locked because some privileged user disabled the ability of connection, or attempt connections with wrong passwords exceeded the limit.
2. The Int32 timeout is likely linked to the ORA-28000 issue, as repeated failed logins (due to misconfiguration) can delay connections and lock the account.

 If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.