The development of this database software was lead in part by former president of Oracle, Charles Phillips. This document provides guidelines to install Oracle 10g database on Microsoft Windows environment.
If you use other operating system other than Microsoft Windows, the process is not too much different from that of Microsoft Windows, since Oracle uses Oracle Universal Installer to install its software. For more information about installing Oracle 10g under operating systems other than Microsoft Windows, please refer to this URL :. You can download Oracle 10g database from www.
You must registered and create an account before you can download the software. The example in this document uses Oracle Database 10g Release 2 If you run the CVU and your system fails system configuration checks, then review the the CVU report, and use the output to resolve failed configuration checks. Refer to the following list to assist you with responding to failed checks. Check for user equivalence for the oracle account by performing a remote login rlogin to each node in the cluster.
For example:. If you are prompted for a password, then you have not given the oracle account the same attributes on all nodes. Check permissions on each node to ensure that the oracle account can write to the new mount points. As the oracle user, use SSH to connect from each node to itself, and from each node to each other node.
For example, to check a two-node cluster with nodes named node1 and node If you are prompted for a password when logging in as the oracle user from one node to another in the cluster, then improper SSH configuration is a probable cause.
This section describes OUI features that you should understand before beginning phase two of the RAC installation process. Create a database : Provides you with the option to create a database using a preconfigured database template designed for particular system load demands, as described in the section "Database Configuration Type Descriptions". If you select the Automatic Storage Management option for storage, then an ASM instance is installed as part of the database installation.
The Oracle home is used for the ASM home when you install the database using this method. Install database software only : Installs Oracle software; you must complete database configuration later. If you are installing Oracle Database software, then Oracle recommends that you use one of the preconfigured database options, or select the Advanced option on the Select Configuration page, and configure a custom starter database.
If you want to configure your environment and create your database manually, then select Do not create a database on the Select Configuration page, and refer to the manual database creation procedures posted at the following Web site:. Click Help if you need assistance. For the first three configuration types, you can complete additional procedures that are described later in this chapter. Oracle recommends that you use DBCA to create your database.
The General Purpose, Transaction Processing, and Data Warehouse configuration types use preconfigured database templates. During database installation, OUI displays a progress indicator.
DBCA processing for these three configuration types creates a starter database, and configures the Oracle network services. If you select Advanced configuration, then you must enter specific information as described in the next section.
The first three templates are customizable versions of the preconfigured database types. The Custom Database type creates a database without using preconfigured options.
The primary phases of DBCA processing are the following:. Verify that you correctly configured the shared disks for each tablespace if you are using raw storage. You can use your Oracle9 i database language and territory definition files with Oracle Database 10 g Release 2 Provide information or run scripts as root when prompted by OUI. If you need assistance during installation, click Help.
When I searched for the phrase, the first hit I found in the official documentation implies that this option was removed over 20 years ago, in version 7. More likely this is a syntax error, and you need to post the relevant code. For future questions: you should always post the SQL you run, state the tool you use to run it and post the exact error message you get. Add a comment. Active Oldest Votes.
Anyway, thanks for the comments guys, it really helped me tons. Improve this answer. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.
0コメント