1748179 Members
4015 Online
108759 Solutions
New Discussion юеВ

Oracle with MCSG

 
SOLVED
Go to solution
Karthik S S
Honored Contributor

Re: Oracle with MCSG

Hi
One small doubt again .... How do I configure the Oracle Server so that the clients always connect to the Virtual IP of the package instead to the actual host. What are all the files need to be modified for this??

Thanks
Karthik
For a list of all the ways technology has failed to improve the quality of life, please press three. - Alice Kahn
John Palmer
Honored Contributor

Re: Oracle with MCSG

Oracle clients will connect via the Net8 (originally SQLNET) listener.

You just need to configure the listener for your package IP address rather than that of the server.

The listener config file is listener.ora and by default will be in $ORACLE_HOME/network/admin although it can also be in /etc or anywhere referenced by an exported variable TNS_ADMIN.

Regards,
John
Christian Gebhardt
Honored Contributor

Re: Oracle with MCSG

Hi

In your listener.ora you have to insert the IP-Adress (or DNS-name) of the package, also in the tnsnames.ora on clientside

listener.ora:
LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

tnsnames.ora:

.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
)
(CONNECT_DATA = (SID = )(SERVER = DEDICATED))
)

Chris