Let us we discuss about networking in oracle 11g

why we need  network?

The network is used to establish connection between two servers here i made two set up on vmware

 i.e primary,standby

Network

-Upto Version5 it supported only host based computing(using  dump terminals) (Both  application and DB resides on the same server)

-From version6 it started supporting client/server computing (client & server are connected via LAN)

-From oracle8i  it supported browser based technology (java is supported at oracle kernel level).Java pool is added SGA

-From  version6 through  8i it supporting following protocol I)TCP/IP II)IPx/SPx  (Novels protocol) III)NetBUEI (Microsoft protocol)

-From oracle9i it only supports TCP/IP as it became industries standard protocol  

Server Side Configuration:

-At the time of oracle installation,we  need to choose oracle network protocol adapter for TCP/IP protocol -We need to define listener in $ORACLE_HOME/network/admin/listner.ora(ASCII file)

-While defining the listener are we  need to mention

I)listener name

II) List of SIDs

III)Protocol (TCP/IP) IV)Port number (1521 is default)

-listner always supports multiple instances but must user 'unique' port  numbers

Listener commands

lsnrctl start - start all listener defined in the listner.ora

lsnrctl stop - to stop all all listner defined in the listner.ora

lsnrctl status - to view the status  of listner to view more options

process that are running in listner

$lsnrctl <lsnrctl> help, start,stop ,reload status

Client  side configuration

-We need to defined tnsname.ora in #ORACLE_HOME/network/tnsname.ora

-While we defining tnsname

I)Aliasname

II)Host name of server or IP address

III)Port number same as mentioned in listener.ora

IV)SID of  server  

In primary

S-1: login your database and startup

net1    

S-2:   logon "root" user like below

net2  

or  use to view host details

cat /etc/hosts
IPAddress     Hostname    		 Alias
127.0.0.1    oracle11g

s-3: To view ip address

ifconfig
above these command ll give the details about our server machine IP address details . now i'm going to edit ip address so pass the command has given below   net4 
  
S-4: 
I 'm going to create new static ip before that we have to delete ip which has been already appeared on it 
=> Deactive => it 'll ask confirmation Press "YES" => Press "Delete" 
net7 net8 
S-5: Press "New " for creating new ip address => Forward 
net11   
Press "Forward"
net12   
Choose Static ip option
 net13   
Enter the ip details and Press "Forward"
 net16   
Press "Apply" 
  net17   
Press "Active"   
net18  
After Active our IP address
 net20   
S-5: restart the network  service
service network restart

net19      

S-6: go to tnsname.ora file and  edit that file where it's located on

cd /u01/app/oracle/11.2.0.3/db_1/network/admin

  net21  

(Note : Here firts one "TEST" is primary server db name ,second one is "CLONE" enter the both ip address in tnsname file ) as the same we have to enter on listener.ora file also  

net23  

S-7: Ping Current ip

ping 192.168.1.4

  net24    

In Standby side

S-8: now we go on "Standby" server side  do  the same steps from  s-1 into s-7 and i mentioned ip "192.168.1.5" also entered on tnsname.ora file   check the ping both ip addresses on each side

[oracle@goldengatesource~] ping 192.168.1.5 
PING 192.168.1.5 (192.168.1.5) 56(84) bytes of data.
64 bytes from 192.168.1.5: icmp_seq=1 ttl=64 time=0.201 ms
64 bytes from 192.168.1.5: icmp_seq=2 ttl=64 time=0.477 ms
64 bytes from 192.168.1.5: icmp_seq=3 ttl=64 time=0.427 ms
64 bytes from 192.168.1.5: icmp_seq=4 ttl=64 time=0.417 ms
64 bytes from 192.168.1.5: icmp_seq=5 ttl=64 time=0.424 ms
64 bytes from 192.168.1.5: icmp_seq=6 ttl=64 time=0.472 ms
64 bytes from 192.168.1.5: icmp_seq=7 ttl=64 time=0.364 ms

--- 192.168.1.5 ping statistics ---
7 packets transmitted, 7 received, 0% packet loss, time 8818ms
rtt min/avg/max/mdev = 0.201/0.397/0.477/0.089 ms


  Primary Server ip ping

[oracle@oracle11g~]ping 192.168.1.4

PING 192.168.1.4 (192.168.1.4) 56(84) bytes of data.
64 bytes from 192.168.1.4: icmp_seq=1 ttl=64 time=0.091 ms
64 bytes from 192.168.1.4: icmp_seq=2 ttl=64 time=0.060 ms
64 bytes from 192.168.1.4: icmp_seq=3 ttl=64 time=0.051 ms
64 bytes from 192.168.1.4: icmp_seq=4 ttl=64 time=0.092 ms
64 bytes from 192.168.1.4: icmp_seq=5 ttl=64 time=0.032 ms
64 bytes from 192.168.1.4: icmp_seq=6 ttl=64 time=0.058 ms

--- 192.168.1.4 ping statistics ---
6 packets transmitted, 6 received, 0% packet loss, time 7470ms
rtt min/avg/max/mdev = 0.032/0.064/0.092/0.021 ms

 (Note : here i did ip configuration on manually we can use those db tools for ip configuration "NETCA" and NETMGR")