Search posterous

Search all posts and users. Type a name, type a favorite song title, whatever! See what comes up.
  

More posterous blogs











More recommended blogs »

Here are posterous posts filed under oracle...

rulix says...

 

Типы лицензий

FU (Full use) – лицензия, позволяющая использовать Oracle Database в полной мере.

ASFU (Application specific full use) – лицензия для использования Oracle Database только в составе программных продуктов.

 

Разновидности Oracle Database

·       Oracle Database Standard Edition ONE – может лицензироваться на серверах с количеством процессоров до двух штук.

·       Oracle Database Standard Edition -  может лицензироваться на серверах с количеством процессоров до четырех штук.

·       Oracle Database Enterprise Editionнеограниченное кол-во процессоров.

 

Метрики

Processor (Proc) – лицензирование по процессорам.

Named User Plus (NUP) – лицензирование по количеству пользователей.

В случае, когда точное количество пользователей, использующих базу данных, определить не удаётся, используется лицензирование по процессорам. Например, когда пользователи получают доступ к БД через веб-сервер.

Когда для доступа к БД используется устройство с операторским управлением (например, касса), то лицензируется каждый пользователь, использующий данное устройство (например, все кассиры).

 

Коэффициенты для подсчета лицензий

Процессор

Коэффициент

SUN UltraSparc T1 (1.0 GHz или 1.2 GHz)

0,25

SUN UltraSparc T1 (прочие тактовые частоты, например, 1.4 GHz)

0,5

SUN UltraSparc T2

0,5

Все процессоры Intel

0,5

Все процессоры AMD

0,5

IBM Power6

1,0

Прочие многоядерные процессоры

0,75

Одноядерные процессоры

1,0

 

Формула подсчета: кол-во процессоров * кол-во ядер * коэффициент.

Например, возьмём сервер HP Superdome с 50-ю двуядерными процессорами  Intel Itanium 2. Соответственно,

50 * 2 * 0,5 = 50.

Значит, для этого сервера необходимо купить 50 процессорных лицензий.

В случае, если при расчетах получается не круглое число –   например, 1,5 – оно округляется в большую сторону.

 

Лицензионные минимумы

В случае лицензирования по пользователям, существуют лицензионные минимумы.

Продукт

Минимум (NUP)

Oracle Database Standard Edition ONE

5

Oracle Database Standard Edition

5

Oracle Database Enterprise Edition

25 на каждый процессор

Лицензионные минимумы по пользователям  на многоядерных системах вычисляются после того, как высчитывается процессорная метрика с учетом коэффициента.

Например, минимальное кол-во NUP для сервера с 8-ю двуядерными процессорами HP PA-RISC, на котором будет работать Oracle Database Enterprise Edition, будет следующим:

8*2*0,75*25=300 NUP.

Лицензирование в виртуализированной среде

Оракл выделяет два типа виртуализации: программное и аппаратное партиционирование. В виду большого многообразия технологий, данный список не является определяющим. Однако можно выделить наиболее распространённые виды партиционирования:

·       Программное – разделение ресурсов сервера с помощью специализированного менеджера  ресурсов операционной системы. Примеры: Solaris 9 Containers, AIX Workload Manager, HP Process Resource Manager, Oracle VM, VMware и т.д.

·       Аппаратное разделение сервера на сегменты, где сегменты физически независимы друг от друга и обладают каждый своим собственным набором процессоров, модулей памяти и прочего аппаратного обеспечения. Примеры: Sun Dynamic System Domains (с помощью DR), IBM LPAR/DLPAR, Solaris 10 Capped Containers, vPar, nPar и т.д.

В случае, если сервер не может использовать аппаратное партиционирование, необходимо лицензировать все процессоры.

Если используются программы расширения доступных ресурсов «Capacity on demand», «Pay as You Grow» и им подобные, разрешается лицензирование только включенных процессоров, используемых для работы Oracle Database.

 

Опции

Существует некоторое количество опций, расширяющих функциональность Oracle Database. Их довольно много, некоторые из них требуют дополнительного лицензирования, некоторые входят в состав Oracle Database. Подробно о них можно узнать по адресу: http://download.oracle.com/docs/cd/B28359_01/license.111/b28287/editions.htm#CIHBAEID

Здесь же надо выделить две опции:

·       Partitioningопция доступна только в редакции Enterprise Edition и требует отдельной оплаты.

·       Real Application Clusters – опция доступна в двух редакциях:

o      Standard Edition. Входит в состав лицензии и не требует дополнительной оплаты.

o      Enterprise Edition. Требует дополнительной оплаты.

Цены

Актуальные GPL цены на продукты Oracle Database доступны по адресу: http://www.oracle.com/corporate/pricing/technology-price-list.pdf.

