Oracle licensing Oracle FAQIntroductioneditOracle database software can be very expensive or very cheap even free, depending on what you buyuse. Oracle Standard Edition costs about the same as Microsoft SQL Server. In todays post I will discuss on steps you should doneed for Oracle Apps R12 installation. Most of these steps are written w. Installation on Linux but I. Viney, You need 32bit drivers for Oracle client installed on your server. Otherwise youre trying to connect a 32bit client software with 64bit server software. Best DBA resume samples and examples you can download easily Career objective Seeking a position as an DBA Developer in initiatives that utilize stateofthe. It can only be licensed on servers, or server clusters, that have a maximum capacity of 4 processor sockets. Oracle Standard Edition 2. It can only be licensed on servers, or server clusters, that have a maximum capacity of 2 processor sockets. Oracle Standard Edition One is less expensive than SQL Server. It may only be licensed on servers that have a maximum capacity of 2 processor sockets. Oracle PE is very inexpensive, full featured version of Oracle DB, but is restricted to one user per database server, not instance, most likely. The license however allows a developer to use all of the features of the EE including the options with the exception of Real Application Clusters. Oracle XE is provided free of charge, but limited to one database. Finished tests on prototype systems detailed document available on my LinkedIn profile, and additional tests and unofficial benchmarking data will follow later in. I would like to thank Multisoft team for their constant support and help that they extended during my study period. I gained proficiency in planning, initiation. We have collected 100 videos just for Oracle Application Framework OAF from Youtube and linked it with www. OracleAppsVideos. The videos are in the below. Install Oracle Developer Suite 10G Windows 7' title='Install Oracle Developer Suite 10G Windows 7' />Oracle Enterprise Manager OEM Database Control and Grid control is provided free of charge, however, the management packs needs to be licensed for the number of users or CPUs that you monitor with it. Oracle Application Server i. AS Standard Edition One may only be licensed on servers that have a maximum capacity of 2 processor cores. A great comparison document showing what is included and what isnt for all of the editions of the Database is available at Oracle. See page 1. 0 for the beginning of the comparison table. Install Oracle Developer Suite 10G Windows 7' title='Install Oracle Developer Suite 10G Windows 7' />What is a licenseeditA license is the right to use RTU the software and not the software itself. If you have a license, you can obtain a copy of the software media through whatever means download, use the CDs from your last project, etc. Please note that Oracle doesnt use software keys. You can just install the software and use it. It is up to you and your consciences to license the software before using it. Licenses are not tied to the product version. For example, an Enterprise Edition database license is equally valid for Oracle 9i, Oracle 1. Oracle 1. 1g or latest Oracle 1. However, you are only entitled to new versions if you have a valid maintenance and support contract in place. Licensing Cost MetricseditOracle provides a summary of their licensing metrics at http www. Oracle licenses can be obtained by speaking directly with Oracle, through an Independent Software Vendor ISV in the case of ESL or ASFU licenses, or through an Oracle Partner i. Oracle License Store. The following licensing metrics are available. Unlimited License AgreementseditA Unlimited License Agreements ULA is a time based 2 3 year unlimited use right license for a subset of Oracle technology or applications. At the end of the term, customers must count and declare usage to Oracle, and are granted that number of licenses for the products covered by the ULA. Processor licensingeditYou pay per Processor you run the Oracle software on however Oracle has a special definition of processor which may or may not match that of your hardware vendor. Intel Hyperthreading technology that makes one core look like two counts as 1 cpu core for this purpose. Other soft partitioning technologies are treated differently for example, the Solaris OS has a concept of Containers, this is similar to hard partitioning on an HP machine however Oracle does not recognize software partitioning with Solaris Containers prior to Solaris 1. Hard partitioning methods such as Suns Domains, IBMs Logical partitioning are recognized as legitimate methods to limit the amount of resources that can run the Oracle software. Also Oracle VM and certain Oracle Appliances configured as per Oracles hard partitioning policy document is also allowed as a valid hard partitioning method. If you are a MS or VMWare virtual machine user, the following document is a must read Oracle Partitioning Policy document. Oracle Standard Edition uses a per socket licensing scheme, however, Enterprise Edition used a per core licensing scheme. Standard Edition Per socket licensingeditIf you use Standard Edition or Standard Edition One on a 2 processor system you simply need 2 processor licenses. Effective 1 Sept 2. Standard Edition DB programs, a processor is counted equivalent to a socket however, in the case of multi chip modules, each chip in the multi chip module is counted as one occupied socket. Oracle has now replaced Oracle Standard Edition and Oracle Standard Edition One with just Oracle Standard Edition 2 SE2. Torrent Windows Server 2008 R2 Active Directory Training Video. If you use Enterprise Edition you need to take the number of cores into account as well. Enterprise Edition Per core licensingeditMulti core processors are priced as number of coresmulti core factor processors, where the multi core factor is. SUNs Ultra. SPARC T1 processors 1. GHz or 1. 2 GHz 0. SUNs Ultra. SPARC T1 processors e. GHz 0. 5. 0 for Intel and AMD processors 0. Intel Itanium Series 9. XX or earlier Multicore chips For servers purchased prior to Dec 1st, 2. SUNs Ultra. SPARC T2 processors updated Oct 1 2. IBMs POWER6, POWER7 and POWER8 processors 0. Intel Itanium Series 9. XX For servers purchased on or after Dec 1st,2. Intel Itanium Series 9. XX For example, a SUN Ultra. Sparc T1 system with 4 x eight core processors will require 40. This is just an example. Sun Ultra. Sparc T1 and T2 are not SMP capable, only Sun Ultra. Sparc T2 is SMP capable. Similarly, an IBM AIX system with 4 x eight core processors will require 40. License requirements were updated in Dec 2. Original document could be found by this URL http www. As at February 1. Oracle still did not recognise soft partitioning technologies such as VMWare and Microsoft Virtual Server when licensing by processorCPU. Instead you must licence by the physical processor in the underlying hardware. Oracle places some caveats on this also. Oracles licensing policies last updated in May 2. Original document can be found here. Oct 1 2. 00. 9 Sparc T2 Update Oracle Processor Core Factor Table has been revised with respect to Processor Licensing Factor for Sun Ultra. SPARC T2 from 0. The rationale for change is that the benchmark for T2 is more in line w Intel Xeon hence the factor aligns with the factor for Intel Xeon on this table. Heres the latest Oracle Processor Core Factor Table. Named User Plus LicensingeditPay per user, however user is defined as any end node that receives data from or creates data for that Oracle DB including human users. The classic case would be a grocery store system that is taking data from refrigerator thermometers and point of sale systems in one case a user is a thermometer and in another case the user is the check out clerk, or in the case of newer self check out terminals it would be the customer thus in this example one would explore processor based licensing. You are required to adhere to the following Oracle user minimums. Oracle Database Standard Edition ONE 5 Named User Plus licenses Oracle Database Standard Edition 5 Named User Plus licenses Oracle Database Standard Edition 2 1. Named User Plus licenses per server Oracle Database Enterprise Edition 2. Named User Plus licenses per CPU Oracle Application Server Standard Edition ONE 5 Named User Plus licenses All other Oracle Application Server products 1. Comparison on DB2 1. Vs SQL Server 2. 01. Vs Oracle 1. 1g R2 latest features to suite SAP Products. Hello all,Comparison on DB2 1. Vs SQL Server 2. 01. Vs Oracle 1. 1g R2 latest features to suite SAP Products Comparison is aimed to highlight the latest features made available by different database vendors for SAP to suite its products on demand. Comparison with latest features provided by Database Vendors. Backup Compression a      RMAN Backup Compression for oracle Oracle Advanced Compression includes compression technology that can dramatically reduce the storage requirements for backup data. Due to RMANs tight integration with Oracle Database, RMAN backup widely used by SAP customers data is compressed before it is written to disk or tape and doesnt need to be uncompressed before recovery providing an enormous reduction in storage costs. SQL Backup compression. Independent of the use of database compression, backup compression showed compression factors of 4 to 5 when backups of SQL Server databases were conducted. As with most SQL Server functionality, backup compression does not require tuning or configurationc      DB2 Backup compression. You can use backup compression with tables that use row compression. Keep in mind, however, that backup compression requires additional CPU resources and extra time. It may be sufficient to use table compression alone to achieve a reduction in your backup storage requirements. If you are using row compression, consider using backup compression only if storage optimization is of higher priority than the extra time it takes to perform the backup. Consider using backup compression only on table spaces that do not contain compressed data 2     OLTP Table Compressiona       Oracle Oracle Database 1. OLTP Table Compression that allows data to be compressed during all types of data manipulation operations, including conventional DML such as INSERT and UPDATE. Oracles unique approach offers significant performance benefits by not introducing additional IO when accessing compressed data. The benefits of OLTP Table Compression go beyond just on disk storage savings. One significant advantage is Oracles ability to read compressed blocks directly without having to first uncompress the block. Therefore, there is no measurable performance degradation for accessing compressed data. The buffer cache will become more efficient by storing more data without having to add memory. Since Oracle Database Rel. SAP has certified the use of Index compression to save disk space for indexes and reduce total database size on disk. Customer experiences show that even after full database reorganization has taken place, an additional 2. SQL OLTP compression is supported and it doesnt compress on every insert and it compress when reaches a certain threshold and is available with 2. DB2 Not supported for DB2 but it has Indexes compression, including indexes on declared or created temporary tables, can be compressed in order to reduce storage costs. This is especially useful for large OLTP and data warehouse environment. Data compression a Oracle It can compress the metadata available from 1. R2 and table datanew in 1. Data Pump compression is fully inline on the import side as well, so there is no need to uncompress a dump file before importing it. The compressed dump file sets are automatically decompressed during import without any additional steps by the Database Administratorb SQL Server Microsoft and SAP also worked together to introduce the highly space efficient SQL Server Page Dictionary compressionunrestricted for data and indexesfor SAP Net Weaver applications based on the SAP ABAP stack. Many customers have reported positive experiences with Page Dictionary compression, with benefits that include One time change with no repetition Once a table is built with Page Dictionary compression, there is no need to rebuild it in order to apply compression to new content. As data is inserted, it is compressed in the pages automatically, without help from the database administration side. Database volume often reduced by half with migrations from competitive platforms. DB2 Adaptive compression. Your DB2 database provides comprehensive compression for almost every type of database object including table data, indexes, temporarytables, XML documents, log files and backup images. In previous versions, classic row compression helped lower storage costs and improve query performance. DB2 Version 1. 0. The adaptive compression feature improves table compression through two levels of compression dictionaries table level and page level to improve compression ratios, particularly as data changes. A page level compression dictionary are smaller than table level dictionaries so as data changes on a page it is easy to update automatically and quickly, and removes the need to perform table reorganizations to update page level dictionaries. Adaptive compression helps you achieve high compression ratios without taking your data offline to perform table reorganizationscontinue to improve query performance and will reduce the size of large tablesincrease storage savings and system availability. Real Application Testing RATOracle 1. R2 Database Replayprovides DBAs and system administrators with the ability to faithfully, accurately and realistically rerun actual production workloads, including online user and batch workloads, in test environments. By capturing the full database workload from production systems, including all concurrency, dependencies and timing. The OracleSAP Development Team recently concluded comprehensive testing of SAP applicationsusing Real Application Testing to measure the effects of Advanced Compression for OLTP and Secure Files. On DML operations for SAP ERPSQL Server 2. Distributed Replay Once again this is answer to a feature that Oracle released Real Application Testing. In Oracle it is a very expensive cost option to Enterprise Edition. With SQL, when you buy your licenses for Enterprise Edition, you get everything. Distributed replay allows you to capture a workload on a production server, and replay it on another machine. This way changes in underlying schemas, support packs, or hardware changes can be tested under production conditions. DB2 version 9. 7 does not have a competitive offering to Oracles Real Application Testing Option. Thus the task of validating changes before introducing them into production is left to the DB2 DBA. The DBA has to rely on 3rd party tools, such as Quests Benchmark Factory, engineer some manual custom testing procedures or blindly implement changes in production and hope for the best, which, for obvious reasons, will most likely result in system outages and severe loss of service. High Availability Disaster Recovery SQL Server 2. Always. On Always. On is the new integrated, flexible, cost efficient high availability and disaster recovery solution in SQL Server 2. This feature is transparent to the SAP Net Weaver system, IBM DB2 1. Multiple HADR Standby Servers. For high availability, IBM includes HADR in the base product. Multiple HADR High availability disaster Recovery Standby Servers You can now install up to three HADR standby servers with or without time delayed replay. Oracle with RAC from 1. Oracle requires customer to purchase additional database options called Real Application Clusters RAC for local high availability and Active Data Guard for remote disaster recovery.