Skip to content

Upgrade your Database - NOW!

Mike Dietrich's Blog About Oracle Database Upgrades… Mostly

  • Blog
  • Slides
  • Hands-On Lab
    • 1. Setup
    • 2. Load
    • 3. Capture and Preserve
    • 4. AutoUpgrade
    • 5. AWR Diff
    • 6. SQL Perf Analyzer
    • 7. SQL Plan Mgmt
    • 8. SQL Tuning Advisor
    • 10. Plugin UPGR => CDB2
    • 11. Migrate FTEX
    • 12. Un-/ Plug / Upgrade
    • 13. Fallback Strategies
      • 14a. Issues During Upgrade
      • 14b. Issues After Upgrade
    • 15. AutoUpgrade – Special
    • AutoUpgrade – HOL 19c – Japanese
  • Events
  • Papers / Docs
  • Videos
  • Scripts
  • Links
  • Oracle Documentation
  • Privacy
    • Cookie Policy (EU)
    • GDPR – Request personal data
  • About

SQL*Plus Banner looks different since Oracle Database 12.2

Posted on May 3, 2017 by Mike.Dietrich Behavior Change 0

Did you recognize that the login messages displayed when you start SQL*Plus in Oracle Database 12.2.0.1 looks different than in releases before?

SQL*Plus banner in Oracle Database 12.2.0.1:
$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue May 2 11:23:10 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


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

SQL>
SQL*Plus banner in Oracle Database 12.1.0.2 and before:
$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue May 2 11:24:15 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL>

This change got introduced as a fix for BUG 22347514 (unpublished) with Oracle Database 12.2.0.1 (thanks to Roderick Manalac for letting me know).

Workaround is to query V$OPTION instead.

–Mike

Share this:
  •  
  •  

Related

Tags: BannerLoginOptionsSQL*Plus

  • Next PGA_AGGREGATE_LIMIT enforces default since Oracle Database 12.2.0.1
  • Previous Is your APEX version certified with your Database release?

You may also like...

  • Database Migration from non-CDB to PDB – Migration with Data Pump

    Database Migration from non-CDB to PDB – Migration with Data Pump

  • Rules Manager and Expression Filter getting removed

    Rules Manager and Expression Filter getting removed

  • Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

    Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Archives

Categories

Upcoming Events

  1. Virtual Classroom: Performance Testing Using the Oracle Cloud for Upgrades and Migrations

    May 19 @ 10:00 - 12:00

View All Events

Upgrade @YouTube

RSS RSS Feed for Upgrade your Database – NOW!

  • Important Recommended Patches for Oracle Database 19c
  • Oracle Database 19.10.0 and Blockchain Tables and COMPATIBLE
  • Virtual Classroom Series – Episode 2: Database Upgrade on Feb 18
  • Virtual Classroom Episode 8: Upgrade Internals and so much more
  • New Parameters in Oracle 19.10.0 – and a default change

Subscribe via Email

Join 5,023 other subscribers

Follow me on Twitter

My Tweets
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Recent Posts

  • Important Recommended Patches for Oracle Database 19c
  • Oracle Database 19.10.0 and Blockchain Tables and COMPATIBLE
  • Virtual Classroom Series – Episode 2: Database Upgrade on Feb 18
  • Virtual Classroom Episode 8: Upgrade Internals and so much more
  • New Parameters in Oracle 19.10.0 – and a default change

Upgrade your Database – NOW! © 2021. All Rights Reserved.