INS0009 Unable to connect to the database
I wanted to delete unauthorized users and workspace in Oracle. I am using Oracle Repository Assistant Version 11.2. All owners of workspace and admin users are known and all their usernames and passwords are kept tracked. An error occurred while trying to delete those unwanted users and workspaces. It says: “INS0009: Unable to connect to the database using user <username>. java.sql.SQLException: ORA-01017 invalid username/password;logon denied.” I tried making new user accounts and workspaces without using a password but I found out that a default password was set for me so that every time I created a user, it will be protected by that password. It is a good thing though. But the bad thing is I don’t know what the password is and I could not delete users without that password. What should I do?