Re: Oracle newbie!! - Please help!!

Robert,

I'm using the book: Oracle8i, A Beginner's Guide which has been most informative. I'm not sure that it has info on migrating databases, but it is shock full of info (from Oracle Press).

As for the question regarding 'HOME': you can do a few things: (a) install 8.1.5 in an entirely different home, leave 8.0.5 alone (b) uninstall 8.0.5, install 8.1.5 in the default home. Either of these approaches should get you to the point you need to be. If you have the hardware available, you might want to stop doing these 'attempts' on your SQL server machine - try 'em on a different machine so that you don't feel pressured if you screw something up.

Regards,
Brice Ruth

Robert Martin wrote:

> Please bear with me. I am a complete newbie that has been thrown into the position as a Oracle DBA (lucky me). Anyways, we have a
> SQL Server 7.0 database that we need to migrate over to Oracle 8i. We have Oracle 8i version 8.0.5 installed on the same machine as
> the SQL Server machine. I tried to download and install the Oracle® Migration Workbench for MS SQL Server 7.0 software in order to
> migrate the database. Well, I read most of the release notes and I have to have the 8.1.5 client installed on the machine that I
> want to install this software on. Do I have to upgrade my Oracle 8.0.5 install to the 8.1.5 install? I have tried to install the
> 8.1.5 Enterprise Edition software over the 8.0.5 install, but I can't because the release notes state I can't install over a HOME
> (whatever the hell a home is - I still don't really understand this concept yet fully) that already exists. So what do I do? Do I
> have to uninstall the 8.0.5 software? I am afraid to do this cause I totally screwed up our NT server when I did this before. Should
> I just forget the DEFAULT_HOME that exists and install into a new home and completely forget the original home I created with the
> 8.0.5 install (which looks like it will waste a lot of disk space if I do this). What do I do!?!?! Any information will be greatly
> appreciated. Also, is there content on the net or a good book that will help me as a newbie? I recently got the "Oracle 8i DBA
> Handbook" from the Oracle Press. Is this good enough?
>
> ALSO: Direct responses to my email address listed below will be greatly appreciated too.
>
> -------------------------------------------
> Robert Martin (rwmartin_at_sisconet.com)
> Design Engineer
> SISCO Inc
Received on Tue Mar 07 2000 - 00:00:00 CET