Oracle 12c Network Configuration

Oracle Net is a software component that resides on the client and on the Oracle database server. It establishes and maintains the connection between the client application and the server, and exchanges messages between them using industry standard protocols.

The Oracle Net listener (the listener), is a process that listens for client connection requests. 

It receives incoming client connection requests and manages the traffic of these requests to the database server. The configuration file listener.ora stores the detail information about the listener. The file contains the protocol, port and host information. Following is the sample listener configuration.

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db.localdomain) (PORT=1521)))

Net service name is the connect descriptor that contains the protocol, hostname of the server,

port of the listener and the service that we are willing to connect. Following is the sample 

net service name.

DESCRIPTION=

   (ADDRESS=(PROTOCOL=tcp)(HOST=db.localdomain) PORT=1521))

   (CONNECT_DATA=

      (SERVICE_NAME=orcl))

Execute netca command from the $ORACLE_HOME/bin location.

Select Listener configuration and Click on Next to continue.

Select Add and Click on Next to continue.

Enter the name of the listener. It may be any name. It is recommended to create Listener with name LISTENER for the first one. Later on we can create multiple listeners with different names as LIST_BATCH, LIST_ACC for batch processing and account departments.

Select the required protocols. Click on Next to continue.

Select required port. 1521 is oracle's default port. We can use different ports in case of multiple listeners. Click on Next to continue.

Finally listener configuration is completed. Click on Next to continue.

Select Local Net Service Name configuration for creating Net service Name. Click on Next to continue.

Select Add and Click on Next.

Select net service Name. Service name is generally the global database name. Click on Next to continue.

Select protocol and Click on Next.

Select host name. Click on Next to continue.

Select No, do not test. Click on Next to continue.

Type net service name. Click on Next to continue.

Click on No and Click on Next.

Click on Next on the Net service name configuration Complete message window. Click on Next to continue.

Finally Click on Finish to end the Local Net service name configuration.

<< install oracle database 12c on linux

oracle 12c Create database with dbca >>