При покупке лицензии обязательно приобретается один год технической поддержки. Стоимость поддержки не входит в стоимость лицензии.


Filed under: oracle

remagio says...

EU Objects to Oracle-Sun Deal

The European Commission today issued a so-called Statement of Objections over Oracle’s (ORCL) proposed acquisition of Sun Microsystems (JAVA). Disclosed in a regulatory filing by Sun, the document gives formal voice to the EC’s concerns over the fate of Sun’s open-source MySQL database. From Sun’s filing:

On November 9, 2009, the European Commission issued a statement of objections relating to the acquisition of Sun by Oracle Corporation. The Statement of Objections sets out the Commission’s preliminary assessment regarding, and is limited to, the combination of Sun’s open source MySQL database product with Oracle’s enterprise database products and its potential negative effects on competition in the market for database products. The issuing of a Statement of Objections allows addressees to present arguments in response to the Commission’s preliminary assessment of the competitive effects of a notified transaction. A Statement of Objections is a preparatory document that does not prejudge the European Commission’s final decision. Any final decision by the European Commission is subject to appeal to the European Court of First Instance.

Indignant that the EC would dare to bring the $7 billion deal into question, Oracle vowed to take it to the mat in a harshly worded rebuttal:

Oracle’s acquisition of Sun is essential for competition in the high end server market, for revitalizing Sparc and Solaris and for strengthening the Java development platform. The transaction does not threaten to reduce competition in the slightest, including in the database market. The Commission’s Statement of Objections reveals a profound misunderstanding of both database competition and open source dynamics. It is well understood by those knowledgeable about open source software that because MySQL is open source, it cannot be controlled by anyone. That is the whole point of open source.

The database market is intensely competitive with at least eight strong players, including IBM, Microsoft, Sybase and three distinct open source vendors. Oracle and MySQL are very different database products. There is no basis in European law for objecting to a merger of two among eight firms selling differentiated products. Mergers like this occur regularly and have not been prohibited by United States or European regulators in decades.

The U.S. Department of Justice carefully reviewed the proposed acquisition during the normal Hart-Scott-Rodino review and considered it again when the European Commission initiated a second phase review. On both occasions the Justice Department came to the conclusion that there is nothing anticompetitive about the deal, including specifically Oracle’s acquisition of the MySQL database product. The U.S. Department of Justice approved the acquisition without conditions and terminated the waiting period under the Hart-Scott-Rodino Act on August 20, 2009.

Sun’s customers universally support this merger and do not benefit from the continued uncertainty and delay. Oracle plans to vigorously oppose the Commission’s Statement of Objections as the evidence against the Commission’s position is overwhelming. Given the lack of any credible theory or evidence of competitive harm, we are confident we will ultimately obtain unconditional clearance of the transaction.

And Oracle will evidently pursue its case with help from the U.S. Department of Justice’s Antitrust Division, which also issued a statement on the EC’s move today:

After conducting a careful investigation of the proposed transaction between Oracle and Sun, the Department’s Antitrust Division concluded that the merger is unlikely to be anticompetitive. This conclusion was based on the particular facts of the transaction and the Division’s prior investigations in the relevant industries. The investigation included gathering statements from a variety of industry participants and a review of the parties’ internal business documents. At this point in its process, it appears that the EC holds a different view. We remain hopeful that the parties and the EC will reach a speedy resolution that benefits consumers in the Commission’s jurisdiction.

Several factors led the Division to conclude that the proposed transaction is unlikely to be anticompetitive. There are many open-source and proprietary database competitors. The Division concluded, based on the specific facts at issue in the transaction, that consumer harm is unlikely because customers would continue to have choices from a variety of well established and widely accepted database products. The Department also concluded that there is a large community of developers and users of Sun’s open source database with significant expertise in maintaining and improving the software, and who could support a derivative version of it.

The Department and the European Commission have a strong and positive relationship on competition policy matters. The two competition authorities have enjoyed close and cooperative relations. The Antitrust Division will continue to work constructively with the EC and competition authorities in other jurisdictions to preserve sound antitrust enforcement policies that benefit consumers around the world.

 

Filed under: Oracle

Jay says...

(photo courtesy of zazzle.com)

Imagine seeing YOURSELF on the cover of Time Magazine or maybe YOU prefer Fortune Magazine or maybe in a future Joking Gorilla Billionaire List.  It doesn't matter, the important thing is YOU imagine.  Imagine YOU'RE reading about YOUR success and new billionaire status today.

“[Insert YOUR Name Here] is now one of the world's richest individuals.  He/She built an empire covering the whole gamut of the computing industry.  He/She is worth a cool $29 billion.  He/She built an amazing array of cool products that redefined how we use computers, mobile phones and other computing devices...  etcera... etcera...  etcera...”

Now, snap out of it!

This is how YOU did it.

