Siemens BS2000/OSD Guía de usuario

Oracle® DatabaseInstallation and Administration Guide 11g Release 2 (11.2) for Fujitsu BS2000/OSD E27508-03July 2014

xE File Types and Names Used by Oracle

Database character sets and Java Encodings12-2 Oracle Database Installation and Administration GuideBS2000 PAM files in ascii can be created by trans

Java Demonstration FilesJava in the Database 12-3An example with database connection using the server-side internal driver is shipped under:$ORAC1120

Java Demonstration Files12-4 Oracle Database Installation and Administration Guide

13XML 13-113 XML This chapter describes BS2000 specific topics of XML such as installation, features, and restrictions. For more information refer

Features and Restrictions13-2 Oracle Database Installation and Administration Guide PL/SQL File output is written to POSIX with ASCII-Data Format.

14Oracle Management Agent 14-114Oracle Management AgentThis chapter describes the Oracle Management Agent for BS2000/OSD and provides installation an

Running the Installation Script14-2 Oracle Database Installation and Administration GuideThe following table describes the parameters in the format:P

Running the AgentOracle Management Agent 14-3To finalize the EM Agent installation login as root and execute the following script: $EMDROOT/root.sh

Restrictions14-4 Oracle Database Installation and Administration Guide14.4 RestrictionsThe following is a list of issues that might affect Oracle En

TroubleshootingOracle Management Agent 14-5Here you find the TSNs of the tasks involved in the PTHREADS application. You can connect to the PTHREADS

xiPrefaceThis manual and Oracle Database User's Guide for Fujitsu BS2000/OSD, form a system-specific set of manuals that provide installation, ma

Troubleshooting14-6 Oracle Database Installation and Administration Guide

15Oracle on SQ Server 15-115Oracle on SQ ServerThis chapter describes features, which are specific to Oracle Database for BS2000/OSD SQ Server: Conc

Definitions15-2 Oracle Database Installation and Administration Guide15.2 DefinitionsBecause there are two Oracle editions for BS2000, that is, one

Oracle application programsOracle on SQ Server 15-315.6 Address Space LimitA user's address space should not be less than 512 MB. Oracle recomm

openUTM Product Set15-4 Oracle Database Installation and Administration GuideApplication programs, which have been developed on /390 systems can run

AOracle Error Messages for BS2000/OSD A-1A Oracle Error Messages for BS2000/OSD This appendix lists Oracle Database 11g Release 2 for Fujitsu BS2000/

A-2 Oracle Database Installation and Administration GuideORA-05004: Fatal error: stack overflow, extension failedCause: A call to a function require

Oracle Error Messages for BS2000/OSD A-3Action: Correct the file name and re-run the program.ORA-05014: sfcopy: non-matching block sizeCause: In a

A-4 Oracle Database Installation and Administration GuideCause: An attempt was made to read a block of an Oracle Database file that does not exist.

Oracle Error Messages for BS2000/OSD A-5Action: Ensure that the ORAENV variable assignments are correct. If you cannot identify the cause of the pro

Type Meaning/UsageGeneric This is the primary Oracle Database documentation, which describes how the product works and how it is used. Use this type o

A-6 Oracle Database Installation and Administration GuideCause: The archiver process was unexpectedly interrupted.Action: If you cannot identify th

Oracle Error Messages for BS2000/OSD A-7ORA-05054: invalid or missing PGA_SIZE Cause: An invalid value for the PGA_SIZE environment variable has bee

A-8 Oracle Database Installation and Administration GuideAction: This value is not normally needed. If specified, it must be a hexadecimal value giv

Oracle Error Messages for BS2000/OSD A-9ORA-05072: cannot enable post/wait item Cause: Probable operating system error.Action: Contact the Oracle S

A-10 Oracle Database Installation and Administration GuideAction: Re-link the UTM application. If the error persists, then contact the Oracle Suppor

Oracle Error Messages for BS2000/OSD A-11Action: Ensure that the ORALOAD link name identifies the correct ORALOAD library. Then restart the program.

A-12 Oracle Database Installation and Administration GuideCause: In the start parameters there must be at least one open string for the Oracle Datab

Oracle Error Messages for BS2000/OSD A-13ORA-05143: Mismatch in TA for User(s) zCause: In the UTM warmstart there is a mismatch between openUTM, and

