RE: Strange banner
Date: Mon, 28 Aug 2017 16:33:38 -0700 (PDT)
Message-ID: <df56809f-fb1a-4e83-81e6-589528b8b687_at_default>
https://mikedietrichde.com/2017/05/03/sqlplus-banner-looks-different-since-oracle-database-12-2/
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.
From: Mladen Gogala [mailto:gogala.mladen_at_gmail.com]
Sent: Monday, August 28, 2017 7:18 PM
To: oracle-l <oracle-l_at_freelists.org>
Subject: Strange banner
I was playing with Oracle 12.2 RAC and have successfully created database:
SQL*Plus: Release 12.2.0.1.0 Production on Mon Aug 28 19:04:48 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> select inst_id,instance_name,status from gv$instance;
INST_ID INSTANCE_NAME STATUS
---------- ---------------- ------------
1 rac121 OPEN 2 rac122 OPEN
SQL> However, it doesn't say "with real application cluster and partitioning option". Before 12.2, all the included options were included in the banner. Here is the 12.1 version, for comparison:
mgogala_at_umajor:~$ sql scott/tiger_at_local
SQLcl: Release 17.2.0 Production on Mon Aug 28 19:14:23 2017
Copyright (c) 1982, 2017, 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>
What's going on? Not that it has any bearing on the DB functionality, RAC works quite nicely, but the strange asceticism of the new 12c R2 banner has attracted my attention.
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 29 2017 - 01:33:38 CEST