The Listener is required to be configured in order to enable connectivity for the OEM repository database using SQL*Net. The Network Configuration Assistant (Netca) utility is used to do the network-related configuration for Oracle databases.
Before you start, ensure that the server is connected to the network, and an SSH or a telnet client is available. Also, make sure you have access to the Unix server.
Invoke the netca utility in order to configure the listener as an
oracle
user.$ ./netca
Select the Listener configuration checkbox, and then click on Next.
Select Add, and then click on Next.
Use the default Listener name as
LISTENER,
and then click on Next.Use the default TCP protocol, and then click on Next.
Select the Use the standard port number of 1521 option, and then click on Next.
Select No, and then click on Next.
Click on Next to complete the listener's configuration.
Create the
tnsnames.ora
file manually, or usenetca
to create a service name.The following entry is added to the
$ORACLE_HOME/network/admin/tnsnames.ora
file in order to create a service name. Host name to be specified is where the OEM repository database resides.oem12c = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SVMUSER.world) (PROTOCOL = TCP) (Host = servername.domain_name.com) (Port = 1521) ) ) (CONNECT_DATA = (SID = oem12c) (GLOBAL_NAME = oem12c) ) )
Check whether the listener has been created successfully and has been registered with the listener.
$ lsnrctl status
Check whether the database is reachable using the Net service name. The following command's output shows that the database is reachable.
[$ tnsping oem12c