I tried to install Oracle 9i Release 2 (18.104.22.168.0) on a Windows 2000 server.
- When I select available products, the second choice seems more appropriate. It seems that management server and OID are a must, correct?
- For installation type, should I choose Oracle Management Server or custom?
- If I select custom, should I check Oracle workflow, HTTP server, and Ultra search media?
I attempted to apply a patch and got the flow error, "There are no patches that need to be applied from the patchset Oracle 9iR2 patch set 22.214.171.124.0."
When I create the database, should I choose the default character set? For the database connection option, should I choose share server mode since the database nature is for OLTP?
Many thanks for your help!
You don't need OID or a management server in order to run a database. You should choose the first option (which is selected by default) to install the database.
The reason you got an error when installing the patchset is because you didn't install the database (see my previous comment).
The default character set is up to you, but if you are unsure, it is safest to use Unicode (UTF) since it is a superset of all character sets and can store any language that Oracle supports. If your database server has enough memory to support dedicated server connections, I'd use them. If not, shared server is my second choice.