Managing Serviceguard Extension for SAP Version B.05.10, December 2012

[x] Use standard port number 1521
End of Installation
Setup Step: MDM222
Configure tnsnames.ora and listener.ora.
Change into directory /oracle/MO7/102_64/network/admin/ and edit tnsnames.ora
and listener.ora. Replace the HOST=clunode1 with the virtual address or virtual hostname
for the database 172.16.11.97 or mdbreloc.
clunode1:
su - oramo7
cd /oracle/MO7/102_64/network/admin/
cp tnsnames.ora tnsnames.ora.ORG
cp listener.ora listener.ORG
vi /oracle/MO7/102_64/network/admin/tnsnames.ora
— — — —
MO7 =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 172.16.11.97)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MO7)
)
)
vi /oracle/MO7/102_64/network/admin/listener.ora
— — — —
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.11.97)(PORT = 1521))
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = MO7)
(ORACLE_HOME = /oracle/MO7/102_64)
)
)
Start the Oracle listener. Test the listener configuration and connect to the MDM database via the
newly configured virtual IP address 172.16.11.97 using the following commands for the oramo7
user (Note: The Oracle client interface will be configured and tested in the next setup step)
NOTE: Replace "passwd" with the password set during the installation.
su – oramo7
lsnrctl start
sqlplus system/passwd@MO7
SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 28 12:07:56 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
174 SAP Master Data Management (MDM)