Oracle® Database Installation Guide
10g Release 1 (10.1.0.2.0) for 64-Bit Windows
Part No. B13805-02
This chapter contains these topics:
Oracle recommends installing the latest patch set release after successful installation of Oracle Database.
You must register online before using OracleMetaLink. After logging in to OracleMetaLink, select Patches from the left-hand column.
To find and download patches:
Go to the OracleMetaLink Web site
Log in to OracleMetaLink.
Note:If you are not an OracleMetaLink registered user, then click Register for MetaLink! and follow the registration instructions.
Click Patches on the main OracleMetaLink page.
Select Simple Search.
Specify the following information, then click Go:
In the Search By field, choose Product or Family, then specify RDBMS Server.
In the Release field, specify the current release number.
In the Patch Type field, specify Patchset/Minipack
In the Platform or Language field, select your platform.
Find the latest patch set for Oracle Database using OracleMetaLink.
From the list of available patches, select a patch to download.
Patch sets for Oracle databases are identified as "
x PATCH SET FOR ORACLE DATABASE SERVER."
Review the README before proceeding with the download.
Each patch has a README file with installation requirements and instructions. Some patches install with Oracle Universal Installer; others require special procedures. Oracle recommends that you always read the README before proceeding.
Download and install the patch.
Oracle recommends running the
utlrp.sql script after creating, or upgrading a database. This script recompiles all PL/SQL modules that may be in an INVALID state, including packages, procedures, types, and so on. This step is optional, but recommended so that the cost of recompilation is incurred during the installation rather than in the future.
Note:There should be no other data definition language (DDL) statements running on the database while the script is running, and packages
C:\> sqlplus /nolog
Connect to the database with the
SQL> CONNECT SYS/PASSWORD@service_name AS SYSDBA
PASSWORD is the password you assigned to the
SYS account during the install process.
Start the database (if necessary):
You must configure many Oracle components and options before you can use them. Before using individual Oracle Database components or options, see the appropriate manual available on the Oracle Documentation Library CD-ROM, the DVD-ROM, and the Oracle Technology Network Web site.
This section contains these topics:
Note:You need only perform postinstallation tasks for components that you intend to use.
If you plan to use Oracle Java Virtual Machine (JVM) or Oracle interMedia, Oracle strongly recommends that you install the natively compiled Java libraries (NCOMPs) used by those components from the Oracle Database Companion CD. These libraries are required to improve the performance of the components on your platform.
See Also:"Installing Oracle Database Components from the Companion CD" section for more information about installing components from the Companion CD
localconfig reset [destination_Oracle_home]
destination_Oracle_home is required if you run this command from the Oracle home where the CSS service is currently configured.
Before using Oracle Counters for Windows Performance Monitor to view Oracle-specific counters, you must specify the
SYSTEM password using
Operfcfg.exe located in the
To set the system password, enter the following:
See Also:Oracle Database Platform Guide for Windows for additional information about Oracle Counters for Windows Performance Monitor
If you installed Oracle Label Security, you must configure it in a database before you use it. You can configure Oracle Label Security with or without Oracle Internet Directory integration. If you configure Oracle Label Security without Oracle Internet Directory integration, you cannot configure it to use Oracle Internet Directory at a later stage.
Note:To configure Oracle Label Security with Oracle Internet Directory integration, Oracle Internet Directory must be installed in your environment and the Oracle database must be registered in the directory.
See Also:Oracle Label Security Administrator's Guide for more information about Oracle Label Security enabled with Oracle Internet Directory
If you have a previous release of Oracle software installed on this system, you can copy information from the Oracle Net
listener.ora configuration files from the previous release to the corresponding files for the new release.
Note:The default location for the
Modifying the listener.ora File
If you are upgrading from a previous release of Oracle Database, Oracle recommends that you use the current release of Oracle Net listener instead of the listener from the previous release.
For any database instances earlier than release 8.0.3, add static service information to the
listener.ora file. Oracle Database releases later than release 8.0.3 do not require static service information.
Modifying the tnsnames.ora File
Unless you are using a central
tnsnames.ora file, copy Oracle Net service names and connect descriptors from the previous release
tnsnames.ora file to the version of that file used by the new release.
If necessary, you can also add connection information for additional database instances to the new file.
An Oracle Text knowledge base is a hierarchical tree of concepts used for theme indexing, ABOUT queries, and deriving themes for document services. If you plan to use any of these Oracle Text features, you can install two supplied knowledge bases (English and French) from the Oracle Database Companion CD.
Reinstalling Oracle XML DB
Configuring or customizing the Oracle XML DB tablespace
Configuring FTP, HTTP/WebDAV port numbers
See Also:Appendix A of Oracle XML DB Developer's Guide
Configuring PL/SQL depends on the network configuration files used. In nearly all cases, configuration is automatic. However, if you are using pre-8.0.3
listener.ora files with your 10g release 1 (10.1) database, you need to manually configure them.
See Also:"Developing Applications for Windows" of Oracle Database Platform Guide for Windows
Configuring shared server support depends on how support was installed. If you installed Oracle Database through the Enterprise Edition, Standard Edition, or Personal Edition installation types, then shared support was not configured. If you created your database through Database Configuration Assistant, then you were offered a choice of shared or dedicated server support.
See Also:"Postinstallation Configuration Tasks on Windows" of Oracle Database Platform Guide for Windows
Windows systems require that you set the correct credentials for the Jobs system to work properly in Enterprise Manager. By default, the Management Agent service is installed as a
LocalSystem user. When submitting jobs, the user submitting the job must have the Log on as a batch job privilege enabled.
Perform the following steps to establish that privilege for any operating system user who needs to submit an Enterprise Manager job.
On Windows Server 2003 and Windows XP systems:
Start the Local Security Policy tool. From the Start menu, select Settings, then Control Panel, Administrative Tools, then Local Security Policy.
Under Local Policies/User Rights Assignment, add the user to the Log on as a batch job privilege.
If a user exists both locally and at the domain level, Windows gives the local user precedence. To use the domain user, qualify the username with the domain name. For example, to use the user
joe in the
ACCOUNTS domain specify the username as
If the Management Agent service is installed as any other user (that is, not
LocalSystem), then, in addition to granting the Log on as a batch job privilege, the "Windows service" user must be granted the following three privileges:
Act as part of the operating system
Adjust memory quotas for a process
Replace a process level token
On Windows, Oracle Database installations that use Automatic Storage Management must use Windows native authentication. By default, Windows native authentication is enabled. To ensure that it is, check the sqlnet.ora file, by default located in
\network\admin, and make sure that it has NTS enabled. For example:
See Also:Oracle Database Platform Guide for Windows for more information about Windows native authentication
You have the option to configure Oracle Enterprise Manager Database Control automatically when creating a new database using Database Control Assistant. This lets you administer your entire database using Enterprise Manager Database Control
See Also:Oracle Enterprise Manager Advanced Configuration for information on configuring a database to use Database Control
You can use Oracle9i database language and territory definition files with Oracle Database 10g release 1 (10.1).
To enable this functionality:
cr9idata.pl script, by default located in
Alternatively, before you install Oracle Database, you can run the Oracle Universal Installer
setup command with the
b_cr9idata variable set to
true, as follows:
Restart Oracle Database.
The Oracle Database Companion CD contains additional components that you can install. Whether you need to install these components depends on which Oracle Database components or features that you plan to use. If you plan to use the following components or features, Oracle strongly recommends that you install the components from the Companion CD:
Oracle Database Examples (formerly Oracle Demos)