OraFAQ Forum: Server Administration » What will happen if i change the IP address of my server on which database reside?

Home » RDBMS Server » Server Administration » What will happen if i change the IP address of my server on which database reside?

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

What will happen if i change the IP address of my server on which database reside? [message #123360]

Sun, 12 June 2005 15:13

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

Before Issue arises . . . i want to know. . .

question:- What will happen if i change the IP address of my server on which database reside?

Note:- database is oracle 10g , there are many user who are conected to the database using space on database for there own different site & using different script such as ASP, PHP etc.
Script use IP address in connection string to connect to the database.

Thank you

By :- Sunilkumar

Report message to a moderator

Re: What will happen if i change the IP address of my server on which database reside? [message #123362 is a reply to message #123360]

Sun, 12 June 2005 16:12

DMcG
Messages: 51
Registered: May 2005
Location: Auckland, New Zealand

Member

It depends on how your clients connect to the database.

If all of them are using a hard coded IP address, then they'll all need to be changed. If they use the host name and you're running DNS, then you may get away with it.

Dougie McGibbon

Report message to a moderator

Re: What will happen if i change the IP address of my server on which database reside? [message #123366 is a reply to message #123362]

Sun, 12 June 2005 21:12

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi.

Do i have to change any thing in My TNSNAMES.ORA file on database server?

Thanks
By :- sunil

Report message to a moderator

Re: What will happen if i change the IP address of my server on which database reside? [message #123453 is a reply to message #123366]

Mon, 13 June 2005 09:38

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

there wont be any need if u r using host naming method with DNS for your connectivity. This has been pointed out by DMcG as well.
But if u r using IP there, then yes u need to change that.

Report message to a moderator

Re: What will happen if i change the IP address of my server on which database reside? [message #123501 is a reply to message #123453]

Mon, 13 June 2005 15:18

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi

Girish can u tell me is it possible to have 2 Host IP address in listener.ora at server side if yes then please tell me how it should be.

Note :- I have to make changes in listener.ora by opening the file listener.ora

As i had changed the IP address of Server machine i have to make changes in listener.ora file on server .... yea i know i have to change in TNSnames.ora file at client side ...

by the way you can see my listener.ora as below
----------------------------------------------------------------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/app/oracle/product/10.1.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))
)
)
)
-----------------------------------------------------------------

Is it possible to have 2 IP for host <--- If yes then how?
Note :- New IP address i can write at (HOST=XX.XX.XX.XX) But i want new as well as old IP of machine is it possible if yes then how?

thanks for your reply
&
Sorry for not posting this issue under networking issue..

From:- sunil

Report message to a moderator

Re: What will happen if i change the IP address of my server on which database reside? [message #123507 is a reply to message #123360]

Mon, 13 June 2005 15:41

DMcG
Messages: 51
Registered: May 2005
Location: Auckland, New Zealand

Member

It's possible to setup a server with one network connection to have multiple IP addresses - but this varies immensely on what hardware and what operating system you're using and can be a complex operation. If this is what you're trying to do then this thread should certainly get moved to the networking section.

Dougie McGibbon

Report message to a moderator

Re: What will happen if i change the IP address of my server on which database reside? [message #123571 is a reply to message #123507]

Tue, 14 June 2005 00:27

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Add one more address_list clause.
eg.
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.xx)(PORT = xxxx))

Report message to a moderator

Previous Topic:	Tablespace without datafile
Next Topic:	Database creation script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 07:04:05 CST 2025