First move, be born to unknown parents.  It might help if YOUR last name is hard to spell, common or unknown.  (Think Gates.  Allen.  Ellison.  Jobs.  Wozniak.  Zuckerberg.  Page.  Brin.).  YOU get the point.

Second move, study until college then drop out.  In the last 50 years, billionaires especially on newly-created industries like computing, software engineering, mobile communications, the Internet, etc. usually dropped out of college to pursue a great idea.  (Gates.  Ellison.  Jobs.  Wozniak.  Zuckerberg.  Page. Brin.).  YOU do need to finish high school though.  We still have to encounter a billionaire who's a high school drop out (If YOU know one, let's hear it!).  This probably means YOU do need to master reading (comprehension), writing and speaking skills as well as knowing a little about history, algebra and physics.

Third, think and pursue a great idea that can change the world.  Now comes the hard part.  It's easy to say this.  It's even easier to put this on a piece of paper and call it a business plan.  But execution is key.  Almost all the new-age billionaires started their startups on their own dime.  They had to invest something themselves first.  The best indicator if YOU have a great idea?  There's none.  If YOU believe in something so strongly and are willing to pursue it then YOU'D probably end up a billionaire.  But that's a BIG IF.  Remember, Edison did fail ten thousand times before perfecting the light bulb mechanism.  And he didn't end up a billionaire but his name will live on forever.  And Col. Sanders did get the door closed on him almost 2,000 times before getting the secret formula right for KFC.  And even Kung Fu Panda had to fail many times before learning the secret of the dragon warrior.

Fourth and the final step, execute with uncanny precision.  Gates hit it big when Microsoft licensed their software program to IBM and built in great functionality (yes guys, at that time Windows was cool and cheap) to it.  Ellison when he got a big contract from the government and by focusing on the server market first.  Jobs when he got fired from Apple.  Sorry, that's not it.  Jobs actually did it in two spades (or is it three?): with Apple, he made an amazing product (Macintosh, others) that the world adored and with Pixar, he built a different kind of movie/animation house.  And with Apple again with the iPod and iPhone.  Larry Page and Sergey Brin did it by creating an amazing search engine they called Google.  Google continues to redefine the marketplace.  Zuckerberg built a site for social interactions – he built a great one, cool functionalities, amazing design and easy sharing of files – photos, videos and links.  Facebook is like the iPhone of social networking – it looks great, YOU can do almost anything with it, and it's not so expensive – it's actually FREE.  Design Matters.  Design in Outlook.  And Design in Process.

Let's recap then:

1 FIRST MOVE, BE BORN TO UNKNOWN PARENTS.  This is so true, it will motivate YOU to become known.
2 SECOND MOVE, DROP OUT OF COLLEGE.  So far, that's how the current billionaires did it.
3 THIRD MOVE, DEVELOP A GAME-CHANGING IDEA.  That will do it.  Provided YOU succeed.
4 FOURTH MOVE, EXECUTE!  Now this is the hardest part, but this is key.

There is in fact a fifth step.  We'll let YOU figure that one out.  There are clues in this article.  But that deserves another post.  We believe Guy Kawasaki has written extensively about that subject.

Let us know what YOU think the fifth step is.  Email it to people.hungry [at] gmail.com.

P.S.

If all else fails, YOU have the following choices (in no particular order):

Marry a billionaire (YOU have to be a really hot!)
Marry into a billionaire's family (YOU have to be smart.)
Marry the ex-billionaire's spouse (Make sure they got at least a billion dollars after the divorce.)
Get YOURSELF adopted by the billionaire or the family (YOU have to be cute!)

Have any other ideas?  Email it to us and we'll post them.

 

Filed under: oracle

justin says...

1. Create a .sql file using the below template
-- set the output file in the first SPOOL command
-- add your query in between the SPOOL sections

set echo off
set newpage 0
set pagesize 0
set space 0
 set feedback off
set trimspool on
set heading off
set linesize 555
SPOOL /path/to/your/output/file.txt
select ... 'replace this line with your query'  ;
SPOOL OFF
quit

2. Create a simple shell script

#!/bin/bash
sqlplus oracle_user/password @/path/to/your/sql_file.sql

3. chmod the script

 chmod +x oracle_sql.sh

4. Also to get sql*plus working you mayneed to set a few environmental variables

setenv ORACLE_HOME ..
setenv ORACLE_SID ..
setenv ORACLE_OWNER ..
setenv ORACLE_VERSION ..
setenv ORACLE_CONF ..
setenv ORACLE_BASE ..
setenv TNS_PORT ..
setenv ORACLE_ALERT_LOG ..
setenv TEMPORARY_TS TEMP
 setenv TWO_TASK ..
setenv ORA_LIB ..

5. then just add the oracle_sql.sh to your cron

6. done

Filed under: oracle

Jesus Hoyos says...

