User's Guide

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.11.97)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MDM)
)
)
/oracle/MDM/920_64/network/admin/listener.ora
— — — —
# LISTENER.ORA Network Configuration File:
# /oracle/MDM/920_64/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.11.97)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = MDM)
(ORACLE_HOME = /oracle/MDM/920_64)
(SID_NAME = MDM)
)
)
Setup Step: MDM224
Configure /etc/tnsnames.ora , /etc/listener.ora and /etc/sqlnet.ora
Copy the above three files in to the /etc/directory so the configuration information is also globally
available. Copy the modified files to the second cluster node.
cd /oracle/MDM/920_64/network/admin/
cp tnsnames.ora /etc/tnsnames.ora
cp listener.ora /etc/listener.ora
cp sqlnet.ora /etc/sqlnet.ora
scp -p /etc/listener.ora clunode2 /etc/listener.ora
scp -p /etc/sqlnet.ora clunode2 /etc/sqlnet.ora
scp -p /etc/tnsnames.ora clunode2 /etc/tnsnames.ora
Start the listener and connect to the MDM database via the newly configured virtual IP address 172.16.11.97
with the following commands:
NOTE: Replace "passwd" with the password set during the installation.
su – oramdm
lsnrctl start
128 SAP Master Data Management (MDM)