I recently installed Oracle 12c on a WIndows server for an application which uses it, and created two databases with SYSTEM password ending with an exclamation mark. I am now trying to get back into the database some weeks later using SQLPlus to do some administration, and keep getting "ORA-01017: invalid username/password; logon denied" messages.
I know the passwords have not changed as if I use the Oracle Administration Assistant for Windows I can connect to both databases by entering SYSTEM and the appropriate password, so the issue must be related to the ! character
I have tried putting double quotes round the password but this makes no difference - any ideas?