| Oracle® Database Release Notes 10g Release 2 (10.2) for Microsoft Windows (32-Bit) Part Number B14264-01 |
|
| View PDF |
| Oracle® Database Release Notes 10g Release 2 (10.2) for Microsoft Windows (32-Bit) Part Number B14264-01 |
|
| View PDF |
Release Notes
10g Release 2 (10.2) for Microsoft Windows (32-Bit)
B14264-01
August 2005
This document contains important information that was not included in the platform-specific or product-specific documentation for this release. This document supplements Oracle Database Readme.
This document may be updated after it is released. To check for updates to this document and to view other Oracle documentation, see the Documentation section on the Oracle Technology Network (OTN) Web site:
http://www.oracle.com/technology/documentation/
For additional information about this release, refer to the readme files located in the ORACLE_BASE\ORACLE_HOME\relnotes directory.
It contains the following topics:
The latest certification information for Oracle Database 10g release 2 (10.2) is available at:
http://metalink.oracle.com
The following products are not supported with Oracle Database 10g release 2 (10.2):
Grid Control Support
Oracle Database 10g release 2 (10.2) can be managed as a target by Grid Control 10.1.0.4. Oracle Database 10g release 2 is not supported by Grid Control 10.1.0.4 as a repository.
Our goal is to make Oracle products, services, and supporting documentation accessible to the disabled community. Oracle Database 10g release 2 (10.2) supports accessibility features. To make best use of these accessibility features, Oracle recommends the following software configuration:
Windows 2000 with Service Pack 2 or later
Sun Java Access Bridge 1.0.4 (included with the Oracle Database 10g release 2 (10.2) media)
JAWS screen reader 5.0
Microsoft Internet Explorer 5.5 or later
Additional accessibility information for Oracle products can be found at
http://www.oracle.com/accessibility
For the latest configuration information and for information about addressing accessibility and assistive technology issues, see the Oracle Accessibility FAQ at
http://www.oracle.com/accessibility/faq.html
Review the following sections for information about issues that affect Oracle Database installation, configuration, and upgrade:
RAC and ASM Interoperability With Oracle Database 10g Release 2
Shutdown of Cluster Ready Services Stack May Leave Processes Running
10.2 RAC Installations on an Oracle Database Release 10.1.0.4 Cluster
Error While Deleting a Remote Instance From a RAC-Shared Oracle Home Database
Reading a Downgraded Oracle Cluster Registry with Database Management Tools
Central Configuration of Oracle Real Application Clusters Disabled on Windows
If the database version does not match the Oracle release version, Database Upgrade Assistant displays a warning message. The warning message incorrectly instructs you to run catpatch.sql from the Oracle Database 10g release 1 home. Do not do this. Instead, run catpatch.sql from the rdbms\admin directory of the source Oracle home from which you are upgrading.
The issue is tracked with Oracle bug 4551401.
After the upgrade, the ORACLE_SID parameter is not defined in the Windows registry.
Workaround:
Set ORACLE_SID=Oracle_Sid at the command prompt before you use SQL*Plus.
Set the ORACLE_SID parameter in the registry (My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_10.2UpgradeHome\ORACLE_SID).
This issue is tracked with Oracle bug 4534421.
If you do not have sufficient address space to allocate PGA memory, you can run into ORA-04030 errors or system commands can fail with OS error 1450 or 997. The following solutions are suggested:
Run a smaller work load and use less users.
Run with the /3GB option and use Windows Enterprise Edition. Note that the /3GB option has the potential to deprive the operating system of necessary kernel resources, which can lead to Oracle instance failures. See the OracleMetaLink technical note at http://metalink.oracle.com entitled Note 297498.1: Resolving Instance Evictions on Windows Platforms Due to OS 10055 Errors (OS-1540).
Aside from not using the /3GB option, you can tune the amount of RAM that is available to the kernel by using the /USERVA parameter. Visit the following URL for details:
http://support.microsoft.com/default.aspx?scid=kb;en-us;810371
Determining the correct value is a trial and error process, but 2048 has worked for some users.
Oracle can support Physical Addressing Extensions/Address Windowing Extensions. This is another way in which you can get the Oracle instance to use large amounts of RAM (64G on 32-bit Windows).
Use VLM with a small window so that address space is allocated for PGA.
Reduce the per thread stack space usage using orastack.
This issue is tracked with Oracle bugs 4552171, 4552150, and 4552097.
10.1.0.2 or 10.1.0.3 RAC or Automatic Storage Management, instances do not interoperate with 10.2 Cluster Synchronization Service on Windows. The following error may appear on the top of the stack:
/_propropen+2162 CALLrel _proprutidtoname/
Workaround:
Apply the patch for bug 3843632 to the 10.1.0.2 or 10.1.0.3 Oracle home.
This issue is tracked with Oracle bug 3843632.
After shutting down the Cluster Ready Services (CRS) stack on a given node using the following command:
CRSCTL.EXE stop crs
the OracleEVMService or OracleCRService may not be listed in the STOPPED state. Furthermore, you may notice the existence of CRSD.EXE or EVMD.EXE in the Task Manager list of running processes. To stop these processes, issue the following commands from the operating system command prompt:
net stop OracleCRService net stop OracleEVMService
When modifying the name, IP address, or netmask of an existing virtual IP address (VIP) resource using the following command:
srvctl modify nodeapps
you must include the existing interfaces for the VIP in the -A argument. For example:
srvctl modify nodeapps -n mynode1 -A 100.200.300.40/255.255.255.0/eth0
This issue is tracked with Oracle bug 4500688.
When Oracle Universal Installer is performing a RAC 10g release 2 installation on a cluster that already has Oracle Database release 10.1.0.4, Oracle Universal Installer gives you an option of performing an upgrade on any databases running on the system.
If you select this option to upgrade, Oracle Universal Installer invokes Database Upgrade Assistant to perform the upgrade. As part of the database upgrade, Enterprise Manager Database Control is also upgraded. This does not impact the upgrade itself. The impact is that if the preupgrade version of the database is 10.1.0.4, Database Control may not start on one or more nodes after the upgrade. As a result, if you run the following command on that node:
emctl status dbconsole
it reports that Enterprise Manager Database Console is not running. Logging in through the browser also fails. This bug is intermittently observed.
Workaround:
Go to the node where the Enterprise Manager Database Console is not running.
End the emagent.exe process from the Task Manager.
Restart the OracleDBConsoleSID service.
This issue is tracked with Oracle bug 4550226.
During a delete instance operation on a cluster database using a shared Oracle home, you can encounter the following error message if the database has been configured for Enterprise Manager Database Control:
Error updating EM configuration for node node name
As a result, the Enterprise Manager configuration is not completely removed from the node where the deleted instance was running. However, this does not have any adverse effects. You can click OK, ignore the error, and proceed.
This issue is tracked with Oracle bug 4547265.
Oracle Database 9.2 management tools (such as srvctl) encounter errors when attempting to read an Oracle Cluster Registry (OCR) that was downgraded from 10.2 to 9.2 on Windows.
Workaround:
Dump the contents of the 10.2 OCR before downgrading by using the ocrdump tool. Identify the set of 9.2 configured databases. The database configuration resides under the DATABASE.DATABASES key.
Follow the downgrade procedure as documented.
Identify the location of the 9.2 OCR. It is either \\.\srvcfg or the file pointed to by registry value CfsOcrRoot under HKEY_LOCAL_SYSTEM\SOFTWARE\Oracle\osd9i\ocr.
Clear the contents of the 9.2 OCR.
Execute the following command from the 9.2 Oracle home:
srvconfig -init -f
Configure the 9.2 cluster databases identified in Step 1:
srvctl add database
This issue is tracked with Oracle bug 4507090.
The srvctl tool fails with the following errors when starting Oracle9i databases after Oracle 10g release 2 Clusterware is installed and the Global Services Daemon (GSD) is started from the Oracle Clusterware home:
/ORA-01005: null password given; logon denied / /ORA-01031: insufficient privileges / /ORA-01005: null password given; logon denied" /
Workaround:
Execute the following command to get the list of nodes in the Oracle Clusterware:
CRS home/bin/olsnodes
where home is the Oracle Clusterware home.
Execute the following command on one node.
CRS home/bin/crsuser add Oracle_user*
This command creates the service on all other nodes.
Execute the following commands for each node identified in Step 1:
CRS home/bin/crs_stop ora.node_name.gsd CRS home/bin/crs_setperm ora.node_name.gsd -o Oracle_user CRS home/bin/crs_start ora.node_name.gsd
This issue is tracked with Oracle bug 4523043.
Starting Oracle Database release 9.2 with srvctl fails when the Global Services Daemon (GSD) is running from Oracle 10.2 Clusterware. A dialog window displays the following error message:
The instruction at hex_address referenced memeory at hex_address. The memory could not be read
Workaround:
Copy srvctl.bat to srvctl.orig.bat in the 9.2 Oracle_Home\bin directory.
Edit the 9.2 Oracle_Home\bin\srvctl.bat file to add the following before -classpath.
-DTRACING.ENABLED=true -DTRACING.LEVEL=2
Save the Oracle_Home\bin\srvctl.bat file and reissue the same command with srvctl that previously failed.
This issue is tracked with Oracle bug 4571520.
If the ORA.ORA_SID.DB resource is ONLINE on a node that you want to delete from Oracle Clusterware, the delete node procedure displays the following errors while running crssetup:
prompt> crssetup del -nn node_name Step 1: shutting down node apps :node_name ora.racr1.db in ONLINE state . . . please manually stop dependent CRS resource before continuing
Workaround:
For the database resource (ora.*.db) mentioned in the error as being ONLINE, perform a relocation of that resource to any other node that is a part of the cluster. Run the crs_relocate command as shown below to perform the relocation:
crs_relocate name_of_the_db_resource -c cluster_node
This issue is tracked with Oracle bug 4564000.
To install Enterprise Security Manager (ESM), install Oracle Client and choose the Administrator installation type.
While Oracle Database 10g supports raw devices, tools such as Database Configuration Assistant do not support the configuration of raw devices for single instances. Instead, use Automatic Storage Management (ASM) or the file system to store database files.For Oracle Real Application Clusters (RAC) installations, configure raw device shared storage by stamping disks with Oracle Object Link Manager. You can also use your own scripts to configure raw devices.
|
See Also:
|
This issue is tracked with Oracle bug 4554058.
The option for configuring central management of your database by Enterprise Manager 10g Grid Control is not available during RAC installation on Windows. Also not supported on Windows is the use of standalone Enterprise Manager Configuration Assistant or Database Configuration Assistant to configure central management for RAC.
If you want central management for the installed RAC database, then you will have to discover the RAC database target manually from Grid Control after the installation.
OCCI libraries for developing applications with Microsoft Visual C++ version 7.1 (.NET 2003) and version 7.0 (.NET 2002) are available in the 10.2 release. Microsoft Visual C++ version 6.0 is no longer supported.
Microsoft Visual C++ version 7.1 libraries are now installed in the default location: oraocci10.dll under ORACLE_BASE\ORACLE_HOME\bin and oraocci10.lib under ORACLE_BASE\ORACLE_HOME\oci\lib\msvc. Copies of these two files are also installed under ORACLE_BASE\ORACLE_HOME\oci\lib\msvc\vc71. The Microsoft Visual C++ 7.0-specific version of the libraries are installed under ORACLE_BASE\ORACLE_HOME\oci\lib\msvc\vc7.
Applications required to link with MSVCRTD.DLL (debug version of Microsoft C-Runtime, /MDd compiler flag) should link with the specific OCCI libraries for this purpose: oraocci10d.lib and oraocci10d.dll.
All Instant Client packages contain the Microsoft Visual C++ version 7.1 compatible version of the OCCI DLL.
Applications should link with the appropriate OCCI library and ensure that the corresponding DLL is located first in the Windows system PATH.
If you are using Oracle Enterprise Manager Java Console to manage your database, grant the following privileges to the repository user and create the repository:
CREATE CLUSTER CREATE DATABASE LINK CREATE SEQUENCE ALTER SESSION CREATE SYNONYM CREATE TABLE CREATE VIEW
|
Note: Oracle Enterprise Manager Java Console is available on the Oracle Database Client installation media. |
Complete the following steps to create a repository user and grant privileges:
Start the standalone Java Console.
Double-click the database node in the navigator tree and connect to the database as a user with the NORMAL role.
Select Create from the Object menu.
The Create window appears.
Expand the database node in the Create window and select User. Then click the Create button.
The Create User property sheet appears.
On the General page, enter the name of the user and the password, and select OEM_REPOSITORY as the default tablespace and TEMP as the temporary tablespace.
On the Role page, grant the CONNECT and SELECT_CATALOG_ROLE roles to the repository user.
On the System Privileges page, grant the CREATE TRIGGER, CREATE PROCEDURE, EXECUTE ANY PROCEDURE, CREATE TYPE, EXECUTE ANY TYPE, SELECT ANY TABLE, CREATE CLUSTER, CREATE DATABASE LINK, CREATE SEQUENCE, ALTER SESSION, CREATE SYNONYM, CREATE TABLE, and CREATE VIEW privileges to the repository user.
On the Quota page, specify unlimited for OEM_REPOSITORY and TEMP.
On the Create User property sheet, click the Create button.
The following sections contain information about issues related to Oracle Database 10g and associated products:
Transportable Tablespaces feature in Enterprise Manager Database Console
Enterprise Manager Database Control Exception Error To Ignore
Some Readme text files contain UNIX line breaks. If you double-click these files, they open in Notepad by default, but Notepad does not recognize UNIX line breaks. Use WordPad (write.exe) or edit.com instead.
If NTS authentication is used with an Oracle client as a .NET remote object impersonating a user credential, then NTS authentication fails with the error ora-12638 Credential Retrieval Failed. This happens due to the failure of the Windows API AcquireCredentialsHandle() in the NTS adapter inside the .NET remote object. Refer to OracleMetalink for more details.
Windows XP Service Pack 2 changes the security of WebDAV configurations. The following access error message may display when computers with Windows XP Service Pack 2 attempt to access an Oracle XML DB repository using the HTTP/Web Distributed Authoring and Versioning (WebDAV) protocol from Windows Explorer or other tools:
The folder you entered does not appear to be valid. Please choose another.
Perform the following steps to access Oracle XML DB from a client computer using the WebDAV protocol:
Create the following registry key on the client machine and set it to a non-zero value:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters\UseBasicAuth (DWORD)
Restart the client computer or restart the WebClient service.
|
See Also:
|
If you plan to connect the Oracle Database to a release of Oracle Database Client that is earlier than 10g release 2 (10.2), you cannot do so if all of the following conditions exist:
Oracle Database Client is running on the same computer as Oracle Database 10g release 2 (10.2).
Microsoft Windows Terminal Services is not running on the same computer as Oracle Database Client. Typically, Terminal Services is installed and configured with Microsoft Windows 2003, but on Microsoft Windows 2000 or XP, it may not be installed or enabled.
Oracle Database Client is version 9.0.x to 9.2.0.6 or 10.1 to 10.1.0.3.
Oracle Database Client is not running as Administrator.
To remedy this problem, upgrade Oracle Database Client to release 9.2.0.7, or 10.1.0.4 or higher by downloading the Oracle Database Family patch set from OracleMetaLink at:
http://metalink.oracle.com/
If you install Oracle Database 10g Products, which include Oracle Workflow server, in a language other than English, the installation adds a submenu named Configuration and Migration Tools in English to the Windows Start menu under the corresponding Oracle home. This submenu includes only one item: Workflow Configuration Assistant. Other Oracle Database tools still appear under a separate, properly translated Configuration and Migration Tools submenu.
This issue is tracked with Oracle bug 4551276.
The transportable tablespaces feature accessible from the Maintenance tab has some limitations when generating and integrating tablespaces in Automatic Storage Mode (ASM). The limitations and workarounds are described below:
Limitation:
There is a limitation when generating the transportable tablespace set on databases using ASM as storage. On Page 4, Files Page, if you provide the disk group name in the dump file location, you receive the following error when you submit the job:
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/22/2005 08:23:58 ORA-19504: failed to create file "+DATA/naresh/testtablespace1.260.566954713" ORA-17502: ksfdcre:4 Failed to create file +DATA/naresh/testtablespace1.260.566954713 ORA-15046: ASM file name '+DATA/naresh/testtablespace1.260.566954713' is not in single-file creation form
Workaround:
On Page 4, Files Page, provide a file system location instead of the disk group name. Data files and dump files are generated on the file system location you provide.
Limitation:
There is a limitation when integrating the transportable tablespace set on databases using ASM as storage. On Page 2, Datafile Destination Page, if in the data files table you provide the same disk group name for all data files, you can receive the following error when you submit the job:
RMAN> 2> 3> Starting backup at 22-AUG-05 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=152 devtype=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 08/22/2005 09:08:36 ORA-15122: ASM file name '+MAKI/+MAKI/+MAKI/+MAKI/' contains an invalid file number
Workaround:
On Page 2, Datafile Destination Page, provide a unique disk group name for each data file.
This issue is tracked with Oracle bug 4566250.
Immediately after switching the Enterprise Manager Agent from nonsecure to secure mode, or vice versa, Enterprise Manager Database Control can show the following exception on the home page:
java.lang.Exception: Exception in sending Request :: null
The home page is fully functional despite this exception, and this exception should go away within five minutes. Starting and stopping Enterprise Manager Database Control should also make this exception go away.
This issue is tracked with Oracle bug 4562655.
This section contains these topics:
The Oracle Data Provider for .NET Dynamic Help differs slightly from the Oracle Data Provider for .NET Developer's Guide (in Acrobat PDF), due to terminology changes describing Real Application Clusters (RAC). These differences occur in the "Connection Pooling for Real Application Clusters (RAC)" section in Chapter 3 of the Oracle Data Provider for .NET Developer's Guide. The information in this guide is up to date. The main differences are as follows:
The Dynamic Help refers to Load Balancing and the guide refers to Runtime Connection Load Balancing in several places. The Dynamic Help refers to a basis in real-time workload metrics and distribution policy and the guide refers to the load balancing advisory and service goal in several places.
Only the Dynamic Help includes the following sentence (in the first paragraph of the first subheading of Chapter 3):
Furthermore, ODP.NET connection pool can be enabled to proactively free resources associated with connections that have been severed due to a down RAC service, service member, or node.
The Dynamic Help references Oracle Real Application Clusters Quick Start and the guide references Oracle Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide and Oracle Database Net Services Administrator's Guide in a See Also note. The Dynamic Help references the Oracle Real Application Clusters Administrator's Guide and the guide references Oracle Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide in another See Also note.
The guide includes the following note in the second subheading:
|
Note: The database service being connected to must be configured forAQ_HA_NOTIFICATIONS. For more details, see Oracle Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide |
The guide includes the following paragraph in the sub-bullets:
In order to use Runtime Connection Load Balancing, specific RAC configurations must be set. For further information, see Oracle Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide. Oracle Net Services should also be configured for load balancing. See Oracle Database Net Services Administrator's Guide for further details.
In Chapter 5 of Oracle Data Provider for .NET Developer's Guide, under the section InitialLOBFetchSize, the following information appears incorrectly under the section "For releases prior to Oracle Database 10g release 2 (10.2)":
If the InitialLOBFetchSize is set to a nonzero value, GetOracleBlob() and GetOracleClob methods are disabled. BLOB and CLOB data are fetched by using GetBytes and GetChars methods, respectively.
This was corrected to appear as follows under: For Oracle Database 10g release 2 (10.2) and later:
Prior to Oracle Database 10g release 2 (10.2), if the InitialLOBFetchSize is set to a nonzero value, GetOracleBlob and GetOracleClob methods were disabled. BLOB and CLOB data was fetched by using GetBytes and GetChars methods, respectively. In Oracle Database 10g release 2 (10.2), this restriction no longer exists. GetOracleBlob and GetOracleClob methods can be used for any InitialLOBFetchSize value zero or greater.
Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.
Accessibility of Code Examples in Documentation
Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.
Accessibility of Links to External Web Sites in Documentation
This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
TTY Access to Oracle Support Services
Oracle provides dedicated Text Telephone (TTY) access to Oracle Support Services within the United States of America 24 hours a day, seven days a week. For TTY support, call 800.446.2398.
Oracle Database Release Notes, 10g Release 2 (10.2) for Microsoft Windows (32-Bit)
B14264-01
Copyright © 1996, 2005, Oracle. All rights reserved.
The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited.
The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose.
If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software—Restricted Rights (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs.
Oracle, JD Edwards, PeopleSoft, and Retek are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party.
