4.Modify the following information for your remote servers that are running the management server:
•IP Address - The IP address or DNS name of a server. If you change the IP address, you must modify the listener.ora file on the remote server, as described in the following step.
•Port (optional) - The Oracle TNS listener port the remote server uses. If this box is left blank, the management server assumes the database on the remote server uses port 1521.
•Site Name - A name that includes the location of the site, for example, London1. Since data in the enterprise reports is grouped by the site name, it is recommended you provide a unique site name to differentiate the sites.
5.Click OK when done.
6.If you changed the IP address of the remote server, you must edit the listener.ora file on that remote server, as described in the following steps:
a. Log onto the remote site.
b. Stop the service for the management server running at the remote site.
c. Stop the listener service for Oracle (OracleOraHome92TNSListener) at the remote site. d. Stop OracleServiceAppIQ at the remote site.
e. Open the following file in a text editor on the computer at the remote site:
Microsoft Windows:
%ORA_HOME%\network\admin\listener.ora
UNIX systems:
$ORACLE_HOME/network/admin/listener.ora
f.Edit the IP address as shown in the following line:
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.1)(PORT = 1521))
g.Save the file and exit.
h.Start the listener service for Oracle (OracleOraHome92TNSListener).
i.Start AppStorManager.
Remote Sites Are Not Removed from the tnsnames.ora File
Each time you add a site for global reporting, its contact information is added to the tnsnames.ora file. When you delete a site, site names are not removed from the tnsnames.ora file. Names of deleted sites left in the tnsnames.ora file do not impact the user interface or the performance of the product. For example, assume you added the site remotesiteA for global reporting. It would appear in the tnsnames.ora file as the following:
remotesiteA =
(DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
)
(CONNECT_DATA = (SID = appiq)
)
)
214 Configuring the Management Server