When I create a user in an 11204 single instance DB and afterwards grant the sysdba privilege to that user I can connect remotely without any problems using:
sqlplus testuser/testuserpwd@testdb as sysdba
However, when I do this against a RAC DB I keep getting an invalid username and password error for some reason. I can login locally with that username and password so they are correct. I can login remotely as well using:
It's only when I add 'as sysdba' at the end that it gives me the invalid username/password error with the RAC DB.
Any ideas? Many thanks.