I recently made a new tablespace and associated a user with it (sonar).
Currently, a copy and paste of the user profile looks like this:
Name SONAR
Profile DEFAULT
Authentication Password
Default Tablespace SONAR
Temporary Tablespace TEMP
Status UNLOCK
Default Consumer Group None
Role Admin Option Default
CONNECT N Y
DBA N Y
RESOURCE N Y
System Privilege Admin Option
CREATE SESSION N
UNLIMITED TABLESPACE N
I can log in to the OEM console with this new user but am unable to connect to the sonar tablespace with that user. I know the connection properties I'm using are valid because I can connect with other users and view their tablespaces.
So, does anyone have an idea what I might be missing that is preventing me from connecting with this user and using their default tablespace? If I need to provide any more information, let me know. I'm not very experienced with DBA stuff.
Thank you.
Since you're getting an "ORA-01017: invalid username/ password" error, there are only a handful of possibilities
Sonar
user. If you can connect as other users using the same connection information, can you query DBA_USERS
and verify that you see the Sonar
user?