oracle client on linux & db on nt - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: oracle client on linux & db on nt

  1. #11
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Can you post the contents of tnsnames.ora here?

  2. #12
    Join Date
    Dec 2002
    Posts
    110

    oracle client on linux

    Sorry

    I have removed the entry from sqlnet.ora & now linux client connects to linux box db using the tnsnames entry .

    now my linux box sqlnet.ora has only 1 entry

    names.directory.path=(tnsnames,onames,hostname)

  3. #13
    Join Date
    Dec 2002
    Posts
    110
    tnsnames.ora content in linux box

    ============
    win nt db connect entry
    ============
    testdb=
    (description=
    (address_list=
    (address =(protocol=tcp)(host=200.200.200.60)(port=1521)
    )
    )
    (connect_data=
    (service_name=testdb)
    )
    )


    ============
    linux db connect entry
    ============
    oralin=
    (description=
    (address_list=
    (address =(protocol=tcp)(host=200.200.200.81)(port=1521)
    )
    )
    (connect_data=
    (service_name=oralin)
    )

  4. #14
    Join Date
    Dec 2002
    Posts
    110
    Hi

    It worked . I dont whether its the right thing to do.

    in linux tnsnames.ora
    I just appended the tnsnames entry for oracle nt db
    with the global_name of linux.


    like this
    testdb.us.oracle.com =
    description =(.............


    Thanks for all the help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width