Oracle SQL*Plus: The Definitive Guide

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, ...