Hi Community,
I have a 2 node RAC test database I'm trying to give an application vendor sysdba access to. So far we have had some success by granting his user id sysdba on both instances, and having him connect with the following string:
conn un/pw@ay00odadb-scanu.uat.net:1521/smp53uat/smp53uat1 as sysdba (for instance 1)
conn un/pw@ay00odadb-scanu.uat.net:1521/smp53uat/smp53uat2 as sysdba (for instance 2)
He can connect to both instances as sys and can do everything sys allows (i.e. shutdown), but once he shuts down the instance he cannot reconnect.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
He is connecting from another server, so I'm guessing it's a local password file issue on the database nodes and/or something that needs to be configured with the scan listener/oranet component? Because of firewall rules he must connect through the scan listener, and we are allowing sysdba so he can bounce and flashback the test database as needed (and his TZ is 12 hours different from ours, making it difficult to support).
Any guidance to resolve this would be appreciated.
Thanks,
James