If I change Oracle database server IP , what problem may exist and how to solve?
- modify hosts file
- modify tnsnames.ora file
- modify listener.ora file
- modify clients' tnsnames.ora files
As I know it is not necessary to have listener.ora and tnsnames.ora files on database server, it is necessary if you need to connect to another database. Am I right?
I have single-instance database, version 18.104.22.168.0