OraFAQ Forum: Server Administration » different ips for one database server

Home » RDBMS Server » Server Administration » different ips for one database server

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

different ips for one database server [message #64320]

Wed, 12 January 2005 03:24

ramya
Messages: 87
Registered: August 2002

Member

hi If i assign 2 IPS for a single db server,
how can i access database using application with 2 ips.
with regards
ramya

Report message to a moderator

Re: different ips for one database server [message #64322 is a reply to message #64320]

Wed, 12 January 2005 03:51

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

You can configure your listener (listener.ora file) to listen on both IP addresses. Or, if you want, configure different listeners for the different addresses.

Also, remember to update your TNSNAMES.ORA entries to point to the different (or both of the) IP addresses.

Best regards.

Frank

Report message to a moderator

Re: different ips for one database server [message #64323 is a reply to message #64320]

Wed, 12 January 2005 04:04

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

should work.

Throw the details in all files ( tnsnames.ora, listener.ora).

In listener

...
...
...
(ADDRESS =(PROTOCOL=TCP )( HOST=xxx.xxx.xxx.xxx)(PORT=1521))
(ADDRESS =(PROTOCOL=TCP )( HOST=xxx.xxx.xxx.xxx)(PORT=1526))
...
...
...

Report message to a moderator

Re: different host for one sid [message #64325 is a reply to message #64322]

Wed, 12 January 2005 10:54

ramya
Messages: 87
Registered: August 2002

Member

Hi thnks all
I will try that one.I have another dought in standby database.If i want to connect the applicaiton to the standby database when its comes as primary.eg if some disaster occured in primary,The client should not change the connect string.If i add addres_list parameter in
tnsnames.ora in client side,can i accomplish this one.In one connetstring i add one more address_list contains the hostname,port,protocol of the standby.If the primary is becomes standby automatically it should select the standby host for connecting wihtout
changing the connect string.
eg

ZAK2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTO = TCP)(HOST = zak2)(PORT = 1521))
(ADDRESS = (PROTO = TCP)(HOST = 192.9.230.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ZAK2.world)
)
)

Report message to a moderator

Previous Topic:	CONTRAINTS
Next Topic:	DATABASE LINK

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 04:24:51 CDT 2024