Install Oracle 7 on W2k Prof
Ping Kam
We need to install Oracle 7.3.4 on W2K prof. I read from Eric Hill's
message that it is possible with manual install. I am interested to know
how to do it. Can someone or Eric help?
I have installed Oracle before using the installer but I have never install
it manually. And I am not a DBA so I hope it is not overly complicated.
Thanks,
Ping Kam
Eric Hill
> We need to install Oracle 7.3.4 on W2K prof. I read from Eric Hill's
> message that it is possible with manual install. I am interested to know
> how to do it. Can someone or Eric help?
Do a custom install. Install the following:
Oracle TCP/IP Protocol
Oracle SQL*Net Client and Server
Oracle 7 Workgroup Server
If you'd like, install the Oracle Administrator Tools.
You'll get an error during the install saying it can't do something - just
ignore it. Also, don't let the installer create a default database.
Once that's all done, you'll need to do a manual database install. Use the
instance manager to create an Oracle instance. Give it most of the
defaults, and note the location of the initORCL.ora file. It will complain
that it can't start the database. That's because the instance manager is
stupid and creates an init.ora file instead of an initORCL.ora file. Duh.
Use LSNRCTL to START the default listener. Make sure the TNSNAMES.ORA,
LISTENER.ORA, and SQLNET.ORA files are set up properly.
Use TNSPING to make sure the listener is started.
Start the Oracle service installed by the instance manager.
Use SVRMGRL to connect to the idle instance.
Now you can go about using CREATE DATABASE to build the actual database.
I can have an Oracle 7 instance up in about 3 or 4 hours. Let me know if
you'd like me to WebEx your box.
Eric
Ping Kam
Thanks for your help. I will give it a try and hopefully everything works
out. I will contact you via private email if I need your DBA support.
One more question, do you know if Oracle 7 supports NAS? I asked our DBA
and he said Oracle 8 and above will work but he didn't know about Oracle 7.
Thanks,
Ping Kam
"Eric Hill" <er...@ijack.net> wrote in message
news:40cfb876$1...@newsgroups.borland.com...
Eric Hill
> and he said Oracle 8 and above will work but he didn't know about Oracle 7.
Depends on the type of NAS. I think you can use UNC paths in file statements, but I would strongly
reccomend iSCSI for NAS.
Eric
Ping Kam
model our IT department selected is made up of IDE drives.
And I don't know anythng about iSCSI. I do a search and all I found is that
it will require some add on device or it will consume 100% of the CPU
resource. I bet mapped drives will not work so I will stick with UNC for
now.
Thanks,
Ping Kam
Ping Kam
One more question, will it be a problem if the server already have Oracle 9i
installed (everything is default)? Do I have to uninstall 9i and cleanup
before I install Oracle 7?
Thanks,
Ping Kam
Eric Hill
> model our IT department selected is made up of IDE drives.
If it's made from IDE drives, then it's probably a UNC-accessible device only.
> And I don't know anythng about iSCSI. I do a search and all I found is that
> it will require some add on device or it will consume 100% of the CPU
> resource. I bet mapped drives will not work so I will stick with UNC for
> now.
iSCSI rocks man. You can even get iSCSI cards (like from Adaptec) that plug into your ethernet SAN
network, configure an IP, and they show up like a regular SCSI hard drive just pointing at a LUN on
the SAN. We've got one here at the office and it kicks ass. I can just allocate some more space to
the LUN and the drive magically gets bigger in the OS. Schweeeeeeet. <G> The Microsoft iSCSI disk
driver eats less than 5% of the CPU on a busy Windows file server. I'm sure that crappy iSCSI
drivers are worse, but if your system is that hammered, you just buy the card and be done with it.
Eric
Ping Kam
> > One more question, will it be a problem if the server already have
Oracle 9i
> > installed (everything is default)? Do I have to uninstall 9i and
cleanup
> > before I install Oracle 7?
>
Then you don't have to
> worry about conflicting Oracle homes (7 doesn't like 9) or paths (that
require a manual change).
>
Removing the Oracle Server and instance is not a problem, but I haven't had
any luck removing the Oracle installer. Do I need to remove the installer
for Oracle 9, and if so how?
Thanks,
Ping Kam
Eric Hill
had
> any luck removing the Oracle installer. Do I need to remove the installer
> for Oracle 9, and if so how?
A) Remove C:\Program Files\Oracle...
B) Remove C:\Oracle\...
C) Remove Oracle from the system path
D) Remove the HKLM\Software\Oracle key
Done.
Eric
Eric Hill
can
> the ISCSI cards support? Does it raid?
Your SAN makes a "drive" available as an iSCSI target. This can be a single
spindle all the way up to a full RAID 6 array. The point is, it shows up to
the OS as a single drive. Typically, you let the SAN take care of the RAID.
The SAN can do other things like moving the volume to a different drive set,
mirroring it to a backup drive set, or backing it up as a single file.
That's the beauty of a SAN. You buy 5TB of storage, and allocate chunks of
it to servers.
Eric
Ping Kam
I followed your instruction and remove the Oralce Installer. Then I got an
error from the installer complaining about the oracle home. I go to the
registry and remove all the key related to Oracle home. Now I got another
error:
'Unable to delete NT Service for the SQL *Net V2 Listener.'
To install Oracle is not easy. But to cleanly remove Oracle is a dream.
:-( Any suggestion.
Ping Kam
"Eric Hill" <er...@ijack.net> wrote in message
news:40d1054e$1...@newsgroups.borland.com...
Eric Hill
> :-( Any suggestion.
Send me a private email to eric at ijack.net.
