Client to database connection

870731

This should be easy. Machine 1 (Windows 7) is running the database. Machine 2 (also Windows 7) is ONLY running SQL Developer. Where do I put the tnsnames.ora file and what else may I be forgetting on the client? Can't connect - obviously I"m missing some of the network stuff but I'm not sure what and do not want a full Oracle install on the little bitty Machine 2.

TPD-Opitz

867728 wrote:
This should be easy. Machine 1 (Windows 7) is running the database. Machine 2 (also Windows 7) is ONLY running SQL Developer. Where do I put the tnsnames.ora file and what else may I be forgetting on the client? Can't connect - obviously I"m missing some of the network stuff but I'm not sure what and do not want a full Oracle install on the little bitty Machine 2.

If you want to use the <tt>tnsnames.ora</tt> you need an oracle client on Machine 2 to support the SQLdeveloper.

bye
TPD

morgalr

On the server, you want to do your install and be sure it is running properly, connect using SQL-Plus and make sure it's working--which includes your listener is working properly. You can check the status of your listener using Enterprise Manager.

One you client box, you need to install the Oracle Client tools. Once that is done you'll use Net Manager on the client box to setup access to your Oracle instance on your server. Once you have defined your service on your client box, then use it to connect to the server instance with anything that uses a JDBC client on that client box.