Install oracle in Windows

Document directory

• Feedback

 

I. Preparation steps

Obtain the Oracle 10g installer or download the CD image from the Oracle technical network (OTN. During the evaluation phase, you can download and use full-featured oracle without technical restrictions for free, but you need to purchase legal authorization for formal commercial applications. : Http://www.oracle.com/technology/software/products/database/oracle10g/index.html

You need about 1.2 GB of disk space for download and decompression, and more than 2 GB of disk space for installation.

II. Oracle 10g installation procedure

Run the decompressed Oracle 10g Installer

SelectAdvanced Installation, And pressNext stepButton

SelectStandard Edition, And pressNext stepButton

Specify the target name and path of the main directory (usually do not need to change), and pressNext stepButton

If the overall result is not "pass", check your prerequisite configuration ),Next stepButton

SelectCreate a database, And pressNext stepButton

SelectGeneral Purpose, And pressNext stepButton

EnterGlobal Database Name:

• For an independent server that does not use directory services (such as Active Directory), the global database name does not need to contain a domain name suffix (the default value is orcl)
• For domain servers that use directory services (such as Active Directory), the global database name must contain the domain name suffix (such as orcl.compieretraining.org)

 

After setting the parameters according to the preceding requirementsNext stepButton

PressNext stepButton

Specify database storage options (use default options)File System), PressNext stepButton

Specifies the backup and recovery options (use the default options)Disable Automatic Backup), PressNext stepButton

To simplify the database password settings for evaluation, selectAll accounts use the same password, Enter the password of a user such as system (the password should not start with a number), and pressNext stepButton

This is the summary after the configuration is installed.InstallButton to start Installation

After several minutes of File Installation, the Database Configuration assistant is executed.

After the data library is created, pressOKButton

Configuration assistant is running

After the installation is complete, pressExitButton

Done! PressYesButton to exit the installer

3. Test whether the installation is successful

To test whether the data installation is successful, you canIn orderPerform the following two steps:

Test procedure1:Run the following command:Tnsping orcl

The preceding command assumes that the global database name is orcl. The following is an example of command execution:

 

C:/> tnsping orcl TNS Ping utility for 32-bit windows: Version 10.2.0.1.0-production on 10-11-2005 10:09:58 Copyright (c) 1997,200 5, Oracle. All rights reserved. Used parameter files: C:/Oracle/product/10.2.0/db_1/Network/admin/sqlnet. ora Alias resolved using tnsnames Adapter Attempting to contact (description = (address = (Protocol = TCP) (host = dbserver ) (Port = 1521) (CONNECT_DATA = (Server = dedicated) (SERVICE_NAME = orcl ))) OK(50 ms)

The resultOKImportant. If the above results are correct, the Listener Configuration is correct.

If this result is not displayed, do not proceed to the next step. Check:

• Use Oracle Net configuration assistant to check network configuration (netca command)
• Use Database Configuration assistant to check database configuration (dbca command)

Test Step 2:Run the following command:Sqlplus system/password @ orcl

The above command assumes that the password of the System user is password, and the global database name is orcl.

The following is an example after the command is executed (enter the red text manually ):

 

C:/> sqlplus system/password @ orcl SQL * Plus: Release 10.2.0.1.0-production on Thursday November 10 10:15:25 2005 Copyright (c) 1982,200 5, Oracle. All rights reserved. Connect: Oracle Database 10g Release 10.2.0.1.0-Production SQL> select 1 + 2 + 3 + 4 test result from dual; Test Results ---------- 10

If the above results are correct, it indicates that the data warehouse routine is installed and started normally.

Posted on Mr. Gan read (1135) Comments (10) EDIT add to favorites reference favorites to 365key category: Oracle

Feedback # Re
Good reply

# Re: Learn how to install Oracle-06-14 signal in windows. After reading your work, I feel a lot of benefits. I am engaged in data security and usually have a lot of databases, I would like to ask you if you have any good methods and suggestions in this regard. Thank you for your advice! Reply to xushuangliang@bjca.org.cn

# Re: Learn how to install Oracle 650-07-27 Liu gehao in windows. I installed this 10i version, which is about less than your big ISO version, what version are you talking about?

# Re: Step by step, install Oracle-07-27 on Windows;
I feel like 9i is less than a tool. I need to have another Web server.
I also asked a question: 10 Gb compared with SQL Server 2005, what are their respective advantages on the win2003 platform? What are the disadvantages? Reply

# Re: Step by Step learn how to install oracle on Windows thanks for your reply

# Re: Step by step. Install Oracle Jialin in windows ..

However, I have encountered problems in the installation process,

The result "OK" is crucial. If the above results are correct, the Listener Configuration is correct.

If this result is not displayed, do not proceed to the next step. Check:

Use Oracle Net configuration assistant to check network configuration (netca command)
Use Database Configuration assistant to check database configuration (dbca command)

This is the case. If it fails, I will continue to describe these solutions :)

Reply

# Re: Step by step. Install Oracle-11-15 har in windows. I executed this command "select 1 + 2 + 3 + 4 test result from dual;", but the result is 2;
In addition, the results of all select statements are "2". Can you tell me what went wrong,
E-MAIL: huangairong7733@yahoo.com.cn

Reply

# Re: Step by Step learn how to install Oracle-11-20 JY in windows. Thank you. The more details, the better. Reply.

# Re: Step by Step learn how to install Oracle-12-01 Lynn in windows. Thank you very much:) Reply

# Re: Step by step, I learned how to install Oracle-shouying on Windows. Thanks for the tutorial! Reply