This discussion is archived
6 Replies Latest reply: Mar 9, 2012 5:30 AM by EdStevens RSS

Client Server Connection

904735 Newbie
Currently Being Moderated
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 Oracle ACE Director
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    In Server Listerner file sould we give any entries???
  • 4. Re: Client Server Connection
    839439 Pro
    Currently Being Moderated
    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. Oracle ACE
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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/

Legend

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