Siemens BS2000/OSD Guía de usuario

Oracle® DatabaseUser's Guide 11g Release 2 (11.2) for Fujitsu BS2000/OSDE27507-02October 2012

xUsing Oracle Database DocumentationThe Oracle Database products that run under BS2000/OSD are identical, in the way in which they are supported, to t

xiTypographic ConventionsThe following text conventions are used in this manual:Command SyntaxPunctuationThe following symbols should always be entere

xiisingle quotation mark'Name Symbol

1Getting Started 1-11 Getting StartedThis chapter provides the BS2000/OSD-specific information that you must use with Oracle Database 11g Release 2 (

The Oracle Database Environment-Definition File1-2 Oracle Database User's Guide/CALL-PROCEDURE $ORAC1120.INSTALL.P.USERwhere $ORAC1120 is the na

Starting Oracle Utilities with BS2000 SDF commandsGetting Started 1-31.2 The ORALOAD LibraryThe ORALOAD library ($ORAC1120.ORALOAD.LIB by default) i

Starting Oracle Utilities in UNIX-Style1-4 Oracle Database User's Guide/START-EXECUTABLE ($ORAC1120.ORALOAD.LIB,program_name)For example, if you

Starting Oracle Utilities in the POSIX environmentGetting Started 1-5Set the variable ORACLE_SID to start an Oracle utility for a specific Oracle ins

Connecting to an Oracle Instance1-6 Oracle Database User's Guide$ SQL> connect / as sysdba1.6 Connecting to an Oracle InstanceYou can connec

Using BS2000 Files for Input and OutputGetting Started 1-71.7 Using BS2000 Files for Input and OutputIn most cases, Oracle Database for BS2000/OSD p

Oracle Database User's Guide, 11g Release 2 (11.2) for Fujitsu BS2000/OSD E27507-02Copyright © 2007, 2012, Oracle and/or its affiliates. All righ

Using BS2000 Files for Input and Output1-8 Oracle Database User's Guide1.7.6 Fixed Link NamesOracle Database 11g Release 2 (11.2) for BS2000/OS

2Oracle Database Utilities 2-12 Oracle Database UtilitiesThis chapter describes how you start the following Oracle Database utilities: SQL*Loader

The Export Utility2-2 Oracle Database User's GuideSTART-PROGRAM $ORAC1120.SQLPLUS* SCOTT/passwordSQL> START $ORAC1120.RDBMS.DEMO.ULCASE1 2. S

The Import UtilityOracle Database Utilities 2-3When exporting a large volume of data, the default disk-space allocation for the output file will be i

The Data Pump Export Utility2-4 Oracle Database User's Guide2.3.1 Starting the Import UtilityTo start the Import utility, IMP, enter the follow

Oracle Text LoaderOracle Database Utilities 2-5/START-PROGRAM $ORAC1120.EXPDP* username/password [options]Data Pump Export dump files are created by

Oracle Text Loader2-6 Oracle Database User's Guide

3SQL*Plus 3-13 SQL*PlusSQL*Plus is a general purpose utility used for running SQL commands and PL/SQL blocks, perform database administration, and so

Running SQL*Plus3-2 Oracle Database User's Guide3.1.1.1 The GLOGIN.SQL Global Startup FileThe global startup file GLOGIN.SQL begins whenever an

Running SQL*PlusSQL*Plus 3-3When you press the INTERRUPT key [K2], the Oracle Database stops retrieving rows and returns you to the SQL*Plus command

iiiContentsPreface ...

Specifying the Search Path for SQL*Plus Command Files3-4 Oracle Database User's GuideYou can also use the EDIT command to edit a SQL file by spe

Using SQL*Plus in the POSIX environmentSQL*Plus 3-5SQL> START filenameIf this file cannot be found, then SQL*Plus searches the paths specified by

Using SQL*Plus in the POSIX environment3-6 Oracle Database User's Guide Running Shell Commands From SQL*Plus Using an Editor in SQL*plus3.5.1

4PL/SQL 4-14 PL/SQLPL/SQL is an extension to the SQL language and is used to create, store, modify, retrieve, and manage information in an Oracle dat

PL/SQL Demonstrations4-2 Oracle Database User's GuideTo run these demos, you must first build the demo tables with PLSQL.DEMO.PLS-EXAMPBLD.SQL a

5Programmatic Interfaces 5-15 Programmatic InterfacesThis chapter provides BS2000/OSD-specific information that supplements the documentation for the

Building and Running a Programmatic Interface Application5-2 Oracle Database User's Guide Pro*COBOL (COBOL85 and COBOL2000)Oracle precompilers

Building and Running a Programmatic Interface ApplicationProgrammatic Interfaces 5-37. You can find sample files in the installation user ID: $ORAC11

Building and Running a Programmatic Interface Application5-4 Oracle Database User's GuideWhen you use LMS library elements, the element name you

Pro*C/C++Programmatic Interfaces 5-5In the following example, Pro*C generates a BS2000-ISAM-output file called SAMPLE.C as the ONAME option has been

iv2.2.2.2 Transferring Data by File Transfer... 2-32.3 The Import Utility.

Pro*COBOL5-6 Oracle Database User's Guide$ORAC1120.C.DEMO.*.PC$ORAC1120.UTM.DEMO.*.PC$ORAC1120.CONFIG.PCSCFG.CFGAn example of a compilation and

Pro*COBOLProgrammatic Interfaces 5-7Before precompiling, the statement PERFORM COB-LABEL1 runs the code in paragraph COB-LABEL1 until the COB-LABEL2

The Oracle Call Interface5-8 Oracle Database User's Guide5.4.2 Pro*COBOL Include, System Configuration, and Demo FilesThe Pro*COBOL include fil

The Oracle Call InterfaceProgrammatic Interfaces 5-9COBOL programming languages. OCI calls are fully described in the Oracle Call Interface Programme

The Object Type Translator5-10 Oracle Database User's Guide5.6 The Object Type TranslatorThis section discusses port-specific notes for using t

6Using the Oracle Database Under openUTM 6-16 Using the Oracle Database Under openUTMThis chapter describes the Oracle Database-specific points that

UTM Operations6-2 Oracle Database User's Guidewhich will wait until input comes from the terminal, or to assign the same TACCLASS to subsequent

7Globalization Support 7-17 Globalization SupportThis chapter describes the globalization support available with Oracle Database 11g Release 2 (11.2)

Supported Language Conventions7-2 Oracle Database User's Guide7.1.2 Other Oracle Database ProductsFor the supported Oracle Database products, y

Supported Character SetsGlobalization Support 7-3 Denmark: denmark Finland: finland France: france Germany: germany Hungary: hungary Italy: ita

v5.2.2.2 User-Specific Configuration Files... 5-45.2.2.3 Input, Output,

Location of Message Files7-4 Oracle Database User's GuideThe character sets WE8BS2000, CL8BS2000, WE8BS2000L5, EE8BS2000, CE8BS2000, and WE8BS20

AOracle Error Messages for BS2000/OSD A-1A Oracle Error Messages for BS2000/OSDThis appendix lists the messages of Oracle Database 11g Release 2 (11.

A-2 Oracle Database User's GuideAction: Make sure that your application program runs in ILCS mode. Some programming languages (for example, FOR

Oracle Error Messages for BS2000/OSD A-3ORA-05013: bad filename parseCause: A file name being analysed is not well-formed for Oracle Database purpos

A-4 Oracle Database User's GuideAction: If the error cannot be identified as one caused by a disk malfunction, then either contact the System A

Oracle Error Messages for BS2000/OSD A-5Action: Ensure that the ORASID definition is correct and re-run the program.ORA-05032: bad name parseCause:

A-6 Oracle Database User's GuideAction: Make sure that the user address space is large enough (in the JOIN entry) and that there is no temporar

Oracle Error Messages for BS2000/OSD A-7ORA-05053: invalid or missing PGA_BASECause: An invalid value for the PGA_BASE parameter has been specified

A-8 Oracle Database User's GuideAction: Verify that it is not one of the preceding causes (check with your database administrator). Otherwise,

Oracle Error Messages for BS2000/OSD A-9Cause: Probable operating system error.Action: Contact your Oracle Support Services Representative.ORA-0507

vi7.5 Location of Message Files ... 7-47.6 Li

A-10 Oracle Database User's Guidedifferent from $ORAC1120 and that the installation procedure has not executed correctly.Action: Ensure that th

Oracle Error Messages for BS2000/OSD A-11Action: If this value is specified, then it must be a hexadecimal value giving the full virtual address for

A-12 Oracle Database User's GuideORA-05132: TA for User x is committed by the Resource-ManagerCause: Transaction has been committed before fail

Oracle Error Messages for BS2000/OSD A-13ORA-05142: Error x at End Transaction for User z, Instance yCause: The end of a transaction in instance y i

A-14 Oracle Database User's GuideORA-05153: xa_switch definition not found for specified Resource-Manager: sCause: System error.Action: Contac

Oracle Error Messages for BS2000/OSD A-15Cause: An invalid value for the KNL_SIZE parameter has been specified in the ORAENV file.Action: You shoul

A-16 Oracle Database User's GuideORA-05181: load/init problem with PRO/OCI interfaceCause: The user-side stub module could not load the PRO/OCI

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

A-18 Oracle Database User's Guide

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

viiB.5.4 TNS_UPDATE_IPNODE ... B-10Index

Built-in VariablesB-2 Oracle Database User's Guide When variable assignments refer to other variables, BS2000 command file substitution syntax

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 User's GuideFormat: EXP_CLIB_FILE_IO=FALSEClassification: USERDefault: EXP_CLIB_FILE_IO=TRUEB.3.5 IMP_CLIB

DBA Startup VariablesOracle Environment Variables B-5Format: ORASID=sid (sid is a characterstring where 1 <= length <= 4)Classification: USER,

DBA Startup VariablesB-6 Oracle Database User's Guide A number with no modifiers is interpreted as a decimal number A number followed by K or

DBA Startup VariablesOracle Environment Variables B-7Format: sid_BGJPAR=parametersSyntax: sid is a string of at the most 4 alphanumeric characterspar

DBA Startup VariablesB-8 Oracle Database User's GuideB.4.10 JOBIDThis variable is used internally in identifying the background tasks and gener

Oracle Net Services VariablesOracle Environment Variables B-9Format: SF_PBLKSIZE=2K|4KClassification: DBADefault: 2KB.4.16 SGA_BASE This variable

Oracle Net Services VariablesB-10 Oracle Database User's GuideB.5.3 TNS_BEQ_TIMEOUT This variable specifies the time after which a connection

Index-1IndexSymbols$ command, 3-3AASCII function, 3-4BBGJ_LOG_JOBSTART, B-6BGJPAR, B-6BS2000 commandsfrom SQL*Plus, 3-3BS2000 editorstarting, 3-

viii

Index-2InterruptingSQL*Plus, 3-2JJOBID, B-8KKNL_BASE, B-8LLanguagesspecifying, 7-1supported, 7-2Linguistic definitions, 7-4LOGNAME, B-2MMessage

ixPrefaceThis manual, with the Oracle Database Installation and Administration Guide for Fujitsu BS2000/OSD, forms the system-specific component of a