The Site and User Profiles
Two script files are executed every
time SQL*Plus is started. These scripts define the site profile and
the user profile, and are named, respectively,
glogin.sql and login.sql.
The Site Profile
The site profile is made up of the commands contained in
glogin.sql, which is the
global
login file, and is
automatically executed every time a user runs SQL*Plus on a given
computer system. The location of glogin.sql
varies from one operating system to the next, but it is always below
the directory containing the SQL*Plus product. On a default Windows
95 installation of Oracle8, glogin.sql may be
found in the following directory:
C:\ORAWIN95\PLUS80
On a typical Unix system, such as the HP-9000, the
glogin.sql file will be found in this directory:
$ORACLE_HOME/sqlplus/admin
The specific version of SQL*Plus you are running makes a difference
as well. If you have multiple versions of SQL*Plus installed, the
default installation procedures will result in your having a separate
glogin.sql file for each. For example, a Windows
95 PC running both SQL*Plus 8.0 and SQL*Plus 3.3 will have a
glogin.sql file in each of the following two
directories:
C:\ORAWIN95\PLUS80 C:\ORAWIN95\PLUS33
The specific file that is executed will depend on which version of SQL*Plus you are running.
Tip
On Windows 95/NT, the PLUSXX registry setting, where XX refers to the
specific SQL*Plus version, points to the location of
glogin.sql. By pointing the PLUS80 and PLUS33 registry settings to the same directory, ...