A-14 Oracle Database Installation and Administration GuideCause: In the start parameters for the Oracle Database there is a syntax error.Action: Re

Oracle Error Messages for BS2000/OSD A-15Action: You should not normally need to specify this variable, as the default value is correct. Contact the

xiii Command SyntaxItem SyntaxCommands This font identifies text which must be entered exactly as shown:set echo offVariables Variables appear in ital

A-16 Oracle Database Installation and Administration GuideCause: The user-side stub module could not load the PRO/OCI module. In this case, the mess

Oracle Error Messages for BS2000/OSD A-17Action: If you cannot identify the cause of the problem, then contact the Oracle Support Services Represent

A-18 Oracle Database Installation and Administration Guide

BOracle Environment Variables B-1B Oracle Environment VariablesThis appendix describes variables that can be specified in the ORAENV file or the POSI

Built-in VariablesB-2 Oracle Database Installation and Administration Guide When variable assignments refer to other variables, BS2000 command file

General VariablesOracle Environment Variables B-3B.3.1 CLN_BASEThis variable specifies the address of the shared code pool of customer written datab

General VariablesB-4 Oracle Database Installation and Administration GuideFormat: EXP_CLIB_FILE_IO=FALSEClassification: USERDefault: EXP_CLIB_FILE_IO

DBA Startup VariablesOracle Environment Variables B-5Format: PRINTPAR=print-optionsClassification: USERB.3.10 SQLPATHThis variable specifies a path

DBA Startup VariablesB-6 Oracle Database Installation and Administration GuideB.4.2 BGJPARThis variable specifies the parameters for the ENTER-PROCE

DBA Startup VariablesOracle Environment Variables B-7Syntax: sid is a string of at the most 4 alphanumeric charactersuserid is a string of at most 8

xiv

DBA Startup VariablesB-8 Oracle Database Installation and Administration GuideClassification: DBADefault: KNL_BASE=72MB.4.12 ORACLE_HOME The Oracle

Oracle Net Services VariablesOracle Environment Variables B-9B.4.16 SGA_BASE This variable gives the address where the SGA is mapped into memory, an

Oracle Net Services VariablesB-10 Oracle Database Installation and Administration GuideB.5.4 TNS_UPDATE_IPNODE This variable forces the Oracle Net s

CInitialization Parameters and the Parameter File C-1C Initialization Parameters and the Parameter FileEvery time SQL*Plus starts an Oracle Database

Additional Notes on Initialization ParametersC-2 Oracle Database Installation and Administration Guidevalue for this parameter is the current BS2000

Additional Notes on Initialization ParametersInitialization Parameters and the Parameter File C-3C.3.6 DB_FILESIf you plan to create a large databas

Additional Notes on Initialization ParametersC-4 Oracle Database Installation and Administration Guide

DTroubleshooting D-1D TroubleshootingThis section describes problems that you may encounter when using the Oracle Database 11g Release 2 on BS2000, a

Problems Accessing the DatabaseD-2 Oracle Database Installation and Administration Guide Did you get an ORA-05032 error with no extra information?Wh

Problems Accessing the DatabaseTroubleshooting D-3 Does the file exist? Is the file accessible to the program which is trying to open it? Is there

1Release Notes 1-11 Release Notes This chapter describes the features of Oracle Database on Fujitsu BS2000/OSD. The following topics are covered in

Problems Accessing the DatabaseD-4 Oracle Database Installation and Administration Guide

EFile Types and Names Used by Oracle E-1EFile Types and Names Used by OracleThe following is a list of file types and names used by Oracle.sid.DBS.xx

E-2 Oracle Database Installation and Administration GuideL.sid.xxx.LOG To be removed after successful installation, for example, L.sid.CATALOG.LOG.OR

Index-1 IndexAAddress Space, 2-5administration utilitySQL*Plus, 5-1ArchitectureOracle Server, 2-1Archiving, 1-4AUDIT_FILE_DEST, C-2BBACKGROUND_DU

Index-2GGlobalization Support, 1-4GLOGIN.SQL, 5-3HHOST, 5-2IIMP_CLIB_FILE_IO, B-4Import, 1-4Initialization parametersCIRCUITS, 9-4DB_FILE_MULTIB

