RE: Unix host name change - what happens to db?

2003-06-04 Thread Sarnowski, Chris
We've juggled names several times here. The tricky part is network connections to the database. You need to make sure that tnsnames.ora files point to the right server. Also, if people are using database connections in other programs (e.g. perl, Pro*C, java, python) they need to make sure they

Re: Unix host name change - what happens to db?

2003-06-04 Thread Jose Luis Delgado
It should not affect you... except, of course, in your CONFIG ora files if you are using HOSTS instead of IP addresses! JL --- Carmen Rusu [EMAIL PROTECTED] wrote: My boss has decided to change the name of the Sun OS 2.8 host of my Oracle 8i databases. Question: how does this name

RE: Unix host name change - what happens to db?

2003-06-04 Thread Stephen Lee
If your network people are good people who pray to the correct gods, then all you need to do is allow the update to the DNS servers propagate. What?! You don't use DNS?! Oh! Well, that's different. (Emily Littella) -Original Message- My boss has decided to change the name of the

RE: Unix host name change - what happens to db?

2003-06-04 Thread DENNIS WILLIAMS
Carmen - I haven't had this happen, but I think the main issue would be in your listener.ora and tnsnames.ora files. If you are referencing the host name in those files, then those will need to be changed. Is the IP address changing? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc.

RE: Unix host name change - what happens to db?

2003-06-04 Thread Stephen Lee
rollback previous post. For a moment there I was thinking IP address change. Never mind (Emily Littella) Now, there is the subject of aliases. I mean, as long as a manager wants to be ridiculous, you might as well go whole hog. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

RE: Unix host name change - what happens to db?

2003-06-04 Thread Nelson, Allan
Your tnsnames.ora will probably need to change. If you are using the Apache instance that comes with the db then you will need to do some work on those config files as well. Allan -Original Message-From: Carmen Rusu [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 03, 2003