after 27+ years in Oracle land I am forced to patch sqlplus

1
Share this on .. Tweet about this on TwitterShare on LinkedIn39Share on Facebook12Share on Google+1Email this to someoneShare on Tumblr0Buffer this page

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!

Share this on .. Tweet about this on TwitterShare on LinkedIn39Share on Facebook12Share on Google+1Email this to someoneShare on Tumblr0Buffer this page

About Author

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.

1 Comment

Leave a Reply