Home > IT Answers > Oracle > Installing Oracle 10g on an external USB drive
GunnyT
0 pts.
 Installing Oracle 10g on an external USB drive
Oracle
I have asked this question before but got no reply. I hope I have better luck this time. I have an external USB hard drive which I can plug into either of my two PC's. I would like to install Oracle 10g on the external USB hard drive and be able to access/use it from either PC. How do I go about it? What are the things I need to do on the external USB hard drive and on each of my two PC's? I would like a list of the steps I must take, e.g.: 1) Install on one PC with home directory on USB drive 2) Install on other PC to same/different home directory 3) Modify Parameter-A to this value 4) Modify Parameter-B to another value 5) Add/delete such and such file/folder 6) etc. The advantages of this arrangement over installing separately on each PC would be: 1) Less overall disk space requirement 2) No regular/frequent synchronization required 3) Less backup space and time 4) Less maintenance (defragging and scanning) 5) I can take the USB drive on the road along with my laptop PC. TIA Gunny

Software/Hardware used:
ASKED: October 10, 2005  7:15 AM
UPDATED: October 11, 2005  10:46 PM
RELATED QUESTIONS
Answer Wiki:
I onced moved Oracle from one server to another by using the installation program to basically set up the Windows registry and anything that ends up on the c:windows drive during installation. Then I shutdown and deleted all Oracle directories. Next I copied the entire drive that contained the entire Oracle setup to the new server. I would imagine this would work using the USB drive. The USB drive must contain everything relating to Oracle. I did this on an Oracle 9i version; so I don't know if it would work with 10g
Last Wiki Answer Submitted:  October 10, 2005  9:36 am  by  Randym   1,740 pts.
All Answer Wiki Contributors:  Randym   1,740 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

That seems to make sense.

I’m thinking that I could do idendical installations from each of my PC’s to the USB drive. The second installation would overwrite everything on the USB drive from the first installation but should end up being identical to what was overwritten.

Both my PC’s have the same Computer Name, so I am thinking I could enter identical info during each installation.

My main concern is whether Oracle 10g generates any internal id or other control numbers/info, etc. during an installation which might be different.

My second concern is whether any subsequent activity (creating a db, writing queries or procedures) in the Database from one PC will be “visible” and “usable” from the other PC.

Gunny

GunnyT
 0 pts.
 

I would think since Oracle is entirely on your USB drive, creating databases etc. would be visible on any PC the USB drive is hooked up to. Again, my thoughts are based on 9i or earlier. I can’t say for sure about 10g. Once installed (services and registry set up on the operating system), Oracle is, for the most part, independent of the Windows operating system. The Oracle service then knows where to look for the control files, system db files and user db files through it’s own system.

Randym
 1,740 pts.
 

Thanks. I suppose the only way to really find out is to actually try it.

Gunny

GunnyT
 0 pts.