A Few Words on Oracle Licenses Oracle Alchemist.Despite reams of legalese and countless blogforum posts, basic Oracle RDBMS licensing still remains a mystery to many.While I wont even begin to discuss components like Oracle Apps, hopefully this post may help you attain a basic understanding of Oracle, what you can license, and what it costs.Editions. The first and most important thing to learn are the editions of Oracle RDBMS.These editions are Oracle Express Edition XE A free use version of Oracle which can use a single CPU though it can be installed on a server with as many CPUs as you want, 1.GB RAM, and 1. 1GB data.Oracle Personal Edition PE Single User, Single Machine developmentdeployment license which can use any SE1, SE, or EE feature with the exception of RAC and Management Packs.Latest trending topics being covered on ZDNet including Reviews, Tech Industry, Security, Hardware, Apple, and Windows.Oracle Enterprise Edition EE Full featured edition of Oracle RDBMS which allows all core features along with the option to purchase add on features like Partitioning and Management Packs like the Diagnostics Pack.Oracle Standard Edition SE A damped down of edition of Oracle which can run on a server with a maximum of four CPU sockets.It cannot take advantage of add ons or Management Packs.It does, however, include Oracle RAC as long as all nodes combined have no more than 4 sockets.Oracle Standard Edition One SE1 A further reduced edition which shares the same features with SE but is limited to 2 CPU Sockets with no RAC option.License Type. On top of knowing the editions, you also need to know about the type of license.The most common is a Processor based license, where your license count is based on the number of CPU SocketsCores and the CPU Type for EE or the number of CPU Sockets for SE and SE1.The other type is a Named User License, where you buy a number of seats on the database instead of licensing it for unlimited users.Please remember if you are pursuing this type of license non human processes are also named users.So any application server, script, or even a scheduled job is a named user.Enterprise Edition Core Factor.For Enterprise Edition and all of its add ons and management packs, there is a concept called core factor which is applied for licensing purposes.Software as a Service Oracle Enterprise Performance Management Cloud.Enterprise Performance Reporting Cloud Enterprise Planning and Budgeting Cloud.Oracle 10g free download Oracle 10g, OpenLink Lite Edition ODBC Driver for Oracle 10g, Windows 10, and many more programs.This factor is based on the type of CPU you are using in your server.For instance, if you are using a SUN M5.SPARC VII processors, the core factor is 0.Price Of Oracle 11G Standard Edition' title='Price Of Oracle 11G Standard Edition' />That means 4 Quad Core CPUs 1.You would purchase 1.EE licenses to cover the server, and then purchase 1.If, on the other hand, you used SPARC VII processors, the core factor is 0.The same CPU setup would only require 8 licenses in that case.For the most part, x.CPUs are a 0. 5 core factor.A small number of processors are 0.Oracle, generally System On A Chip SOC solutions with a very high amount of hyperthreading.You can find the full core factor table here.Special Cases. Two types of databases are exempt from licensing restrictions RMAN Catalogs and GridCloud Control Repositories.If one of these repositories is the only database on a server, that server does not have to be licensed.But if the server or those databases are used for any custom or other Oracle purpose, they must be licensed.Generally speaking it can be beneficial to put these databases on the same server.See this page under Infrastructure Repository Databases for details.Add Ons and Management Packs.Lets get one thing out of the way Standard Edition and Standard Edition One CAN NOT use any add on or Management Pack features except RAC for SE.That means you cant even buy Diagnostics Pack for Oracle SE.The option does not exist.Based on licensing requirements, AWRASHADDM are completely off limits on an SE or SE1 database.However, Enterprise Edition has options for add ons like RAC, Partitioning, and Active Data.Guard. These add ons are extra cost and apply to any database on which they are used.For instance, if you want to use Enterprise Edition with Partitioning and RAC across four nodes, each of the four nodes must be fully licensed for EE, Partitioning, and RAC.If Oracle is running on it, you must license it.Misconceptions. Your standby databases need to be licensed.Ive heard a lot of mixed opinions on Data.Guard and whether your standby database must be licensed.The definitive answer is YES.A Data. Guard standby is running Oracle in MOUNT mode, which means it must be fully licensed for all features.This goes for Development, QA, and Testing servers as well.This one has a lot of misinformation surrounding it.While you can install Oracle on your PC and use it for your own developmentdeployment purposes with Oracle Personal Edition, you cannot have a dedicated production cycle development or QA server without a license.If it is part of the development cycle, then it must be paid.The only way you can get around that is if it is single machine, single user, for personal development.One other big misconception is Oracle on a virtual server, like an ESX environment.Oracle does not recognize soft partitioning of CPUs.If you host Oracle on a VM in ESX, you must license the entire ESX server.Note, this article mentions that it is possible to work with Oracle on this.Cost Cases. So lets take a look at some costs.The license costs are Enterprise Edition 4.Standard Edition 1.Standard Edition One 5,8.You can find the full cost list on Oracles site, which includes all licenses types, add ons, and management package.Node RAC Data. Guard AWRASHIn this example we are going to set up a 2 node RAC cluster with Data.Guard to a standby 2 node RAC cluster.We also want AWRASH for diagnostics.Each server 4 total will have 2 Intel Xeon X7.Our costs for Enterprise Edition would be in list prices 4 servers 2 sockets per server 8 cores per socket 0.Units Enterprise Edition 4.Units RAC 2. 3,0.Units Diagnostics Pack 5,0.Our grand total for this setup in EE would be 2,4.Hopefully you have a good discount Now, if we wanted to do the same thing in Standard Edition, we would have to make some exceptions.Data. Guard does not work on SE, so we would have to use a third party software like DBVisit or homegrown scripts.Also, AWRASH dont work in SE and cant be added, so you might have to fall back to Statspack and adapt with excellent tools like Tanel Poders Snapper.In return for these trade offs, lets look at pricing 4 servers 2 sockets per server 8 units.Standard Edition 1.The total price for two 2 node RAC clusters which 2 sockets per server you cant have more than 4 sockets in a single SE RAC cluster is 1.Quite a big savings, and definitely enough leftover to buy some extra utilities.Production, QA, and Development with Partitioning and AWRIn this example well have three databases which must be licensed as they are part of the development production cycle.Each server is a SUN M5.Quad Core SPARC VII processors.Enterprise Edition 3 servers 4 sockets per server 4 cores per socket 0.Enterprise Edition 4.Partitioning 1. Diagnostics Pack 5,0. Download Lagu Tonight I Wanna Cry Video . The grand total is 2,3.If we were able to forego Partitioning and Diagnostics Pack, the requirement in Standard Edition would be 3 servers 4 sockets per server 1.Standard Edition 1.Conclusion. Remember, a lot of this is up to you and your sales rep or third party reseller.Make sure you work out all the details and understand exactly what you can and cant deploy.It is highly recommended that you keep an eye out for license use the last thing you want is a licensing audit that you are not prepared for, with database installations ranging all over the environment.This paragraph also servers as a DISCLAIMER This post is based on my personal knowledge and references available online and is not a substitute for actual information from Oracle Corporation.Please check with your sales rep on all licensing questions.As you can see in these prices, it is VERY important that you buy what you need and nothing more.Instead of going the whole hog and getting Active Data.Guard, Diagnostics and Tuning Packs, Partitioning, etc.You can save a huge amount of money that way.Also note that there are special types of licensing structures out there such as site licenses.These are special deals worked out with Oracle in order to license your entire enterprise for a certain period, and can often save you a lot of money on licensing depending on your plans.Installing Oracle instantclient basic and instantclient sqlplus on win.Sometimes basic things like installing the latest Oracle instantclient on the PCs of all of your developers can take considerable time.I typically setup a dedicated DBA Portal website wherever I work and then write up instructions for repetitive things like these.Its all about do it once and forget it.Heres the copy of the writeup I did to install the latest 1.Oracle instantclient basic and instantclient sqlplus on win.Download Software.Go to Instant Client Downloads for Microsoft Windows 3.And download basic win.PC for example instantclient basic win.Create Oracle Directory.Create a C oracle directory on your C drive if you dont already have one and move both files into C oracle.Unzip both filesfirst unzip instantclient basic win.Win. Zip. Click Extract to here End result should be a new folder called instantclient1.C oracle Setup your system PATH and TNSADMIN variables.In Windows explorer LEFT pane, right click on My Computer icon and click Properties.Click Advanced tab.Click Environment variables button In the System Variables panel select Path variable and click Edit button In the Variable Value field paste the following C oracleinstantclient1.Make sure its before all other path values that point to your OLD Oracle clients, then click.Ok. Now find a variable called TNSADMIN it could be in either panel System User, if you dont have such variable, create it in the User panel by clicking New Variable Name TNSADMIN.Variable Value C oracleinstantclient1.Click Ok. Now click Ok on the Environment Variables screenand click Ok on the System Properties window to close it.Setup tnsnames. ora file.If you already have an existing copy of tnsnames.C oracleinstantclient1.If you dont then create a new tnsnames.XRACQMYSERVICETAF.DESCRIPTION. ADDRESS PROTOCOL TCPHOST vip qarac.PORT 1. 52. 1. ADDRESS PROTOCOL TCPHOST vip qarac.PORT 1. 52. 1. ADDRESS PROTOCOL TCPHOST vip qarac.PORT 1. 52. 1. ADDRESS PROTOCOL TCPHOST vip qarac.PORT 1. 52. 1. LOADBALANCE yes.CONNECTDATA. SERVER DEDICATED.SERVICENAME XRACQMYSERVICETAF.FAILOVERMODE. TYPE SELECT.METHOD BASIC. RETRIES 1.DELAY 5. Test 1. Open a new CMD window by going to Start Run.In the Run Window type in cmd and press Ok in the CMD windows prompt enter the following sqlplus userpassTNSALIAS where user is the database username given to you by the DBA.DBA. TNSALIAS The alias you setup in the tnsnames.C sqlplus xxxxxxxxxxxXRACQMYSERVICETAF.SQLlus Release 1.Production on Wed Aug 2.Copyright c 1. 98.Oracle. All rights reserved.Oracle Database 1.Enterprise Edition Release 1.Production. With the Partitioning, Real Application Clusters, OLAP, Data Mining.Real Application Testing options.Known Errors If you get the ORA 1.C sqlplus xxxxxxxxxxxxxxxxxxxxxxxxx.SQLlus Release 1.Production on Wed Aug 2.Copyright c 1. 98.Oracle. All rights reserved.ORA 1. 27. 05 Cannot access NLS data files or invalid environment specified.Enter user name. Heres the solution To fix the ORA 1.Cannot access NLS data files or invalid environment specified error, go to your registry editor run regedit from Start Run and then Navigate to Windows Registry in HKEYLOCALMACHINESOFTWAREORACLERemove the NLSLANG from there select it and deleteRe run the sqlplus test to make sure it works you will need to open a new CMD window for the registry changes to take place.Bonus PDFIf youd like to get a copy of this article in an easy to share PDF please sign up for my newsletter Confessions of an Oracle DBA where I share tips, scripts and tricks Ive learned during almost two decades in the tech field as an Oracle DBA SUBSCRIBEAdditional Resources.If you have any additional questions please join our Oracle DBA Community and post them there.And if you need any further Oracle DBA help I can be reached at http www.End. Vitaliy Mogilevskiy August 2.Posted In Operations.Tags instantclient basic, instantclient sqlplus, oracle instant client, win.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |