tag:blogger.com,1999:blog-90878872351345094162024-03-13T18:42:16.650+01:00OraCleverOracle E-Business Suite - Oracle RDBMS - High Availability - Virtualization - Architecture - InfrastructureArnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.comBlogger50125tag:blogger.com,1999:blog-9087887235134509416.post-3650546957563077342012-11-23T16:02:00.000+01:002012-11-23T16:06:40.422+01:00E-Business Suite R12 integration with Oracle Identity Management 11g <div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;"><span style="font-family: Arial, Helvetica, sans-serif;">After successful implementations of Oracle SSO 10g with Oracle E-Business Suite 11i and R12, I have now completed an installation and implementation of the Oracle Identity Management and Access Management 11g. This is the Single Sign-On solution of Oracle.<br />We used the latest version of Oracle Identity Management( Idm) solution, which is <b style="mso-bidi-font-weight: normal;">currently certified</b> with E-Business Suite R12. This is version IdM 11gR1, to be more precise 11.1.1.5.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;"><span style="font-family: Arial, Helvetica, sans-serif;">Oracle Access Manager (OAM) provides the access management service for authentication and authorization and replaces the Oracle 10g OSSO service.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;"><span style="font-family: Arial, Helvetica, sans-serif;">The current certified implementation requires an Oracle Internet Directory (OID). We have setup the synchronizing process of users from MS Active Directory to Oracle OID. Furthermore, we have setup Oracle provisioning from OID to EBS to create EBS users automatically. <o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;"><span style="font-family: Arial, Helvetica, sans-serif;">We completed the installation with Kerberos authentication. <span style="mso-spacerun: yes;"> </span>With this Windows Native Authentication (WNA) solution, <span style="mso-spacerun: yes;"> </span>we created a ‘zero Single Sign-on’ solution. The user is authenticated by Kerberos tickets and user logon into EBS R12 is based on the network credentials.<span style="mso-spacerun: yes;"> </span>Users do not need to enter the EBS username and password anymore, because they are already authenticated on the network. A very secure solution and saves a lot on user administration.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<span lang="EN-US" style="font-family: Arial, Helvetica, sans-serif; mso-ansi-language: EN-US;">Overview of products installed:<br />- Oracle Identity Management <span style="mso-spacerun: yes;"> </span>11g (11.1.1.5)<br />- Oracle Access Manager 11g (11.1.1.5)<br />- Oracle EBS Access Gate 11g (1.1.1)<br />- Oracle Webserver 11g<br />- Oracle WebGate 11g (11.1.1.5)<br />- Oracle WebLogic Server (10.3.5)</span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbymHcilEwaGvHyiMuUYx1A_GDTnQ2BHsT3ubz06-Ek7cAawP2uLNK5sm23GkKB6rLsAD2HxN3phHgbwDFDbZm3LQVv4Vl2EdAZW6D-pXxDHOuX8AJ3U2NE3pF1zArnj_RZDzbW-4sqDg/s1600/EBSandIDMandOAM11g.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="403" rea="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbymHcilEwaGvHyiMuUYx1A_GDTnQ2BHsT3ubz06-Ek7cAawP2uLNK5sm23GkKB6rLsAD2HxN3phHgbwDFDbZm3LQVv4Vl2EdAZW6D-pXxDHOuX8AJ3U2NE3pF1zArnj_RZDzbW-4sqDg/s640/EBSandIDMandOAM11g.JPG" width="640" /></a></div>
André Eveleenshttp://www.blogger.com/profile/17805962796301573654noreply@blogger.com15tag:blogger.com,1999:blog-9087887235134509416.post-6859296794590841052012-07-10T19:23:00.001+02:002012-07-10T19:23:51.319+02:00Certified Oracle IT Architecture Specialist!Tonight I received an e-mail from PearsonVue that my score report for Exam 1Z1-574 was published. I didn't expect it this soon, since the beta period ended on May 26, if I remember well.<div>
I was so happy to see that I have passed the exam!</div>
<div>
Now it is official: I am Oracle IT Architecture Certified Specialist!</div>
<div>
<img src="https://education.oracle.com/pls/eval-eddap-dcd/get_opn_logo?p_id=600" />
</div>Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com5tag:blogger.com,1999:blog-9087887235134509416.post-81034070004511544162012-03-29T15:38:00.000+02:002012-08-31T12:05:02.857+02:00Collaborate Dutch Preview Event<a href="http://collaborate12.com/" target="_blank">‘COLLABORATE 12: Technology and Applications Forum for the Oracle Community’</a> is de grootste Oracle gebruikersgroep conferentie ter wereld en wordt jaarlijks georganiseerd in de Verenigde Staten. Het is hét evenement om bij te zijn wanneer je geïnteresseerd bent niet alleen in Oracle Applications (E-Business Suite, JD Edwards, Siebel, etc.) maar ook in Oracle Technologie in het algemeen, van ontwikkeling tot beheer. Duidelijke aanwezigheid van Oracle geeft ook aan dat Oracle zelf veel waarde hecht aan deze conferentie. Ook dit jaar zal een aantal Nederlandse Oracle experts een presentatie geven op deze conferentie: Roel Hartman (Logica), Alex Nuijten (AMIS), Arian Stijf (Arven) en Arnoud Roth (Inter Access). Aangezien niet iedereen naar Las Vegas kan om deze conferentie bij te wonen, wordt er door Inter Access een Dutch Preview Event georganiseerd op woensdag 18 april vanaf 17 uur op het kantoor van Inter Access te Hilversum, waar alle presentaties van deze experts zullen worden getoond. Van Application Development, E-Business Suite Security, SOA tot Oracle Fusion Applications, de onderwerpen zijn zo divers dat je zeker een interessante avond zult beleven.<br />
<br />
<b>Nodig gerust geïnteresseerden uit jouw netwerk uit om mee te komen! </b><br />
<br />
Wil je deelnemen aan dit event? stuur een mail naar <a href="mailto:info@interaccess.nl">info@interaccess.nl</a>.<br />
Kijk ook op <a href="http://linkd.in/H2QLSU" target="_blank">LinkedIn</a> en geef aan dat je komt!<br />
<br />
Hieronder het programma van sprekers en presentaties:<br />
<br />
<b>Alex Nuijten, AMIS</b><br />
<br />
<i>Solving Puzzles with SQL: Cheating when playing the game SET</i><br />
Set is a card game which is fun to play while exercising your mind. In this session you will learn about the SET game, as well as how you can leverage SQL to solve it really quickly.<br />
Learn advanced features of SQL, such as Subquery Factoring and ANSI join syntax while we’re cheating in the game of SET.<br />
<br />
<i>Who’s Afraid of Analytic Functions</i><br />
“I never had the need for Analytic Functions”, is one of the phrases that is heard quite often. Maybe that’s true, maybe it isn’t. Recognizing the need for a particular feature can only occur when you have enough exposure to the feature. In this presentation a number of real life examples will be covered which will show the power of Analytic Functions and the ease of solving the challenge at hand.<br />
You can learn the syntax from the Oracle Documentation, but you will learn to recognize “the need for them” by real life examples.<br />
<br />
<i>Database Development: SQL Holmes – The Case of the Missing Performance</i><br />
During this presentation, a case study is unfolded to reveal the true cause of a slow performing query. Did the database just “have a bad day”? Was the evil DBA to blame? The PL/SQL developer who didn’t get enough coffee? Or was it the application sending the “wrong” query in the first place?<br />
In this classic “whodunnit” you will take a tour past the crime scene. Investigate the query, use the tools of the trade and collect all the relevant information. Follow the trail to uncover the truth and nothing but the truth…<br />
<br />
<br />
<b>Roel Hartman, Logica</b><br />
<br />
<i>5 Cool Things You Can Do With HTML5</i><br />
There is a buzz going around about HTML5. What is it exactly? And can we use it now? What are the benefits in an APEX environment?<br />
This presentation will answer these questions and contain some nice demo’s using the new HTML5 features.<br />
<br />
<i>APEX Boot Camp: Striving for Perfection: The Ultimate APEX Architecture</i><br />
APEX supports a flexible architecture. That means that there are multiple ways of solving problems like: separation of data and logic, security issues, re-use, including javascript and CSS, etc. etc.<br />
In this session I’ll give the pro’s and cons of each available option. As this is aimed to be an interactive session, the attendees are encouraged to put forward their own ideas – and concerns. So, maybe, in the end, we’ll reach the “Ultimate APEX Application Architecture”!<br />
<br />
<i>Done in 60 Seconds – Creating Web 2.0 Applications Made Easy</i><br />
This is a two-part session. Dynamic Actions is the most striking new feature of APEX 4. In this session you will learn how to using this new feature will speed up the development of your Web 2.0 enabled APEX applications tremendously.<br />
And of course the main part of this presentation will be live demo<br />
<br />
<b>Arian Stijf, Arven</b><br />
<br />
<i>Securing the E-Business Suite. A Layered Approach</i><br />
In this presentation we look at the features available on different levels of the technology stack, from the User Management in eBS down to the OS and network level. In this presentation we will present you with an overview of features available to secure your e-Business Suite. We discuss a holistic approach to securing your suite, by showing you the interaction between different security features. After the presentation you will be able to achieve the required level of security throughout the entire tech stack.<br />
<br />
<i>From Workflow to BPEL</i><br />
In the (near) future Workflow will be replaced by BPEL. In this presentation we show how customers can prepare for the transition to BPEL. We look at the differences in technology and structure. An overview of the SOA architecture is given. We show how workflows can be 're-designed' in BPEL. There is special attention for developing new workflows that are easier to transfer to BPEL. Hands-on a number of workflows are redesigned in BPEL<br />
<br />
<br />
<b>Arnoud Roth, Inter Access</b><br />
<br />
<i>Oracle Fusion Applications Architecture Fundamentals</i><br />
Oracle Fusion Applications offers the new standard for Business. It also offers a new standard for applications technology and applications architecture. For anyone interested in Oracle Fusion Applications, this is a fundamentals session to explain the technical architectural elements, component interaction and major technology features of Oracle’s newest enterprise application: Oracle Fusion Applications.Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com0tag:blogger.com,1999:blog-9087887235134509416.post-57032884247674941102011-04-11T14:57:00.001+02:002011-04-12T16:41:56.516+02:00IT Strategies from OracleHaving an Enterprise Architecture is essential for successfully rolling out an IT strategy for almost any company. Enterprise Architecture is all about defining what your business wants to do from the perspective of why you want to do it, and translating it into how to do it. There are many frameworks available that help you define an architecture, be it Business, Data, Application or Technology related. For the latter, Oracle has developed a technology architecture, called the Oracle Reference Architecture (ORA). The ORA is part of the IT Strategies from Oracle.<br />
<br />
<img alt="itso-diagram" src="http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/171788.png" /><br />
<br />
The IT Strategies from Oracle give you a whole library of whitepapers, not only to develop a Reference Architecture for your own, by adapting the ORA to your needs, but it also focuses on the surrounding Enterprise Technology Strategies and Enterprise Solution Designs. In other words, ITSO covers both the horizontal technology perspectives (SOA, BPM, EDA, etc.), but also the vertical business perspectives (Utilities, Government, etc.).<br />
<br />
Now, in case you think that this is all about Oracle Technology products, you might be surprised: the whole ITSO / Oracle Reference Architecture is Vendor-Neutral. It is only scoped to Oracle's product portfolio. Now, one might ask themselves: what technology product area's doesn't Oracle have products for, so that shouldn't be too much of an issue as far as completeness is concerned.<br />
<br />
ITSO can help you organizing complex product landscapes, by means of a holistic approach to technology adoption. By covering the technology as a whole, you can reduce risk and become more in control of your IT solutions.<br />
<br />
The ITSO, and, being part of it, the Oracle Reference Architecture is not an Architecture Framework. For this, many solutions are already available, of which TOGAF and Oracle's Enterprise Architecture Framework (OEAF) are good examples. The ORA can be perfectly integrated in any of the currently available frameworks.<br />
<br />
If you are interested in the ITSO, please visit <a href="http://www.oracle.com/goto/itstrategies">www.oracle.com/goto/itstrategies</a>, you will find a great deal of information there:<br />
<br />
Oracle Reference Architectures <br />
These cover<br />
<ul><li>Application Infrastructure Foundation, </li>
<li>Service Orientation,</li>
<li>Service-Oriented Integration, </li>
<li>Software Engineering,</li>
<li>Security, </li>
<li>Management and Monitoring</li>
</ul><br />
Enterprise Technology Strategies for Service-Oriented Architecture <br />
Practitioner Guides<br />
<ul><li>SOA Foundation</li>
<li>Creating an SOA Roadmap, </li>
<li>Frameworks for Governance, </li>
<li>Identifying Services, </li>
<li>Determining ROI, </li>
<li>Software Engineering</li>
</ul><br />
Enterprise Technology Strategies for Business Process Management <br />
These documents contain<br />
<ul><li>BPM Foundation</li>
<li>BPM Infrastructure </li>
<li>Practitioner Guide on Creating a BPM Roadmap</li>
</ul>I am sure you will find something useful in this library for your enterprise information technology strategy.<br />
Be sure to check it out!Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com0tag:blogger.com,1999:blog-9087887235134509416.post-58713860779953533022011-02-25T09:28:00.000+01:002011-02-25T09:28:26.577+01:00Finally took the step: TwitterI have just tweeted for the very first time in my life. Awkward feeling, especially since I am not altogether convinced whether twitter really suits me. On the other hand, blogging takes a lot of time which I can spare really, so maybe twitter will fill the gap...<br />
My account, for anyone interested in following me: OraClever (I have no followers yet, so please...?:-)Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com0tag:blogger.com,1999:blog-9087887235134509416.post-83203583002919044572011-01-31T14:58:00.000+01:002011-01-31T14:58:20.764+01:00TOGAF 9 CertifiedIn the week before Christmas, I attended a <a href="http://www.togaftraining.nl/">TOGAF 9 course</a> (<a href="http://www.the-unit.nl/">http://www.the-unit.nl/</a>). This was particularly interesting, since I have certain architectural responsibilities at the company I work for. TOGAF is becoming more and more a world leading framework for developing architectures.<br />
It was a five-day training, and it has been a most interesting week. The trainer (<a href="http://nl.linkedin.com/in/rienkdekok">Rienk de Kok</a>) was very knowledgeable at the subject and clearly had a lot of working experience. He led us through the wondrous world of developing architectures, and at the end of the course week, we had to take the first exam (TOGAF Foundation). We all passed the exam, which gave us the key to the next exam: TOGAF Certified. In order to pass this exam, you have not only to know the terms and put them in the right place in the framework (Foundation exam), but also need to know how to apply the framework in a series of 8 cases that are examined in the Certified exam. I must say, it was a difficult exam. Not only because the cases are quite extensive (lots of reading), but the answers to the question that comes with each case each are differently awarded. In other words: 3 of the 4 answers are more or less correct in one way or another. There is one best answer, a second best answer and a least good answer. Beside these 3 answers there is one distractor (if you can call it a distractor... sometimes it is quite hard to tell...). <br />
Today I passed the TOGAF Certified exam, which makes me TOGAF 9 Certified.<br />
<br />
5 stars for the training and the trainer!<br />
(and for me, passing both exams at the first attempt :-))Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com4tag:blogger.com,1999:blog-9087887235134509416.post-17177307930228482932010-11-12T20:15:00.000+01:002010-11-12T20:15:01.971+01:00It has been some time......since I last posted here... It has been a busy time. Hopefully I will get back to blogging shortly.<br />
Just be a little more patient...Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com0tag:blogger.com,1999:blog-9087887235134509416.post-64529226531258556782010-06-10T08:29:00.001+02:002010-06-10T08:39:40.648+02:00Oracle Contest: Are You The Smartest 2010 - WINNER!!!In the past half year Oracle BeNeLux organized a contest, called Are You The Smartest. This is a contest for Oracle Partners, and covered 7 evening sessions.<br />
The idea behind this contest is to get Oracle Partner consultants up to speed with new products and strategies on the technology level. Seven evenings packed with information on the following topics:<br />
<br />
<div> </div><ul><li><strong><span style="font-family: Arial;"><strong>Oracle Technology Overview</strong></span></strong></li>
<li><strong><span style="font-family: Arial;"><strong>Layering your Enterprise Security</strong></span></strong></li>
<li><strong><span style="font-family: Arial;"><strong>Database 11g r2 New Features</strong></span></strong></li>
<li><strong><span style="font-family: Arial;"><strong>Enterprise 2.0 and more</strong></span></strong><strong><span style="font-family: Arial;"><strong>Large Databases, Partitioning, Exadata, OWB-ODI, Golden Gate</strong></span></strong><strong><span style="font-family: Arial;"><strong>Oracle </strong></span></strong></li>
<li><strong><span style="font-family: Arial;"><strong>Enterprise Manager from OS to Application</strong></span></strong></li>
<li><strong><span style="font-family: Arial;"><strong>Application Grid 11g with WLS, Coherence, Tuxedo, JRockit, RealTime, ...</strong></span></strong></li>
</ul><br />
<div> </div>Every topic was followed by an exam, to be taken right before the next session.<br />
These were no easy exams, I can tell you. 20 questions in half an hour. Half of the questions were taken directly from the session content, the other half from other documentation and information on the web. Scoring is quite particular: every correct answer is a point, every wrong answer is a negative... So in theory, a negative score can be achieved... Hence, study was necessary.<br />
<br />
<div> </div>My company (Inter Access B.V.) subscribed with approximately 25 consultants, so we were a "big" partner. One of us was to be rewarded the grand prize: An All-inclusive trip to San Francisco and Las Vegas, including a visit to Oracle Headquarters in Redwood Shores.<br />
<br />
<div> </div>Three weeks ago, I received the good news: I am one of the winners of the grand prize! Yesterday evening I was awarded the prize, and next week I will be flying to San Francisco for the trip.<br />
<br />
<div> </div>For a complete coverage of the trip, please visit <a href="http://ayts2010.blogspot.com/">http://ayts2010.blogspot.com/</a>. Stay Tuned!Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com2tag:blogger.com,1999:blog-9087887235134509416.post-20143984438313810222010-01-28T20:18:00.004+01:002010-01-28T20:38:47.686+01:00ACFS: NOT for Database Files!ASM Cluster File System was introduced with Grid Infrastructure along with Oracle 11g Release 2. To be honest, I assumed this file system layer was also provided to store database files, a kind of improvement, because ASM, being a black box to many, 'hided' these database files from sight on the Operating System. Which - on the other side - was kind of neat, because chances were lowered these files to be accidentally removed by non-knowledgable users.<br /><br />It is technically possible to store your database files on ACFS, no question about that. I already deployed a number of test databases on ACFS. However, the <a href="http://download.oracle.com/docs/cd/E11882_01/server.112/e10500/asmfilesystem.htm#CACJFGCD">Oracle 11g Release 2 Storage Administrator's Guide, Chapter 5</a> states:<br /><br /><ul><li> <p>Oracle ASM is the preferred storage manager for all database files. It has been specifically designed and optimized to provide the best performance for database file types.</p> </li><li> <p>Oracle ACFS is the preferred file manager for non-database files. It is optimized for general purpose files.</p> </li><li> <p>Oracle ACFS does not support any file that can be directly stored in Oracle ASM.</p> <p style="font-weight: bold;">Not supported means Oracle Support Services will not take calls and development will not fix bugs associated with storing unsupported file types in Oracle ACFS.</p></li></ul>Especially that last sentence says it all: If you run into trouble with your database stored on ACFS, you will not be assisted by Oracle Support.<br /><br />Here is the list of file types that are NOT supported to be stored on ACFS:<br /><br /><table style="border-collapse: collapse; width: 321pt;" border="0" cellpadding="0" cellspacing="0" width="428"><col style="width: 321pt;" width="428"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 321pt;" headers="r1c1-t2" height="20" width="428">Control files</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r2c1-t2 r1c2-t2" height="20">Data files</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r3c1-t2 r1c2-t2" height="20">Redo log files</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r4c1-t2 r1c2-t2" height="20">Archive log files</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r5c1-t2 r1c2-t2" height="20">Temporary files</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r6c1-t2 r1c2-t2" height="20">Data file backup pieces</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r7c1-t2 r1c2-t2" height="20">Data file incremental backup pieces</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r8c1-t2 r1c2-t2" height="20">Archive log backup piece</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r9c1-t2 r1c2-t2" height="20">Data file copy</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r10c1-t2 r1c2-t2" height="20">Persistent initialization parameter file (SPFILE)</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r11c1-t2 r1c2-t2" height="20">Flashback logs</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r12c1-t2 r1c2-t2" height="20">Change tracking file</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r13c1-t2 r1c2-t2" height="20">Data Pump dumpset</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r14c1-t2 r1c2-t2" height="20">Automatically generated control file backup</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r15c1-t2 r1c2-t2" height="20">Cross-platform transportable data files</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r16c1-t2 r1c2-t2" height="20">Flash file</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r17c1-t2 r1c2-t2" height="20">Oracle ASM Persistent initialization parameter file (SPFILE)</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r18c1-t2 r1c2-t2" height="20">backup</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" headers="r19c1-t2 r1c2-t2" height="20">Oracle Cluster Registry file</td> </tr> </tbody></table><br /><br />Be aware of this when you are designing your Grid Infrastructure!Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com5tag:blogger.com,1999:blog-9087887235134509416.post-86263554102130406362010-01-19T21:58:00.004+01:002010-01-19T22:16:36.084+01:00UKOUG RAC & HA SIG Meeting Agenda AvailableOn February 10 <a href="http://oraclever.blogspot.com/2009/12/presenting-ukoug-rac-ha-sig-meeting-on.html">I will present</a> at the <a href="http://www.ukoug.org/calendar/show_event.jsp?id=4547">UKOUG RAC & HA SIG meeting</a> at Oracle in Reading.<br />The agenda has been published and will contain the following interesting sessions:<br /><br />10:00<br />Welcome and Introduction<br /><br />10:15<br />Support Roundup - Phil Davies, Oracle<br /><br />10:35<br />Recovery of very Large Database in shortest time possible - Arnoud Roth, Inter Access<br /><br />11:45<br />ASM Split Brain - Problem Description - Pavel Rabel, DSP Managed Services<br /><br />12:15<br />Application Consolidation Experiences on a 3-node RAC Cluster - Martin Bach, Markit Group Ltd.<br /><br />14:00<br />Using RAC and Grid for Database Consolidation - Panel Discussion<br /><br />14:45<br />Rolling Database Upgrade, a Real World Experience - Thomas Ramanauskas, ekc<br /><br />15:15<br />Oracle RAC on Cisco UCS hardware, boxes to blades by brunch - Dev Nayak, DSP Managed Services and Carl Bradshaw, Cisco<br /><br />16:00<br />Stretched RAC Cluster with 11gR2, David Burnham, Ioko365<br /><br />16:30<br />Close<br /><br /><br />Looks to be a promising day!<br />I am really looking forward being there.Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com0tag:blogger.com,1999:blog-9087887235134509416.post-42615585432555650512009-12-24T23:33:00.002+01:002009-12-24T23:37:17.685+01:00Happy Holidays!Wishing everybody out there a very merry Christmas and a prosperous 2010, full of learning and sharing!<br />Keep in Touch!<br />ArnoudArnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com0tag:blogger.com,1999:blog-9087887235134509416.post-12826852116130234822009-12-22T21:23:00.003+01:002009-12-22T21:46:40.487+01:00Presenting @ UKOUG RAC & HA SIG meeting on Feb 10On February 10, 2010, the <a href="http://www.ukoug.org">UKOUG</a> <a href="http://www.ukoug.org/communities/show_community.jsp?id=70&parent=811">RAC & HA SIG</a> will organize it's half-yearly <a href="http://www.ukoug.org/calendar/show_event.jsp?id=4547">SIG meeting</a>.<br /><br />I am very pleased to tell you that I have been invited to join this meeting and present about the recovery method I have been exploring lately (see <a href="http://oraclever.blogspot.com/2009/11/coolest-recovery-demo-ever.html">this post</a>, with all its referring posts).<br /><br />The agenda is not yet fully confirmed, but there will be<br /><ul><li>a forum discussion on the topic of using Grid and/or Real Applications Cluster for consolidation;<br /></li><li>Martin Bach (Oracle 10g Certified Master) will do a presentation.<br /></li><li>My presentation - Lightning fast recovery of (physically) corrupted databases without the need to restore the backup - or - To Restore Or Not?<br /></li></ul>Other presentations / sessions have to be confirmed yet, but it all seems quite promising (if I may speak - partially - for myself:-).<br />Once the program is confirmed completely, I will post about it again.<br /><br />The event will take place on Feb. 10 at the <a href="http://www.oracle.com/global/uk/corporate/locations/readingmap.html">Customer Visitor Center at Oracle Thames Valley Park in Reading, UK</a>.<br /><br />Looking forward to an incredible day of learning and sharing.Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com0tag:blogger.com,1999:blog-9087887235134509416.post-26253820335512565392009-12-22T13:17:00.004+01:002009-12-22T15:12:41.668+01:00E-Business Suite Release 12.1.2 availableHaving been ill for a couple of days, I missed Steven Chan's <a href="http://feedproxy.google.com/%7Er/OracleE-BusinessSuiteTechnology/%7E3/SBHLP7z3K-g/ebs_1212_available.html">announcement</a> for Oracle E-Business Suite Release 12.1.2.<br />In an earlier <a href="http://oraclever.blogspot.com/2009/10/oracle-e-business-suite-release-1212.html">post</a> I already elaborated on the new Technology Features of this release.<br />I will get my 12.1.1 environment started up this weekend and see whether I can upgrade to 12.1.2 according to <a href="https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=845809.1">Metalink Note 845809.1</a>.<br /><br />Nice new feature: Oracle Database 11gR2 is certified with R12.1.2 (or should it be the other way around?)!<br /><br />I will keep you updated on my progress.Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com0tag:blogger.com,1999:blog-9087887235134509416.post-89195330452348311252009-12-09T13:59:00.003+01:002009-12-09T14:51:40.685+01:00E-Business Suite R12: Shared Application Tier File SystemIn Oracle E-Business Suite Release 12, one of the eye-catching new features was the Instance Home, or $INST_TOP. The result of this Instance Home is that you can now share the APPL_TOP between multiple installations of Oracle E-Business Suite.<br />I have seen a number of articles and discussions on the Internet discussing the reasons why one would want to share the APPL_TOP between E-Business Suites.<br /><br /><span style="font-weight: bold;">Why share?</span><br />Personally, I didn't see any reason why I would want this, other than to see it work and be able to use the feature, when time would come that I would need it.<br />I cannot remember where anymore, but I saw a reason lately that actually made sense to me:<br />As a DBA, it could be of use when I would want to replay issues that have been reported to me, being sure that I would be using the exact same APPL_TOP. I could set up a separate E-Business Suite, sharing the APPL_TOP, but having my own database. Now I can play around with my own E-Business Suite, without making changes to the production data, but I am still using the very same code as in the production environment. To make sure I do not break anything, I could even mount the APPL_TOP read only.<br />Recently I found another reason why it could be interesting to share the APPL_TOP: When your production environment consists of multiple E-Business Suites. I heard about Oracle's recommendations to separate Advanced Supply Chain Planning from your OLTP E-Business Suite environment. You would have to maintain two E-Business Suites, and I can see a couple of reasons why you would want to have identical code versions on each of them. In order to keep the two (or any number of) environments synchronous, you might want to implement the shared APPL_TOP.<br /><br /><span style="font-weight: bold;">Share what? APPL_TOP vs. Application Tier File System</span><br />By the way, can "shared APPL_TOP" also be read as "Shared Application Tier File System"? I have taken up the habit of asking whether APPL_TOP means Application Tier File System, or it just reflects the $APPL_TOP directory with all its subdirectories. It happens to be that the two are not the same, even though many of us use the two simultaneously.<br />In my opinion (but that may be because my experience goes back to the days these technologies were introduced), the APPL_TOP is just the ($)APPL_TOP: the top level directory that contains the product tops (<span style="font-family: arial;"><span style="font-family: courier new;">/whatever_directory/apps/apps_st/appl)<span style="font-family: georgia;">.<br />The Application Tier File System is more than just the APPL_TOP. It contains the whole set of code that makes the Application Tier, i.e. the APPL_TOP, COMMON_TOP, but also the 10.1.2 and 10.1.3 ORACLE_HOMEs that reside under </span></span></span><span style="font-family: arial;"><span style="font-family: courier new;">/whatever_directory/apps/tech_st</span></span><span style="font-family: arial;"><span style="font-family: courier new;"><span style="font-family: georgia;">. To conclude: The Application Tier File System is everything that resides under </span></span></span><span style="font-family: arial;"><span style="font-family: courier new;">/whatever_directory/apps</span></span><span style="font-family: arial;"><span style="font-family: courier new;"><span style="font-family: georgia;">. That is a whole lot more.<br />But hang on? The question now is what Oracle means by stating that the APPL_TOP can be shared among multiple E-Business Suite environments. Do they mean just the <span style="font-weight: bold;">APPL_TOP</span>, or the <span style="font-weight: bold;">Application Tier File System</span>?<br />The official answer can be found in <a href="https://supporthtml.oracle.com/ep/faces/secure/km/DocumentDisplay.jspx?id=384248.1&h=Y#appendix_b">Metalink Note 384248.1</a><a href="https://supporthtml.oracle.com/ep/faces/secure/km/DocumentDisplay.jspx?id=384248.1&h=Y#appendix_b">, Appendix B</a> where you can read that it is possible to share the complete Application Tier File System among multiple unshared E-Business Suite Databases.<br /></span></span></span>Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com0tag:blogger.com,1999:blog-9087887235134509416.post-40382416825274163782009-11-04T14:12:00.003+01:002009-11-04T14:33:20.065+01:00"...Coolest Recovery Demo Ever..."Yesterday, I got the chance to perform a presentation at the Dutch Oracle User Group (OGh) DBA day about a topic that I have blogged about a couple of days ago: <a href="http://oraclever.blogspot.com/2009/10/using-rman-backup-as-copy-as-base-for.html">Database Crash Recovery : To Restore Or Not Restore</a>.<br /><br />I proved my "theory" with a live demo. In VMware I crashed my database after having it backed up, after which I was able to recover within 5 minutes, without restoring the backup. All changes were kept, even the changes after the last incremental backup was taken... (I admit, I was impressed myself, too!:-)<br /><br />The presentation went well, and today I received some comments from some of the attendees, telling me that the presentation was received extremely well. One of the attendees even twittered about "the coolest recovery demo ever".<br /><br />For anyone interested in the solution/approach: The concepts of this approach are outlined in <a href="http://oraclever.blogspot.com/2008/11/recovering-large-databases-in-shortest.html">this</a> and <a href="http://oraclever.blogspot.com/2009/10/using-rman-backup-as-copy-as-base-for.html">this</a> article, founde elsewhere on my weblog.<br /><br />Happy reading and testing!Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com0tag:blogger.com,1999:blog-9087887235134509416.post-71350889746369029412009-10-28T11:04:00.007+01:002009-10-28T12:28:16.630+01:00Oracle E-Business Suite Release 12.1.2 - New FeaturesWondering what the next release of E-Business Suite R12 will contain? Steven Chan posted a <a href="http://feedproxy.google.com/~r/OracleE-BusinessSuiteTechnology/~3/vzWLIZJ7LSc/ebs_1212_rcd_available.html">weblog about the availability of the 12.1.2 RCD</a> yesterday, way before R12.1.2 is made available (the release date is not yet known).<br />However, it is always interesting to see what the next upcoming release will contain. I will stick to the Applications Technology, because that is my part of the pond:<br /><br /><em>Technology Highlights</em><br /><ul><li>The most eye-catching new feature is <strong>support for 11gR2 database</strong>. Unfortunately (in a way) 11gR2 will not be shipped with 12.1.2. It'll still come with 11.1.0.7.</li><li>On the middle-tier, support is introduced for <strong>AS 10gR3 (10.1.3.5)</strong> which will be shipped with the release, <strong>JDeveloper 10.1.3</strong> and it uses the <strong>Sun Java Plug-in version 6</strong>.</li><li><strong>The Application Server for Forms and Reports</strong> will be <strong>10.1.2.3</strong>. The maintenance pack will either include or require customers to upgrade to this version.</li><li>Of all <strong>externally installed Oracle technology</strong> (WebCenter, Discoverer, Portal, Internet Directory, SSO, BPEL PM, OBIEE, OEM, etc) the <strong>most recent version</strong> will be certified with 12.1.2.</li></ul><p><em>Internationalization Highlights</em></p><ul><li>Added support for Lithuanian, Indonesian and Ukrainian languages.</li><li>Space and single quote number group separators</li><li>First day of the week support (choose whichever day is the first day of the week)</li><li>The Gantt chart and inline date picker features support Thai and Hijrah calendars</li></ul><p><em>Oracle Applications Framework Highlights</em></p><ul><li>Redesigned Home Page<br />new folder-like structure, better spacing, favorites are now in a pull-down menu. In general the home page is more compact and allows for easy extension and custom content.</li><li>New Navigator Menu and favorites Pull-Down menue in the Global Header area<br />The Navigator Menu now appears in every OAF page (Pull-down menu). Favorites menu is also a pull down menu from the Global Header area and allows for marking the current page as favorite.</li><li>Look-ahead capability in lists of values<br />When entering a limited number of characters in a field, an inline window will let you select from a list of values based on the characters you typed. This way, you can limit the number of values in the inline window and ease your search for the correct value.</li><li>ability to add, view, edit and delete attachments inline<br />Inline attachments now have a hover-over interaction allowing users to view, add, edit and delete attachments to an entity. This capability eliminates the need to go to the Add and View attachments pages to maintain attachments.</li><li>pop-up component<br />This allows applications to display a pop-up window on top of an OAF page.</li><li>Portlet Generator<br />For static conversion of a standalone OAF region into a portlet. These can be embedded in any portal application or WebCenter.</li><li>A new component: rich container that can hold OBIEE content.<br />Through personalization, users can configure this component to hold a certain OBIEE report that accepts specific parameters.</li></ul><p><em>Oracle Application Object Library Highlights</em></p><ul><li>Oracle Access Manager integration support<br />OAM can be used in stead of Oracle Single Sign On for thos applications or products that support it, but it can also be used together with OSSO to provide centralized authentication.</li><li>AOL Java APIs<br />Support for Oracle E-Business Suite Release 12.1.2 is provided</li><li>Scheduling Charts UI Enhancements<br />Dragging task numbers into the scheduling chart to create new tasks and shifts on the fly. Simplified ability for creating, assigning, searching and displaying new task assignments from a single source.</li></ul><p><em>Diagnostics Framework</em></p><ul><li>Added support for XML file type diagnostics.</li></ul><p><em>Integrated SOA Gateway</em></p><ul><li>SAML Token Support<br />E-Business Suite environments can trust external systems. These external systems can use a public key to authenticate a SOAP request using SAML.</li><li>Enhanced SOA Diagnostics<br />To check the health of the EBS Integrated SOA Gateway.</li><li>New interface type: Java APIs for Forms<br />these are XML document based interfaces, wrapped in Java classes to execute logic in Oracle Forms. Integrated in the Oracle Integration Repository (iRep)</li><li>Integrated SOA Gateway Customization<br />Support for custom integration interfaces, that can be deployed as custom Web Services. Customization feature is provided through the Integration Repository Parser.</li></ul><p><em>Web ADI Highlights</em></p><ul><li>Introducing the Web Applications Desktop Integrator Extension Framework<br />wizard-based UI to create and manage desktop integrator solutions, providing a user-friendly approach to create custom integrators, without having to know the complexity of the EBS Schema.</li></ul><p><em>Conclusion</em></p><p>My personal curiosity is focused on 11gR2 (I would be really interested in seeing the E-Business Suite running on 11gR2 Grid Infrastructure!). For sure there is enough to lookout for. Again, I am eagerly awaiting this new release.</p><p></p>Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com7tag:blogger.com,1999:blog-9087887235134509416.post-2034331566170709982009-10-27T09:55:00.001+01:002009-10-27T09:58:21.804+01:00using the RMAN backup as copy as base for Disaster Recovery<div>In an <a href="http://oraclever.blogspot.com/2008/11/recovering-large-databases-in-shortest.html">earlier post</a> I have elaborated on the advantages the backup as copy feature offers to quickly recover from a damaged database.</div><br /><div>In this article I will try to show how this advantage goes even further by adding another server to the infrastructure, introducing some kind of Disaster Recovery solution. OK, it is not fully featured like Oracle Dataguard, but it works and can be the first step towards Disaster Recovery. No need for a standby database, redo log shipping etc. It is all plain simple and straight-forward.</div><br /><div>Shopping list:</div><ol><li>2 servers, not necessarily equal in specifications, but having identical Operating Systems</li><li>Clustered File System (OCFS2 will suffice, even NFS will do the job)</li></ol><div>Preparations</div><div>First of all, you need to set up OCFS. Tons of information out there on the Internet to get your OCFS working. It is not difficult, See this <a href="http://oss.oracle.com/projects/ocfs2/dist/documentation/ocfs2_users_guide.pdf">PDF</a> for information.<br />What I have done to make this work is set up 2 OCFS2 File Systems, one under /oradata and one under /orafra.<br />Next, install the Oracle RDBMS software on both machines, each using the same location for the Oracle Home and installing identical copies.</div><br /><div>Once you have OCFS2 set up on your 2 servers, create or move your database onto /oradata, and make sure the DB_FILE_RECOVERY_DEST parameter points to /orafra and the DB_FILE_CREATION_DEST points to /oradata. Don't forget the DB_FILE_RECOVERY_DEST_SIZE parameter! Set it to a size equal to the file system where it is located, to make sure you will not run out of space too soon.</div><br /><div>Your infrastructure will look like this (more or less):</div><br /><div> </div><br /><div><img style="margin: 0px auto 10px; text-align: center; width: 320px; display: block; height: 282px;" id="BLOGGER_PHOTO_ID_5376080000283103714" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPDhVStvUtdLC5piImuLgE9f8WhRuxf0sLXGOVZ4JvtG1By2GFrT6-Z3PiEeE-dDgPnLaGtpgx-83blBRZwt4j8hrGQ6Fy68QCAFXyrDQBwKmDzk2zU0JUUmEc13moj18pXSbR2YqQr_Ze/s320/fra1.gif" border="0" /></div><br /><br /><div>/oradata is the location for you database, /orafra is for the Flash Recovery Area.</div><p>Now we can prepare the secondary machine to serve as Failover server.</p><p>To do this, take the following steps:</p><p>1. Copy the server parameter file and bring it to the secondary machine under $ORACLE_HOME/dbs. Edit this file and make adjustments to the following parameters:<br />CONTROL_FILES = /orafra/<em>SID<sid></sid></em>/controlfile/cp_cntrl.ctl<br />DB_FILE_RECOVERY_DEST = /oradata<br />DB_FILE_CREATE_DEST = /orafra<br />Optionally, you can create an spfile from this parameter file on the secondary machine.</p><p>2. Copy the /etc/oratab file to the secondary node</p><p>3. Create the necessary dump directories ($ORACLE_HOME/admin)</p><p>Now you are ready to go! Bring up your database on the primary machine and create a full backup as copy from your database:</p><p><span style=";font-family:courier new;font-size:85%;" >allocate channel for maintenance type disk;<br /></span><span style=";font-family:courier new;font-size:85%;" >configure controlfile autobackup on;<br />configure default device type to disk;<br />run<br />{<br />RECOVER COPY OF DATABASE WITH TAG ‘IMG_COPY’ UNTIL TIME ‘SYSDATE – 1’;<br />BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG ‘IMG_COPY’ DATABASE PLUS ARCHIVELOG DELETE INPUT;<br />copy current controlfile to ‘/orafra/<sid>/controlfile/cp_cntrl.ctl’;<br />} </sid></span></p><p><span style="font-family:georgia;">This script will do everything for you. See <a href="http://oraclever.blogspot.com/2008/11/recovering-large-databases-in-shortest.html">this post</a> for an explanation of the script.</span></p><p>Now let's make some changes to the database and run the backup script again (NOTE: in order to have all changes you made to the database immediately reflected in the copy of your database, remove the UNTIL clause in the first line of the backup script).</p><p>What you can do now, is to simulate a crash of the database (there are a lot of ways to do this, I would recommend you just issue a shutdown abort at your first attempt).</p><p>Go to the second machine, log in as the oracle user, source your environment and perform the following steps to recover your database:</p><ol><li>start an rman session to the database (which is not started yet)</li><li>mount the controlfile (located in /orafra/SID/controlfile, pointed to by the parameter file)</li><li>issue "switch database to copy"</li><li>issue "recover database"</li><li>issue "alter database open resetlogs"</li></ol><p>That is all it takes. Now your database is opened and available from the secondary machine. Now make sure that you reverse file locations in the backup scripts on the secondary machine to reflect the database file locations and the Flash Recovery Area. The database files should be located in /orafra, the flash recovery area should be located in /oradata. If you want to switch back, just use the backup script to create another backup as copy and switch back the way you did earlier. Make sure you have defined the correct file locations on the primary server, alike the secondary machine, to smoothen the switch.</p><p>Caveats</p><p>Like what is the case with any other regular backup, when you have made changes to the physical structure of your database (like adding datafiles, tablespaces, etc), an incremental backup needs to be taken immediately after, to prevent issues while recovering the database from the copy.</p><p>Another caveat is that it is necessary to have both database servers available in your tns alias being used to access the database. In such a case it is important to have load balancing set to off and failover set to on, having the primary as the first address.</p><p>Alternatives</p><p>If your server is still available, but the database has become corrupted, you can easily switch to the copy without the need for the secondary machine with a similar procedure as mentioned above. This way you will always have the choice of what to do.</p><p>Happy testing!</p>Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com0tag:blogger.com,1999:blog-9087887235134509416.post-33716310357851631132009-09-23T13:13:00.004+02:002009-09-23T13:21:25.390+02:00Oracle 11g Release 2 Clusterware New Feature: Policy-based Cluster and capacity management<p class="MsoNormal">I was reading through the Oracle 11g Release 2 Real Applications Cluster New Features List and stumbled upon this really cool new feature. I have to tell you about it, because this, imho, is one of the things that makes Oracle Clusterware a “Grid”.</p> <p class="MsoNormal">So, what is Policy-based management? In order to answer that, you must first understand some basic changes in 11gR2. This is what the manual says:</p> <p class="MsoNormal">With Oracle Clusterware 11g release 2 (11.2) and later, resources are contained in logical groups of servers called server pools. Resources are hosted on a shared infrastructure and are isolated with respect to their resource consumption by policies, behaving as if they were deployed in a single-system environment.</p> <p class="MsoNormal">What does this mean? I have a bunch of resources and a bunch of servers (a grid) and subsets of these servers are combined in server pools. The resources are assigned to these server pools, but the server pool acts as if it were just one system. The isolation is done on a policy base. The whole idea is being able to limit the capacity that is assigned to a resource, and have a set of server pools to service those resources. BTW. It is possible to assign a server to multiple server pools.</p> <p class="MsoNormal">This kind of management enables you to dynamically assign capacity to meet your policies and priorities, as well as to allocate (physical) resources by importance. Your critical applications will always have a minimum of resources at its disposal. It also gives you the opportunity to limit applications to use a set of servers.</p> <p class="MsoNormal">How does it work? You just assign the minimum and maximum number of nodes to a resource, as well as the priority and Oracle Clusterware will do the rest.</p> <p class="MsoNormal">The servers will get a number of attributes, like a name (basically the node name), the pools to which it belongs and the state it is in with some details.</p> <p class="MsoNormal">How do Server Pools work? They are sets of servers, that service resources. What they will try to do is to spread the workload over the available servers in the pool. It is possible to limit a database to run in a specific server pool.</p> <p class="MsoNormal">The top-level server pool is an exclusive server pool, which means that any given server can only be a part of one top-level server pool. It is impossible to be a member of multiple top-level server pools. This way, the grid or cluster is logically divided.</p> <p class="MsoNormal">All servers that join the cluster/grid are automatically assigned to the Free Pool initially. This Free Pool is a server pool that is automatically created at installation. From here, servers can be assigned to other server pools. Another pool, the Generic Pool is also automatically generated, and all servers will be part of this pool too, in order to ensure compatibility with prior releases. Any pre-11gR2 database will need to run in this generic server pool.</p> <p class="MsoNormal">The server pool is given an minimum and maximum number of nodes. As soon as the number of nodes decreases below the minimum value, Clusterware will automatically take necessary action and take servers from other pools to increase the number of servers to meet the required minimum number.</p> <p class="MsoNormal">If this poses a problem for other server pools, decisions are made upon the importance of the pools. When importance is equal, it is only possible to take servers, if the number of servers is higher than the minimum value.</p><p class="MsoNormal">All of the above can be done completely dynamically, however, manual manipulation is still possible. You might think: "Where is my control?", but if you set it up carefully, it could save you a bundle. For example, when you configure Grid Plug and Play (another one of those new features), it is possible to have a database bring up a new instance in the server pool and automatically create new log threads, undo tablespaces, etc. Isn't that way cool?<br /></p>Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com0tag:blogger.com,1999:blog-9087887235134509416.post-65880930266873242632009-09-23T09:00:00.004+02:002009-09-23T09:13:31.221+02:00Oracle 11g Release 2 - ADVM (ASM Dynamic Volume Manager)One of the new features in Oracle 11g Release 2 is Automatic Storage Management Cluster File System. This file system provides concurrent access from multiple (clustered) nodes.<br /><br />ACFS is provided through the Automatic Storage Management Dynamic Volume Manager. In order to have a file system, one needs a volume (be it physical or logical) to put it on. Oracle has developed a Dynamic Volume Manager (ADVM) that can provide these volumes from ASM Diskgroups. You can use ADVM to create volumes that are replicated within the ASM diskgroup mechanism – by means of normal or high redundancy. Multiple volumes can reside on one diskgroup. The ADVM provides a device driver interface to the ACFS client.<br /><br />Due to the mirroring features of ASM, it is possible to have a mirrored file system (even across a stretched cluster, when your storage infrastructure allows for such an architecture) that will leverage the features of ASM to provide consistency over hardware failure and ASM instance crashes.<br /><br />You can use the file systems provided through ADVM not only for database files, but also for regular files such as executables and log files. During creation of the file system you have the choice to designate the file system for Oracle Home functionality. By choosing this option, the file system is registered in the Cluster Registry as a managed resource, giving Oracle the opportunity to layer dependencies on this file system for the use of Oracle Homes.<br /><br />Because of the fact that Oracle ADVM Volumes are technically spoken ASM files located on ASM Disk groups, and the fact that the Dynamic Volumes do not use the traditional device partitioning, it enables Oracle to extend some of the ASM features to the ASM Clustered File Systems, which are created inside these ADVM Volumes, such as dynamic resizing or dynamically adding volumes. This makes ADVM and ACFS a far more flexible solution than traditional physical devices.<br /><br />Important Note: Oracle ADVM supports all storage solutions supported for Oracle ASM with the exception of NFS and Exadata storage. That will have to wait for some time still…<br /><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMatRTx0Q1zoeLjEEeey4AWql4HvYG_8Ai0pIxhJxaEbP3FEMTRnoLrwsv0R_WjrsVQsvi0Zmya1Bqz0HApUL8xB3c6m844q4NOoDd-Rwz2a3E-1sybrki0UY_M5zAjUHn7Bcvv1Ki5Ep2/s1600-h/19.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 270px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMatRTx0Q1zoeLjEEeey4AWql4HvYG_8Ai0pIxhJxaEbP3FEMTRnoLrwsv0R_WjrsVQsvi0Zmya1Bqz0HApUL8xB3c6m844q4NOoDd-Rwz2a3E-1sybrki0UY_M5zAjUHn7Bcvv1Ki5Ep2/s320/19.png" alt="" id="BLOGGER_PHOTO_ID_5384556322238201410" border="0" /></a>The above picture shows the User Interface, provided through the ASM Configuration Assistant (asmca), to create file systems inside ASM using the ADVM.Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com5tag:blogger.com,1999:blog-9087887235134509416.post-20493329949313407862009-09-16T11:41:00.006+02:002009-09-16T12:00:00.101+02:00Oracle ACFS advanced topicsWhile everybody is exploring new features of the latest release of Oracle 11g, we're all very excited about all the new possibilities.<br />One of those new features is Oracle ACFS (ASM Cluster File System), wich provides an Oracle Home shared file system or a general purpose clustered file system on ASM storage. These are very nice features that will be used by many customers, in time to come. My first experiences are quite good. However, it is of great importance to know the limitations of those new features as well. Oracle has - on the topic of ACFS - thought about this very carefully, by adding an Appendix to the <a href="http://download.oracle.com/docs/cd/E11882_01/server.112/e10500/toc.htm">Storage Administrator's Guide</a>, called <a href="http://download.oracle.com/docs/cd/E11882_01/server.112/e10500/asmfs_extra.htm#sthref1278">ACFS Advanced Topics</a>. Amongst these, a number of limitations are discussed. Well, one can argue whether these are actual limitations, that really limit you in operating ACFS, but it is good to know about these when planning for you Grid Infrastructure.<br /><br /><span style="font-weight: bold;">Oracle ACFS Disk Space Usage</span><br />Some Facts and Figures: Oracle ACFS supports:<br /><ul><li>64 million files in a file system, </li><li>63 snapshots, </li><li>64 mounts on 32 bit systems, </li><li>256 mounts on 64 bit systems.</li></ul><br />Oracle allocates metadata for each node that mounts the file system, comprising approximately 64 – 128 MB per node. Also, some space is reserved for local bitmaps to reduce contention on the global bitmap in order to find free space. This can add up to 128MB per node. All of this space is reported as “in use” when querying the file system for disk space.<br /><br /><span style="font-weight: bold;">Oracle ACFS Error Handling</span><br />CAUTION: It is very important to unmount any file system that is using the Oracle ASM Dynamic Volume Manager (ADVM), before shutting down an Oracle ASM Instance. Failing to do so can result in I/O failures. One can never guarantee that the ASM instance(s) will never fail, but in case it does, volumes must be closed and opened again to be able to access them. Dismount the file systems that were mounted during failure and after the instance is restarted, mount the corresponding disk group with the volume enabled, after which you can mount the file system again.<br /><br />Therefore, if any file systems are currently mounted on Oracle ADVM volume files, the SHUTDOWN ABORT command should not be used to terminate the Oracle ASM instance without first dismounting those file systems.<br /><br />When a metadata write fails, regardless whether it be an ASM or storage failure, ACFS isolates the errors to a single file system and puts it in an off-line state. The only thing you can do with it is dismount. Other nodes (when available) recover the transaction, if it can write to that particular storage. After this, the file system can be mounted again.<br /><br />When the file system being put offline is in use by processes or users, it might not be possible to unmount it. The administrator has to identify the processes that are claiming the file system and stop them before unmounting.<br /><br /><span style="font-weight: bold;">Oracle ACFS and NFS</span><br />Because block device major numbers of ADVM devices can be different after a reboot, the -fsid=# should be used when exporting NFS file systems. The option forces the clients to use this number (#) when communicating with this file system. Obviously, the number should be unique across the cluster. It replaces the number derived from the major/minor number of the device itself, since it can change with reboots.<br /><br /><span style="font-weight: bold;">Limits of Oracle ADVM</span><br />Some Facts: The default configuration for an Oracle ADVM volume is four columns of 64 MB extents in length and a 128 KB stripe width. Oracle ADVM writes data as 128 KB stripe chunks in round robin fashion to each column and fills a stripe set of four 64 MB extents with 2000 stripe chunks before moving to a second stripe set of four 64 MB extents for volumes greater than 256 megabytes. Note that setting the number of columns on an Oracle ADVM dynamic volume to 1 effectively turns off striping for the Oracle ADVM volume (are you still with me?;-)<br /><br />On Linux platforms Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume devices are created as block devices regardless of the configuration of the underlying storage in the Oracle ASM disk group. Do not use raw (8) to map Oracle ADVM volume block devices into raw volume devices.<br /><br /><span style="font-weight: bold;">Oracle ACFS and Oracle Restart</span><br />Oracle Restart does not support root-based Oracle ACFS resources for this release. As a result, the following operations are not automatically performed:<br /><ul><li>Loading Oracle ACFS drivers</li><li>Mounting Oracle ACFS file systems listed in the Oracle ACFS mount registry</li><li> Mounting resource-based Oracle ACFS database home file systems</li></ul>The Oracle ACFS resources associated with these actions are not created for Oracle Restart configurations.<br />In short, the following resources are only supported for the Oracle Grid Infrastructure Cluster configurations, and are not supported for Oracle Restart Configurations:<br /><ul><li>The Oracle ACFS drivers resource (ora.drivers.acfs),</li><li>The Oracle ACFS registry resource (ora.registry.acfs)</li><li> The Oracle ACFS individual file system resource ora.diskgroup.volume.acfs)</li></ul><br />Source: <a href="http://download.oracle.com/docs/cd/E11882_01/server.112/e10500/toc.htm">Oracle Database Storage Administrator's Guide, 11g Release 2</a>, <a href="http://download.oracle.com/docs/cd/E11882_01/server.112/e10500/asmfs_extra.htm#sthref1278">Appendix B</a>Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com0tag:blogger.com,1999:blog-9087887235134509416.post-49148857723885245742009-09-15T08:07:00.005+02:002009-09-15T08:20:47.842+02:00ASM Cluster File System: Available Storage From the ASM PerspectiveI was checking my system this morning, having it booted for the first time after the installation of Oracle 11g Release 2 Grid Infrastructure.<br />I opened up SQL*plus for a connection to ASM, to see what the disk space usage was.<br />I found the following information:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDwNWLQ98EMkxGs-7j5ukrrVa7vTSdSASCtxoMJI3mFD7BtggU4-V4L3giutDd2JYIEVwOZpr-kQ94-yjLhiVowLzvn9bVBPGGmD0F9jtT_O3BsbT0pnhtD0cWTFIJNObQf375lxLZl0G8/s1600-h/21.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 192px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDwNWLQ98EMkxGs-7j5ukrrVa7vTSdSASCtxoMJI3mFD7BtggU4-V4L3giutDd2JYIEVwOZpr-kQ94-yjLhiVowLzvn9bVBPGGmD0F9jtT_O3BsbT0pnhtD0cWTFIJNObQf375lxLZl0G8/s320/21.png" alt="" id="BLOGGER_PHOTO_ID_5381573048928442194" border="0" /></a>The first section of the screen shows the total amount of diskspace and available diskspace from an ASM perspective, the lower part of the screen shows the file system usage.<br />Here you can see that the file system, even though it has practically all space available, has claimed all of its space in ASM. Logically, you might think, but since the two are so tightly integrated, might surprise a bit.<br />The principle is the same compared to 10g ASM with Oracle Datafiles. The datafile itself might not been occupied fully, still all of the space that the datafile is configured with needs to be allocated in ASM. When you want to see what your actual usage is on an ASM disk and how much you can grow, you would need to calculate the free space in your file system and add the FREE_MB column from within ASM to it to determine the exact free space on your ASM Disk(s).Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com0tag:blogger.com,1999:blog-9087887235134509416.post-16170813795320368292009-09-11T16:23:00.010+02:002009-09-11T17:10:11.993+02:00Configuring ASM Clustered File Systems (ACFS) in Oracle 11g Release 2After having finished the installation of Oracle 11g Release 2 Grid Infrastructure, the next step is to configure your storage.<br />ASM has always been a layer between the hardware and the database files.<br />Starting with Oracle 11g Release 2, Oracle has introduced a second cluster file system (next to OCFS2) called ACFS (ASM Cluster File System), to be hosted within ASM This is a major new feature of Oracle 11g Release 2.<br />This cluster file system not only supports binaries, like the ORACLE_HOME. In fact, what we'll see further on in this post, there is a differentiation between a file system for Oracle Home purposes and for General Purposes.<br />In order to setup an ASM Cluster File System, you simply start the ASM Configuration Assistant. Source the ORACLE HOME of Grid Infrastructure, make the bin subdir accessible from the PATH variable and simply type: <span style="font-family:courier new;">asmca</span><br />What you will get is something similar to this (click on the images to get a larger view):<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGao2rKQEGD-70WLPE8NOLc7O8eaBJxDRxwvO09BFBeCZ7dwqO-_s9rHRwKf8BRMUrbQS9kFy_b6_dfbwJ1VUF4w8E5-kx8-jZRplOeWmS7rrNidRkUcZvnxtkk2KlRG4vTavwW5Egsx0c/s1600-h/1.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 192px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGao2rKQEGD-70WLPE8NOLc7O8eaBJxDRxwvO09BFBeCZ7dwqO-_s9rHRwKf8BRMUrbQS9kFy_b6_dfbwJ1VUF4w8E5-kx8-jZRplOeWmS7rrNidRkUcZvnxtkk2KlRG4vTavwW5Egsx0c/s320/1.png" alt="" id="BLOGGER_PHOTO_ID_5380217745100254514" border="0" /></a>You can see the four tabs, ASM Instances, Disk Groups, Volumes and ASM Cluster File System. We'll cover each of them later on. For now, only the first two tabs are shown.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8oA1twAlZkCdaP6sGpcJxPOoT1UR_T2iEQ3_jl9Go0klFR6pEq91YEbu7gs_xqA1LyR-giqKrOKcQEiBRHjGJONza-bH0z598IcOW7nf3ERo-oc5xUu1sVKAOLS_5EUuHLHNDuLyGwzg5/s1600-h/2.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 198px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8oA1twAlZkCdaP6sGpcJxPOoT1UR_T2iEQ3_jl9Go0klFR6pEq91YEbu7gs_xqA1LyR-giqKrOKcQEiBRHjGJONza-bH0z598IcOW7nf3ERo-oc5xUu1sVKAOLS_5EUuHLHNDuLyGwzg5/s320/2.png" alt="" id="BLOGGER_PHOTO_ID_5380217740768642370" border="0" /></a>What we'll have to do first is to create a diskgroup. I happened to be prepared for this, so I created an ASM disk prior to running this Configuration Assistant. Just hit the "Create" button and you'll get:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMpyTCiowESELQlcV7cCcrWBiJd4d7D0uwKXuluj-91T2BjC_N_N2vEEKDss7OmNVp4OaFq2pH8TORYNf-eYv7WWWeNxDLQLoqD2kWUZKlYYGlt_4LWzjy0xiOkhGtlXrMFK6CDWsIdUd7/s1600-h/3.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 300px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMpyTCiowESELQlcV7cCcrWBiJd4d7D0uwKXuluj-91T2BjC_N_N2vEEKDss7OmNVp4OaFq2pH8TORYNf-eYv7WWWeNxDLQLoqD2kWUZKlYYGlt_4LWzjy0xiOkhGtlXrMFK6CDWsIdUd7/s320/3.png" alt="" id="BLOGGER_PHOTO_ID_5380217735339737874" border="0" /></a>I have called my first disk group DATA. By clicking on the button "Show Advanced Options" you will see the compatibility parameters that can be set per diskgroup (ASM, Database and ADVM (ASM Dynamic Volume Manager) compatibility). Select the disk(s) and click on OK to create the Disk Group:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxvKc5SkjD7vkODbsKoEJT4cEtkitTb3lGDksfECLwNMic0KCrlOFAl_xn2SalLoWEIZmapB7zvtVT6tZHR4EGlpdoXpSlAVpIaaaT1G3i29pWLgfmLxRjyJz1FktNhyphenhyphenmUkeKAARNZIIji/s1600-h/4.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 90px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxvKc5SkjD7vkODbsKoEJT4cEtkitTb3lGDksfECLwNMic0KCrlOFAl_xn2SalLoWEIZmapB7zvtVT6tZHR4EGlpdoXpSlAVpIaaaT1G3i29pWLgfmLxRjyJz1FktNhyphenhyphenmUkeKAARNZIIji/s320/4.png" alt="" id="BLOGGER_PHOTO_ID_5380217725929708098" border="0" /></a><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuo4MomfA0InqhH6TLUpEiKHAE7hgdgXiivnMCECDDIYTZMC9IoqG_lSQ9qgtonm-XtIAwxjIn9vJePObNK095J2ONqsYi7kUqwJaGmmDqyoRnCneF6DZ2Qv3ztbvcqkXCrepKkd_V57Ub/s1600-h/5.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 243px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuo4MomfA0InqhH6TLUpEiKHAE7hgdgXiivnMCECDDIYTZMC9IoqG_lSQ9qgtonm-XtIAwxjIn9vJePObNK095J2ONqsYi7kUqwJaGmmDqyoRnCneF6DZ2Qv3ztbvcqkXCrepKkd_V57Ub/s320/5.png" alt="" id="BLOGGER_PHOTO_ID_5380217725346995186" border="0" /></a>Well, I think that was a success:-)<br />Next, go to the Volumes tab. We will have to create a volume first. By the way, doesn't this sound like an old-fashioned Volume Manager setup? It does, because it actually is. The difference with all the OS's proprietary volume managers is that this one is optimized for Oracle, and that should be enough to prefer this one over anything else.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhABxzifb4YZTbXS90NPPJX3SKRq43u0gyWei2BJizfFDZBQMO9Jdo9GILUOPV0uLaz0vbaJs6zVEpMoH6JoqNunv5ZJNLH_bM5-vALjxj-mZDTY3iJAxhIBmmNJmRlaHn1MgAyVM0ct3K-/s1600-h/6.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 192px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhABxzifb4YZTbXS90NPPJX3SKRq43u0gyWei2BJizfFDZBQMO9Jdo9GILUOPV0uLaz0vbaJs6zVEpMoH6JoqNunv5ZJNLH_bM5-vALjxj-mZDTY3iJAxhIBmmNJmRlaHn1MgAyVM0ct3K-/s320/6.png" alt="" id="BLOGGER_PHOTO_ID_5380217577110442258" border="0" /></a>Hit Create and this is what you will get:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg71YmaXIFv3tz5FJJs-hI5CoXAYNpHjfL1UKQE2rd5J59DSRiVkHSdPvMVUSeePgkx8ET0cz_gMke0-6lHx9crO-Shyji9TJpiLh5BNQY43etgU9IBf-rY_jcblL5cD6nqrYM1M5NlMhkg/s1600-h/7.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 214px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg71YmaXIFv3tz5FJJs-hI5CoXAYNpHjfL1UKQE2rd5J59DSRiVkHSdPvMVUSeePgkx8ET0cz_gMke0-6lHx9crO-Shyji9TJpiLh5BNQY43etgU9IBf-rY_jcblL5cD6nqrYM1M5NlMhkg/s320/7.png" alt="" id="BLOGGER_PHOTO_ID_5380217571548569170" border="0" /></a>Now, be a little careful here. Notwithstanding the fact that the CA tells you that (in this case) you have 14,91 GB of space, you cannot use it all. I have tried 14,91, 14,9, they all failed. The example above shows 14.5, which worked for me. Don't take all you can get, don't get too greedy:-). You have to reserve some space for management, apparently.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbe3gDiYdHlkhI0Zw9Hj9o1evJzbZFnPXkY5qFnFDIYORETqWYe9MxzxjCFzc5i-j0EIepkReRRdR0DQQAC8Zj7DtEVNLAFpTeqPd1fYGjS-fUNyI2PExW3V38_6gIiUadPK9crMUPzuce/s1600-h/8.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 243px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbe3gDiYdHlkhI0Zw9Hj9o1evJzbZFnPXkY5qFnFDIYORETqWYe9MxzxjCFzc5i-j0EIepkReRRdR0DQQAC8Zj7DtEVNLAFpTeqPd1fYGjS-fUNyI2PExW3V38_6gIiUadPK9crMUPzuce/s320/8.png" alt="" id="BLOGGER_PHOTO_ID_5380217563327618738" border="0" /></a>Another success!<br />Now we're almost there, and the most interesting part has to come yet: The ASM Cluster File System tab:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjajizjD8z6R_t-UjpWoL3sY5lxQEKB3nzLEC973biFcv0EOq4x8ncEMzVgvPk55Ea0w2bMPGHdsSG3cypavsu5y55ZopslBSc4dJI13uPuQCXQijHVRh3CQhlerDiVqcMN9tQApUReEhLP/s1600-h/10.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 192px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjajizjD8z6R_t-UjpWoL3sY5lxQEKB3nzLEC973biFcv0EOq4x8ncEMzVgvPk55Ea0w2bMPGHdsSG3cypavsu5y55ZopslBSc4dJI13uPuQCXQijHVRh3CQhlerDiVqcMN9tQApUReEhLP/s320/10.png" alt="" id="BLOGGER_PHOTO_ID_5380217552028092834" border="0" /></a>Again, just hit the Create button to get started:<br />Interesting choice here: You can choose between a Database Home File System or a General Purpose File System. When you choose your file system to be a database home file system, it will be registered under Grid Infrastructure as a managed resource, so Grid Infrastructure can maintain dependencies (- hey, we can all read, you know...). Anyway, I chose the Database Home File System for DATAVOL01. Just enter the mountpoint (/ora11g in the example), who should own it and to which group it should belong:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhakYfuMyg4DVFIH5MGj6NO4Wpv0sTP2i5SQscybcyFtM1FrAQGgKCY_RED9RGTOQx_UHGNi7e-5XrknOxodQGG-fTtYqIW3kjkCWTF9KiZxGqphoTZ95KaarHhLm4Z4hZpEqdttNJ6Riw3/s1600-h/12.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 270px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhakYfuMyg4DVFIH5MGj6NO4Wpv0sTP2i5SQscybcyFtM1FrAQGgKCY_RED9RGTOQx_UHGNi7e-5XrknOxodQGG-fTtYqIW3kjkCWTF9KiZxGqphoTZ95KaarHhLm4Z4hZpEqdttNJ6Riw3/s320/12.png" alt="" id="BLOGGER_PHOTO_ID_5380217404017657426" border="0" /></a>There is a button there at the bottom: "Show Command", which is worthy to be investigated. It shows you the commands that will be executed to create the ACFS and the registration command:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhJKRL7neR99_-7ApGJaVLtjdt9cKi49YmdT2OrvSnqJl4qGEdviKljXJDwScx3gQB4oscvxCel7FcfsMLUOX8BGbj6GsE8ka3DADjhogUC1GQcGcoWac2vXwgvWLxC94bN0nPDCXQGSb2/s1600-h/13.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 279px; height: 245px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhJKRL7neR99_-7ApGJaVLtjdt9cKi49YmdT2OrvSnqJl4qGEdviKljXJDwScx3gQB4oscvxCel7FcfsMLUOX8BGbj6GsE8ka3DADjhogUC1GQcGcoWac2vXwgvWLxC94bN0nPDCXQGSb2/s320/13.png" alt="" id="BLOGGER_PHOTO_ID_5380217396598685074" border="0" /></a>And the bottom half of the commands:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiD3t_GB5NLHzC7Hhjf-ljNv_V5NYAu0CDpV9sIN7JnZOpIr1Mxlx99_8uXwiI3c0wcNd8U7m5wM3RZS0jkoMm7c3WMHfOqcKER2lS8Syo70WsiTnsva52AMPHkKhJjOXa7Jv7KJh2W4NHh/s1600-h/14.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 279px; height: 245px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiD3t_GB5NLHzC7Hhjf-ljNv_V5NYAu0CDpV9sIN7JnZOpIr1Mxlx99_8uXwiI3c0wcNd8U7m5wM3RZS0jkoMm7c3WMHfOqcKER2lS8Syo70WsiTnsva52AMPHkKhJjOXa7Jv7KJh2W4NHh/s320/14.png" alt="" id="BLOGGER_PHOTO_ID_5380217390704619282" border="0" /></a>After the file system has been created, it needs to be registered, by running a script. This needs to be done by a privileged user (e.g. root):<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCs6DcHZwKASdQwu8IvRHSbO2KZDuhtMc_ZShqwDWpZo3r2xd0kpU8DoU6KDzh7XAsh4BmHG8_FbXY7gGzbYE2552UXPbRWOuJLrBGXhRnEYKdExs9u-UjxqbA_wq7DXdUSSRL-cGc_kaX/s1600-h/15.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 130px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCs6DcHZwKASdQwu8IvRHSbO2KZDuhtMc_ZShqwDWpZo3r2xd0kpU8DoU6KDzh7XAsh4BmHG8_FbXY7gGzbYE2552UXPbRWOuJLrBGXhRnEYKdExs9u-UjxqbA_wq7DXdUSSRL-cGc_kaX/s320/15.png" alt="" id="BLOGGER_PHOTO_ID_5380217389086670050" border="0" /></a>Screenshot of running the script, and Oh my! It's there! I just created a clustered file system under ASM and it is registered in Grid Infrastructure:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUBeHP3KLtTYgDrTC8NXc7A3yyqA5qK2PayhWei1MkXYJusrPmnXEf-DpsrZlMRwiEr9TKd16XBw1thA5EhvF4f6YUsuUHC6vv1GyDM84vf1YYhSww7eKx-s_Dm8TztSokIlWryu1W9-UZ/s1600-h/16.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 225px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUBeHP3KLtTYgDrTC8NXc7A3yyqA5qK2PayhWei1MkXYJusrPmnXEf-DpsrZlMRwiEr9TKd16XBw1thA5EhvF4f6YUsuUHC6vv1GyDM84vf1YYhSww7eKx-s_Dm8TztSokIlWryu1W9-UZ/s320/16.png" alt="" id="BLOGGER_PHOTO_ID_5380217187535938946" border="0" /></a>OK. Now we'll configure another file system, this time a General Purpose File System. Starting with the second tab in the Configuration Assistant (Disk Groups), define the name of the disk group (DATABASE). You can see that suddenly I have got another set of disks available. Well I created those earlier, but didn't register yet them with ASMlib, while going through the previous cycle.<br />This time I have got two disks, and I will both use them for my DATABASE disk group. Still with External Redundancy, because the diskspace is too costly for me.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDfCjlo6aaSNtXV2OrhiJfR_8AsZWKmBJJv-iqUXCS98s-jBVzZi9ctryVwqLxcNwBnTjXLOIrW_sLy6q1tmCKHqsH-b44hiuz7hgVZxZXg2-Pt1SaNtnDQijkFsq-CvgFzBw2Q2Xkj1_a/s1600-h/17.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 220px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDfCjlo6aaSNtXV2OrhiJfR_8AsZWKmBJJv-iqUXCS98s-jBVzZi9ctryVwqLxcNwBnTjXLOIrW_sLy6q1tmCKHqsH-b44hiuz7hgVZxZXg2-Pt1SaNtnDQijkFsq-CvgFzBw2Q2Xkj1_a/s320/17.png" alt="" id="BLOGGER_PHOTO_ID_5380217180679470466" border="0" /></a>After the Disk Group has been created, I create a volume on it:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKkaJuVVSzM0mIDk_TfZYTgf0at1RZ25AAMmZiggsknCY8M_3GWZvdH8kkC-anUWkJJqtnGh_joePH9ePOY1-zgxNcYtA-lK8dXcwFg3squMeQHSdaGNH1xtjvbz5pDvA7YR8ak9iSGebR/s1600-h/18.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 192px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKkaJuVVSzM0mIDk_TfZYTgf0at1RZ25AAMmZiggsknCY8M_3GWZvdH8kkC-anUWkJJqtnGh_joePH9ePOY1-zgxNcYtA-lK8dXcwFg3squMeQHSdaGNH1xtjvbz5pDvA7YR8ak9iSGebR/s320/18.png" alt="" id="BLOGGER_PHOTO_ID_5380217172739203314" border="0" /></a>After that, I come to the ASM Cluster File System tab again and now I choose a General Purpose File System. I will register this one as well, hopefully resulting in an automount feature at boot time.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwbxm_cGDjWHwJdeG98k81e__zp54mMsig_nFUYH6GyXGxFXZvISb8TVWRi-mrsxPLoKVXuYdrLB611tEWXtAiGOj6biP4SDugzAPT1tlIbw1tm6LFBqn0gFksoefu2eTZml_IgWF9fGOR/s1600-h/19.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 270px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwbxm_cGDjWHwJdeG98k81e__zp54mMsig_nFUYH6GyXGxFXZvISb8TVWRi-mrsxPLoKVXuYdrLB611tEWXtAiGOj6biP4SDugzAPT1tlIbw1tm6LFBqn0gFksoefu2eTZml_IgWF9fGOR/s320/19.png" alt="" id="BLOGGER_PHOTO_ID_5380217168439807762" border="0" /></a>The file system has been created and registered successfully:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxRlAAGlclIksen8wpZxvQ8YL2C-Ie_8WEmw_dLuRPehlrl5JCn-cop8NDrjOcAiYWriY847rv85qLY9bjEEFGYCP6j94evm1w3zXFu0UAv_OsP5hPtsTZ95zPgsn1UQrtMKI13riCz79k/s1600-h/20.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 243px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxRlAAGlclIksen8wpZxvQ8YL2C-Ie_8WEmw_dLuRPehlrl5JCn-cop8NDrjOcAiYWriY847rv85qLY9bjEEFGYCP6j94evm1w3zXFu0UAv_OsP5hPtsTZ95zPgsn1UQrtMKI13riCz79k/s320/20.png" alt="" id="BLOGGER_PHOTO_ID_5380217161218130994" border="0" /></a><br />Now you have two clustered file systems, one designated for Oracle Homes, the other for anything you would like (like databases?).<br />Next step is to install Oracle 11g Release 2 Database software. That will be covered in the next post.<br />Happy testing!Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com9tag:blogger.com,1999:blog-9087887235134509416.post-87338354150781595752009-09-09T15:44:00.014+02:002009-09-11T10:27:16.189+02:00Networking Requirements for Oracle Grid InfrastructureWith the release of Oracle 11gR2, Oracle has provided a whole new concept for the Grid Infrastructure. One of the most eye-catching requirements is a new Network Infrastructure requirement. It is no longer possible (maybe with some hacking and tricking) to just have a couple of Network Interface Cards and a bunch of IP addresses configured through the hosts file in /etc. I will try to summarize the requirements that Oracle has defined, and how to implement them:<p><strong>Network Hardware Requirements</strong></p><p>Oracle states the following requirements:</p><ul><br /><li>Each node must have at least two network adapters or network interface cards (NICs): one for the public network interface, and one for the private network interface (the interconnect).If you use multiple NICs for the public network or for the private network, the recommendation is to use NIC bonding. Public and private bonds should be separated</li><li>The interface names Oracle will use for the network adapters for each network must be the same on all nodes.In other words: The public network adapter should, for example, be called eth0 on all nodes and the private adapter eth1 on all nodes.</li><li>The public network adapter must support TCP/IP.</li><li>The private network adapter must support the user datagram protocol (UDP)High-speed network adapters and switches that support TCP/IP (minimum requirement 1 Gigabit Ethernet) are required for the private network.</li></ul><p><strong>IP Address Requirements</strong><br />Before starting the installation, you must have at least two interfaces configured on each node: One for the private IP address and one for the public IP address.</p>Reading the installation manual for Grid Infrastructure (of which btw this article is a summary) a DNS server and a DHCP server are now required to setup an Oracle Grid Infrastructure.<br /><br /><br /><p>You can configure IP addresses with one of the following options:</p><p><em>Oracle Grid Naming Service (GNS)<br /></em>Using a static public node address and dynamically (DHCP) allocated IP addresses for the Oracle Clusterware provided VIP addresses. The hostnames will be resolved using a multicast domain name server, which is configured as a part of Oracle Clusterware, within the cluster. If you plan to use GNS, then you are required to have a DHCP service running on the public network for the cluster which will be able to provide an IP address for each node's virtual IP, and 3 IP addresses for the cluster used by the Single Client Access Name (SCAN) for the cluster.</p><em>Fixed IP addresses, assigned on a DNS Server for each node.<br /></em>In other words, you can no longer trick around by defining the hosts in the /etc/hosts file. DNS is a requirement, as well as DHCP. Well, that may not be the case, but I will have to test this still...<br /><br /><strong>IP Address Requirements with Grid Na</strong><strong>ming Service</strong><a name="sthref270"></a><br />If you enable Grid Naming Service (GNS), name resolution for any node in the cluster is delegated to the GNS server, listening on the GNS virtual IP address. You have to define this address in the DNS domain before you start the installation. The DNS must be configured to delegate resolution requests for cluster names (any names in the subdomain delegated to the cluster) to the GNS. When a request is made, GNS processes the requests and responds with the appropriate addresses for the name requested.<br />In order to use GNS, the DNS administrator must establish a DNS Lookup to direct DNS resolution of an entire subdomain to the cluster. This should be done before you install Oracle Grid Infrastructure! If you enable GNS, then you must also have a DHCP service on the public network that allows the cluster to dynamically allocate the virtual IP addresses as required by the cluster.<br /><br /><strong>IP Address Requirements for Manual Configuration<br /></strong>If you choose not to enable GNS, then the public and virtual IP addresses for each node must be static IP addresses, but they should not be in use before you start the installation. Public and virtual IP addresses must be on the same subnet, but that should be no news, since that has been the case since the days VIPs were introduced (Oracle 10g).<br />The cluster must have the following IP addresses:<br /><br /><br /><ul><li>A public IP address for each node</li><li>A virtual IP address for each node</li><li>A single client access name (SCAN) configured on the domain name server (DNS) for Round Robin resolution to at least one address (three addresses is recommended).</li></ul><em>SCAN</em><br />The single client access name (SCAN) is a name used to provide service access for clients to the cluster. One of the major benefits of SCAN is that the SCAN enables you to add or remove nodes from the cluster without the need to reconfigure clients This is because the SCAN is associated with the cluster as a whole, rather than to a particular node. Another benefit is location independence for the databases. Client configuration does not have to depend on which nodes are running a particular database. Clients can however continue to access the cluster like with previous releases. The recommendation is to use SCAN.<br />The SCAN addresses must be on the same subnet as virtual IP addresses and public IP addresses. For high availability and scalability, you should configure the SCAN to use Round Robin resolution to three addresses. The name for the SCAN cannot begin with a numeral. For installation to succeed, the SCAN must resolve to at least one address.<br />It is best not to use the hosts file to configure SCAN VIP addresses. In stead, use DNS resolution for SCAN VIPs. If you use the hosts file to resolve SCANs, then you will only be able to resolve to one IP address. The result is that you will have only one SCAN address. It could possibly be a workaround for lab circumstances, but again, I didn't test it this way yet.<br /><br /><strong>DNS Configuration for Domain Delegation to Grid Naming Service<br /></strong>If you plan to use GNS, then before grid infrastructure installation, you must configure your DNS server to forward requests for the cluster subdomain to GNS.<br />In order to establish this, you must use so-called delegation. This is how you configure delegation: In the DNS, create an entry for the GNS virtual IP address. For example:<br />gns.domain.net: 192.168.146.51 (The address you provide must be routable)<br />In the DNS, create an entry similar to the following for the delegated domain, where cluster.domain.net is the subdomain you want to delegate:<br />cluster.domain.net: NS gns.domain.net<br />You must also add the DNS Servers to the resolv.conf on the nodes in the cluster<br /><br />Make sure that the nis entry in /etc/nsswitch.conf is at the end of the search list. For example:<br />hosts: files dns nis<br /><br /><strong>Grid Naming Service Configuration Example<br /></strong>When nodes are added to the cluster, the DHCP server can provide addresses for these nodes dynamically. These addresses are then registered automatically in GNS, and GNS provides delegated resolution within the subdomain to cluster node addresses registered with GNS.<br />Because allocation and configuration of addresses is performed automatically with GNS, additional configuration is no longer required. Oracle Clusterware provides dynamic network configuration as nodes are added to or removed from the cluster. The following example should make things a bit clear (click on the image to get a larger view):<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhh4R6CMSdZJ4_cZoNs2nbyUJ6W0K5BbugV4f-t0BITjDEGYF9y2SIUNJpqOTz4RyAu7CJfj18LqWP2qoggUmR3gyT12gKTaK1_82d82O4O8rxZvyAPjQKvVEVN13fnTwQzyxOJ4LPgvrPx/s1600-h/gns.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 219px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhh4R6CMSdZJ4_cZoNs2nbyUJ6W0K5BbugV4f-t0BITjDEGYF9y2SIUNJpqOTz4RyAu7CJfj18LqWP2qoggUmR3gyT12gKTaK1_82d82O4O8rxZvyAPjQKvVEVN13fnTwQzyxOJ4LPgvrPx/s400/gns.png" alt="" id="BLOGGER_PHOTO_ID_5380122731011864626" border="0" /></a><br />The above table reflects a two node cluster with GNS configured. The cluster name is "cluster", the GNS parent domain is domain.net, the subdomain is cluster.domain.net, 192.0.2 in the IP addresses represent the cluster public IP address network, and 192.168.0 represents the private IP address subnet.<br /><br /><p><strong>Manual IP Address Configuration Exa</strong><strong>mple<br /></strong>If you decide not to use GNS, then you must configure public, virtual, and private IP addresses before installation. Also, check that the default gateway is reachable.<br />For example, with a two node cluster where each node has one public and one private interface, and you have defined a SCAN domain address to resolve on your DNS to one of three IP addresses, you might have the configuration shown in the following table for your network interfaces: </p><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwUDfGf1lkeoRXKFMhdtFuNr24rVDPorqPMP7vQdjaonz4X0L9FzIRrkyC9IAmNfQzI6JS7CxW4WETM6ZncyvKFJlFz3GANGCqa1QN2_3cq4uTA-jBB666lpU4CSJQGCXWNtPK8bxZMedm/s1600-h/nogns.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 201px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwUDfGf1lkeoRXKFMhdtFuNr24rVDPorqPMP7vQdjaonz4X0L9FzIRrkyC9IAmNfQzI6JS7CxW4WETM6ZncyvKFJlFz3GANGCqa1QN2_3cq4uTA-jBB666lpU4CSJQGCXWNtPK8bxZMedm/s400/nogns.png" alt="" id="BLOGGER_PHOTO_ID_5380123301268609250" border="0" /></a> <p>You do not need to provide a private name for the interconnect. If you want name resolution for the interconnect, then you can configure private IP names in the hosts file or the DNS. However, Oracle Clusterware assigns interconnect addresses on the interface defined during installation as the private interface (eth1, for example), and to the subnet used for the private subnet.<br />The addresses to which the SCAN resolves are assigned by Oracle Clusterware, so they are not fixed to a particular node. To enable VIP failover, the configuration shown in the preceding table defines the SCAN addresses and the public and VIP addresses of both nodes on the same subnet, 192.0.2. </p><p><strong>Network Interface Configuration Options<br /></strong>An important thing to be aware of is when you use NAS for RAC and this storage is connected through an Ethernet network. In this case, you must have a third network interface for NAS I/O, otherwise you can face serious performance issues. </p><p><strong>Enable Name Service Cache Daemon<br /></strong><a name="sthref279"></a><a name="sthref280"></a><a name="sthref281"></a>You should enable nscd (Name Service Cache Daemon), to prevent network failures with RAC databases using Network Attached Storage or NFS mounts.<br />Use chkconfig --list nscd<br />To change the configuration, enter one of the following command (as root):<br /># chkconfig --level 35 nscd on<br /><br />If you meet either one of the above method requirements (GNS or Manual configuration), you are safe to install Oracle Grid Infrastructure.</p>Source: <a href="http://download.oracle.com/docs/cd/E11882_01/install.112/e10812/prelinux.htm#insertedID0">Oracle 11gR2 Grid Infrastructure Installation Guide</a>Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com10tag:blogger.com,1999:blog-9087887235134509416.post-7354199261971263772009-09-04T20:14:00.014+02:002009-09-05T14:55:51.418+02:00Oracle 11gR2 Grid Infrastructure InstallationOne of the new "features" of Oracle 11gR2 is the Grid Infrastructure. Oracle 11gR2 Grid Infrastructure is the collection of infrastructural components provided for Oracle Database and other software.<br />I tested the installation of Oracle Grid Infrastructure on two virtual machines running OEL 5.3, operating under VMware Server 1.08. I suppose it is not supported this way, but it can give an idea of what to expect during the installation. The screenshots below show the installation procedure. I will add some comments when appropriate, especially to emphasize on new features. NOTE: Click on the screenshot to get a larger view.<br /><br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWO4qu4nLg0rnpBY1P4c1a_94CAwihqHT69DDi2XGT-3aKMH8dzEw0c1hyphenhyphenZHxJZD4qnaL14UP-z9wSxUvuehdun60GIsROqIPrdLqWKeV6LRxbAni2_nn_YHQ27BHC-mad7AMgeAmDThPj/s1600-h/1.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 240px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377922574105974962" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWO4qu4nLg0rnpBY1P4c1a_94CAwihqHT69DDi2XGT-3aKMH8dzEw0c1hyphenhyphenZHxJZD4qnaL14UP-z9wSxUvuehdun60GIsROqIPrdLqWKeV6LRxbAni2_nn_YHQ27BHC-mad7AMgeAmDThPj/s320/1.png" /></a>The first installation screen. The bullet shows which option I chose here.<br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqe2Y7PD5zkH2ctlrrO6IdBIsNDmP5EnLjPca46L1gF6cKbOZ24B_gbmKzj73bNIMxXdYtMeYePEmvGM0qfTd3M50ycKOlZ-62imx0CWZZNlGW1ovdEtrgE-jwLTz9snFszSwHqgQ7NeqD/s1600-h/2.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 240px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377922483993047938" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqe2Y7PD5zkH2ctlrrO6IdBIsNDmP5EnLjPca46L1gF6cKbOZ24B_gbmKzj73bNIMxXdYtMeYePEmvGM0qfTd3M50ycKOlZ-62imx0CWZZNlGW1ovdEtrgE-jwLTz9snFszSwHqgQ7NeqD/s320/2.png" /></a>Usually the Advanced option is for experienced users. Well, at least I think I am experienced, I suppose...<br /><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiWmNAilzKyKRrZiaMut1lcKArhxPDKuusDx21M3JjYp3lxiVRctA0V-UfJAZTLb5fc_qxNelkT9yyD8w_XQylEe-P4tfTYj85iH8ApiJKoJYcuC8_TBR4M8v2Ie8ns6LHRMWs6OKrWugV/s1600-h/3.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 240px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377922473442589282" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiWmNAilzKyKRrZiaMut1lcKArhxPDKuusDx21M3JjYp3lxiVRctA0V-UfJAZTLb5fc_qxNelkT9yyD8w_XQylEe-P4tfTYj85iH8ApiJKoJYcuC8_TBR4M8v2Ie8ns6LHRMWs6OKrWugV/s320/3.png" /></a>Languages. Anyone ever chose additional languages here? I never did.</div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhd5V1_XZblgnr92L6DnnB0FhfKIF14Moanl9yLEUSjst1v9pgGsUSJVhdNS_OMN3PKQ78qmAkVdNgyMBer5HydWCh1cTwU2hIiGtjqrbtUrpQmMUgSCuEG2c3ko2UDFCuEIBKGukVDnlZa/s1600-h/4.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 240px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377922471251357122" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhd5V1_XZblgnr92L6DnnB0FhfKIF14Moanl9yLEUSjst1v9pgGsUSJVhdNS_OMN3PKQ78qmAkVdNgyMBer5HydWCh1cTwU2hIiGtjqrbtUrpQmMUgSCuEG2c3ko2UDFCuEIBKGukVDnlZa/s320/4.png" /></a> Nice new feature here: SCAN (Single Client Access Name): All the servers in the cluster will act upon a single hostname. This way, the cluster becomes completely transparent.</div><div>GNS: If you enable Grid Naming Service (GNS), then name resolution requests to the cluster are delegated to the GNS, which is listening on the GNS virtual IP address. You define this address in the DNS domain before installation. The DNS must be configured to delegate resolution requests for cluster names (any names in the subdomain delegated to the cluster) to the GNS. When a request comes to the domain, GNS processes the requests and responds with the appropriate addresses for the name requested.<br />To use GNS, before installation the DNS administrator must establish DNS Lookup to direct DNS resolution of a subdomain to the cluster. If you enable GNS, then you must have a DHCP service on the public network that allows the cluster to dynamically allocate the virtual IP addresses as required by the cluster.</div><div> </div><div></div><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdNYUZfNP7_sFcHnV_MM4gd6M-yi8ugRAjTS8TWgvTFPELMXoKoL8pFmeaJo31CjjySmvCQOKlLjsRGZL8J-miV0GK6-bRCP5T0vhCN9y0JQ2ll2IIaefcaGe0HWG5NzvInfYBg-ve1oQs/s1600-h/5.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 106px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377922463156423538" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdNYUZfNP7_sFcHnV_MM4gd6M-yi8ugRAjTS8TWgvTFPELMXoKoL8pFmeaJo31CjjySmvCQOKlLjsRGZL8J-miV0GK6-bRCP5T0vhCN9y0JQ2ll2IIaefcaGe0HWG5NzvInfYBg-ve1oQs/s320/5.png" /></a>Validation is performed... and accepted!</div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUj4zQwuwARD-WPVP-UCDkSi5m8abohD4nDQKi31p2YP73ArU3E6VIh6Ivv2P7KTuu-7wtASBZAUa7wsPdBwTLHGAsekeKnlTVzaIR5dbPTKeKLEBsRa4Q1Xd9gKYhlhirVppDdwtCUdZv/s1600-h/6.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 240px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377922460159789074" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUj4zQwuwARD-WPVP-UCDkSi5m8abohD4nDQKi31p2YP73ArU3E6VIh6Ivv2P7KTuu-7wtASBZAUa7wsPdBwTLHGAsekeKnlTVzaIR5dbPTKeKLEBsRa4Q1Xd9gKYhlhirVppDdwtCUdZv/s320/6.png" /></a> As a result of enabling GNS, I can no longer assign VIP addresses to my cluster node names. These addresses are assigned by GNS from now on. Of course, when I wouldn't have enabled GNS, I were able to assign the addresses in this screen.</div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhls4_SwzaBydP6nepVcTdrmMplJi58B6leUmKk1O1b2GrQG0JIUAE4ZXvMznyQWnxD_Lj-Xo7da8UMovbMNpuc3OB1QWr8-demDhUt0qTKPFvt3rnd79OsHyeYgJx-rbDcCv30P1uoaPy_/s1600-h/7.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 78px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377922225406235186" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhls4_SwzaBydP6nepVcTdrmMplJi58B6leUmKk1O1b2GrQG0JIUAE4ZXvMznyQWnxD_Lj-Xo7da8UMovbMNpuc3OB1QWr8-demDhUt0qTKPFvt3rnd79OsHyeYgJx-rbDcCv30P1uoaPy_/s320/7.png" /></a>Regular SSH connectivity test</div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0A9x52CMfkSEkBC5LFeKJ2VdQ5ks0bd-Zov5GglhM5X84KlYC1l1Ire4LAtj4LSAFPWB8FCHigoSeBTa1zAFTBx3l81hA-noM3FvB6TR-n7oZvOL_RB0vxSDghajmyooUzlwoJh2WnXDZ/s1600-h/8.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 239px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377922217103348914" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0A9x52CMfkSEkBC5LFeKJ2VdQ5ks0bd-Zov5GglhM5X84KlYC1l1Ire4LAtj4LSAFPWB8FCHigoSeBTa1zAFTBx3l81hA-noM3FvB6TR-n7oZvOL_RB0vxSDghajmyooUzlwoJh2WnXDZ/s320/8.png" /></a> Network Interface Usage specification. Should be no surprise for anyone experienced in 10g Clusterware.</div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLVYWbIB7PC_BdIAPToIOJPWCcY71jVIstf6bjG3c7iyh2XaZpaoJ0Y_Y392VesdvPG4a4YWnSUvCDXFAlXjY2MDV0O5-Q-VvN8talRVDmfXuoW6FUHqWIwH6SffPKlaAepC2J_YlzNBDd/s1600-h/9.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 240px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377922212921892098" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLVYWbIB7PC_BdIAPToIOJPWCcY71jVIstf6bjG3c7iyh2XaZpaoJ0Y_Y392VesdvPG4a4YWnSUvCDXFAlXjY2MDV0O5-Q-VvN8talRVDmfXuoW6FUHqWIwH6SffPKlaAepC2J_YlzNBDd/s320/9.png" /></a> Now, I will come to the choice of my storage solution. Before I started the installation I added another shared disk, enabled ASMlib on both servers and created an ASM Disk. Therefore, I can now choose ASM for storage.</div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-ZfveSGDZImspmuJer4cM4FNhVKaoLag2jDLgbpdtapbpVHM5_3quhiaoHos_qTCC5vAmOEcSzi3i4GAD0YZRTVp0h8n0QX1C4rpwFfgMjfsq0mFJAUmHqqLuMV6SKP4HoIqteAe0i7Wv/s1600-h/10.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 240px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377922204661582594" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-ZfveSGDZImspmuJer4cM4FNhVKaoLag2jDLgbpdtapbpVHM5_3quhiaoHos_qTCC5vAmOEcSzi3i4GAD0YZRTVp0h8n0QX1C4rpwFfgMjfsq0mFJAUmHqqLuMV6SKP4HoIqteAe0i7Wv/s320/10.png" /></a>Choose the diskgroup name and assign disks to the diskgroup.</div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpsuQ88__-cCv8VfoyTRzC8FMFzi9K7Md6iyY7u5BRJLW1N53AQYf5rQrjEqpfsomJQao5KbmYV11O5T8bND7KUanHjiJivmHkEMYCw48kCC4UCZBxrgp_W0vNDD7YNV5P72sMzbXH9Vac/s1600-h/11.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 240px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377922197183058434" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpsuQ88__-cCv8VfoyTRzC8FMFzi9K7Md6iyY7u5BRJLW1N53AQYf5rQrjEqpfsomJQao5KbmYV11O5T8bND7KUanHjiJivmHkEMYCw48kCC4UCZBxrgp_W0vNDD7YNV5P72sMzbXH9Vac/s320/11.png" /></a>Passwords. Be careful here! Passwords should comply with Oracle Recommendations, however you can ignore them. You will be notified when something is wrong or should be reviewed according to Oracle: </div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilo7rFNNokX-Igi7n9zXmr4rayqXePgJbwC7etL4S-34MH1meNHSngiEHOBJCBexXejJ18bPwUIHYkhK3z-26UJPNRTc0HfH9A94efbVmW4w-HIDpyP3xkQyXUSwZahJCRgRPpCAZ3Mqxu/s1600-h/12.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 59px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377921563684796786" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilo7rFNNokX-Igi7n9zXmr4rayqXePgJbwC7etL4S-34MH1meNHSngiEHOBJCBexXejJ18bPwUIHYkhK3z-26UJPNRTc0HfH9A94efbVmW4w-HIDpyP3xkQyXUSwZahJCRgRPpCAZ3Mqxu/s320/12.png" /></a><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoJ8CIi4NF9dPbKZ4ZoPxZa8xH0GiWXz_TCTzQwQ-CxrXerxAlkO_UOpkg04BkUgyxsID0SSCfrdyOcudkFr_iTpKgRloi-2TZSMbzurHiL2nCpv27w7jq2LljKfkRJALYqMlouT9yJAYa/s1600-h/13.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 241px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377921561758983234" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoJ8CIi4NF9dPbKZ4ZoPxZa8xH0GiWXz_TCTzQwQ-CxrXerxAlkO_UOpkg04BkUgyxsID0SSCfrdyOcudkFr_iTpKgRloi-2TZSMbzurHiL2nCpv27w7jq2LljKfkRJALYqMlouT9yJAYa/s320/13.png" /></a>I am not using IPMI (Intelligent Platform Management Interface) so, I didn't select this option.</div><div>IPMI provides a set of common interfaces to computer hardware and firmware that system administrators can use to monitor system health and manage the system. With Oracle 11g release 2, Oracle Clusterware can integrate IPMI to provide failure isolation support and to ensure cluster integrity. <a id="sthref349" name="sthref349"></a><a id="sthref350" name="sthref350"></a><a id="sthref351" name="sthref351"></a><br />You can configure node-termination with IPMI during installation by selecting a node-termination protocol, such as IPMI. You can also configure IPMI after installation with crsctl commands.</div><div><br /></div><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMYh4VSuCyb7gCtzksxKiBaMSGp7AN_hG-553krBuJGvkAeUj22kRj58h5lT4vp5lo4Yclf_GccjfUlZy6mI2JilktFbJt1cuDqB6STARNjGg4FMPVzGDqxkhGXZSVIvtXliIbYeCAag_Y/s1600-h/14.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 241px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377921550045407586" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMYh4VSuCyb7gCtzksxKiBaMSGp7AN_hG-553krBuJGvkAeUj22kRj58h5lT4vp5lo4Yclf_GccjfUlZy6mI2JilktFbJt1cuDqB6STARNjGg4FMPVzGDqxkhGXZSVIvtXliIbYeCAag_Y/s320/14.png" /></a>Here you can assign different groups to specific management options.</div><div>ASM Database Administrator (OSDBA)</div><div>ASM Instance Administration Operator (OSOPER)</div><div>ASM Instance Administrator (OSASM)<br /></div><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTm9abp5tRQG8ANWjHheNoCgAl2s6gAtApIAmDA_NH8vqcCrwXDsRoA17t_08m4DAwUHidE4lMse9KItgt85p4_tUgoyEnDEY8qTZyCOYB0VLZrKxqgTc_QknCL9OD5dgrITKizlw7OO4w/s1600-h/15.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 136px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377921548691332658" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTm9abp5tRQG8ANWjHheNoCgAl2s6gAtApIAmDA_NH8vqcCrwXDsRoA17t_08m4DAwUHidE4lMse9KItgt85p4_tUgoyEnDEY8qTZyCOYB0VLZrKxqgTc_QknCL9OD5dgrITKizlw7OO4w/s320/15.png" /></a>Oracle has separated the privileges for each of these groups of administrators. Therefore, when I chose dba as group for each of these, I got a warning. Under normal (production operational) circumstances, I should have created three different groups and assigned these groups to different users on my system. Well, I have got only one user on my test environment: oracle, so what is the use of setting up three separate groups? Anyway, the idea is clear and it is good practice to follow these guidelines.</div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSJ_Td-u3Kd-cwhq9w0anl2iodmGvWMd53z8x6cIad6KO_NUeoFneLt4sUqMHrMEMS3wVJFm4JdPSkyMRQ1d7DhWTKDMMj7baa6kHav7AviB4gHAGL5_FzSCq3HuUN_QSHgk0MLRlAduf7/s1600-h/16.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 240px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377921533656881458" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSJ_Td-u3Kd-cwhq9w0anl2iodmGvWMd53z8x6cIad6KO_NUeoFneLt4sUqMHrMEMS3wVJFm4JdPSkyMRQ1d7DhWTKDMMj7baa6kHav7AviB4gHAGL5_FzSCq3HuUN_QSHgk0MLRlAduf7/s320/16.png" /></a>Specify the locations of the Oracle Base and Oracle Grid Home. Oracle Grid Home should be installed parallel to the Oracle Base, so not inside the Oracle Base!</div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpTlVjdTWGxC_lMTju8SqFTEvMl38jmERZ_BBJyzqJke9Xxh0S4Zl1Gno2HPBWA35kLtLM8hwgbA8Y0SBH-Va-fs3H0zP-dZuXToA1fM01EFTDfZsfjmIrw0K6KVYkTCKnMdoBoTF748wx/s1600-h/17.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 74px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377921152331595282" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpTlVjdTWGxC_lMTju8SqFTEvMl38jmERZ_BBJyzqJke9Xxh0S4Zl1Gno2HPBWA35kLtLM8hwgbA8Y0SBH-Va-fs3H0zP-dZuXToA1fM01EFTDfZsfjmIrw0K6KVYkTCKnMdoBoTF748wx/s320/17.png" /></a> File locations are being checked on both servers.</div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgikOIqGGfaoearjqntnqbs89mMjAzHkpgFk0ZA4lirOofthOceITWZsXImJq_9VcEW_pctLQnco_4d8Q3PcSupv8FePLdSaxP6Dwx1U3BHc4bwWQfdFW3f7mNJmfYDgZIuIKDedvoCSbjd/s1600-h/18.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 240px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377921142924425778" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgikOIqGGfaoearjqntnqbs89mMjAzHkpgFk0ZA4lirOofthOceITWZsXImJq_9VcEW_pctLQnco_4d8Q3PcSupv8FePLdSaxP6Dwx1U3BHc4bwWQfdFW3f7mNJmfYDgZIuIKDedvoCSbjd/s320/18.png" /></a> New feature: Maybe it is better to say there is an enhancement here. The system is being verified thouroughly for prerequisites. The result can be seen in the next screen shots:</div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsCXxryZUG1PP3W2mxhSzHa6EYqaF9Y6ZNNFSjfRylkXjOEhBp588x3JxwmWGjjsnFXoCuyN2_-mSUhMuaWOsRx_w8Zu0jb_0NbEvE4bgC9a2IegKR3Ze61AVu2_NpfBSaq_OsD19CKEzu/s1600-h/19.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 240px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377921140088692370" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsCXxryZUG1PP3W2mxhSzHa6EYqaF9Y6ZNNFSjfRylkXjOEhBp588x3JxwmWGjjsnFXoCuyN2_-mSUhMuaWOsRx_w8Zu0jb_0NbEvE4bgC9a2IegKR3Ze61AVu2_NpfBSaq_OsD19CKEzu/s320/19.png" /></a>Uhh. I have got some work to do here...<br />Nice new feature : the fixup script. Everything that Oracle can change in a script, a script is provided for by the installer. Just run the script and those checks that failed and are Fixable are being fixed. Don't worry about prerequisite checks before running the installer. Just let the installer do the work for you. It'll report everything you need to fix before installing. Just push the "Check Again" button as many times as you wish until everything is reported as passed.</div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBUHvxhyBJeSDGZ2MDzmTRlkUVaLH0pUUwhQS6UFLkjZ3Xay9Yzbw6lDjnvGV8NBmXxn9tzv2nzWXF7D03BxPsXTCxmZ3VCPiO9ItqcShY0Ugxj0M0jcyfcWJn9KTYbjX63I9Sb3nyxFqm/s1600-h/20.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 216px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377921130083160050" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBUHvxhyBJeSDGZ2MDzmTRlkUVaLH0pUUwhQS6UFLkjZ3Xay9Yzbw6lDjnvGV8NBmXxn9tzv2nzWXF7D03BxPsXTCxmZ3VCPiO9ItqcShY0Ugxj0M0jcyfcWJn9KTYbjX63I9Sb3nyxFqm/s320/20.png" /></a> Execute the runfixup.sh script: </div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgU_juaVxMH_51K7MFq_mYOV2AwW1_N5jkKRJFjgdyQmtPhQIDYyaYxIeHJI9lvY8vrTMUtdkQEUeh_yvwrRjXUkmMkKJ2zZAZ5DT-993heS0AfzZUkIRsv1C6AVOHqHR8zdUdzeBHeHIf/s1600-h/21.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 138px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377921124397596546" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgU_juaVxMH_51K7MFq_mYOV2AwW1_N5jkKRJFjgdyQmtPhQIDYyaYxIeHJI9lvY8vrTMUtdkQEUeh_yvwrRjXUkmMkKJ2zZAZ5DT-993heS0AfzZUkIRsv1C6AVOHqHR8zdUdzeBHeHIf/s320/21.png" /></a>...And Check Again...</div><div>Well, I didn't have enough memory and swap. Also, NTP wasn't started with the -x option... Who cares? - We'll see at the end of this weblog...</div><div> </div><div></div><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJjsP613tZcctHA3O0n3vqVyDePrsmG2yhMcX8yrxzUqFK22_aEkGRIZNMP7ZsXvlWLyv0uNtpU6KesijyyonRLHWSOZu6y4zAd2O2-48grHXBdH272M72Pa96AkZ8J0Aam7LSboGpUEVF/s1600-h/22.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 240px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377920902186681058" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJjsP613tZcctHA3O0n3vqVyDePrsmG2yhMcX8yrxzUqFK22_aEkGRIZNMP7ZsXvlWLyv0uNtpU6KesijyyonRLHWSOZu6y4zAd2O2-48grHXBdH272M72Pa96AkZ8J0Aam7LSboGpUEVF/s320/22.png" /></a> ...summary...<br /><p align="left"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbl4pYf8-ixqAfLPsXCd0dGpCZPEa0S0Fj3JDvxreKd9nx237tbPxp4c8gVq_J_qw-snokTeYTmuQ6JWF_weWU4EnicjUPPSgGnP9ykqvYC3NKZp3C8wFRBUgMJe75d0IauGOwnc6dAwXD/s1600-h/23.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 240px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377920682559193666" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbl4pYf8-ixqAfLPsXCd0dGpCZPEa0S0Fj3JDvxreKd9nx237tbPxp4c8gVq_J_qw-snokTeYTmuQ6JWF_weWU4EnicjUPPSgGnP9ykqvYC3NKZp3C8wFRBUgMJe75d0IauGOwnc6dAwXD/s320/23.png" /></a></p>Start the installation by clickin on Finish.</div><div>This is what you'll see during installation:</div><div> </div><div></div><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgceDEt9GB2Id7iA1Ib775RWTBtrhl_HyHVhXFDg-D3d8d_OO6IpwBiPioEYLv-hG-vLCpnsBkhiiQPgLD2AAV8B1O44qI0LK2ivaJpqMedOITlA_H-vV_d-Kxl1PsU8Mw1o6IMLKp8GVoA/s1600-h/24.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 240px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377920574909223410" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgceDEt9GB2Id7iA1Ib775RWTBtrhl_HyHVhXFDg-D3d8d_OO6IpwBiPioEYLv-hG-vLCpnsBkhiiQPgLD2AAV8B1O44qI0LK2ivaJpqMedOITlA_H-vV_d-Kxl1PsU8Mw1o6IMLKp8GVoA/s320/24.png" /></a> Tap, tap... :-)</div><div><br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjIv3XM7BdEQiS-GlhfjCTeEwmrh86IFIBFseBFpHBIqzFGWGtkTCGq1tXoizCCpVwAryjQkrxkfHFOFj_NdwIFvVklJqJUPVDKwNtkN4X5mH_BreC4Ok1SLZmXsJIHdAUMmccCTtB-RTW/s1600-h/25.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 78px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377919971370085746" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjIv3XM7BdEQiS-GlhfjCTeEwmrh86IFIBFseBFpHBIqzFGWGtkTCGq1tXoizCCpVwAryjQkrxkfHFOFj_NdwIFvVklJqJUPVDKwNtkN4X5mH_BreC4Ok1SLZmXsJIHdAUMmccCTtB-RTW/s320/25.png" /></a> ...tap...!<br /><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7N2yGf6sca8VVvWVvwXLHIryEtHZ-XSYbrBGwjmSOshgTjRzKxQ92MybTutlLIMD4yLTLDx3NDOMu_BYKTdrFmcUFv4rfF-FA_r6ZZ4cgMavazLnlOoZqSDRqnGXk5fB2UIvLVV-mPYtA/s1600-h/26.png"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 320px; DISPLAY: block; HEIGHT: 247px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5377919888587267986" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7N2yGf6sca8VVvWVvwXLHIryEtHZ-XSYbrBGwjmSOshgTjRzKxQ92MybTutlLIMD4yLTLDx3NDOMu_BYKTdrFmcUFv4rfF-FA_r6ZZ4cgMavazLnlOoZqSDRqnGXk5fB2UIvLVV-mPYtA/s320/26.png" /></a> <div>We're almost there! Just run these two scripts and we're finished with the installation of Grid Infrastructure.</div><div></div><div></div><div>Well, that is what I thought. It took my virtual machines almost all night to finish the last script (root.sh in Grid Home). In fact, the script timed out after an hour or so, and the Virtual Machine practically froze... After having waited a couple of hours it even rebooted my entire machine (Including the Host OS!).</div><div></div><div>I will have to assign some more memory to the guests and see if I can finish the installation, or whether that is needed at all. However, it is weekend now, my wife and kids will not like me sitting behind my laptop all weekend. We'll be back next week...</div><div></div><div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com68tag:blogger.com,1999:blog-9087887235134509416.post-75688922649078358892009-09-04T09:05:00.003+02:002009-09-04T09:17:03.082+02:0011g Release 2 New Features for Grid InfrastructureBeing a RAC fanatic, the new Oracle 11g Release 2 Grid Infrastructure is one of my main focuses to investigate. Here is what I found to be the new features of Grid Infrastructure, which by the way comprises of Oracle Clusterware and Oracle Automatic Storage Management (ASM). All of them are truly fantastic features that are screaming to be investigated... I'll do my best to cover some of them here in the near future.<br /><br /><strong>Oracle grid Infrastructure</strong><br />With Oracle grid infrastructure 11g release 2 (11.2), Automatic Storage Management (ASM) and Oracle Clusterware are installed into a single home directory, which is referred to as the Grid Infrastructure home.<br /><br /><strong>Oracle Automatic Storage Manager and Oracle files</strong><br />With this release, Oracle Cluster Registry (OCR) and voting disks can be placed on Automatic Storage Management (ASM).<br />This feature enables ASM to provide a unified storage solution, storing all the data for the clusterware and the database, without the need for third-party volume managers or cluster filesystems.<br />For new installations, OCR and voting disk files can be placed either on ASM, or on a cluster file system or NFS system. <a id="sthref16" name="sthref16"></a><a id="sthref17" name="sthref17"></a><a id="sthref18" name="sthref18"></a><a id="sthref19" name="sthref19"></a>Installing Oracle Clusterware files on raw or block devices is no longer supported, unless an existing system is being upgraded.<br /><br /><strong>Automatic Storage Management Cluster File System (ACFS)<br /></strong>Oracle Automatic Storage Management Cluster File System (Oracle ACFS) is a new multi-platform, scalable file system and storage management design that extends Oracle Automatic Storage Management (ASM) technology to support all application data. Oracle ACFS provides dynamic file system resizing, and improved performance using the distribution, balancing and striping technology across all available disks, and provides storage reliability through ASM's mirroring and parity protection.<br /><br /><strong>ASM Job Role Separation Option with SYSASM</strong><br />The SYSASM privilege that was introduced in Oracle ASM 11g release 1 (11.1) is now fully separated from the SYSDBA privilege. If you choose to use this optional feature, and designate different operating system groups as the OSASM and the OSDBA groups, then the SYSASM administrative privilege is available only to members of the OSASM group. The SYSASM privilege also can be granted using password authentication on the Oracle ASM instance.<br />You can designate OPERATOR privileges (a subset of the SYSASM privileges, including starting and stopping ASM) to members of the OSOPER for ASM group.<br />Providing system privileges for the storage tier using the SYSASM privilege instead of the SYSDBA privilege provides a clearer division of responsibility between ASM administration and database administration, and helps to prevent different databases using the same storage from accidentally overwriting each other's files.<br /><br /><strong>Cluster Time Synchronization Service<br /></strong>Cluster node times should be synchronized. With this release, Oracle Clusterware provides Cluster Time Synchronization Service (CTSS), which ensures that there is a synchronization service in the cluster. If Network Time Protocol (NTP) is not found during cluster configuration, then CTSS is configured to ensure time synchronization.<br /><br /><strong>Enterprise Manager Database Control Provisioning</strong><br />Enterprise Manager Database Control 11g provides the capability to automatically provision Oracle grid infrastructure and Oracle RAC installations on new nodes, and then extend the existing Oracle grid infrastructure and Oracle RAC database to these provisioned nodes. This provisioning procedure requires a successful Oracle RAC installation before you can use this feature.<br />See Also: <a href="http://download.oracle.com/docs/cd/E11882_01/rac.112/e10718/toc.htm">Oracle Real Application Clusters Administration and Deployment Guide</a> for information about this feature.<br /><br /><a name="BGGBFJAD"></a><strong>Fixup Scripts and Grid Infrastructure Checks<br /></strong>With Oracle Clusterware 11g release 2 (11.2), the installer (OUI) detects when minimum requirements for installation are not completed, and creates shell script programs, called fixup scripts, to resolve many incomplete system configuration requirements. If OUI detects an incomplete task that is marked "fixable", then you can easily fix the issue by generating the fixup script by clicking the Fix & Check Again button.<br />The fixup script is generated during installation. You are prompted to run the script as root in a separate terminal session. When you run the script, it raises kernel values to required minimums, if necessary, and completes other operating system configuration tasks.<br />You also can have Cluster Verification Utility (CVU) generate fixup scripts before installation.<br /><a name="BGGJCEEJ"></a><br /><strong>Grid Plug and Play<br /></strong>In the past, adding or removing servers in a cluster required extensive manual preparation. With this release, you can continue to configure server nodes manually, or use Grid Plug and Play to configure them dynamically as nodes are added or removed from the cluster.<br />Grid Plug and Play reduces the costs of installing, configuring, and managing server nodes by starting a grid naming service within the cluster to allow each node to perform the following tasks dynamically: Negotiating appropriate network identities for itself<br />Acquiring additional information it needs to operate from a configuration profile<br />Configuring or reconfiguring itself using profile data, making hostnames and addresses resolvable on the network Because servers perform these tasks dynamically, the number of steps required to add or nodes is minimized.<br /><br /><a name="sthref20"></a><strong>Intelligent Platform Management Interface (IPMI) Integration<br /></strong>Intelligent Platform Management Interface (IPMI) is an industry standard management protocol that is included with many servers today. IPMI operates independently of the operating system, and can operate even if the system is not powered on. Servers with IPMI contain a baseboard management controller (BMC) which is used to communicate to the server.<br />If IPMI is configured, then Oracle Cluster uses IPMI when node fencing is required and the server is not responding.<br /><br /><a name="BGGEAEJB"></a><strong>Oracle Clusterware Out-of-place Upgrade<br /></strong>With this release, you can install a new version of Oracle Clusterware into a separate home from an existing Oracle Clusterware installation. This feature reduces the downtime required to upgrade a node in the cluster. When performing an out-of-place upgrade, the old and new version of the software are present on the nodes at the same time, each in a different home location, but only one version of the software is active.<br /><br /><a name="BGGIEFJH"></a><strong>Oracle Clusterware Administration with Oracle Enterprise Manager<br /></strong>With this release, you can use Enterprise Manager Cluster Home page to perform full administrative and monitoring support for both standalone database and Oracle RAC environments, using High Availability Application and Oracle Cluster Resource Management.<br />When Oracle Enterprise Manager is installed with Oracle Clusterware, it can provide a set of users that have the Oracle Clusterware Administrator role in Enterprise Manager, and provide full administrative and monitoring support for High Availability application and Oracle Clusterware resource management. After you have completed installation and have Enterprise Manager deployed, you can provision additional nodes added to the cluster using Enterprise Manager.<br /><br /><a name="BGGCEBAE"></a><strong>SCAN for Simplified Client Access<br /></strong>With this release, the single client access name (SCAN) is the hostname to provide for all clients connecting to the cluster. The SCAN is a domain name registered to at least one and up to three IP addresses, either in the domain name service (DNS) or the Grid Naming Service (GNS). The SCAN eliminates the need to change clients when nodes are added to or removed from the cluster. Clients using the SCAN can also access the cluster using EZCONNECT.<br /><a name="BGGBHIHJ"></a>SRVCTL Command Enhancements for Patching<br />With this release, you can use srvctl to shut down all Oracle software running within an Oracle home, in preparation for patching. Oracle grid infrastructure patching is automated across all nodes, and patches can be applied in a multi-node, multi-patch fashion.<br /><a name="sthref21"></a><br /><strong>Typical Installation Option<br /></strong>To streamline cluster installations, especially for those customers who are new to clustering, Oracle introduces the Typical Installation path. Typical installation defaults as many options as possible to those recommended as best practices.<br /><br /><a name="sthref22"></a><strong>Voting Disk Backup Procedure Change<br /></strong><a name="sthref23"></a><a name="sthref24"></a><a name="sthref25"></a>In prior releases, backing up the voting disks using a dd command was a required postinstallation task. With Oracle Clusterware release 11.2 and later, backing up and restoring a voting disk using the dd command is not supported.<br />Backing up voting disks manually is no longer required, as voting disks are backed up automatically in the OCR as part of any configuration change and voting disk data is automatically restored to any added voting disks.Arnoud Rothhttp://www.blogger.com/profile/03608371398611583649noreply@blogger.com3