Forum Discussion
Gateway configured incorrectly error when creating new oracle connection in on premises gateway
Hi Anonymous ,
- 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.
- 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.
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
Super User
Are you using TNSNAMES.ORA ? Are you able to successfully log in to that TNS entry via sqlplus ?
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 ?
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!
