SQL PLUS 12.2 NOT OBSERVING SQLPATH IN REGISTRY OR ENV VARIABLE FOR LOGIN.SQL
(Doc ID 2559069.1)
Last updated on MAY 20, 2021
Applies to:
SQL*Plus - Version 12.2.0.1 and laterInformation 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 <USER>/<PASSWORD>@<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.
C:\oracle\product\12.1.0.2\BIN>set SQLPATH=c:\tmp
C:\oracle\product\12.1.0.2\BIN>sqlplus <USER>/<PASSWORD>@<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
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 <USER>/<PASSWORD>@<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.
C:\oracle\product\12.2.0.1\bin>set SQLPATH=c:\tmp
C:\oracle\product\12.2.0.1\bin>sqlplus <USER>/<PASSWORD>@<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 |