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!
after 27+ years in Oracle land I am forced to patch sqlplus
Related Posts
![OOW 2012: Is PL/SQL still alive?]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "OOW 2012: Is PL/SQL still alive?")
About The Author
Andre van Winssen
I am an Oracle software professional since 1990 and interested in everything around Oracle databases, weblogic, security My professional certifications: CISA & CISSP-ISSAP, OCM 10/11/12.
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.