HP Serviceguard Extension for SAP (SGeSAP) Connectdata = Server = Dedicated Servicename = MDM

(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)