Skip Headers

Oracle® Database Release Notes
10g Release 1 (10.1.0.2.0) for IBM z/OS (OS/390)
Part No. B13528-01
 

 

Copyright © 1996, 2004,  Oracle. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Oracle® Database

Release Notes

10g Release 1 (10.1.0.2.0) for IBM z/OS (OS/390)

Part No. B13528-01

April 2004

This document contains important information that was not included in the platform-specific or product-specific documentation for this release. Unless stated otherwise, the information in this document applies equally to z/OS, and z/OS.e.

It contains the following topics:

This document may be updated after release. To check for updates to this document and to view other product-specific release notes, see the Documentation section on the OTN Web site:

http://otn.oracle.com/documentation

For additional information about this release, go to the Install CD-ROM, open the file welcome.html, and click the ReadMe tab. This provides access to the readme files.

Documentation Updates

The following sections contain updates to the Oracle Database 10g documentation:

Globalization Support

The instructions about the ORA_NLS10 environment variable in the "Using Oracle9i Database Language and Territory Definition Files with Oracle Database 10g" section of the Oracle Database 10g README file are incorrect. This is because the $ORACLE_HOME/nls/data/old directory contains definitions files which have changed in Oracle Database 10g release 1 only, and not the complete set of the database locale definition files. To include the Oracle 9i definitions:

  1. Create a new directory:

    $ mkdir $ORACLE_HOME/nls/data/9i
    
    
  2. Copy the contents of the $ORACLE_HOME/nls/data directory to the new directory:

    $ cp $ORACLE_HOME/nls/data/*.nlb $ORACLE_HOME/nls/data/9i
    
    
  3. Copy the contents of the $ORACLE_HOME/nls/data/old directory to the directory that you created in step 1:

    $ cp $ORACLE_HOME/nls/data/old/*.* $ORACLE_HOME/nls/data/9i
    
    
  4. Set the ORA_NLS10 environment variable to specify the directory that you created, for example:

    • Bourne, Bash, or Korn shell:

      $ ORA_NLS10=$ORACLE_HOME/nls/data/9i ; export ORA_NLS10
      
      
    • C shell:

      % setenv ORA_NLS10 $ORACLE_HOME/nls/data/9i
      

    See Also:

    Refer to the Oracle Database 10g Globalization Support Guide and the Oracle Database 10g README for more information about the changes in the language and territory definition files between Oracle9i and Oracle Database 10g.

Support for Hearing and Speech Impaired Customers

The Text Telephone (TTY) phone number for non-technical support is listed incorrectly in several documents. The correct phone number is 1.800.464.2330.

Required Disk Space for Transparent Gateway for iWay

Refer to Oracle Database Installation Guide for IBM z/OS to determine the total Oracle non-database disk space requirements, including those for code, JCL, and samples.

Unsupported Features and Functions

This release of Oracle10g for IBM z/OS (OS/390) does not include support for the following features and functions. Existing customers should also consult Oracle10g Enterprise Edition System Administration Guide for z/OS for unsupported features or functions that should be taken into consideration during a migration or upgrade.

Known Restrictions

The following is a list of known restrictions to this release o f Oracle Database on IBM z/OS:

Advanced Queuing

Non-repudiation of Advance Queuing messages sent across a firewall using Internet Document Access Protocol (IDAP) is not supported in this release.

ALTER DATABASE...RESIZE

Oracle database files on IBM z/OS are implemented as VSAM linear data sets. IBM does not provide a space release function for VSAM data sets, so using ALTER DATABASE...RESIZE to make a database file smaller has no effect. Database files can be resized larger, both manually (with ALTER) and automatically as they fill (when a tablespace is defined with AUTOEXTEND).

Automatic Recall of Database Data Sets

No support is available currently for automatically recalling IBM z/OS data sets that are used by the Oracle server if they have been migrated to other media by IBM's DFSMShsm, or a similar product. This applies to the VSAM linear data sets (LDS) comprising the database, and to non-VSAM data sets such as parameter files. All such data sets must be on disk in their original form at the time that they are opened by the server.

Client Runtime with C Programs

To use 10g Release 1 (10.1.0.2.0) Client with a C program, you must complete the following steps:

  1. Ensure that the C for z/OS V1R2 compiler is installed, instead of or addition to the C for OS390 V2R10.

  2. Recompile all OCI programs using the C for z/OS V1R2 compiler with the ENUM(INT) option.


Note:

Refer to z/OS V1R2.0 C/C++ Compiler and Run-Time Migration Guide for additional information about this issue.

IEEE Standard Floating Point Number Restrictions

The following is a list of restrictions that apply to the IEEE standard floating point numbers:

  • The new BINARY_DOUBLE and BINARY_FLOAT database data types are not supported for client applications running on z/OS.

    This restriction applies to both customer-written applications and Oracle tools and utilities on z/OS. Attempts to store or fetch these types from a client program running on z/OS will produce unpredictable results with both local and remote Oracle10g servers.

  • Use of z/Architecture Binary Floating Point (BFP, also known as IEEE 754 floating point) in Oracle applications running on z/OS is not supported.

    This restriction means that customer-written Oracle applications cannot bind or define host variables that are BFP types in an Oracle SQL statement. This restriction also affects tools and utilities: both SQL*Loader and the server External Table feature cannot load file data that is BFP.

    Traditional System/370 floating point data (now known as Hexadecimal Floating Point or HFP) remain supported, as in the past.

Java Virtual Machine (JavaVM)

The following java methods are not supported with the JavaVM:

  • java.lang.Runtime.exec()

  • java.lang.System.load()

  • java.lang.System.loadLibrary()

  • java.lang.System.mapLibraryName()

  • java.nio.channels.

Native Compilation of Java and PL/SQL

Native compilation of Java or PL/SQL programs is not supported.

Oracle Call Interface

The Oracle C++ Call interface is not supported in this release.

Oracle Datapump

Oracle Datapump is restricted to HFS and zFS file systems.

Oracle Enterprise Manager Intelligent Agent

The following sections contain issues that affect Oracle Enterprise Manager Intelligent Agent:

Available Functions with Oracle Enterprise Manager Intelligent Agent

Oracle10g Database for IBM z/OS (OS/390) supports only a minimal set of host functions, as the grid control is provided with the z/OS system CPU usage. This release does not provide the grid control with disk activity, swap size, or information about active users.

Configuration of Oracle Enterprise Manager Intelligent Agent

Configuration of the Agent must be done manually. The Oracle Enterprise Manager Configuration Assistant is not supported with this release.

Database Startup and Shutdown with Oracle Enterprise Manager

Oracle10g Database for IBM z/OS (OS/390) supports database startup and shutdown from the console. Before you can use this feature, the OSDI rdbms and net subsystem must be active.

Oracle Enterprise Manager Grid Control Console and iSQL*Plus

Oracle10g Database for IBM z/OS (OS/390) does not support the iSQL*Plus interface from the console.

Oracle Enterprise Manager Grid Control Console Not Shipped

Currently, Oracle10g Database for IBM z/OS (OS/390) only ships with the Oracle Enterprise Manager Agent. Oracle Enterprise Manager Grid Control Console is not supported, though this release does support a remote Oracle Enterprise Manager Grid Control Console. This is because the repository for this console must not reside on a z/OS platform.

Oracle External Tables

External Tables is an Oracle feature that allows you to process non-Oracle operating system files as Oracle database tables. On IBM z/OS, the External Tables feature is limited to accessing files in the HFS and zFS file systems.

Oracle JDBC OCI Drivers

The Oracle JDBC OCI drivers are not available for this release.

Oracle OLAP

The following sections contain issues affecting Oracle OLAP:

Oracle OLAP API

The Oracle OLAP API interface is not supported.

Oracle OLAP Installation

Dynamically linking options into the Oracle kernel as part of the Oracle Universal Installer installation is not supported in this release. If you choose the OLAP optional feature, then after the Oracle Universal Installer installation is complete, you must complete the following task manually to link the required code into Oracle:

  1. Set your $ORACLE_HOME and $ORACLE_HLQ_PDS.

    Do this by running the ENV file in your ORACLE_HOME location. For example:

    cd $ORACLE_HOME/server/rdbms
    make -f ins_rdbms.mk olap_on
    make -f ins_rdbms.mk ioracle
    
    

    A backup copy of the oracle executable is kept automatically in $ORACLE_HOME/server/rdbms/bin. It is named oracleO.

  2. (Optional) Allocate a temporary AUTHLOAD to hold the new Oracle executable.

    The final stage of the relink make attempts to copy the new Oracle executable into your AUTHLOAD, provided the link is successful. To allocate a temporary AUTHLOAD:

    1. Allocate your new AUTHLOAD, using the same attributes as the current AUTHLOAD

    2. Set the ORACLE_HLQ_PDS environment variable to point to this new HLQ.

  3. Refer to the Oracle OLAP documentation to run the OLAP installation scripts.

    At a minimum, you will need to run the script $ORACLE_HOME/olap/admin/olap.sql.

Oracle Scheduler

External jobs are not supported from Oracle Scheduler onIBM z/OS.

Oracle Programmer

Pro*Fortran is not supported in this release.

Oracle Real Application Clusters

If you use ARCHIVE mode with Oracle Real Application Clusters (RAC), then you must either set the LOG_ARCHIVE_FORMAT/DEST values, or make sure that each instance within the RAC cluster is in a separate subsystem and uses the same OSDI service name for each instance. Failure to do so will cause database recovery to fail, due to an inability to find archive log files.

Oracle Security Server

For Oracle Security Server, an Oracle10g server or client on IBM z/OS cannot be a participant in an Oracle security connection. However, an Oracle database server on IBM z/OS can be the security repository.

Oracle Spatial Data Option

The SDO_GEORASTER feature is not supported.

Oracle Streams

The DBMS_FILE_TRANSFER PL/SQL package is not supported.

Oracle Universal Installer

The following configuration assistants for Oracle Universal Installer are not supported:

  • Database Configuration Assistant (dbca)

  • Net Configuration Assistant (netca)

  • Enterprise Manager Configuration Assistant (emca)

Oracle Utilities

The utilities Oracle Trace and dbnewid are not available.

Additional utilities are also not available with this release. For a complete list of unavailable utilities, refer to the documents Oracle Database Installation Guide 10 g Release 1 (10.1) for IBM z/OS (OS/390), and Oracle Database System Administration Guide 10 g Release 1 (10.1) for IBM z/OS (OS/390).

Oracle XML Developers Kit

The following parts of the XML Developers Kit are not supported:

  • XML Class Generator for Java and C++

Propagation from Object Queues

Propagation from object queues with BFILEs is not supported in Oracle Database 10g.

XML Database (XML DB)

The following XML DB components are not supported in this release:

  • WebDAV access

  • HTTP access

  • FTP access

Known Bugs

This section provides a list of known bugs with this release of Oracle Database 10g.


Note:

For the latest information and workarounds for the bugs in this list, go to OracleMetaLink, which is at the following Web site:

http://metalink.oracle.com


Bug Number Description
3274855 ORA-00600: [kghstack_underflow_internal_2]
3420185 PROC batch – CMDLINE filespecs as PDS members or using comma delimiter do not work.Workaround: Use //DD: or DD
3443934 ATTN (TSO) ore CTR-C (POSIX shell) from RMAN can cause a loop
3455276 CTR-C from SQLPLUS may give errors
3467355 ORA-nnnnnnnnn: Message nnnnnnnnn not found occurring during error handling. nnnnnnnnn can vary
3470354 Asynch parallel DBMS_DEFER_SYS.PUSH from within PL/SQL block with XM dblink hangs. This is unsupported but should not hang.
3483016 ORA-3113 on RAC reconnect attempt after instance abort
3511137 Potential loop in thread reader/writer
3527035 ORA-10388: parallel query server interrupt during STREAM apply
3572959 OWA_UTIL gets PLS-00307: TOO MANY DECLARATIONS OF 'BIND_VARIABLES' MATCH THIS CALL

Documentation Accessibility

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. 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 additional information, visit the Oracle Accessibility Program Web site at

http://www.oracle.com/accessibility/

Accessibility of Code Examples in Documentation

JAWS, a Windows screen reader, 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, JAWS 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.