OraFAQ Forum: Server Administration » IP address Change of Oracle database server

Home » RDBMS Server » Server Administration » IP address Change of Oracle database server (Oracle 10g, Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IP address Change of Oracle database server [message #662431]

Tue, 02 May 2017 02:13

kumarravik
Messages: 31
Registered: January 2016
Location: delhi

Member

Hi there,

I have an upcoming change in Oracle RDBMS server. The team is planning to change the IP address of Oracle database server.

Can you please guide me what are the things that could be impacted or needs to taken care due to this?

Do i need to take care of database objects like re-validating all objects?

We have many jobs (both Oracle jobs and UNIX jobs) that extracts data from it send it to different sources (i.e. Mainframe, SAP, Other RDBMS systems). And few jobs extract data from other sources and update Oracle tables here.

Any impact on these jobs ? Please let me know if any other details required.

Thank you!!

Report message to a moderator

Re: IP address Change of Oracle database server [message #662432 is a reply to message #662431]

Tue, 02 May 2017 02:36

John Watson
Messages: 8458
Registered: January 2010
Location: Global Village

Senior Member

If you have name resolution services set up, then there is no reason why changing IP address will have any impact. Consider the situation if you are using DHCP; no difference.

Report message to a moderator

Re: IP address Change of Oracle database server [message #662477 is a reply to message #662432]

Wed, 03 May 2017 03:18

gazzag
Messages: 1091
Registered: November 2010
Location: Bedwas, UK

Senior Member

If you have an Oracle Enterprise Manager/Cloud Control agent stop that and de-install it. Then remove it as a target from the monitoring console. Once the IP address has been changed, the management agent can be re-installed.

Report message to a moderator

Re: IP address Change of Oracle database server [message #662480 is a reply to message #662432]

Wed, 03 May 2017 07:01

kumarravik
Messages: 31
Registered: January 2016
Location: delhi

Member

Thank you for your inputs. Seems, it's not very scary Smile

Report message to a moderator

Previous Topic:	ORA-02165
Next Topic:	Knowledge Transfer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 24 20:01:25 CST 2021