How to Configure Oracle Network Environment

Oracle Network Environment is a method to configure the Server and Client machines. The client machine for any application that needs to connect the oracle database to send and receive data from the Oracle server. On the client, the machine needs to install only Oracle client software.

The Production server and client machine required a network service which is providing by Oracle Net. Oracle Net is responsible for establishing and maintaining the connection between the client application and the server, as well as exchanging messages between them.

Oracle Net service makes a connection for client or all middle tire applications to the oracle server. After a network connection established. The Oracle network work as a data courier for all the clients and server applications.

How to configure Oracle Network Environment?

To configure Oracle Network Environment just follow all below steps carefully.

Important key points

  1. Production machine and Client machine must be ping to each other by network.
  2. TNS must be configured on production.
  3. Database must be in open mode.
  4. Listener must be started on production machine.
  5. Oracle client software must be installed on client machine.
  6. TNS service must be configured on client machine also.

Action on Production

Login as a Root user and set IP address to your production machine and follow same steps for your client machine also.

#setup  

=> NETWORK CONFIGURATION  
=> EDIT DEVICES  
=> eth0 (eth0)

Then save and restart network service using following command.

#service network restart

OR

#/etc/init.d/network restart 

After completing above activity check ping is working for both machines.

In my case my both machine IP addresses like below.

Production machine IP:  192.168.1.10
Client machine IP:  192.168.1.20

Check ping using following command on both machines.

On production
 
#ping <client ip> 
#ping 192.168.1.20

On Client

#ping <server ip> 
#ping 192.168.1.10 

Now login with oracle user and start your Production machine Database using following command.

$sqlplus / as sysdba

SQL> startup

Start Listener on Production machine.

$lsnrctl start
$lsnrctl status

Action On Client Machine

Configure TNS service using NETCA utility or manually with the same name which you configured on Production.

If you did not configure TNS service on production then follow the same steps on production.

$netca

=> naming methods configuration 
=> next 
=> select your naming methods 
=> next 
=>  local net service name configuration 
=> Add 
=> service name [giving server database name suppose it's 'orcl' ] 
=>  next 
=> TCP 
=> host name [sever machine IP] 
=> next 
=>  if you want to check your connection then yes otherwise no 
=> next then FINISH. 

Check tnsping is working or not.

$tnsping <tns service name> 
$tnsping orcl

After completing all steps, Now login in your Database using using tns service name on client machine using following command.

$sqlplus sys/password@orcl as sysdba

I hope you will get access.

Read – You also read to like how to check hostname using SQL query in oracle?

Connect with me on:

Instagram: https://www.instagram.com/shripaldba
Linkedin: 
https://www.linkedin.com/in/shripal-singh
Twitter: 
https://twitter.com/ocptechnology
Facebook: 
https://www.facebook.com/ocptechnology
YouTube:
https://www.youtube.com/ocptechnology

1 thought on “How to Configure Oracle Network Environment”

Leave a Comment

%d bloggers like this:
Enable Notifications    OK No thanks