Index-3 S.E.tsn.YYYY-MM-DD.hh.mm.ss, E-1SF_PBLKSIZE, B-8SGA_BASE, B-9SGA_MAX_SIZE, C-3shared code pool, B-7SHARED_SERVER_SESSIONS, 9-4SHARED_SERV

Index-4

Features not Supported1-2 Oracle Database Installation and Administration Guide Oracle RAC One Node Oracle Real Application Clusters (Oracle RAC)1.

Known Restrictions, Problems, and WorkaroundsRelease Notes 1-3 Oracle Data Pump Import and Oracle Data Pump Export Globalization Support Oracle Ca

Known Restrictions, Problems, and Workarounds1-4 Oracle Database Installation and Administration Guide1.4.7 Oracle SchedulerExternal Jobs are not su

Known Restrictions, Problems, and WorkaroundsRelease Notes 1-5 If you use the SQL*Plus -s option, then it must be the first option entered at the pr

Oracle Database Installation and Administration Guide, 11g Release 2 (11.2) for Fujitsu BS2000/OSD E27508-03Copyright © 2007, 2014, Oracle and/or its

Known Restrictions, Problems, and Workarounds1-6 Oracle Database Installation and Administration Guide Dynamic, or Private Ports, or both, from 4915

2Architecture and Implementation 2-12 Architecture and Implementation This chapter describes the Oracle Database system architecture for Fujitsu BS20

Basic Structures2-2 Oracle Database Installation and Administration GuideTherefore, Oracle Database 11g Release 2 for BS2000/OSD requires the POSIX f

Note: Both the BS2000/OSD operating system and Oracle Database perform input and output efficiently in units called blocks. A block is the basic unit

Basic Structures2-4 Oracle Database Installation and Administration Guide2.2.3 Oracle-Managed FilesThe following is a list of the INIT.ORA parameter

See Also: Refer to "Using Oracle Managed Files" in Oracle Database Administrator's Guide for more information about file name formatsA

Oracle Database Environment Definition File2-6 Oracle Database Installation and Administration GuideFigure 2–1 Placement of Data Areas in Background

Oracle Database Environment Definition FileArchitecture and Implementation 2-72.5.2 Oracle Environment VariablesAppendix B, "Oracle Environment

Note: The Oracle variable BGJPAR is not set after running the .profile.oracle. If you do not set this variable, then the default value, BGJPAR=START=

User ID RequirementsArchitecture and Implementation 2-92.6 The ORALOAD LibraryThe ORALOAD library ($ORAC1120.ORALOAD.LIB by default) is required to

iii ContentsPreface ...

User ID Requirements2-10 Oracle Database Installation and Administration Guide You must not use the BS2000/OSD System Administrator user ID TSOS as

User ID RequirementsArchitecture and Implementation 2-11USER-ACC=OWNER-ONLY, ACCESS=WRITE the POSIX user for the DBA user ID must be initialized wit

User ID Requirements2-12 Oracle Database Installation and Administration Guide

3Oracle Database Installation and Deinstallation 3-13 Oracle Database Installation and Deinstallation This chapter describes preinstallation requirem

See Also: Oracle Database Licensing Information for more licensing informationOracle Database Preinstallation Requirements3-2 Oracle Database Instal

Oracle Database Preinstallation RequirementsOracle Database Installation and Deinstallation 3-3 To determine the user address space limit, log in to

Oracle Database Preinstallation Requirements3-4 Oracle Database Installation and Administration Guide BS2000 file system:Item Disk SpaceSoftware 1.0

Oracle Database Preinstallation RequirementsOracle Database Installation and Deinstallation 3-53.3.2.1 Operating System and Communication System Req

Oracle Database Preinstallation Requirements3-6 Oracle Database Installation and Administration GuideThe POSIX administrator or BS2000 system adminis

Oracle Database Preinstallation RequirementsOracle Database Installation and Deinstallation 3-73.3.2.4 Additional BS2000 Software ComponentsThe foll

iv2 Architecture and Implementation 2.1 Operating System Environment ...

Oracle Database Preinstallation Requirements3-8 Oracle Database Installation and Administration Guide CRTE V2.8E CRTE V2.93.3.2.6 Additional Softw

Oracle Database Preinstallation RequirementsOracle Database Installation and Deinstallation 3-93.3.3.4 Checking Loopback AddressCheck if the file $T

