Oracle® Database Administrator's Reference 10g Release 2 (10.2) for hp OpenVMS Part Number B25416-02 |
|
|
View PDF |
This appendix presents some useful tips about managing OpenVMS processes. It contains the following topics:
Section F.1, "Interrupting and Terminating Oracle Operations"
Section F.2, "Running Oracle Programs as Detached Processes"
See Also:
The operating system documentation for more information about these topicsThe following sections explain how to cancel an operation without terminating, how to cancel an operation with the option to continue, and how to disable the control keys.
This section contains the following topics:
To cancel an operation without terminating the Oracle image, press Ctrl+C. The current query is canceled. After pressing Ctrl+C, you may need to press Enter to display the prompt again. You may have to do this when you use a command line tool, such as SQL*Plus.
You can also terminate any Oracle operation by pressing Ctrl+Y. This returns the DCL prompt ($) with a message that Oracle has been interrupted.
To continue the Oracle session, enter CONTINUE
. To terminate the session, type EXIT
.
Entering EXIT
or any other OpenVMS command cancels the query and shuts down the tool. Entering EXIT
causes a noticeable delay before the DCL prompt returns or before the requested OpenVMS command runs because a partial shutdown of the Oracle session occurs.
Sometimes, you may want to run programs as detached processes. For example, you may want to run a Pro*C program while you are logged into SQL*Plus or while doing work unrelated to working with Oracle Database.
A detached process does not inherit the logical names that its parent has. Consequently, when a program executable is passed to the detached process, the detached process stops because it cannot find the logical names referenced by the program.
You can work around this problem by starting the login process LOGINOUT
, which maps DCL into the virtual space of the detached process. This can run a command procedure to run the program in the detached process. The command file should:
Set up the proper execution environment by defining the referenced logical names, symbols, and defaults.
Start the program to be run. For example:
$ RUN/DETACH/INPUT=TEST.COM/OUTPUT=TEST.LOG SYS$SYSTEM:LOGINOUT
In this command, TEST.COM
is:
$ @DISK$TEST:[ORACLE10g]ORAUSER SID $ RUN myprog.EXE
You may need to include certain process quotas to map DCL into the detached process's virtual space.
See Also:
The operating system documentation for more information