question

Ian Ringrose avatar image
Ian Ringrose asked

How do I painlessly install oracle on a development machine?

I have never found it hard to install SqlServer as a developer, however it seems whenever I try to install oracle someone goes wrong

What is the best way for a developer to get a test oracle database setup on their windows machine?

(Note, I am asking about development database not production databases so easy to setup is more important then speed of operation)

developerwindowsinstall
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kastaka avatar image Kastaka commented ·
Could you give some examples of the problems you've been having? I've run into a lot of trouble installing on Linux, but on Windows I generally find that just accepting every default on every setup wizard gets me a database which is functional enough to mess around with...
0 Likes 0 ·
Ian Ringrose avatar image Ian Ringrose commented ·
@Kastaks, I have had oracle not like our network using a DCHP server. Also every web page I looked at give a different set of files I need to edit to allow an application to connect to the database, even giving totally different ways of naming databases.
0 Likes 0 ·
Kastaka avatar image Kastaka commented ·
That's because there are a lot of different ways to connect to / name an Oracle database - for a test box you can probably get away with using 'basic' connections, which just use the hostname, port and SID - the first is obvious and the others are specified in the database creation wizard - and require no editing of files at all.
0 Likes 0 ·
KillerDBA avatar image KillerDBA commented ·
This is a great question! I'm looking for ideas on this, too.
0 Likes 0 ·
Cee avatar image
Cee answered

http://ivan.kartik.sk/oracle/install_ora11gR1_elinux.html is a reasonably comprehensive guide to getting it working on EL/Centos-type operating systems with all the secondary startup and shutdown scripts that are needed.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Christian13467 avatar image
Christian13467 answered

I suggest an Oracle XE (= Oracle Express) database. This edition is limited but works with most features like the big editions.

Following is a step by step guide through oracle xe installation:
http://theopensourcery.com/orainstall.htm

After installing the connect string to the running xe instance should by username/password@localhost/xe. An oracle xe database is configured using a connection method named easy connect.

2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

thecoop avatar image thecoop commented ·
In the features it does support, is XE compatible with the full database?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.