This discussion is archived
14 Replies Latest reply: Feb 26, 2013 8:37 PM by 972355 RSS

TCP vs IPC  for  DBLINK

972355 Newbie
Currently Being Moderated
Good Morning to all ;

MAY i know some details about TCP vs IPC connectivity (for DB LINK).

My Questions are ,

When we use TCP connectivity ? and
when we use ICP connectivity ?

IS this right ?

IPC connection does require listener ..

From this thread : https://forums.oracle.com/forums/thread.jspa?threadID=986797  +(final  reply from i am al)+
  • 1. Re: TCP vs IPC  for  DBLINK
    sb92075 Guru
    Currently Being Moderated
    969352 wrote:
    Good Morning to all ;

    MAY i know some details about TCP vs IPC connectivity (for DB LINK).

    My Questions are ,

    When we use TCP connectivity ? and
    when we use ICP connectivity ?

    IS this right ?

    IPC connection does require listener ..

    From this thread : https://forums.oracle.com/forums/thread.jspa?threadID=986797  +(final  reply from i am al)+
    you can & do connect to a local DB without any listener only by using IPC.
    listener requires only TCP to be used.
  • 2. Re: TCP vs IPC  for  DBLINK
    TSharma-Oracle Guru
    Currently Being Moderated
    This link might help you

    http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6136118136754
  • 3. Re: TCP vs IPC  for  DBLINK
    972355 Newbie
    Currently Being Moderated
    OK sb Thanks. I'm clear.

    sorry for again asking similar question. I saw your reply (IPC not required  for listener).
    but i am doing DB link for (materialized view).


    When i am connecting to any  database using putty (LAN connection only).

    Can i use TCP ?

    I have OWN virtual machine ( two databases running)

    Here , Can i use TCP ?

    (For all ) ..


    Thanks ..
  • 4. Re: TCP vs IPC  for  DBLINK
    sb92075 Guru
    Currently Being Moderated
    969352 wrote:
    OK sb Thanks. I'm clear.

    sorry for again asking similar question. I saw your reply (IPC not required  for listener).
    but i am doing DB link for (materialized view).


    When i am connecting to any  database using putty (LAN connection only).

    Can i use TCP ?
    sqlplus scott/tiger@orcl
    above uses TCP; while below does not use TCP, but IPC
    sqlplus scott/tiger

    >
    I have OWN virtual machine ( two databases running)

    Here , Can i use TCP ?
    TCP is REQUIRED when two different hosts are involved.
  • 5. Re: TCP vs IPC  for  DBLINK
    972355 Newbie
    Currently Being Moderated
    My question was answered Thanks sb

    Very clear.
  • 6. Re: TCP vs IPC  for  DBLINK
    972355 Newbie
    Currently Being Moderated
    Again  Small confusion  with Listener

    LISTENER  does ..

    Every time a client requests a network session , a listener receives the actual request.
    If the client's information matches the listener's information, the listener grants a connection to the server.

    My confusion is :

    For Remote Database (TCP) : i issue following command
    *$ sqlplus scott/tiger@orcl*

    "Listener.ora" containing SID_NAME , ORACLE_HOME , GLOBAL_DBNAME.
    Here , How username/password verified by whom ?

    Thanks in advance ..

    Anyhow ,   listener won't check username/password@<net_service_name> . then who will do that ?
  • 7. Re: TCP vs IPC  for  DBLINK
    sb92075 Guru
    Currently Being Moderated
    969352 wrote:

    Anyhow ,   listener won't check username/password@<net_service_name> . then who will do that ?
    The instance/DB does the username/password validation.
    SQL> connect user1/user2
    ERROR:
    ORA-01017: invalid username/password; logon denied
    
    
    Warning: You are no longer connected to ORACLE.
    ORA-01017 is an Application failure & NOT a database error
  • 8. Re: TCP vs IPC  for  DBLINK
    972355 Newbie
    Currently Being Moderated
    Thanks a lot and fine sb.


    The instance/DB does the username/password validation.

    - Oh ! I don't know really this. May i get any related threads to understand ?

    Oracle  link  n't  giving   any information  about   username/password verification

    http://www.oracle.com/pls/db102/homepage .

    Can i get  any related articles  (instance/DB* does the username/password validation.) ?*

    Thanks sb ..
  • 9. Re: TCP vs IPC  for  DBLINK
    sb92075 Guru
    Currently Being Moderated
    969352 wrote:
    Thanks a lot and fine sb.


    The instance/DB does the username/password validation.

    - Oh ! I don't know really this. May i get any related threads to understand ?

    Oracle  link  n't  giving   any information  about   username/password verification

    http://www.oracle.com/pls/db102/homepage .

    Can i get  any related articles  (instance/DB* does the username/password validation.) ?*

    Thanks sb ..
    are you unwilling or incapable to use online SEARCH &
    then to Read The Fine Manual?

    http://docs.oracle.com/cd/E11882_01/server.112/e25789/process.htm#sthref1834

    "A session is a logical entity in the database instance memory that represents the state of a current user login to a database. For example, when a user is authenticated by the database with a password, a session is established for this user. A session lasts from the time the user is authenticated by the database until the time the user disconnects or exits the database application."
  • 10. Re: TCP vs IPC  for  DBLINK
    972355 Newbie
    Currently Being Moderated
    Are you unwilling or incapable to use online SEARCH ?

    No. Once again Thanks for kind help. I will read the link.
  • 11. Re: TCP vs IPC  for  DBLINK
    sb92075 Guru
    Currently Being Moderated
    969352 wrote:
    Are you unwilling or incapable to use online SEARCH ?

    No. Once again Thanks for kind help. I will read the link.
    For example, when a user is authenticated by the database with a password, a session is established for this user. A session lasts from the time the user is authenticated by the database until the time the user disconnects or exits the database application."
  • 12. Re: TCP vs IPC  for  DBLINK
    972355 Newbie
    Currently Being Moderated
    IN TNSNAMES.ORA

    If TNS alias_name , net service name is different which one is used to connect DB ?

    11g doc says : scott/tiger@net_service_name

    10g doc says : scott/tiger@tns_alias_name

    _ Please help me ..


    I got " One of the most common connect identifiers is a net service name"

    - when we use tns_alias_name to connect remote db ?
  • 13. Re: TCP vs IPC  for  DBLINK
    sb92075 Guru
    Currently Being Moderated
    969352 wrote:
    IN TNSNAMES.ORA

    If TNS alias_name , net service name is different which one is used to connect DB ?

    11g doc says : scott/tiger@net_service_name

    10g doc says : scott/tiger@tns_alias_name

    _ Please help me ..


    I got " One of the most common connect identifiers is a net service name"

    - when we use tns_alias_name to connect remote db ?
    have service_name different from tns_alias_name & use the one that works.
    or use EZCONNECT instead to avoid accessing the tnsnames.ora file completely.
  • 14. Re: TCP vs IPC  for  DBLINK
    972355 Newbie
    Currently Being Moderated
    Any how i know local naming method('tnsnames.ora') only.

    " use the one that works." -

    Hmm .. I will check it and i will come back tomorrow with TNSNAMES.ORA setup

    Thanks sb ..

Incoming Links

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points