I am planning on installing oracle for personal use. I am doing this to
learn PL/SQL. I would like to install oracle on a server and access via
PL/SQL and ADO on a client. I downloaded the free version of oracle from
their web site. First, I want to access oracle from a remote client
should I install the enterprise edition or will the standard or personal
edition work? Next, what do I need to do on the client so PL/SQL or ADO
will know where to find oracle?

Are there any docs on oracle's site that address these questions?

thanks for the help

john

On Oct 22, 2:44*pm, coltrane <tendenga... (AT) yahoo (DOT) com> wrote:
Since all editions of Oracle are free for evaluation purposes, and if
you have sufficient disk space, I would suggest installing the
Enterprise edition so you can get used to features such as
partitioning, block-level media recovery, multi-channel RMAN backups,
tablespace point-in-time recovery, parallelism, streams, etc.

As long as you're using this just for single-user testing/learrning
purposes the license is free for the database; the client license has
always been free. I would ensure that only you can get to your
database server through your network; the following document can help
you:

http://www.crswann.com/2-NetSecurity...n_10-steps.pdf


David Fitzjarrell


David Fitzjarrell

John:

# Are there any docs on oracle's site that address these questions?

Ton of docs ... starting with the concepts manual is probably the way
to go.

If you are looking for articles with complete solutions of how to get
something installed Jeffrey Hunter at idevelopment ( http://www.idevelopment.info/
) probably has the most well organized full articles. Check out the
stuff there from the Oracle link.

If you are running on windows you may want to install some
virtualization software and get used to installing/running oracle
under unix/linux.

On 10/22/2010 8:31 PM, John Hurley wrote:
with a dual boot for linux. I would prefer to learn on windows and linux.
cheers

David, thanks