Getting error message when try to create a new project. But I am able to create a new Domain. This is the error message we are getting. Failed to Get Tablespace Info; [Mercury][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied
From the DB server tab in siteadmin, I am ping is also failing.
Failed to Test Connection; Test connection failed; [Mercury][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied
We are using HP ALM 11, patch 19.
Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit
Any idea how to fix this issue?
Many thanks in advance.
Answer by Dan · Feb 06 at 03:09 PM
Hi TheKing, Make sure that the siteadmin username ansd password are correct and valid (meaning they haven't changed or expired), and that the DBA hasn't changed or revoked the permissions necessary to create new table space on the DB (the installation guide lists the permissions that this user account should have in order to fully perform and if one or more of them have changed then this issue can result). Since you can't ping someone may have changed something on the DB server as well, and I would check into that. Sometimes DBA's and IT Admins do periodic maintenance and site survey's and decide that the security is too lax on these servers and "tighten" it up not realizing that they are effecting the performance and capabilities of the server by removing necessary permissions.