This chapter describes the following postinstallation configuration tasks:
Oracle recommends installing the latest patch set release after successful installation of Oracle Database.
You must register online before using My Oracle Support (formerly OracleMetaLink). After logging in to My Oracle Support, select Patches from the left-hand column.
To find and download patches:
Go to the My Oracle Support (formerly OracleMetaLink) Web site at
https://support.oracle.com
Log in to My Oracle Support.
Note:
If you are not a My Oracle Support (formerly OracleMetaLink) registered user, then click Register and follow the registration instructions.Click Patches & Updates on the main My Oracle Support page.
In the Patch Search section, specify the Patch Name, Number, or Sun CR ID, then click Search.
If you select the Patch Name or Number option, you can specify the exact patch names or numbers.
If you select Sun CR ID option instead, specify the exact change request.
If you choose the Platform option, you have the option of selecting a maximum of 5 platforms from the list.
If you choose Language option instead, you have the option of selecting one or more languages from the list.
You can also search by Product, Release, and Platform using the Product or Family (Advanced Search) link.
Select the patch to download. Patch sets for Oracle databases are identified as x.x.x.x.x PATCH SET FOR ORACLE DATABASE SERVER
Review the README file 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 file 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 performance 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 packagesSTANDARD
and DBMS_STANDARD
must be valid.Start SQL*Plus:
SYSTEM_DRIVE:\> sqlplus /nolog
Connect to the database with the SYS
account:
SQL> CONNECT SYS/PASSWORD@service_name AS SYSDBA
where PASSWORD
is the password you assigned to the SYS
account during installation.
Start the database (if necessary):
SQL> STARTUP
Run the utlrp.sql
script, which by default is located in ORACLE_BASE
\
ORACLE_HOME
\rdbms\admin\utlrp.sql
. For example:
SQL> @c:\oracle\product\10.2.0\rdbms\admin\utlrp.sql
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 Database 10g Release 2 (10.2) Online Documentation Library and the Oracle Technology Network Web site.
This section contains these topics:
Installing Natively Compiled Java Libraries for Oracle JVM and Oracle interMedia
Running Oracle Cluster Synchronization Services from a Different Oracle Home
Setting Credentials for the Job System to Work with Enterprise Manager
Configuring Oracle Database to Communicate with Automatic Storage Management
Configuring Databases to Use Oracle Enterprise Manager Database Control
Using Oracle9i Language and Definition Files with Oracle Database 10g Release 2 (10.2)
Note:
You need only perform postinstallation tasks for components that you intend to use.Oracle Administration Assistant for Windows requires the Microsoft Management Console (MMC) and HTML Help 1.2 or later to run. Following are the MMC versions shipped along with the following platforms:
Windows Server 2003: MMC 3.0, version 5.2
Windows Server 2008: MMC 3.0, version 6.0
Windows Server 2008 R2: MMC 3.0, version 6.1
Oracle recommends the latest MMC version available.
See Also:
Microsoft documentation athttp://www.microsoft.com/
If you plan to use Oracle Java Virtual Machine (JVM) or Oracle interMedia, Oracle 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" for more information about installing components from the Companion CDTo reconfigure Oracle Cluster Synchronization Services (CSS) to run from a different Oracle home, enter the following at the command prompt:
localconfig reset [destination_Oracle_home]
where 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 by running operfcfg.exe
, located in the ORACLE_HOME\
bin
directory. operfcfg.exe
prompts for a user name, password, and TNS alias.
For example:
DRIVE_LETTER:\> ORACLE_HOME\bin\operfcfg.exe Enter user-name: system Enter password: password Enter tns-alias: orcl operfcfg: New registry values have been successfully set.
If you run the following command, then operfcfg.exe
does not prompt for a password:
operfcfg.exe -U user_name -D tns_alias
See Also:
Oracle Database Platform Guide for Microsoft Windows Itanium (64-Bit) for additional information about Oracle Counters for Windows Performance MonitorIf 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 DirectoryIf you have a previous release of Oracle software installed on this system, you can copy information from the Oracle Net tnsnames.ora
and listener.ora
configuration files from the previous release to the corresponding files for the new release.
Note:
The default location for thetnsnames.ora
and listener.ora
files is the ORACLE_BASE
\
ORACLE_HOME
\network\admin\
directory.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.
To use the listener from the current release, you must copy static service information from the listener.ora
file from the previous release to the version of that file used by the new 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.
See Also:
Oracle Text Reference for information about creating and extending knowledge bases, such as extending the supplied knowledge bases to accommodate your requirements, or creating your own knowledge bases in languages other than English and French
"Installing Oracle Database Components from the Companion CD" for more information about installing components from the Companion CD
See Oracle XML DB Developer's Guide for more information about the following tasks:
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 GuideConfiguring 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 tnsnames.ora
and listener.ora
files with your 10g Release 2 (10.2) database, you must manually configure them.
See Also:
"Developing Applications for Windows" of Oracle Database Platform Guide for Microsoft Windows Itanium (64-Bit)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 Oracle 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 Microsoft Windows Itanium (64-Bit)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, such as stopping or starting the database, 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.
Start the Local Security Policy tool:
Windows Server 2003: From the Start menu, select Administrative Tools, then Local Security Policy.
Windows Server 2008 and Windows Server 2008 R2: From the Start menu, select Programs, Administrative Tools, then Local Security Policy.
Under the Security Settings list, expand the list to Local Policies.
Under Local Policies, double-click User Rights Assignment.
Under Policy, search for the Log on as a batch job policy.
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, you must grant the "Windows service" user the following three privileges:
Act as part of the operating system
Adjust memory quotas for a process
Replace a process level token
With each policy, perform the following steps:
Double-click the policy name.
In the Properties dialog box, click Add User or Group.
In the Select Users or Groups dialog box, enter the name of the user (for example, jsmith
, administrator
, and so on.)
Note:
On Windows Server 2008 and Windows Server 2008 R2, the name of the dialog box is Select Users, Computers, or Groups.Click Check Names to check that you have entered the name correctly.
Click OK.
Click OK to exit the Properties dialog box, then exit Local Security Settings and Administrative Tools.
Restart your computer.
If a user exists locally and at the domain level, Windows gives the local user precedence. To use the domain user, qualify the user name with the domain name. For example, to use the user joe
in the ACCOUNTS
domain specify the user name as ACCOUNTS\joe
.
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 ORACLE_BASE
\
ORACLE_HOME
\network\admin
, and ensure that it has NTS enabled. For example:
sqlnet.authentication_services=(NTS)
See Also:
Oracle Database Platform Guide for Microsoft Windows (32-Bit) for more information about Windows native authenticationYou 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 about configuring a database to use Database ControlYou can use Oracle9i database language and territory definition files with Oracle Database 10g Release 2 (10.2).
To enable this functionality:
Run the cr9idata.pl
script, by default located in ORACLE_BASE
\
ORACLE_HOME
\nls\data\old
.
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:
setup.exe oracle.rsf.nlsrtl_rsf:b_cr9idata=true
Set the ORA_NLS10
environment variable to point to the directory where you installed the new language and territory definition files, which by default are in ORACLE_BASE
\
ORACLE_HOME
\nls\data
.
Restart Oracle Database.
See Also:
Appendix C, "Installing and Configuring Oracle Database Using Response Files" for information about response files, in which you can set the b_cr9idata
variable and then run the response file with Oracle Universal Installer
Appendix D, "Configuring Oracle Database Globalization Support" for information about globalization support that is affected by this release of Oracle Database
Oracle Database Globalization Support Guide for information about the NLS_LANG
parameter and Globalization Support initialization parameters
The Oracle Database Companion CD contains additional database-related components that you can install. Whether you must install these components depends on which Oracle Database components or features you plan to use. If you plan to use the following components or features, Oracle recommends that you install the components from the Companion CD:
JPublisher
Oracle Database Examples (formerly Oracle Demos)
Oracle JVM
Oracle interMedia
Oracle Text Supplied Knowledge Bases
Oracle Ultra Search
Oracle HTTP Server
Oracle HTML DB
Oracle Workflow server and middle-tier components