3.5.1 MxDB-Oracle-HiAv Installation and Administration Guide

Chapter 2: Operations 50

solution pack that the SQL*Net entries already exist. The following

example shows a portion of a listener.ora file for a Data Guard Standby

database with DB_UNIQUE_NAME and SERVICE_NAMES assignments

of SEATTLE. The HOST assignment of seattle.pdx.polyserve.com is a

Virtual Oracle Service VHOST.

SEATTLE =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST =

seattle.pdx.polyserve.com)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = PROD)

)

In this example, there would be no loss of functionality if the HOST

assignment were changed from the Virtual Oracle Service VHOST to the

hostname of the server itself. When setting up SQL*Net with

MxDB-Oracle-HiAv, you should have SQL*Net files that are fully

functional whether using the Virtual Oracle Service or the hostname of

the server. With that strategy in mind, setting up SQL*Net for

MxDB-Oracle-HiAv is simple.