Ask the Expert

Access Oracle server on different machine without client

I have installed Oracle server on Linux and want to access Oracle (through Oracle prompt) on a different machine on a network without installing client. How could I do this?

    Requires Free Membership to View

There are only three ways I know of to access an Oracle database without installing Oracle client on the workstation. One, access the database through a Java program using JDBC drivers. The JDBC driver is one .jar file which needs to be on your workstation. Two, use generic ODBC drivers. This option normally has many problems so I really do not recommend it. Three, install iSQL*Plus on your database server, which is a Web-based version of SQL*Plus. Your client can point thier Web browser to iSQL*Plus and access the database.

This was first published in August 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: