Siemens BS2000/OSD - Manuals

vii 8.5 Troubleshooting .......................................................................................................................... 8-8 8.5.1 Trace Files ............................................................................................................................. 8-8 8...

viii 14 Oracle Management Agent 14.1 Preinstallation Issues ............................................................................................................... 14-1 14.2 Running the Installation Script .........................................................................................

ix B.4.3 BGJPRC_UID / BGJPRC_SID ........................................................................................... B-6 B.4.4 BGJ_LOG_JOBSTART ........................................................................................................ B-6 B.4.5 sid_BGJPAR .........................

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...

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...

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...

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...

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...

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 ...

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...

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...

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...

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...

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...

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....

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 ...

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...

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...

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 ...

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...

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...

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 ...

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...

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...

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...

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 ...

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 "...

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...

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...

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...

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...

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...

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...

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...

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 ...

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...

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 ...

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...

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...

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...

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...

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...

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 ...

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...

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 ....

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...

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 '...

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 ....

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...

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 ...

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 ...

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...

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...

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-...

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 . ■...

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...

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/...

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...

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 ...

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 ...

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...

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...

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...

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 ...

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 ...

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...

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...

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...

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...