My Oracle Support Banner

OpenVMS: How to run Client images as Detached Processes (Doc ID 564292.1)

Last updated on APRIL 16, 2024

Applies to:

Precompilers - Version 10.1.0.3 to 10.2.0.2 [Release 10.1 to 10.2]
HP OpenVMS Itanium
HP OpenVMS Alpha
NOTE: In the images and/or the document content below, the object names and the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Goal

 

 

This document provides two examples of running Client images as Detached processes on OpenVMS.

The first example demonstrates the fully supported approach of executing Oracle Client images as Detached processes under the control of a command line interpreter (CLI)

The second example demonstrates the ability to run the same image without a CLI.

The examples are based on the SAMPLE3.PC demonstration file located in ORA_ROOT:[precomp.demo.proc]

If not present, the demonstration files can be installed from the CCD kit.

The example image has been built using the following commands:

      $ @<path>ORAUSER
      $ SET DEFAULT ORA_ROOT:[PRECOMP.DEMO.PROC]
      $ PROC SAMPLE3
      $ CC SAMPLE3/INCLUDE=ORA_ROOT:[PRECOMP.PUBLIC]
      $ LNPROC SAMPLE3

Confirm that this works:

      $ @<path>ORAUSER <sid>
      $ RUN SAMPLE3.EXE

Connected to ORACLE as user: SCOTT

Number Employee Salary
------    --------    -------
7369     SMITH     800.00
7499    ALLEN    1600.00
7521    WARD     1250.00
7566    JONES     2975.00
7654    MARTIN  1250.00

Number Employee Salary
------    --------    -------
7698     BLAKE    2850.00
7782    CLARK    2450.00
7788    SCOTT     3000.00
7839    KING        5000.00
7844    TURNER  1500.00

Number Employee Salary
------    --------     -------
7876    ADAMS    1100.00
7900    JAMES        950.00
7902    FORD        3000.00
7934    MILLER    1300.00

Au revoir.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.