Using PL/SQL Developer without local Oracle installation

[piclez]

Hello,

I'm starting to use Oracle and also new to PL/SQL Developer.
Is it possible to use the Developer to connect to a remote Oracle 8 Database without have installed any Oracle client in my local machine (just the Developer)?

Thanks.

Peter.

 

[oraclelover]

I think PL/SQL Developer only officaly supports having a client installed. ODBC may be an option but even that may require the client to be installed, not sure on that as I don't use ODBC.

Maybe look at the new 10g thin client or easy client not sure what they call it. It's suppose to be a much thinner install(less disk space.

Or run a remote access program like pcanywhere on or vnc on the machine that's running Oracle and install developer on there and run developer via vnc or pcanywhere. This of course assumes you are running Oracle on a windows machine.

What is your reason for not wanting a client installed?

Not sure why you wouldn't want a client installed. The only way to really get at any database is with some kind of client peice. Sometimes this may only be a one file in some cases it may be hundreds depending on the database and the platform.

 

[Marco Kalter]

The Oracle Client must be available. It doesn't have to be installed on the local machine though. Oracle Net, or the Oracle10g Instant Client, can be installed on a file server. All you need is a PATH or ORACLE_HOME environment variable.

 

[katlun]

Marco are you saying that I could use the same method when I connect to Oracle10g trough the browser and with PL/SQLDveloper?

e.g username/password@//serverort

Regards
Katlun

 

[Marco Kalter]

I wasn't saying that, but if Oracle Net is configured correctly this is indeed possible.