sec_return_server_release_banner
845641May 2 2013 — edited May 2 2013What is the difference ? everything is same ? it should show 11.0.0.0.0 instead of 11.2.0.1.0 ? why its not working
SQL> show parameter banner
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_return_server_release_banner boolean FALSE
[oracle@node4 ~]$ sqlplus scott@test
SQL*Plus: Release 11.2.0.1.0 Production on Thu May 2 11:46:13 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> alter system set sec_return_server_release_banner=true scope=spfile;
System altered.
SQL> startup force
ORACLE instance started.
Total System Global Area 367439872 bytes
Fixed Size 2213456 bytes
Variable Size 243272112 bytes
Database Buffers 117440512 bytes
Redo Buffers 4513792 bytes
Database mounted.
Database opened.
SQL> show parameter banner
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_return_server_release_banner boolean TRUE
[oracle@node4 ~]$ sqlplus scott@test
SQL*Plus: Release 11.2.0.1.0 Production on Thu May 2 11:47:30 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
Edited by: 842638 on May 1, 2013 11:23 PM