Hardware dummy trying to set up Unix workstation for Oracle at home for practice!


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Hardware dummy trying to set up Unix workstation for Oracle at home for practice!
# 1  
Old 12-02-2001
Hardware dummy trying to set up Unix workstation for Oracle at home for practice!

I have been planning to set up a Unix workstation at home to host an Oracle database just for database admin. practice. But I don't know enough about hardware to know whether this can be done on a regular desktop and the required hardware config. If anyone could kindly guide me in this mission I would be forever grateful. Thank you in advance. Smilie

Peace.
Tman.
# 2  
Old 12-02-2001
Hi tmanpakdee,
The short answer is yes, you can do it.
I won't go into to much detail because that would take all day but you can install Linux on a standard PC. I run mine on a P133 with 128 MB of RAM. Nothing fancy by todays standards. Oracle, as well as many other DBs, can be installed on Linux. Depending on what kind of environment you want you will want to have more memory and disk. Linux runs pretty well with few resources, Oracle on the other hand will need a significant amount of memory to run efficently. Even with a 128 MB RAM + Swap + several GB of disk, you can run Oracle at home with no problem.

TioTony

Last edited by TioTony; 12-02-2001 at 05:11 PM..
# 3  
Old 12-04-2001
Hi UncleTony.
Thank you for your advice. I guess I will go ahead with it then. Would you happen to know anything about partitioning to have say two operating systems on the same machine? I'm thinking about having more than one db system on it. Maybe Oracle and SQL Server. Or can i do both on Unix?

Respectfully,
Toneman Smilie
# 4  
Old 12-04-2001
Well, if you wanted to run SQLServer (I am assuming Microsoft SQLServer), you could dual-boot, but keep in mind you would not be able to run them at the same time, generally speaking. Normally, when you dual boot, you are working with one OS, or the other. There are certain solutions (I think VMWare could do something like this), but keeping costs, details, and simplicity in mind, it's probably not the best solution.

If you accepted beforehand that you could only work with one at a time, it could be a very viable solution... Also, you could run multiple Unix SQL databases on the same machine at once (MySql, Oracle, PostgreSQL, etc...) without having to reboot to switch operating systems, although you would take somewhat of a performance hit running so much at once... Yet another twist on the latter option would be to have the databases set up, just turn each one on as you use it, and off again when you're done.

Lots of choices!
# 5  
Old 12-07-2001
Or, if it is more important that you learn SQLServer and Oracle rather than SQLServer and Oracle on Unix, install Oracle for NT on your NT box and forget about unix.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash set dummy ?

Could somebody please provide me with verbatim description / purpose of the following ? set dummy $ac_prog; ac_word=$2 set dummy $ac_tool_prefix; ac_word=$2 could it be written set dummy $ac_prog; ac_word=$2 set dummy $ac_tool_prefix; ac_word=$2 (9 Replies)
Discussion started by: anne
9 Replies

2. UNIX for Dummies Questions & Answers

Unix set home directory

Hi I've just made a directory, what command do I use to now make it the base directory? Thanks!!!!!!!!!!!!!!! (1 Reply)
Discussion started by: beckywatson
1 Replies

3. UNIX for Dummies Questions & Answers

Newbie Wants Hardware For Practice?

I want a cheap dedicated machine to install a flavour of unix on and try to learn this OS. I know nothing about unix, just gone out and bought some books etc. Should I just get the cheapest old laptop off Ebay to install it on? What type of unix OS should I install?...a version of... (5 Replies)
Discussion started by: IBMPBC
5 Replies

4. Solaris

Sun Workstation Hardware - Is it broken?

Hi everyone! I have an odd question - If a sun workstation (Blade 2000) boots up into a login prompt, is there any chance that it could have hardware issues? Or once it gets that far is it 100% working. I cant play with it before buying, so was interested to see if anyone could shed some... (4 Replies)
Discussion started by: ajdiamond
4 Replies

5. UNIX for Dummies Questions & Answers

To practice Unix at home

Hi Everyone, Gud Afternoon. Myself Amol working on unix (vi editor ). I want to practice shell scripts and vi editor command at home. So can anyone guide me, if there is any standalone application or some software like vi editor which can be installed at my home PC and i can... (9 Replies)
Discussion started by: Amol_Dicholkar
9 Replies

6. Solaris

free software to test the hardware of a sun workstation specially the RAM how about f

hi can anybody give me a site that provide a free software for sun solaris workstation to test above title. i downloaded this RUMT-0.2 sofware in the net but it doesn't work after i try. thnks a lot for any help. (1 Reply)
Discussion started by: jao_madn
1 Replies

7. Shell Programming and Scripting

$HOME Not Getting Set for Oracle Scheduler Script at Runtime

We are researching the possibility of using Oracle 10g Scheduler on Solaris 10 to launch scripts at our site, and the script that I am testing does not get $HOME (and other environment variables) set correctly. Here is the Korn shell script (show_info.ksh): #!/usr/bin/ksh id env | sort Here... (4 Replies)
Discussion started by: shew01
4 Replies

8. UNIX for Dummies Questions & Answers

VMWare Workstation for home lab

I was wondering if anyone has used VMWare Workstation? I wanted to practice and learn Unix in a networking environment and have my own home lab. However room and money prevent me from buying several computers to do so. Any input would help thank you. (0 Replies)
Discussion started by: vedder191
0 Replies

9. UNIX for Advanced & Expert Users

How to set up dummy printer on UNIX

Hi, I work at IT department of a home furnishing company in Canada. Presently we are working on printer issue on UNIX system and we like to set up a dummy printer on the system. We are not much sure about the procedure to try it and it woul dbe great if we get some advice to go ahead. Thanks... (3 Replies)
Discussion started by: srabanti
3 Replies

10. UNIX for Advanced & Expert Users

Set up the own Unix ENvironment at home

Hello! All Unix Expert, I just graduated from college with Bachalor degree in Computer Information System, and decided to start my career in Unix System. I am trying to set up my own unix Environment at home so that I can get more hand on experience since the class offered by unix vendors are... (1 Reply)
Discussion started by: jung1975
1 Replies
Login or Register to Ask a Question