Ask the Expert

Questions about installing Oracle 9i on Windows 2000 server

I tried to install Oracle 9i Release 2 (9.2.0.1.0) on a Windows 2000 server.

  1. When I select available products, the second choice seems more appropriate. It seems that management server and OID are a must, correct?
  2. For installation type, should I choose Oracle Management Server or custom?
  3. 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 9.2.0.5.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!


    Requires Free Membership to View

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.


This was first published in October 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

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
Sort by: OldestNewest

Forgot Password?

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

Your password has been sent to: