Connect to database: ORA-01017: invalid username/password; logon denied
I’m new to Ui path and keep getting this error and don’t know how to resolve. The login credentials I provided are correct but I still get this error
Hi @cemenike
→ First double check your login credentials, In Oracle database credentials, passwords are case sensitive and have special characters, check this properly.
→ Ensure that you have a stable network connection to the Oracle database server. Check if you can connect to the database using the same credentials using other tools such as SQL Developer or a command-line interface like SQL*Plus. If you cannot connect using these tools as well, there might be an issue with your database setup or network configuration.
→ Try to login to the Oracle database from the other tools with the same credentials.
Hope it helps!!
thanks @mkankatala . I’ve tried all these steps, same error. I believe this could probably be a database error and not a ui path one. Thanks anyways
Better to reach out your database administrator for further assistance in troubleshooting the connection problem. @cemenike
Have you tried to login to Oracle database by using the same credentials. If not do it.
Yes i have. I have a database application and I’ve tested the creds on there. Connects just fine
@cemenike Did you develop connection in ODBC and did you put connection string in ora file?
Ensure that you have the necessary Oracle client software installed on the machine running UiPath
and Ensure that there are no firewall restrictions or security settings blocking the connection between UiPath and the Oracle database.
not entirely sure what this means. The connection credentials are gotten from my orchestrator workspace as a string and then passed into the database connector
@cemenike One more Question: is it Oracle database ?
Yes, the database is an Oracle one
@cemenike Ok got it: You can’t use database activities without Configuration With ODBC driver
@cemenike First develop connection with ODBC Driver:’
Read this thread and apply all steps
Thanks. Will give it a look
@cemenike I used multiple oracle databases and for all I used this method. If you find any other method please share with me as well. It will increase my knowledge as well.
I am checking other tutorial for this method.
1 Like
@cemenike
Check this also. Its steps are clear and understandable.
1 Like
@cemenike Try This one if you faced any issue during configuration, let me know we will check it
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
manasrlenka25