Oracle Database Preinstallation Requirements3-10 Oracle Database Installation and Administration GuideThe inst_group parameter shows the group name o

Oracle Database Preinstallation RequirementsOracle Database Installation and Deinstallation 3-11/SHOW-POSIX-USER-ATTRIBUTESIf the output shows defaul

Note: The installation user ID and the installation group must have read, write and execute permissions to the subdirectory app. During Oracle Data

Oracle Database Preinstallation RequirementsOracle Database Installation and Deinstallation 3-133.3.5.3 Oracle Home DirectoryThe Oracle home directo

Oracle Database Preinstallation Requirements3-14 Oracle Database Installation and Administration Guide The directory paths specified on each line ide

Installing the Oracle Database SoftwareOracle Database Installation and Deinstallation 3-15# chown -R oracle_sw_owner:oracle_installation_group /moun

Installing the Oracle Database Software3-16 Oracle Database Installation and Administration GuideIf you have stored the staging library in a differen

Oracle Database Postinstallation TasksOracle Database Installation and Deinstallation 3-17The installation procedure also provides the opportunity to

v 3.3.2.3 Package Requirements... 3-63.3.2.4 Additiona

Installing Multiple Oracle Systems3-18 Oracle Database Installation and Administration Guide Creates the file /var/opt/oracle/oraInst.loc Creates a

4Creating and Upgrading a Database 4-14 Creating and Upgrading a Database This chapter describes how to create a new 11.2 database or upgrade an exis

Note: The value of ADDRSPACE must be at least 512 MB.Creating a Database4-2 Oracle Database Installation and Administration Guide3. Oracle recommend

Creating a DatabaseCreating and Upgrading a Database 4-3Unless specified otherwise, $ORAC1120.INSTALL.P.SUPER generates and enter a batch job which:

Creating a Database4-4 Oracle Database Installation and Administration Guide Creates the system and sysaux tablespace Creates the default permanent

Creating a DatabaseCreating and Upgrading a Database 4-5/CALL-PROCEDURE $ORAC1120.INSTALL.P.DBAThis procedure prompts you for the following informati

Creating a Database4-6 Oracle Database Installation and Administration GuideDatabase block size given in the init.ora parameter DB_BLOCK_SIZE, refer

Creating a DatabaseCreating and Upgrading a Database 4-74.1.3.3 Installing Data Dictionary ViewsData dictionary views provide easy access to diction

Upgrading a Database4-8 Oracle Database Installation and Administration Guide4.1.3.9 Installing Oracle TextUsage and installation of Oracle Text is

Upgrading a DatabaseCreating and Upgrading a Database 4-94. Enter the following command to create an Oracle Database 11g Release 2 init.ora and an Or

vi4.2.1 Upgrade from Version 9 ... 4-84.2.2 Upgrad

Upgrading a Database4-10 Oracle Database Installation and Administration GuideRe-compilation of C and COBOL Programmatic Interface ProgramsAll C and

5Administering Oracle Database 5-15 Administering Oracle Database This chapter describes how to administer Oracle Database 11g Release 2 for BS2000/O

