0 
0 When starting to use sqlplus 12.2 I noticed that my SQL prompt was not changing to what login.sql told it to be. This did not happen in sqlplus 12.1 or lower versions.
Maybe this is a bug, maybe a new feature I thought. Behaviour in 12.2 of sqlplus indeed has changed according to documentation: sqlplus 12.2 no longer looks in local directory (i.e. where you start sqlplus) for a login.sql file to run but only looks for .sql files in directories indicated by environment variables (SQLPATH for Windows and ORACLE_PATH on Linux). However, even when setting these environment variables to the proper values sqlplus still did not run my login.sql automatically. Ok, then I’ll create an SR with Oracle Support. They confirmed that this odd behaviour indeed is a bug and that a patch is available for sqlplus: PATCH:25804573. So now finally I have a reason to patch sqlplus!
Related posts:
Oracle Database SQL – Recursive Subquery to inspect events in football matches – find the MVP 
The AMIS Summary of Oracle OpenWorld 2013 is available for download – 60-page white paper 
Oracle SQL Pattern Recognition – introducing the Match Recognize operator 
Juggling with SQL Types in SQL and PL/SQL – fading borders between Collection and Table 
Jouw toekomst als Oracle professional – AMIS !!EXTRA!! informatieavond over jouw ontwikkelingspad
After patch 25804573, login.sql ran automatically when using /nolog switch, but not when connecting to a database. I needed to add login.sql to my glogin.sql as a work-around. Now, login.sql runs twice when using /nolog.
Thanks, Andre – this was driving me insane! Worked like a charm.