Topic Options
Rate This Topic
#113130 - 03/07/05 04:18 AM [OT] Changing IP Address on Oracle Server
jjmckenzie51464 Offline
enthusiast

Registered: 03/09/05
Posts: 334
Folks:

What do I need to do to change the IP address on our Remedy system's Remote Oracle Server (other than the obvious.) We were forced to move IP space from one network to another, just in case you are wondering....


James McKenzie


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


Top
#113131 - 03/06/05 07:50 PM Re: [OT] Changing IP Address on Oracle Server [Re: joe_dsouza]
Jarl Groneng Offline
enthusiast

Registered: 03/10/05
Posts: 2371
If you using dns there should be not issues related to this. If not, depening on your setup; change tnsnames.ora (or sqlnet.ora) on your AR System server.

--
Jarl



> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG]On Behalf Of James Mckenzie
> Sent: 7. mars 2005 17:19
> To: arslist@ARSLIST.ORG
> Subject: [OT] Changing IP Address on Oracle Server
>
>
> Folks:
>
> What do I need to do to change the IP address on our Remedy
> system's Remote Oracle Server (other than the obvious.) We
> were forced to move IP space from one network to another,
> just in case you are wondering....
>
>
> James McKenzie
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


Top
#113132 - 03/06/05 08:18 PM Re: [OT] Changing IP Address on Oracle Server [Re: joe_dsouza]
jjmckenzie51464 Offline
enthusiast

Registered: 03/09/05
Posts: 334
Jarl:

Where there any license issues? We will be updating our DNS server at the same time that we move IPs.

James McKenzie

-----Original Message-----
From: Jarl Groneng
Sent: Mar 7, 2005 12:50 PM
To: arslist@ARSLIST.ORG
Subject: Re: [ARSLIST] [OT] Changing IP Address on Oracle Server

If you using dns there should be not issues related to this. If not, depening on your setup; change tnsnames.ora (or sqlnet.ora) on your AR System server.

--
Jarl



> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG]On Behalf Of James Mckenzie
> Sent: 7. mars 2005 17:19
> To: arslist@ARSLIST.ORG
> Subject: [OT] Changing IP Address on Oracle Server
>
>
> Folks:
>
> What do I need to do to change the IP address on our Remedy
> system's Remote Oracle Server (other than the obvious.) We
> were forced to move IP space from one network to another,
> just in case you are wondering....
>
>
> James McKenzie
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


Top
#113133 - 03/06/05 08:33 PM Re: [OT] Changing IP Address on Oracle Server [Re: joe_dsouza]
Jarl Groneng Offline
enthusiast

Registered: 03/10/05
Posts: 2371
James,

I does not know how Oracle is licensed, but suspect its tied to the hostid.

--
Jarl


On Mon, 7 Mar 2005 13:18:30 -0700, James Mckenzie
wrote:
> Jarl:
>
> Where there any license issues? We will be updating our DNS server at the same time that we move IPs.
>
> James McKenzie
>
> -----Original Message-----
> From: Jarl Groneng
> Sent: Mar 7, 2005 12:50 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: [ARSLIST] [OT] Changing IP Address on Oracle Server
>
> If you using dns there should be not issues related to this. If not, depening on your setup; change tnsnames.ora (or sqlnet.ora) on your AR System server.
>
> --
> Jarl
>
> > -----Original Message-----
> > From: Action Request System discussion list(ARSList)
> > [mailto:arslist@ARSLIST.ORG]On Behalf Of James Mckenzie
> > Sent: 7. mars 2005 17:19
> > To: arslist@ARSLIST.ORG
> > Subject: [OT] Changing IP Address on Oracle Server
> >
> >
> > Folks:
> >
> > What do I need to do to change the IP address on our Remedy
> > system's Remote Oracle Server (other than the obvious.) We
> > were forced to move IP space from one network to another,
> > just in case you are wondering....
> >
> >
> > James McKenzie
> >
> >
> >
> > UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> > (Support: mailto:support@arslist.org)
> >
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


Top
#113134 - 03/07/05 04:12 AM Re: [OT] Changing IP Address on Oracle Server [Re: joe_dsouza]
arslist899 Offline
addict