Using the SQL*Plus Utility5-2 Oracle Database Installation and Administration Guide5.1.2 Calling SQL*Plus from a ProcedureSet Task Switch 1 to on (/

Startup and Parameter FilesAdministering Oracle Database 5-35.1.5 Using an Editor in SQL*PlusStart a text editor in SQL*Plus with the EDIT command,

Startup and Parameter Files5-4 Oracle Database Installation and Administration Guide The Server Parameter File SPFILE Using the Correct Initializat

Remote Startup of a Database InstanceAdministering Oracle Database 5-5with no PFILE clause, Oracle locates the initialization parameter file by exami

Automatic Diagnostic Repository5-6 Oracle Database Installation and Administration Guide5. Execute SQL*Plus on the remote computer and connect as use

Automatic Diagnostic RepositoryAdministering Oracle Database 5-7Within ADR base, there can be multiple ADR homes, where each ADR home is the root dir

Checking the Integrity of the Physical Data Structure5-8 Oracle Database Installation and Administration GuideYou can either select the preferred tex

6Backing Up and Recovering a Database 6-16 Backing Up and Recovering a Database This chapter supplements the generic Oracle Database documentation se

vii 8.5 Troubleshooting ... 8

Recovering Databases6-2 Oracle Database Installation and Administration Guide2. To ensure that all Oracle database files are synchronized at the time

Recovery ManagerBacking Up and Recovering a Database 6-3While Oracle database is running, the names of all files which it comprises can be determined

Recovery Manager6-4 Oracle Database Installation and Administration Guide

7Tuning Oracle Database 7-17 Tuning Oracle Database Careful tuning can dramatically increase the speed of an Oracle database. This chapter describes

BS2000/OSD-Specific Parameters7-2 Oracle Database Installation and Administration Guide

8openUTM Product Set 8-18 openUTM Product Set This chapter describes how to use the BS2000/OSD transaction monitor openUTM for coordinated interopera

Installing8-2 Oracle Database Installation and Administration Guide The following files provide examples of procedures and programs:UTM.DEMO.P.COMPI

Developing an Oracle Database/openUTM ApplicationopenUTM Product Set 8-3An Oracle Database/openUTM application requires the following information for

Developing an Oracle Database/openUTM Application8-4 Oracle Database Installation and Administration Guidecorresponding programming language compiler

Notes: Remember the following: You can enter the required fields and optional fields in any order when constructing the open string. All field names

viii14 Oracle Management Agent14.1 Preinstallation Issues...

Developing an Oracle Database/openUTM Application8-6 Oracle Database Installation and Administration GuideFor more information about precompilers, sp

Developing an Oracle Database/openUTM ApplicationopenUTM Product Set 8-78.4.2 Using Precompilers with openUTMYou can choose from two options when in

Troubleshooting8-8 Oracle Database Installation and Administration GuideYou can use a character host variable in the AT clause, as the following exam

TroubleshootingopenUTM Product Set 8-9The following example shows a trace file for an application's task '1234' that was opened on Apr

Troubleshooting8-10 Oracle Database Installation and Administration Guide V$GLOBAL_TRANSACTIONNote: For detailed information about how to use these

9Oracle Net Services 9-19 Oracle Net Services This chapter describes Oracle Net Services and it’s implementation in the BS2000/OSD environment. It su

Introducing Oracle Net Services9-2 Oracle Database Installation and Administration Guide9.1.1.2 Using the IPC ProtocolThe IPC protocol allows applic

Introducing Oracle Net ServicesOracle Net Services 9-39.1.3 Using the TCP/IP ProtocolThe TCP/IP protocol support implements a standard interface tha

Shared Server Architecture9-4 Oracle Database Installation and Administration Guide Is used for local connections where an Oracle Database client ap

Oracle Advanced SecurityOracle Net Services 9-5information in the following shared server dynamic tables to help you arrive at your decision: V$DISPA

ix B.4.3 BGJPRC_UID / BGJPRC_SID ... B-6B.4.4 BGJ_LOG_JOBST

Configuring the Network9-6 Oracle Database Installation and Administration GuideThe value of each of these parameters can be either a list of algorit

Configuring the NetworkOracle Net Services 9-7 Testing the Configuration on the Client9.4.1 Using Easy Connect Naming MethodThe Easy Connect naming

Configuring the Network9-8 Oracle Database Installation and Administration GuideThe following example of an ORAENV file configured for a central list

Troubleshooting Oracle Net ServicesOracle Net Services 9-99.4.5 Configuration on the ClientConfiguration of network clients involves adding or editi

Troubleshooting Oracle Net Services9-10 Oracle Database Installation and Administration Guide Check the naming service if the host name returned by

10Oracle Text 10-110 Oracle TextThis chapter describes how to install and run Oracle Text and the restrictions of this option on BS2000/OSD.10.1 Ins

Restrictions of Oracle Text on BS2000/OSD10-2 Oracle Database Installation and Administration Guide10.3 Restrictions of Oracle Text on BS2000/OSDDue

11External Procedures 11-111External Procedures This chapter describes how to create an environment on BS2000/OSD, where external procedure calls can

Loading External Procedures11-2 Oracle Database Installation and Administration GuideThe external C routine has to be compiled and the generated LLM

12Java in the Database 12-112Java in the DatabaseThis chapter describes BS2000-specific features for Java in the database. This chapter includes: In