16
Oracle on SX Server

This chapter describes those features, which are specific for Oracle/BS2000 on SX Server line.

The topics described include:

• Concepts

• Definitions

• Product Set

• Hardware requirements

• Software requirements

• Address space limit

• Installing Oracle Server Software

• Database Creation

• Upgrade/Migration

• Administration

• Oracle application programs

• UTM Product Set

Concepts

The SX server line is a new line of BS2000/OSD business servers which is based on SPARC64 architecture. Oracle Server Release 9.2.0.2.15 supports this innovative line of SX servers (e.g. SX130) and the BS2000 operating system OSD/XC.

Oracle Server Release 9.2.0.2.15 runs in the BS2000 partitions of the SX server.

Oracle 9.2.0.2.15 for SX Server is running in native SPARC mode.
Programs running in this mode provide much better performance than programs running in /390 mode (= compatibility mode).

There are no differences in handling and administration compared to the "conventional" Oracle for BS2000 (on /390 machines).
So the migration from conventional Oracle for BS2000 to Oracle for SX Server is very simple.

All products you know from the /390 port of Oracle (e.g. Oracle Net Services, SQL*Plus, Precompilers) are available in native SPARC mode for the SX Server line.

Definitions

Because there are two Oracle ports for BS2000 (i.e. one for the /390 series and one for the SX series), we will introduce some definitions in order to avoid confusion:

Oracle port	Meaning
Oracle for BS2000/390:	BS2000 port of Oracle, which is running on machines with /390 CPU's (S-machines). This Oracle port can also run on SX Server, but only in the slower /390 mode ("compatibility mode").
	Synonyms: "/390 port of Oracle(BS2000)"
Oracle for BS2000/SPARC:	BS2000 port of Oracle, which is running in native SPARC mode in the BS2000 partition of the SX Server. This Oracle port can't run in the Solaris partition of the SX Server. This Oracle port can't run on /390 CPU's.
	Synonyms: "SPARC port of Oracle(BS2000)" "Oracle for SX Server" "Oracle for SX Server line"

Product Set

All products which are available with the /390 port of Oracle (BS2000) are also available with Oracle for SX Server (see product list in Chapter 1). There are no differences in functionality and production status between the products of these two Oracle/BS2000 ports.

The release numbers of the products of the two Oracle/BS2000 ports are identical with the exception of the last digit:

".10":   Oracle /390 port

".15":   Oracle SPARC port

for example:

Oracle9i Release 2 Server (/390 port):  9.2.0.2.10
Oracle9i Release 2 Server (SPARC port): 9.2.0.2.15

Hardware requirements

SX Server (e.g. SX130)

Main memory: at least 128 MB

Disk Space:

Total static Oracle Server non-database requirements are approximately 350 000 PAM pages. Dynamic requirements (for example, application, SQL files, host language programs, output spool files) depend on Oracle Server usage.

Database Space

No difference to /390 port of Oracle (refer to Chapter 1)

Software requirements

Component	Requirement
Operating System	OSD/XC V1.0 Korrekturpaket 1/03 (includes BS2000/OSD V5.0, SDF, EDT, LMS, CRTE, openNet Server, ....)
Compilers	Though not required to run the Oracle Server, if high-level languages (such as C or COBOL) are used to interface to the Oracle Server, the following compilers are supported:
	COBOL85: V2.3
	COBOL2000: V1.1
	CPP: V3.1
UTM	UTM: V5.1
CRTE	CRTE-BASYS: V1.4B
	CRTE: V2.4B
Communication System	openNet Server V3 including BCAM V17 and Sockets V2.1

Address Space Limit

A user's address space should not be less than 128MB.

We recommend to load the SPARC version of BS2000 DSSM "CRTE-BASYS"
(= CRTEBASP) to reduce memory requirements.

Installing Oracle Server Software

There are almost no differences in installing the Oracle Server Software compared to the /390 port of Oracle:

1. The BS2000 System Administrator needs to create the Oracle installation userid, the userid under which you want the Oracle Server 9.2.0 software to reside. Throughout these release notes we refer to this userid as "$ORACL920". This userid does not require any special BS2000 privileges and should have at least 350 000 PAM pages free.

2. LOGON under your installation userid ($ORACL920).

3. Oracle 9.2.0.2.15 for SX Server is distributed on CD-ROM. Use ARCHIVE to load the contents of the CD-ROM:

      /START-PROGRAM ARCHIVE
   
      FILES NAME=($0920SPRC.,RENAME=$userid.)
   
      IMPORT FROM=(volser),DEVICE=T6250 
   
      END
   
   
   
   

   "volser" is the Volume Serial Number of the CD-ROM (="ORACL1").
   CD-ROM drive has device type "T6250".

   The "RENAME=$userid" parameter is used to specify the installation userid ($ORACL920).

4. Review the .DOC files transferred from the installation CD-ROM, especially the README.DOC file. These text files serve as an online supplement to the printed documentation and provide up-to-date information on this release.

5. Execute the install procedure as follows:

   /CALL-PROCEDURE INSTALL.P.ORACLE,($userid)
   
   

where $userid is your current installation userid.

This procedure applies the necessary changes to a number of command files. If any problems occur, you should inspect the log file and perform any relevant actions.

Database Creation

The creation of a database works exactly as described in the Chapter 4, "Creating/Migrating a Database". You may create a database automatically (by BS2000 procedure INSTALL.P.SUPER) or manually.

There are no differences to the /390 port of Oracle for BS2000.

Upgrade/Migration

see Chapter 4, "Creating/Migrating a Database"

Administration

There are almost no differences in administration to the /390 port of Oracle Server. The only difference is that Oracle on SX server does not support executables ("phases"), but only LLMs. So you must start Oracle programs like SQLPLUS as follows:

/START-PROGRAM *MODULE($ORACL920.ORALOAD.LIB,SQLPLUS,A,A)

Oracle application programs

Oracle for SX Server supports the same programming languages for Oracle application programs as the /390 port of Oracle. There are Precompilers for C/C++ and Cobol.

Oracle application programs can run on SX Servers only in /390 mode.

Application programs have to be linked as described in the "User's Guide".

Application programs which have been developed on /390 machines can run on SX Servers without any changes.

UTM Product Set

The UTM product set of Oracle 9.2.0.2.15 on SX Server requires openUTM V5.1.

There are no differences in developing Oracle/UTM applications in comparison with the /390 port of Oracle (see chapter "Using the Oracle Server under openUTM" in the Oracle9i for Fujitsu Siemens BS2000/OSD User's Guide).