Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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

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...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    Hi Anonymous ,

    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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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!