cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle with MCSG

 
SOLVED
Go to solution
Highlighted
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
Highlighted
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
Highlighted
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