Installing Oracle 10g on an external USB drive

pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • GunnyT
    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
    0 pointsBadges:
    report
  • Randym
    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.
    1,740 pointsBadges:
    report
  • GunnyT
    Thanks. I suppose the only way to really find out is to actually try it. Gunny
    0 pointsBadges:
    report
  • GunnyT
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/installing-oracle-10g-on-an-external-usb-drive/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following