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
  • 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 – The Minimal Downtime Challenge

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

  • Rules Manager and Expression Filter getting removed

    Rules Manager and Expression Filter getting removed

  • Database Migration from non-CDB to PDB - Various Pitfalls

    Database Migration from non-CDB to PDB – Various Pitfalls

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

There are no upcoming events at this time.

Upgrade @YouTube

RSS RSS Feed for Upgrade your Database – NOW!

  • How to speed up datapatch – and much more information
  • Simple database installation with applyRU and applyOneOffs
  • A new version of AutoUpgrade has been released
  • Binary patching is slow because of the inventory
  • How to speed up your database and GI patching

Subscribe via Email

Join 6,058 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

  • How to speed up datapatch – and much more information
  • Simple database installation with applyRU and applyOneOffs
  • A new version of AutoUpgrade has been released
  • Binary patching is slow because of the inventory
  • How to speed up your database and GI patching

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

Manage Cookie Consent
We use cookies to optimize our website and our service.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
View preferences
{title} {title} {title}