Article about Some useful tools from my SE Toolbox…and some SE2 License stuff at the end 😉
A New kid on the block – SQLCLI
As a Standard Edition DBA, I’m sure you have numerous times used the good old SQL*PLUS. Recently I noticed that the new SQLCLI tool is not a common known fact among “DBA’s not attending any conferences”, so I like to promote this nice new tool to the Standard Edition database DBA’s toolbox.
The Oracle SQL Developer Product Manager Jeff Smith’s team has developed this new tool “SQLCLI”, and it can be downloaded from SQLDeveloper homepage. (scroll down the page).
After the download and installation, it is ready for use. Note! On my mac the “sql” didn’t run, so I just started the java jar file from the “sqlcli/lib- directory:
cd $HOME/sqlcl/lib SE2mac$ java -jar oracle.sqldeveloper.sqlcl.jar hr@//se12t1:1521/se2pdb
Why not Check some youtube videos about SQLCLI, to get the drift about this tool?
SQLDeveloper – a must in SE/SE2
This tool has grown in maturity since the first version, and I think it’s the first tool to add to your SE/SE2 toolbox. It is free and will bring a nice value to your DBA job.
Check this link to get started.
SQLDeveloper pitfall in SE/SE2:
In older versions of SQLDeveloper, I faced some pitfalls with the predefined DBA reports. For example I was able to use the “AWR reports” without any notifications about violating the license agreement in my Standard Edition database.
The latest version of SQLDeveloper, version 4.1.1, will give you a warning about the license requirements:
And why do you need to READ this note and answer NO?
By answering YES, I am able to use these AWR reports without any problems, and if proceeding I will violate the License agreement, since I am on a Standard Edition 2 database environment.
Note! Also in a Enterprise Edition database this violation is possible, if you haven’t purchased the “Diagnostic&Tuning Pack”.
By answering YES, you will be able to use the reports as shown in the screenshot below:
The “dialog” warning, looks like a normal behaviour independently of the software. For example TOAD software provide with the same kind of dialog during the installation phase. And remember, you can at any later state enable the pack, by changing the softwares preferences/properties; so an other challenge to remember.
Standard Edition 2 on the Menu
After a long wait amongst people in the Standard Edition Community, Oracle Corporation finally released the 22.214.171.124 edition of the Standard Edition Database on the 1st of September.
With this release, lots of buzz has been generated in all Social Medias available, and lots of blog posts have been generated.
As always, a message can be interpreted in many ways, and both good and less good stuff can be found out there on what this SE2 realease bring to the table; after you have carefully read the license documents available, and still feeling unsure, please check with your local Oracle LMS before making any false or unecessary assumptions on the impacts on your business.
Some small rules to remember about SE2
- The minimums for Database Standard Edition 2 are 10 Named User Plus licenses per server
- This metric is used in environments where users can be identified and counted.
- Install onto a servers that have a maximum capacity of 2 sockets (*see)
- Oracle Database Standard Edition 2 database may use a maximum of 16 CPU threads(**see) at any time
- Oracle Real Application Clusters, Oracle Database Standard Edition 2 may only be licensed on a maximum of 2 one-socket servers
- on RAC – each Oracle Database Standard Edition 2 database may use a maximum of 8 CPU threads per instance at any time
- Hard partitioning (*** see) can be used on 2 sockets servers to enable you to run RAC on 2 two socket servers with both CPUs populated
(*)When licensing Oracle programs with Standard Edition One, Standard Edition 2, or Standard Edition in the product name, a processor is counted equivalent to an occupied socket; however, in the case of multi-chip modules, each chip in the multi-chip module is counted as one occupied socket.
(**)From the CPU's perspective, a thread (short for "thread of execution") is merely an ordered sequence of instructions that tells the computer what to do. So when someone talks about a "multithreaded processor," they're talking about a processor that can execute multiple instruction streams simultaneously. There are two ways that a processor can perform such a feat: simultaneous multithreading, and using multiple cores. Neither of these methods is mutually exclusive, and both are often used together.
*** HARD partitioning physically segments a server, by taking a single large server and separating it into distinct smaller systems.
*** SOFT Partitioning: Unless explicitly stated elsewhere in this document, soft partitioning (including features/functionality of any technologies listed as examples above) is not permitted as a means to determine or limit the number of software licenses required for any given server or cluster of servers.
Take care, stay well and let’s enjoy the Autumn.
Helsinki, 24st September 2015