Oracle® Database Installation and Administration Guide 11g Release 2 (11.2) for Fujitsu BS2000/OSD Part Number E27508-02 |
|
|
PDF · Mobi · ePub |
This chapter describes the features of Oracle Database on Fujitsu BS2000/OSD. The following topics are covered in this chapter:
Oracle Database is delivered in two editions for the two BS2000/OSD hardware lines:
Oracle Database 11g Release 2 for Fujitsu BS2000/OSD (S series) is the edition for the BS2000/OSD servers based on /390 architecture (S Server)
Oracle Database 11g Release 2 for Fujitsu BS2000/OSD (SQ series) is the edition for the BS2000/OSD servers based on x86-64 architecture (SQ Server)
Depending on the type of hardware, you must choose between these two editions. Oracle does not provide installation software specifically for the BS2000/OSD SX server. Use the Oracle Database 11g Release 2 for Fujitsu BS2000/OSD (S Series) software to install on an SX server. All information specific to the SQ series server is located in Chapter 15, "Oracle on SQ Server". All other chapters refer to both editions (the S and SX) server series.
This release implements the features of Oracle Database 11g Release 2 Enterprise Edition. These features are listed and described in the generic Oracle Documentation and in Oracle Database Licensing Information and Oracle Database New Features Guide.
The following options are not supported on Oracle Database 11g Release 2 for Fujitsu BS2000/OSD:
Oracle Data Mining
Oracle Database Vault
Oracle In-Memory Database Cache
Oracle Label Security
Oracle On-Line Analytical Processing (OLAP)
Oracle RAC One Node
Oracle Real Application Clusters (Oracle RAC)
The following features are not supported on Oracle Database 11g Release 2 for Fujitsu BS2000/OSD:
Oracle Universal Installer
Oracle Automatic Storage Management
Oracle Multimedia
Oracle Globalization Development Kit
Oracle XML DB
Oracle Secure Backup
Oracle Heterogeneous Services
OCCI
Oracle Instant Client
Oracle Messaging Gateway
Native Compilation of Java and PL/SQL
JIT in Oracle JavaVM
Cross Platform Transportable Tablespace
Oracle Java Server Pages
Oracle Application Express
Oracle JDBC OCI drivers
This section provides information about known restrictions and problems. It contains workarounds where possible and suggestions for certain common usage problems in the following sections. In addition to this section, refer to Appendix D, "Troubleshooting". If you encounter a problem that is not reported here, then contact Oracle Support for further assistance.
The German characters ä, ö, ü and ß, cannot be used in the names of tables, columns, fields, synonyms, and so on. This is because these characters are converted into bracket symbols (for example, {). The characters can, however, be stored as data.
The SDO_GEORASTER
feature is not supported.
Workload Replay is not supported in this release.
The operation ALTER DATABASE ... RESIZE
, to make a database file smaller, is not supported on BS2000. This operation has no effect on the corresponding BS2000 files.
However, database files can be altered to larger sizes either manually, by using ALTER
or automatically, when a tablespace is defined with AUTOEXTEND
.
The BINARY FLOAT
and BINARY DOUBLE
data types are not supported for customer-written database applications running on BS2000/OSD.
Attempts to store or fetch these types from an application program running on BS2000/OSD produces unpredictable results with both local and remote Oracle databases.
The binary data types FLOAT
and DOUBLE
of SQL*Loader are not supported on BS2000/OSD. Using these data types with SQL*Loader and External Tables produces unpredictable results.
Use the external, non-binary data type FLOAT EXTERNAL instead.
Multithreading functionality of direct path loads is not supported on BS2000.
External Jobs are not supported.
A few initialization parameters in the INIT.ORA
file, described in the generic documentation are not supported by Oracle Database 11g Release 2 for BS2000/OSD. Refer to Appendix C, "Initialization Parameters and the Parameter File" for more information.
Archiving to tape is not supported; archive log files must always be created as disk files. You may, however, use normal BS2000 backup procedures to back up the archive log files created by the archive process.
This section provides information about Import and Export:
Avoid ASCII/EBCDIC conversions by the operating system, FTP, or PERCON. Import and Export utilities perform their own conversions; additional conversions render the files unusable.
Import and export on tapes are not possible to or from more than one tape.
This section provides information about Oracle Data Pump Import and Oracle Data Pump Export:
Avoid ASCII/EBCDIC conversions by the operating system, FTP, or PERCON. Oracle Data Pump Import and Oracle Data Pump Export utilities perform their own conversions; additional conversions render the files unusable.
Tapes are not supported with Data Pump Export and Data Pump Import.
User-defined character sets implemented by Customizing Locale Data (as described in Oracle Database Globalization Support Guide) are not supported in this release.
The following features are currently not supported:
OCI shared mode functionality
OCI publish-subscribe functions
OCI Thread package
The following remarks relate to SQL*Plus:
SQL*Plus truncates and displays a warning message if the input lines exceed 511 characters.
If you use the SQL*Plus -s
option, then it must be the first option entered at the prompt.
The internal message buffer is limited to 76 characters, therefore, certain messages are truncated. This typically occurs if a message includes a second message. In such cases, you usually refer to the message number part of the second message. For further information, refer to the manual relevant to the particular message, either Oracle Database Error Messages, or Appendix A, "Oracle Error Messages for BS2000/OSD" of this guide.
If ECHO
is set to ON
, TAB
is set to ON,
and you specify a spool file, then the listing of commands may be misaligned.
To define the POSIX editor edtu
as your preferred text editor with SQL*Plus in the POSIX environment, the POSIX correction level A43 or higher is required.
If your preferred POSIX text editor is edtu
, then the POSIX correction level A43 or higher is required.
Oracle Database 10g clients can connect to Oracle Database 11g Release 2 instances on Fujitsu BS2000/OSD, if the initialization parameter SEC_CASE_SENSITIVE_LOGON
is set to FALSE
. Otherwise, the connection fails with the following message:
ORA-01017: invalid username/password; logon denied
For utilities in the POSIX shell, such as SQL*Plus, Import or Export, the maximum length of path names is 54 byte.This restriction applies to the names of SQL scripts or spool files.
The following remarks relate to Oracle Net Services:
When you specify a name for the listener in the LISTENER.ORA
file, Oracle recommends that the name is less than 20 characters long. If you use a listener name with more than 20 characters, then you must specify a log directory (trace directory) and log file (trace file).
The listener can be started only if the POSIX subsystem is running.
The support of the handoff/direct handoff technique makes the BEQ protocol incompatible to the BEQ protocol of releases prior to Oracle Database 10g Release 2. For example, an 11.2 listener cannot start a server of an Oracle9i instance.
The Internet Assigned Numbers Authority (IANA) divided port numbers into three ranges:
Well Known Ports from 0 through 1023
Registered Ports from 1024 through 49151
Dynamic, or Private Ports, or both, from 49152 through 65535
Fujitsu documentation for TCP/IP on BS2000 recommends setting the privileged port to 2050. However, using a registered Oracle port number may cause conflicts (see http://www.iana.org/assignments/port-numbers
). For example, if you set the port number for the listener process to 1521, then any Oracle process that listens on such a registered port number may fail with the following error:
TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist BS2000 Error: 126: Can't assign requested address BS2000 BCAM-RC: 40010020
The workaround is to use a non-privileged port, or to set the privileged port number to a value less than 1500, usually to 1024.
Oracle Database 11g Release 2 requires the POSIX subsystem and access to the POSIX file system. The following exceptions may occur:
Ask the BS2000 administrator to increase the number of UFS devices (parameter NOSTTY
in SYSSSI.POSIX-BC
.version
), if you get the following message:
CCM0090: ALL UFS TERMINAL DEVICES ARE IN USE OR PERMISSION DENIED
The termination of the POSIX subsystem also terminates the Oracle instance.