My Oracle Support Banner

SQL PLUS 12.2 NOT OBSERVING SQLPATH IN REGISTRY OR ENV VARIABLE FOR LOGIN.SQL (Doc ID 2559069.1)

Last updated on AUGUST 12, 2020

Applies to:

SQL*Plus - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

 

Example 1: When running sqlplus 12.1, SQLPATH is respected for login.sql 


C:\oracle\product\12.1.0.2\BIN>echo prompt IN LOGIN SCRIPT > c:\tmp\login.sql 
C:\oracle\product\12.1.0.2\BIN>set SQLPATH=c:\tmp 
C:\oracle\product\12.1.0.2\BIN>sqlplus db_user/db_pswd@db_alias 

SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 30 15:10:32 2017 
Copyright (c) 1982, 2016, Oracle.  All rights reserved. 

Last Successful login time: Thu Mar 30 2017 15:09:57 +08:00 

Connected to: 
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 

IN LOGIN SCRIPT 

======================================================= 
Example 2: When running sqlplus 12.2, SQLPATH is NOT respected for login.sql 


C:\oracle\product\12.2.0.1\bin>echo prompt IN LOGIN SCRIPT > c:\tmp\login.sql 
C:\oracle\product\12.2.0.1\bin>set SQLPATH=c:\tmp 
C:\oracle\product\12.2.0.1\bin>sqlplus db_user/db_pswd@db_alias 

SQL*Plus: Release 12.2.0.1.0 Production on Thu Mar 30 15:12:27 2017 
Copyright (c) 1982, 2016, Oracle.  All rights reserved. 

Last Successful login time: Thu Mar 30 2017 15:10:32 +08:00 

Connected to: 
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 

Changes

 Upgraded to Oracle Database 12c Enterprise Edition 12.2.0.1.0 or SQL*Plus 12.2.0.1.0 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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