Registered: 03/11/04
Posts: 619
As long as the oracle client is able to resolve the oracle db, you will be
fine. Usually, the tnsnames.ora file contains the hostname, port number,
and sid used to connect to oracle. You can use tnsping (included with the
oracle client) to test your tnsnames configuration.


Axton


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jarl Grøneng
Sent: Monday, March 07, 2005 3:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: [OT] Changing IP Address on Oracle Server

James,

I does not know how Oracle is licensed, but suspect its tied to the hostid.

--
Jarl


On Mon, 7 Mar 2005 13:18:30 -0700, James Mckenzie
wrote:
> Jarl:
>
> Where there any license issues? We will be updating our DNS server at the
same time that we move IPs.
>
> James McKenzie
>
> -----Original Message-----
> From: Jarl Groneng
> Sent: Mar 7, 2005 12:50 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: [ARSLIST] [OT] Changing IP Address on Oracle Server
>
> If you using dns there should be not issues related to this. If not,
depening on your setup; change tnsnames.ora (or sqlnet.ora) on your AR
System server.
>
> --
> Jarl
>
> > -----Original Message-----
> > From: Action Request System discussion list(ARSList)
> > [mailto:arslist@ARSLIST.ORG]On Behalf Of James Mckenzie
> > Sent: 7. mars 2005 17:19
> > To: arslist@ARSLIST.ORG
> > Subject: [OT] Changing IP Address on Oracle Server
> >
> >
> > Folks:
> >
> > What do I need to do to change the IP address on our Remedy
> > system's Remote Oracle Server (other than the obvious.) We
> > were forced to move IP space from one network to another,
> > just in case you are wondering....
> >
> >
> > James McKenzie
> >
> >
> >
> > UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> > (Support: mailto:support@arslist.org)
> >
>
>


> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>


> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


Top
#113135 - 03/08/05 06:42 AM Re: [OT] Changing IP Address on Oracle Server [Re: joe_dsouza]
jjmckenzie51464 Offline
enthusiast

Registered: 03/09/05
Posts: 334
Axton and Jarl:

From what I read here, we should not have an Oracle License issue when
we change IP addresses of the server. All I have to do is change the IP
address on our DNS server and all should be well. The tnsnames.ora file
does not contain IP addresses, but rather uses DNS lookup to get the IP
address.

James McKenzie

Axton Grams wrote:

>As long as the oracle client is able to resolve the oracle db, you will be
>fine. Usually, the tnsnames.ora file contains the hostname, port number,
>and sid used to connect to oracle. You can use tnsping (included with the
>oracle client) to test your tnsnames configuration.
>
>
>Axton
>
>
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG] On Behalf Of Jarl Grøneng
>Sent: Monday, March 07, 2005 3:34 PM
>To: arslist@ARSLIST.ORG
>Subject: Re: [OT] Changing IP Address on Oracle Server
>
>James,
>
>I does not know how Oracle is licensed, but suspect its tied to the hostid.
>
>--
>Jarl
>
>
>On Mon, 7 Mar 2005 13:18:30 -0700, James Mckenzie
> wrote:
>
>
>>Jarl:
>>
>>Where there any license issues? We will be updating our DNS server at the
>>
>>
>same time that we move IPs.
>
>
>>James McKenzie
>>
>>-----Original Message-----
>>From: Jarl Groneng
>>Sent: Mar 7, 2005 12:50 PM
>>To: arslist@ARSLIST.ORG
>>Subject: Re: [ARSLIST] [OT] Changing IP Address on Oracle Server
>>
>>If you using dns there should be not issues related to this. If not,
>>
>>
>depening on your setup; change tnsnames.ora (or sqlnet.ora) on your AR
>System server.
>
>
>>--
>>Jarl
>>
>>
>>
>>>-----Original Message-----
>>>From: Action Request System discussion list(ARSList)
>>>[mailto:arslist@ARSLIST.ORG]On Behalf Of James Mckenzie
>>>Sent: 7. mars 2005 17:19
>>>To: arslist@ARSLIST.ORG
>>>Subject: [OT] Changing IP Address on Oracle Server
>>>
>>>
>>>Folks:
>>>
>>>What do I need to do to change the IP address on our Remedy
>>>system's Remote Oracle Server (other than the obvious.) We
>>>were forced to move IP space from one network to another,
>>>just in case you are wondering....
>>>
>>>
>>>James McKenzie
>>>
>>>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


Top