Forum Stats

  • 3,874,171 Users
  • 2,266,675 Discussions


How to connect Oracle database installed in another machine in the same lan network

User_AEY85 Member Posts: 12 Green Ribbon

Hi experts,

Hope you all are doing well.

I am using Oracle 6i and 10g release 2.

Few clients are using my software and working well.

Few clients wants to add one more computer as a lan network and wish to use the software.

Please help me how to connect the database from another machine?

Will it work by simply giving connection string with IP address?

Do I need to also set listener in client machine? If Yes, can I use the same listener of database machine or do i want to make any changes after copying it to the client machine?

Please advise me.

Thank you.