My Oracle Support Banner

User Cannot Locate or Use SQLPlus LOGIN.SQL or GLOGIN.SQL (Doc ID 1017808.6)

Last updated on MAY 01, 2023

Applies to:

SQL*Plus - Version 10.2.0.1 and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Solaris on SPARC (32-bit)
HP-UX PA-RISC (32-bit)
Sun SPARC Sun OS

Goal

You want to create a custom login.sql script on a UNIX platform.
 
It works correctly if you place the login.sql file in your current working directory.
 
However, if you place it in some other directory in your UNIX PATH, the login.sql commands are not executed.
 
How does SQLPLUS search for the login.sql file?
 

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!

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