have installed Oracle E-Business Suite (EBS) on Server A, but I want the database to be on a separate machine, Server B.
What are the necessary configurations to make this work? Is it enough to configure tnsnames.ora on Server A and listener.ora on Server B? Or are there additional steps required?
I would appreciate any guidance on this setup. Thanks!
So far, I have configured tnsnames.ora on Server A (Oracle EBS) and listener.ora on Server B (Database). Additional Information:
The database listener on Server B is running. I can successfully tnsping the database from Server A. However, Oracle EBS is still unable to connect to the database.