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...

  • Can you have more than 1 PDB with Standard Edition 2 (SE2)?

  • Remove and Clean Up Components from Oracle Database 11.2 – 19c

    Remove and Clean Up Components from Oracle Database 11.2 – 19c

  • Can you connect as SYSDBA without password into a PDB directly?

    Can you connect as SYSDBA without password into a PDB directly?

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.

Mike Dietrich
Oracle Senior Director of Product Manager for Database Upgrade, Migrations and Patching writing just another blog.

Opinions certainly are my own as is this page.

Archives

Categories

Upgrade @YouTube

RSS RSS Feed for Upgrade your Database – NOW!

  • A patch (RU, OJVM, 32-bit) is not available yet – where will I find information?
  • March 2023 release of AutoUpgrade is available
  • Oracle Optimizer Statistics Advisor in Oracle 19c
  • ORA-13516 “CATPROC not valid” during datapatch or autoupgrade to 19.18.0
  • Hide and Seek with RU 19.18.0

Subscribe via Email

Join 12,434 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

  • A patch (RU, OJVM, 32-bit) is not available yet – where will I find information?
  • March 2023 release of AutoUpgrade is available
  • Oracle Optimizer Statistics Advisor in Oracle 19c
  • ORA-13516 “CATPROC not valid” during datapatch or autoupgrade to 19.18.0
  • Hide and Seek with RU 19.18.0

Upgrade your Database – NOW! © 2023. 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}