Managing Serviceguard Extension for SAP Version B.05.10, September 2010

)
(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
sqlplus system/passwd@MDM
SQL*Plus: Release 9.2.0.8.0 - Production on Fri Feb 16 04:30:22 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production With the Partitioning, OLAP and Oracle Data
Mining options JServer Release 9.2.0.8.0 - Production SQL>
Repeat the connect test for user mdmuser
su – mdmuser
sqlplus system/passwd@MDM
SQL*Plus: Release 9.2.0.8.0 - Production on Fri Feb 16 04:30:22 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production With the Partitioning, OLAP and
Oracle Data Mining options JServer Release 9.2.0.8.0 – Production SQL>
Setup Step: MDM226
Install the MDM IMPORT SERVER 5.5
146 SAP Master Data Management (MDM)