Is it possible to change hostname of the database server after oracle 10g installation and database running on the server. What files would need to be modified other than thnsnames and listener.ora?
Printable View
Is it possible to change hostname of the database server after oracle 10g installation and database running on the server. What files would need to be modified other than thnsnames and listener.ora?
That should do it. Change the tnsnames.ora and listener.ora on the server and the tnsnames.ora on the clients.
Maybe /etc/hosts as well.
maybe init.ora depending on how you have local_listener and dispatches configured...