Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: IP address change
On Wed, 07 May 2003 21:21:00 GMT, andreyNSPAM_at_bookexchange.net
(NetComrade) wrote:
>On Wed, 07 May 2003 15:11:28 -0500, Ed Stevens <nospam_at_noway.nohow>
>wrote:
>
>
>>How are your clients resolveing connection requests? TNSNAMES? IF
>>so, look in the TNSNAMES.ORA file. If the old IP address is found
>>there, change it to the new address. Better yet, change it to the
>>machine name. If every user has their own TNSNAMES file, good luck!
>
>For a local network that can be resolved via a user registry entry
>TNS_ADMIN pointing to a central tnsnames.ora file
>
Which is exactly what we do, but there was no indication that the OP did so.
>.......
>We use Oracle 8.1.7.4 on Solaris 2.7 boxes
>remove NSPAM to email
Received on Thu May 08 2003 - 07:39:24 CDT
![]() |
![]() |