DBLINKS

   

                                              NETWORKING

SERVER SIDE à                                                     CLIENTSIDE à

LISTENER.ORA                                                      TNSNAMES.ORA

1. Listener name                                               1.Alias name 
2. Protocol                                                        2.Protocal
3. Port number                                                  3.Port number
4. SID names                                                 (Same as server Port)

                                                                         4. SID names

                                                                            (Same as server SID)

• In .bash_profile            TNS_ADMIN=$HOME

• LISTENER.ORA & TNSNAMES.ORA    LOCATION…….

                  $ORACLE_HOME/network/admin

• Port range    1024     to      65536

                    (Default port number is   1521)