Page 3 - Contents; Preface
iii Contents Preface ................................................................................................................................................................. xi Audience ............................................................................................................
Page 4 - Architecture and Implementation
iv 2 Architecture and Implementation 2.1 Operating System Environment ............................................................................................... 2-1 2.1.1 File Systems ..................................................................................................................
Page 5 - Creating and Upgrading a Database
v 3.3.2.3 Package Requirements ................................................................................................. 3-6 3.3.2.4 Additional BS2000 Software Components ................................................................ 3-7 3.3.2.5 Compiler and CRTE Requirements for Oracle Da...
Page 7 - Oracle Net Services
vii 8.5 Troubleshooting .......................................................................................................................... 8-8 8.5.1 Trace Files ............................................................................................................................. 8-8 8...
Page 8 - 4 Oracle Management Agent
viii 14 Oracle Management Agent 14.1 Preinstallation Issues ............................................................................................................... 14-1 14.2 Running the Installation Script .........................................................................................
Page 9 - C Initialization Parameters and the Parameter File
ix B.4.3 BGJPRC_UID / BGJPRC_SID ........................................................................................... B-6 B.4.4 BGJ_LOG_JOBSTART ........................................................................................................ B-6 B.4.5 sid_BGJPAR .........................
Page 10 - E File Types and Names Used by Oracle
Page 11 - Audience
xi Preface This manual and Oracle Database User's Guide for Fujitsu BS2000/OSD , form a system-specific set of manuals that provide installation, maintenance, and usage information about Oracle Database and related products. This manual provides information for those responsible for installing and a...
Page 12 - Documentation Accessibility; Related Documents; Conventions Used in this Manual
Type Meaning/Usage Generic This is the primary Oracle Database documentation, which describes how the product works and how it is used. Use this type of documentation to learn about product functions and how to use any Oracle Database product or utility. System Specific This documentation provides t...
Page 15 - Release Notes
1 Release Notes 1-1 1 Release Notes This chapter describes the features of Oracle Database on Fujitsu BS2000/OSD. The following topics are covered in this chapter: ■ Oracle Database Editions for BS2000/OSD ■ Options Not Supported ■ Features not Supported ■ Known Restrictions, Problems, and Workaroun...
Page 16 - Features not Supported
Features not Suppor ted 1-2 Oracle Database Installation and Administration Guide ■ Oracle RAC One Node ■ Oracle Real Application Clusters (Oracle RAC) 1.3 Features not Supported The following features are not supported on Oracle Database 11 g Release 2 for Fujitsu BS2000/OSD: ■ Oracle Universal Ins...
Page 17 - IEEE Standard Floating Point Number Restrictions
Known Restrictions, Problems, and Workarounds Release Notes 1-3 ■ Oracle Data Pump Import and Oracle Data Pump Export ■ Globalization Support ■ Oracle Call Interface ■ ADRCI ■ Connecting from Oracle Database 10g clients ■ Utilities in the POSIX environment ■ Oracle Net Services ■ Oracle Net BEQ Prot...
Page 18 - 1 Oracle Data Pump Import and Oracle Data Pump Export
Known Restrictions, Problems, and Workarounds 1-4 Oracle Database Installation and Administration Guide 1.4.7 Oracle Scheduler External Jobs are not supported. 1.4.8 INIT.ORA Parameters A few initialization parameters in the INIT.ORA file, described in the generic documentation are not supported by ...
Page 19 - 6 Connecting from Oracle Database 10g clients
Known Restrictions, Problems, and Workarounds Release Notes 1-5 ■ 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 includ...
Page 21 - Architecture and Implementation; Operating System Environment
2 Architecture and Implementation 2-1 2 Architecture and Implementation This chapter describes the Oracle Database system architecture for Fujitsu BS2000/OSD. The chapter includes the following topics: ■ Operating System Environment ■ Basic Structures ■ Two-Task Mode ■ Address Space Planning ■ Oracl...
Page 22 - Basic Structures
Basic Structures 2-2 Oracle Database Installation and Administration Guide Therefore, Oracle Database 11 g Release 2 for BS2000/OSD requires the POSIX file system. While in Oracle Database 10 g the use of the POSIX file system was optional, it is mandatory in Oracle Database 11 g Release 2. During t...
Page 25 - Address Space Planning; Oracle Database Data Area Placement
See Also: Refer to "Using Oracle Managed Files" in Oracle Database Administrator's Guide for more information about file name formats Address Space Planning Architecture and Implementation 2-5 2.2.4 Bigfile Tablespaces Oracle Database 11 g Release 2 on BS2000/OSD supports bigfile tablespaces...
Page 26 - Oracle Database Environment Definition File
Oracle Database Environment Definition File 2-6 Oracle Database Installation and Administration Guide Figure 2–1 Placement of Data Areas in Background, Server and User Tasks The xxx _BASE values must be compatible with the BS2000/OSD value SYSBASE (defined by BS2000/OSD generation and delimiting the...
Page 29 - The ORALOAD Library
User ID Requirements Architecture and Implementation 2-9 2.6 The ORALOAD Library The ORALOAD library ( $ORAC1120.ORALOAD.LIB by default) is required to run any Oracle Database 11 g Release 2 program. The Oracle Database uses this library to load executables and subroutines dynamically when required....
Page 33 - Oracle Database Installation and Deinstallation; Overview of Oracle Database Installation; Planning the Installation
3 Oracle Database Installation and Deinstallation 3-1 3 Oracle Database Installation and Deinstallation This chapter describes preinstallation requirements, postinstallation tasks, and the installation and deinstallation of Oracle Database 11 g Release 2 on BS2000/OSD. It provides information about ...
Page 34 - Oracle Database Preinstallation Requirements
See Also: Oracle Database Licensing Information for more licensing information Oracle Database Preinstallation Requirements 3-2 Oracle Database Installation and Administration Guide 3. Complete preinstallation tasks : "Oracle Database Preinstallation Requirements" describes preinstallation t...
Page 37 - Operating System and Communication System Requirements
Oracle Database Preinstallation Requirements Oracle Database Installation and Deinstallation 3-5 3.3.2.1 Operating System and Communication System Requirements The following operating system and communication system versions or higher, are required for Oracle Database 11 g Release 2: ■ BS2000/OSD V7...
Page 41 - Checking the Configuration Files in the POSIX File System; Creating Required Operating System Users and Groups
Oracle Database Preinstallation Requirements Oracle Database Installation and Deinstallation 3-9 3.3.3.4 Checking Loopback Address Check if the file $TSOS.SYSDAT.BCAM.ETC.HOSTS contains an entry for the loopback address. For example: 127.0.0.1 localhost loopback # local address 3.3.3.5 Checking the ...
Page 43 - Identify Required Directories in POSIX
Oracle Database Preinstallation Requirements Oracle Database Installation and Deinstallation 3-11 /SHOW-POSIX-USER-ATTRIBUTES If the output shows default values and the directory is /home/gast , then initialize the POSIX user with the following BS2000 command: /ADD-POSIX-USER The POSIX user attribut...
Page 45 - Identifying or Creating Oracle Base Directory in POSIX; Identifying an Existing Oracle Base Directory in POSIX
Oracle Database Preinstallation Requirements Oracle Database Installation and Deinstallation 3-13 3.3.5.3 Oracle Home Directory The Oracle home directory is the directory where you install the software for a particular Oracle product. When you run the Oracle installation procedure, it prompts you to...
Page 46 - Create or Expand a File System for the Oracle Base Directory
Oracle Database Preinstallation Requirements 3-14 Oracle Database Installation and Administration Guide The directory paths specified on each line identify Oracle home directories. Directory paths that end with the user name of the Oracle software owner are existing Oracle base directories. For the ...
Page 47 - Installing the Oracle Database Software
Installing the Oracle Database Software Oracle Database Installation and Deinstallation 3-15 # chown -R oracle_sw_owner : oracle_installation_group /mount_point/app/ oracle_sw_ owner # chmod -R 775 / mount_point /app/ oracle_sw_owner For example: # mkdir -p /u01/app/orac1120 # chown -R orac1120:orac...
Page 49 - Oracle Database Postinstallation Tasks
Oracle Database Postinstallation Tasks Oracle Database Installation and Deinstallation 3-17 The installation procedure also provides the opportunity to run the installation in a background task. In this case, you must specify the parameters ORACLE-BASE and ORACLE-HOME , otherwise the installation is...
Page 50 - Installing Multiple Oracle Systems
Installing Multiple Oracle Systems 3-18 Oracle Database Installation and Administration Guide ■ Creates the file /var/opt/oracle/oraInst.loc ■ Creates an empty file /var/opt/ortacle/oratab ■ If the product APACHE is installed, then it creates a link in the lib directory of the APACHE installation to...
Page 51 - Creating and Upgrading a Database; Creating a Database
4 Creating and Upgrading a Database 4-1 4 Creating and Upgrading a Database This chapter describes how to create a new 11.2 database or upgrade an existing database to release 11.2. It contains the following topics: ■ Creating a Database ■ Upgrading a Database Note: Creating a Java enabled database ...
Page 58 - Upgrading a Database
Upgrading a Database 4-8 Oracle Database Installation and Administration Guide 4.1.3.9 Installing Oracle Text Usage and installation of Oracle Text is summarized in the "Oracle Text" chapter of this book. 4.1.3.10 Installing Java Using and installing of Java is summarized in the chapter "...
Page 61 - Administering Oracle Database
5 Administering Oracle Database 5-1 5 Administering Oracle Database This chapter describes how to administer Oracle Database 11 g Release 2 for BS2000/OSD. Common administration tasks are described in the following sections: ■ Using the SQL*Plus Utility ■ Startup and Parameter Files ■ Remote Startup...
Page 63 - Startup and Parameter Files
Star tup and Parameter Files Administering Oracle Database 5-3 5.1.5 Using an Editor in SQL*Plus Start a text editor in SQL*Plus with the EDIT command, if you want to edit an SQL statement. If you run SQL*Plus in the native BS2000 environment, then the only editor supported is BS2000 EDT . If you ru...
Page 64 - The Environment Definition File ORAENV; Using the Correct Initialization File
Star tup and Parameter Files 5-4 Oracle Database Installation and Administration Guide ■ The Server Parameter File SPFILE ■ Using the Correct Initialization File 5.2.1 The Environment Definition File ORAENV The ORAENV file is identified by sid .P.ORAENV , where SID is the database identifier. The sa...
Page 65 - Remote Startup of a Database Instance
Remote Star tup of a Database Instance Administering Oracle Database 5-5 with no PFILE clause, Oracle locates the initialization parameter file by examining file names in the following order: 1. sid .DBS.SPFILE.ORA 2. DBS.SPFILE.ORA 3. sid .DBS.INIT.ORA If you want to use some other initialization f...
Page 66 - Automatic Diagnostic Repository; Automatic Diagnostic Repository Directories and Files
Automatic Diagnostic Repository 5-6 Oracle Database Installation and Administration Guide 5. Execute SQL*Plus on the remote computer and connect as user sys to a server of the instance you want to startup. In the following example, which shows the commands for SQL*Plus on a UNIX client, we use the n...
Page 68 - Checking the Integrity of the Physical Data Structure
Checking the Integrity of the Physical Data Structure 5-8 Oracle Database Installation and Administration Guide You can either select the preferred text editor by setting the environment variable EDITOR before starting ADRCI or specify your preferred text editor within ADRCI with the ADRCI set edito...
Page 69 - Backing Up and Recovering a Database; Backing Up an Oracle Database
6 Backing Up and Recovering a Database 6-1 6 Backing Up and Recovering a Database This chapter supplements the generic Oracle Database documentation set with information about backup and recovery. Refer to the following Oracle manuals for detailed information about database backup and recovery: ■ Or...
Page 70 - Recovering Databases
Recovering Databases 6-2 Oracle Database Installation and Administration Guide 2. To ensure that all Oracle database files are synchronized at the time of the backup, shut down Oracle database using SQL*Plus. 3. Back up all database files and log files using the BS2000 ARCHIVE utility or the BS2000 ...
Page 71 - Recovery Manager
Recovery Manager Backing Up and Recovering a Database 6-3 While Oracle database is running, the names of all files which it comprises can be determined by querying the table V$DATAFILE . Enter the following command when the SQL prompt is displayed: SQL> select file#,name FROM V$DATAFILE; The foll...
Page 73 - Tuning Oracle Database
7 Tuning Oracle Database 7-1 7 Tuning Oracle Database Careful tuning can dramatically increase the speed of an Oracle database. This chapter describes how you can monitor and tune the system for optimal performance of Oracle database. For a general discussion of performance and tuning issues, refer ...
Page 75 - openUTM Product Set; Operation of Oracle Database Using openUTM Programs; Distributed openUTM Files
8 openUTM Product Set 8-1 8 openUTM Product Set This chapter describes how to use the BS2000/OSD transaction monitor openUTM for coordinated interoperation with Oracle Database 11 g Release 2 (11.2). The following areas are covered: ■ Operation of Oracle Database Using openUTM Programs ■ Distributed...
Page 76 - Developing an Oracle Database/openUTM Application
Installing 8-2 Oracle Database Installation and Administration Guide ■ The following files provide examples of procedures and programs: UTM.DEMO.P.COMPILE.C UTM.DEMO.P.COMPILE.COBOL UTM.DEMO.P.KDCDEF UTM.DEMO.P.KDCROOT UTM.DEMO.P.PROBIND UTM.DEMO.P.PROSTRT UTM.DEMO.CSELEMP.PC UTM.DEMO.SELDEP.PCO UTM...
Page 83 - Oracle Database SYS Account Tables
Troubleshooting openUTM Product Set 8-9 The following example shows a trace file for an application's task '1234' that was opened on April 2nd 1999. The DB field for this application was not specified in the open string when the resource manager was opened ORAXALOG.1234-NULL-990402.TRC The following...
Page 85 - Oracle Net Services; Introducing Oracle Net Services
9 Oracle Net Services 9-1 9 Oracle Net Services This chapter describes Oracle Net Services and it’s implementation in the BS2000/OSD environment. It supplements the Oracle Database Net Services Administrator's Guide with BS2000/OSD-specific information about the following topics: ■ Introducing Oracl...
Page 88 - Shared Server Architecture
Shared Server Architecture 9-4 Oracle Database Installation and Administration Guide ■ Is used for local connections where an Oracle Database client application, such as SQL*Plus, communicates with an Oracle Database instance running on the same computer. ■ Only works in Dedicated Server mode. It ca...
Page 89 - Oracle Advanced Security
Oracle Advanced Security Oracle Net Services 9-5 information in the following shared server dynamic tables to help you arrive at your decision: ■ V$DISPATCHER ■ V$QUEUE ■ V$SHARED_SERVERS ■ V$SHARED_SERVER_MONITOR For more information about these tables, refer to the Oracle Database Administrator's ...
Page 90 - Configuring the Network
Configuring the Network 9-6 Oracle Database Installation and Administration Guide The value of each of these parameters can be either a list of algorithm names in parenthesis separated by commas or a single algorithm name. The default crypto checksum type is MD5, while the encryption defaults to all...
Page 93 - Testing the Configuration on the Client; Troubleshooting Oracle Net Services
Troubleshooting Oracle Net Ser vices Oracle Net Services 9-9 9.4.5 Configuration on the Client Configuration of network clients involves adding or editing parameters in the client configuration file SQLNET.ORA and dependent on the used naming method, the configuration file LDAP.ORA or TNSNAMES.ORA ....
Page 95 - Oracle Text; Installing Oracle Text; Starting Oracle Text utilities
10 Oracle Text 10-1 10 Oracle Text This chapter describes how to install and run Oracle Text and the restrictions of this option on BS2000/OSD. 10.1 Installing Oracle Text When you follow the procedures explained in chapter 4 about creating an Oracle Database 11 g Release 2 database the result is no...
Page 96 - Restrictions of Oracle Text on BS2000/OSD
Restrictions of Oracle Text on BS2000/OSD 10-2 Oracle Database Installation and Administration Guide 10.3 Restrictions of Oracle Text on BS2000/OSD Due to ASCII-EBCDIC and other dependencies, the following restrictions are inherent: ■ No index themes, that is CTX_DDL.set_attribute (' DEFAULT_LEXER '...
Page 97 - External Procedures; Loading External Procedures
11 External Procedures 11-1 11 External Procedures This chapter describes how to create an environment on BS2000/OSD, where external procedure calls can operate. It complements the chapter about External Routines in the Fundamentals section of Oracle Database Advanced Application Developer's Guide ....
Page 99 - Java in the Database
12 Java in the Database 12-1 12 Java in the Database This chapter describes BS2000-specific features for Java in the database. This chapter includes: ■ Installation of a Java Enabled Database ■ Database character sets and Java Encodings ■ Java Demonstration Files For more information, refer to the O...
Page 100 - Database character sets and Java Encodings; Java Demonstration Files
Database character sets and Java Encodings 12-2 Oracle Database Installation and Administration Guide BS2000 PAM files in ascii can be created by transferring files (FTP) from an ascii platform to BS2000 in binary mode. The distinction between a native BS2000 file name and a POSIX file name is made ...
Page 103 - XML; Installation of Xdk
13 XML 13-1 13 XML This chapter describes BS2000 specific topics of XML such as installation, features, and restrictions. For more information refer to Oracle XML Developer's Kit Programmer's Guide , Oracle XML DB Developer's Guide , Oracle Database XML C API Reference , Oracle Database XML C++ API ...
Page 105 - Oracle Management Agent; Preinstallation Issues
14 Oracle Management Agent 14-1 14 Oracle Management Agent This chapter describes the Oracle Management Agent for BS2000/OSD and provides installation and configuration information. The reader is supposed to be familiar with Oracle Enterprise Manager. The Oracle Management Agent for BS2000/OSD is re...
Page 106 - Running the Installation Script
Running the Installation Script 14-2 Oracle Database Installation and Administration Guide The following table describes the parameters in the format: Parameter Description ORACLE_SID system identifier of the database ORACLE_HOME Oracle home directory under POSIX ORACLE_DATA user ID where the databa...
Page 107 - Running the Agent
Running the Agent Oracle Management Agent 14-3 To finalize the EM Agent installation login as root and execute the following script: $EMDROOT/root.sh The installation of the Management Agent, can also be operated by a background process. In this case, the parameters EMDROOT , EM-AGENT-PORT , EM-OMS-...
Page 108 - Troubleshooting
Restrictions 14-4 Oracle Database Installation and Administration Guide 14.4 Restrictions The following is a list of issues that might affect Oracle Enterprise Manager Agent ■ Oracle Management Agent for BS2000/OSD can monitor servers that are running Oracle Database 10 g or Oracle Database 11 g . ■...
Page 111 - Oracle on SQ Server
15 Oracle on SQ Server 15-1 15 Oracle on SQ Server This chapter describes features, which are specific to Oracle Database for BS2000/OSD SQ Server: ■ Concepts ■ Definitions ■ Product Set ■ Hardware Requirements ■ Software Requirements ■ Address Space Limit ■ Installing Oracle Database Software ■ Dat...
Page 112 - Hardware Requirements; Software Requirements
Definitions 15-2 Oracle Database Installation and Administration Guide 15.2 Definitions Because there are two Oracle editions for BS2000, that is, one for the /390 series and one for the SQ series, the following definitions are introduced to avoid confusion: Oracle edition Meaning Oracle for BS2000/...
Page 113 - Address Space Limit; Upgrade and Migration
Oracle application programs Oracle on SQ Server 15-3 15.6 Address Space Limit A user's address space should not be less than 512 MB. Oracle recommends loading the x86-64 version of BS2000 DSSM "CRTE-BASYS" (= CRTEBASK) to reduce memory requirements. 15.7 Installing Oracle Database Software R...
Page 115 - Oracle Error Messages for BS2000/OSD
A Oracle Error Messages for BS2000/OSD A-1 A Oracle Error Messages for BS2000/OSD This appendix lists Oracle Database 11 g Release 2 for Fujitsu BS2000/OSD messages with possible causes and suggested actions. The messages shown in this chapter may be accompanied by additional text when displayed on ...
Page 133 - Oracle Environment Variables
B Oracle Environment Variables B-1 B Oracle Environment Variables This appendix describes variables that can be specified in the ORAENV file or the POSIX shell. Oracle parameters, such as ORACLE_SID and NLS_LANG , may be specified in the ORAENV file or POSIX shell.If you use a ORAENV file, then you ...
Page 134 - B.3 General Variables
Built-in Variables B-2 Oracle Database Installation and Administration Guide ■ When variable assignments refer to other variables, BS2000 command file substitution syntax applies. Substitution takes place when a variable is actually used, not when it is read from the ORAENV file. For example: ORAUID...
Page 137 - B.4 DBA Startup Variables
DBA Star tup Variables Oracle Environment Variables B-5 Format: PRINTPAR = print-options Classification: USER B.3.10 SQLPATH This variable specifies a path where SQL*Plus looks for command files. Elements of the path are separated by semicolons (;). For example: SQLPATH=PRIVATE;$ORAC1120 This assign...
Page 141 - B.5 Oracle Net Services Variables
Oracle Net Ser vices Variables Oracle Environment Variables B-9 B.4.16 SGA_BASE This variable gives the address where the SGA is mapped into memory, and must represent a megabyte-boundary. Format: SGA_BASE = address Classification: DBA Default: SGA_BASE = 190M Note: The value of SGA_BASE is read fro...
Page 143 - Initialization Parameters and the Parameter; C.1 Example Parameter File
C Initialization Parameters and the Parameter File C-1 C Initialization Parameters and the Parameter File Every time SQL*Plus starts an Oracle Database instance, it uses a set of parameters which specify the characteristics of the instance's operation. These parameters are kept in a file, typically ...
Page 147 - Troubleshooting; D.1 Problems Installing Oracle Database 11; D.2 Problems Starting a Database
D Troubleshooting D-1 D Troubleshooting This section describes problems that you may encounter when using the Oracle Database 11 g Release 2 on BS2000, and provides you with information about how to diagnose and overcome such problems. To solve a problem, identify the type of the problem and locate ...
Page 148 - D.3 Problems Accessing the Database; D.3.1 Problems with Database and Log files
Problems Accessing the Database D-2 Oracle Database Installation and Administration Guide ■ Did you get an ORA-05032 error with no extra information? When you attempt to start a database and the startup fails, you sometimes get an ORA-05032 message and not much other information. This indicates that...
Page 149 - Trace Files
Problems Accessing the Database Troubleshooting D-3 ■ Does the file exist? ■ Is the file accessible to the program which is trying to open it? ■ Is there a hardware problem? ■ Did you specify the correct block size? If you specified the ORAENV environment variable, SF_PBLKSIZE , at database creation...
Page 151 - File Types and Names Used by Oracle
E File Types and Names Used by Oracle E-1 E File Types and Names Used by Oracle The following is a list of file types and names used by Oracle. sid.DBS.xxx.DBF Database files such as sid . DBS . CONTROL . DBF , sid . DBS . DATABASE1 . DBF , or sid . DBS . LOG1 . DBF contain the entire Oracle databas...
Page 153 - Index
Index-1 Index A Address Space, 2-5administration utility SQL*Plus, 5-1 Architecture Oracle Server, 2-1 Archiving, 1-4AUDIT_FILE_DEST, C-2 B BACKGROUND_DUMP_DEST, C-1BCAM, 9-10Bequeath adapter, 9-3BGJ_LOG_JOBSTART, B-6BGJPAR, 7-1, B-6Bigfile Tablespaces, 2-5 C CE8BS2000, 12-2CIRCUITS, 9-4CL8BS2000, 1...
