6 Replies Latest reply: Mar 9, 2012 7:30 AM by EdStevens RSS

    Client Server Connection

    904735
      Hi Gurus,

      we installed Oracle 10gR2 Client Version and i want to connect from client to server.So could you pls suggest me what updates i have to do in Client network related files..

      Thanks in advance.
        • 1. Re: Client Server Connection
          Hans Forbrich
          Check whether you have netca installed. Use that tool.

          Beyond that, check out http://docs.oracle.com/cd/B28359_01/server.111/b28301/network001.htm
          • 2. Re: Client Server Connection
            INRi
            Update ur tnsname.ora file like this....

            connect string =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = sever computer name)(PORT = 1521))
            )
            (CONNECT_DATA =
            (SERVICE_NAME = SERVER DB SEVICE NAME)
            )
            )

            ORACLR_CONNECTION_DATA =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
            )
            (CONNECT_DATA =
            (SID = CLRExtProc)
            (PRESENTATION = RO)
            )
            )
            • 3. Re: Client Server Connection
              904735
              In Server Listerner file sould we give any entries???
              • 4. Re: Client Server Connection
                839439
                In Server Listerner file sould we give any entries???
                No ....

                Client machine only required the tnsnames.ora file . No need to do anything at server side.....


                --neeraj                                                                                                                                                                                                                                                                                                                                                                   
                • 5. Re: Client Server Connection
                  Paul M.
                  we installed Oracle 10gR2 Client Version and i want to connect from client to server.So could you pls suggest me what updates i have to do in Client network related files..
                  You may not need any configuration on the client. See Using the Easy Connect Naming Method
                  • 6. Re: Client Server Connection
                    EdStevens
                    Srini wrote:
                    Hi Gurus,

                    we installed Oracle 10gR2 Client Version and i want to connect from client to server.So could you pls suggest me what updates i have to do in Client network related files..

                    Thanks in advance.
                    http://edstevensdba.wordpress.com/presentations/