Vayan a este enlace:

http://media.newlink-group.com/ladtimes/oow09//oow_e12.htm

Es un buen ejemplo de un social media press release y tiene buena informacion sobre los que esta pasando en el evento. Via la gente de Newlink.

Filed under: Oracle

cscyphers says...

The Monday keynote is all about a unified, integrated suite of tools. The Primavera, vertical Apps (retail & manufacturing specifically), Siebel and PeopleSoft / Hyperion subtalks have been focused on how the app connects to an Oracle database, runs through the specific app and does the spiffy display and knowledge manipulation in OBIEE. I rather suspect that the integration (particularly the OBIEE one) involved a *lot* of engineer hours to get to the rather useful state as displayed on the big screen during the KeyNote.

It's unclear how much of this will be done out of the box and how much custom coding/extensions will be required. I suspect Paredo holds and the out of the box part will do most things for most people. But retail is a bad area to use as an example. Margins are thin; good enough doesn't cut it in that cutthroat environment.

Filed under: Oracle

cscyphers says...

Tonight was Scott's valedictory keynote address. It was clear that he was doing the "let's gaze back upon my last 25 years and bask in the glow of the accomplishments." I don't begrudge him for that; he's been successful for a long time in a field where "technology innovations have the shelf life of a banana" (to quote Mr. McNealy). Still, both he & Uncle Larry told everyone to rest their worried head about the pending Oracle acquisition. They both pointed towards this ad:

which lists 4 specific things (updated today during the keynote to 5):

  1. Oracle will spend more money developing SPARC than Sun does now
  2. Oracle will spend more money developing Solaris than Sun does now
  3. Oracle will have 2x(+) hardware specialists selling & servicing SPARC/Solaris systems than Sun does now
  4. Oracle will dramatically improve Sun's hardware performance by tightly integrating Oracle's software with Sun hardware
  5. [New] Oracle will spend more money developing MySQL than Sun does now

Now, there is a big loophole with this approach on points 1-3 & 5; point 4 is (IMO) why the merger happened in the first place.  The loophole is the somewhat vague "spend more money ... than Sun does now".  Spend how much more money?  Twice as much?  Ten times?  One penny more?  And, more importantly, spend more money on what?  If I spend money on marketing Solaris, does that count as developing it ("hey, I'm just trying to develop the marketspace...").  And, as the US government proves time and time again, just throwing more money at something does not always equate to better performance.

 

Also, a stat that is germane here: Sun has about 250k servers installed (if I heard Mr. McNealy correctly).  250k?  That's a rounding error to Dell or HP.  Sure, Sun now has the #1 spot in all commercial benchmarks, but the Pareto principle works _against_ Sun here; if it does 80% of what I need at 40% of the cost, then why would I buy Sun?  I'll buy more cheap boxes and horsepower the problem away.  Sure, this doesn't work for the edge cases, but that's a fraction of the market.

Filed under: Oracle

Jesus Hoyos says...

Si no estas en Twitter aqui puedes ver los tweets del Oracle OpenWorld 2009

Filed under: Oracle

cscyphers says...

During a break between sessions, I saw that Aerosmith, Three Dog Night, Roger Daltrey & The Wailers are all playing for the Wednesday night party. This says to me one of two things:

  • The recession is over for Oracle, as I generally know what the fees are for at least two of the bands
  • The recession is starting for Aerosmith
Of course, it could be both...

Filed under: Oracle

Jesus Hoyos says...

La transformación de la industria de CRM #oow09 #CRM #crmlatam #scrm

A scene from Oracle OpenWorld in San Francisco.Image via Wikipedia

Esta semana es el Oracle OpenWorld 2009 en San Francisco y creo que muchos de nosotros en la industria estamos en la expectativa de que nuevo trae Oracle para el mundo de CRM. Tenia planeado estar en San Francisco pero esta semana tengo que estar en México, asi que estaré monitoreando los blog y twitter. Para mas información vayan a este enlace del evento. A principio del 2009 tuve la oportunidad de estar en OpenWorld en Brazil y lo encontre muy bueno... con mucha información valiosa.

Varias cosas me llaman la atención del evento esta semana en San Francisco: 1) Salesforce.com es un sponsor, 2) que ofrecerá Oracle en termino de integración con los canales de social media, 3) que anunciaran sobre como van a ofrecer mas servicios en la nube, 4) cuales son los próximos pasos con Sun y Java, 5) estarán ofreciendo plataformas de comunidades para consumidores, y 6) Oracle Fusion, como va su roadmap de integración.

Me hago estas preguntas, ya que veo tendencias de una transformación en la industria de CRM y estoy ansioso de ver que Oracle estará anunciando esta semana.

¿Que veo en la industria?

Mas en mi blog de CRM en Latinoamerica ...

Filed under: Oracle