14 Replies Latest reply: Feb 26, 2013 10:37 PM by 972355 RSS

    TCP vs IPC  for  DBLINK

    972355
      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
          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
            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
              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
                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
                  My question was answered Thanks sb

                  Very clear.
                  • 6. Re: TCP vs IPC  for  DBLINK
                    972355
                    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
                      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
                        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
                          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
                            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
                              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
                                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
                                  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
                                    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 ..