User`s guide

Startup and Parameter Files
Administering Oracle Database 5-3
5.1.5 Using an Editor in SQL*Plus
Start a text editor in SQL*Plus with the EDIT command, if you want to edit an SQL
statement.
If you run SQL*Plus in the nat
ive BS2000 environment, then the only editor supported
is BS2000
EDT .
If you run SQL*Plus in a POSIX shell, then
the default editor depends on the terminal
connected with your POSIX session. If the POSIX shell is started on a blockmode
terminal, then the default editor in SQL*Plus is set to
edtu . If the POSIX shell is started
by a remote X-client through
rlogin or ssh using a xterm terminal, then the default
editor in SQL*Plus is set to
vi .
SQL*Plus provides the opportunity to define a preferred text editor with the
DEFINE _
EDITOR
command. In the BS2000 environment, SQL*Plus accepts any editor you
specify in the
DEFINE _EDITOR command, but the called editor is always the EDT . In the
POSIX environment you can define a preferred editor. For example, if you want to
define the editor, used by the
EDIT command, to be the POSIX editor edtu , then enter
the following command in SQL*Plus:
DEFINE _EDITOR = edtu
Note:
■ The editor in the BS2000 environment is always the EDT .
■ The editor vi does not work on blockmode terminals.
■ The editor edtu does not work on xterm terminals.
5.1.6 Customizing SQL*Plus Profiles
The DBA can update the global SQL*Plus profile file,
$ORAC1120.SQLPLUS.ADMIN.GLOGIN.SQL , which is run when a user logs in to SQL*Plus.
This file is run before the user's local
LOGIN.SQL and is provided to enable sites to set
up several defaults useful to all users. You can place any SQL and SQL*Plus statement
in
GLOGIN.SQL .
See Also: SQL*Plus User's Guide and Reference for more information
about customizing SQL*PLUS profiles
5.2 Startup and Parameter Files
Oracle uses two parameter files when starting the database:
1. The ORAENV file, the environment definition file, which contains BS2000-specific
information. In the
ORAENV file you identify the database to be started, or shut
down. You can use this file to set configuration variables, which adapt the Oracle
Database to the local operating system and application environment.
2. The initialization file INIT.ORA or the server parameter file SPFILE , which exists in
all Oracle Database implementations and contains database-specific parameters.
This section describes the following:
■ The Environment Definition File ORAENV
■ The Initialization File INIT.ORA