7.0

Application Discovery Manager Administration Guide
24 VMware, Inc.
10 Logintothedatabasebyrunningthefollowingcommand.
$ sqlplus system/nlayers
11 InSQLPlus,runthefollowingcommand:
SQL> @/opt/oracle/app/oracle/product/11.2.0/db_1/sqlplus/admin/pupbld.sql
12 Create the remotepasswordfile.
aLogintothe Oracleserverwithuserasoracle.
bRunthefollowingcommand:
$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=nlayers force=Y
To Configure the Oracle Listener
1LogintotheOracleserverwithuserasoracle.
2 Navigateto$ORACLE_HOME/network/admin
3 Createanewfile,tnsnames.ora,withthefollowingcontentandensurethat#DATABAS_SERVER_IP#is
replacedwiththeIPaddressofthedatabaseserver.
#
# Filename: tnsnames.ora
#
NLAYERS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = #DATABAS_SERVER_IP#)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = nlayers)
)
)
4Runthefollowingcommand:
$chmod 777 tnsnames.ora
5 Createanewfile,listener.ora,withthefollowingcontentandensurethat#DATABAS_SERVER_IP#is
replacedwiththeIPaddressofthedatabaseserver.
#
# Filename: listener.ora
#
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = #DATABAS_SERVER_IP# )(PORT = 1521))
)
)
)
6Runthefollowingcommand:
$chmod 777 listener.ora