Return-Path: <oracle-l-bounce@freelists.org>
X-Original-To: oracle-l@orafaq.com
Delivered-To: oracle-l@orafaq.com
Received: from puck1183.startdedicated.com (localhost [127.0.0.1])
 by puck1183.startdedicated.com (Postfix) with ESMTP id BD3981961037
 for <oracle-l@orafaq.com>; Tue,  2 Feb 2016 18:55:04 +0100 (CET)
Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180])
 by puck1183.startdedicated.com (Postfix) with ESMTPS
 for <oracle-l@orafaq.com>; Tue,  2 Feb 2016 18:55:04 +0100 (CET)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B870D31DB9;
 Tue,  2 Feb 2016 12:55:02 -0500 (EST)
X-Virus-Scanned: Debian amavisd-new at turing.freelists.org
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id ptrxMjhMu20w; Tue,  2 Feb 2016 12:55:02 -0500 (EST)
Received: from turing.freelists.org (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D6E4A31D8E;
 Tue,  2 Feb 2016 12:54:21 -0500 (EST)
Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 02 Feb 2016 12:53:40 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C11B531D65
 for <oracle-l@freelists.org>; Tue,  2 Feb 2016 12:53:40 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id W-98WZiJP-DO for <oracle-l@freelists.org>;
 Tue,  2 Feb 2016 12:53:40 -0500 (EST)
Received: from cpanel.firstlight.net (cpanel.firstlight.net [72.0.157.4])
 (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 54D4531D11
 for <oracle-l@freelists.org>; Tue,  2 Feb 2016 12:53:40 -0500 (EST)
Received: from c-65-96-123-158.hsd1.nh.comcast.net ([65.96.123.158]:49712 helo=mwf4500)
 by cpanel.firstlight.net with esmtpsa (TLSv1:AES256-SHA:256)
 (Exim 4.86)
 (envelope-from <mwf@rsiz.com>)
 id 1aQf91-0004Ui-V7; Tue, 02 Feb 2016 12:53:40 -0500
From: "Mark W. Farnham" <mwf@rsiz.com>
To: <pete.sharman@oracle.com>,
 <dedba@tpg.com.au>,
 "'Seth Miller'" <sethmiller.sm@gmail.com>
Cc: "'Oracle Discussion List'" <oracle-l@freelists.org>
References: <0D8F4CAC0F9D3C4AACC63F50FD9957F75457CBF0@PRDCTWPEMLMB31.prod-am.ameritrade.com>	<9AC8C8EE-7604-4A76-B047-52646E10BD2B@gmail.com>	<56ABCDD6.3090502@gmail.com>	<56AC3F1B.7050604@tpg.com.au> <CAEueRAVkqWaVo419BvvD5vYXg1RTomjMAq0c0yMO55Z_QRdaFQ@mail.gmail.com> <56AE996B.7040207@tpg.com.au> <2c01b202-429c-4a58-a988-b28393b52e01@default> <56B092B7.3020702@tpg.com.au> <e42a5db1-fb4e-467e-a19a-4d96a501082a@default>
In-Reply-To: <e42a5db1-fb4e-467e-a19a-4d96a501082a@default>
Subject: RE: Anyone with experience with the Oracle Data Appliance/ODA?
Date: Tue, 2 Feb 2016 12:53:38 -0500
Message-ID: <039001d15de2$a58a6e80$f09f4b80$@rsiz.com>
MIME-Version: 1.0
Content-Type: multipart/related;
 boundary="----=_NextPart_000_0391_01D15DB8.BCB92170"
Content-Language: en-us
X-AntiAbuse: This header was added to track abuse, please include it with any abuse report
X-AntiAbuse: Primary Hostname - cpanel.firstlight.net
X-AntiAbuse: Original Domain - freelists.org
X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
X-AntiAbuse: Sender Address Domain - rsiz.com
X-Get-Message-Sender-Via: cpanel.firstlight.net: authenticated_id: mfarnham@rsiz.com
X-Authenticated-Sender: cpanel.firstlight.net: mfarnham@rsiz.com
X-archive-position: 63263
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: mwf@rsiz.com
Precedence: normal
Reply-To: mwf@rsiz.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:mark.bobak@proquest.com>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
------=_NextPart_000_0391_01D15DB8.BCB92170
Content-Type: multipart/alternative;
 boundary="----=_NextPart_001_0392_01D15DB8.BCB92170"
------=_NextPart_001_0392_01D15DB8.BCB92170
Content-Type: text/plain;
 charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Thanks Pete.

=20

Wouldn=E2=80=99t it be great if there was some pointy-clicky MAP of =
features to license requirements. This is one time I think a Graphical =
User Interface (GUI) would wind hands down over a Command Line Interface =
(CLI).

=20

In this metaphor the CLI is essentially reading the features and license =
documents from the bottom up.=20

=20

The GUI could have a search box for a specific feature or command, flash =
up the appropriate bundle =E2=80=9Cbox=E2=80=9D and have links to the =
various license requirements to use the feature.

=20

Reading the license matrix is time consuming and error prone (and the =
errors are difficult to test for as a user until a visit from license =
auditing!) Freeing that research time for learning to use the database =
better (which I find much more interesting) and avoiding unfortunate =
customer confrontations would be a wonderful advance!=20

=20

Of course only Oracle could be the authoritative voice to create such a =
tool. (It might even =E2=80=9Chelp=E2=80=9D salesmen be accurate!)

=20

mwf

=20

From: oracle-l-bounce@freelists.org =
[mailto:oracle-l-bounce@freelists.org] On Behalf Of Peter Sharman
Sent: Tuesday, February 02, 2016 12:36 PM
To: dedba@tpg.com.au; Seth Miller
Cc: Oracle Discussion List
Subject: RE: Anyone with experience with the Oracle Data Appliance/ODA?

=20

Snap Clone is part of the Cloud Management pack, which has the DBLM pack =
as a prerequisite.

=20

Pete

Oracle logo

Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA

Phone:  <tel:+61262924095> +61262924095 | | Mobile: +61414443449=20
Email:  <mailto:pete.sharman@oracle.com> pete.sharman@oracle.com  =
Twitter: @SharmanPete  LinkedIn: au.linkedin.com/in/petesharman
Website: petewhodidnottweet.com

  _____ =20

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

=20

"Oh no, it's not, it's much harder than that!"

Bruce Pihlamae, long term Oracle DBA

  _____ =20

=20

From: De DBA [mailto:dedba@tpg.com.au]=20
Sent: Tuesday, February 2, 2016 10:28 PM
To: Peter Sharman <pete.sharman@oracle.com>; Seth Miller =
<sethmiller.sm@gmail.com>
Cc: Oracle Discussion List <oracle-l@freelists.org>
Subject: Re: Anyone with experience with the Oracle Data Appliance/ODA?

=20

Thanks Pete.

I've now seen the ODA. The database is version 11.2.0.4. The data files =
are stored in ASM disk groups, not on ACFS mounts. I am not sure if it =
is still possible to create snapshots with oakcli in this situation?

Is the snap clone functionality in EM/Cloud Control licensed with any =
optional pack? It sounds promising.. there is not much disk space left =
on the array, so a thin clone is preferable ;-)=20

Cheers,
Tony

On 2/02/2016 12:45 pm, Peter Sharman wrote:

Tony

=20

I don=E2=80=99t think I saw anything about database versions in the =
thread, so there are a couple of other options you could use depending =
on the version:

=20

=C2=B7         If the DB is 12c, there is snapshotting capability built =
into the database itself

=C2=B7         From DB 10g onwards you could look at using Enterprise =
Manager=E2=80=99s Snap Clone functionality which uses copy on write =
technology to build thin clones, optionally including masking as well.  =
This may make it easier for you to do the snapshotting as its built into =
the product, which makes it less error prone than a manual snapshotting =
process.

=20

Let me know if you need any more details on that.

=20

Pete

Oraclelogo

Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA

Phone:  <tel:+61262924095> +61262924095 | | Mobile: +61414443449=20
Email:  <mailto:pete.sharman@oracle.com> pete.sharman@oracle.com  =
Twitter: @SharmanPete  LinkedIn: au.linkedin.com/in/petesharman
Website: petewhodidnottweet.com


  _____ =20


"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

=20

"Oh no, it's not, it's much harder than that!"

Bruce Pihlamae, long term Oracle DBA


  _____ =20


=20

From: De DBA [mailto:dedba@tpg.com.au]=20
Sent: Monday, February 1, 2016 10:32 AM
To: Seth Miller  <mailto:sethmiller.sm@gmail.com> =
<sethmiller.sm@gmail.com>
Cc: Oracle Discussion List  <mailto:oracle-l@freelists.org> =
<oracle-l@freelists.org>
Subject: Re: Anyone with experience with the Oracle Data Appliance/ODA?

=20

Seth,

Thanks for that. I haven't got access to the systems yet, just reading =
up and preparing for the shock..

You will not find OCFS on the ODA. It uses ACFS for the cluster file =
system as well as the database files.

=20

Ah, yes, of course, it's on ASM... I understand that oakcli will create =
& manage fs automatically, but I'm not going to have RAC. One node is =
supposed to be production, whereas the other node will run dev, test and =
UAT. I will need to refresh the dev & test databases from production, =
and wonder whether I can create a snapshot, do the masking etc. and then =
mount the copy on the other node where it will then be used as the gold =
copy for the refreshes.

get yourself a couple of excellent books.=20

Practical Oracle Database Appliance =
<http://www.amazon.com/Practical-Oracle-Database-Appliance-Curtis/dp/1430=
262656>=20

Oracle Database Appliance: A Hands-On Guide =
<http://www.amazon.com/Oracle-Database-Appliance-Hands--Guide/dp/00718274=
47>=20


I did look at the first one, which has some famous names amongst the =
authors. One of the reviews that I saw mentions that it is somewhat =
dated? Is it still worthwhile getting even if you work with the latest =
hard/software?

Cheers,
Tony

On 31/01/2016 2:45 pm, Seth Miller wrote:

Tony,=20

=20

The ODAs apparently are each set up as two stand-alone servers with =
shared storage. I understand that one needs to use oakcli to create =
databases and that this tool hides pretty much all functionality that we =
are used to through dbca etc.

Yes, oakcli is the magic behind ODA but it does not preclude you from =
using DBCA. If you need to create a database that does not fall into one =
of the oakcli templates, feel free to use DBCA or any other classic =
method.

=20

But what does it do exactly?

Oakcli is nothing more than a bunch of very well written perl and shell =
scripts that wrap the classic tools included with the Oracle database =
software. They are easy to find and read if you really want to know what =
they are doing.

=20

How does one manage the OCFS?

You will not find OCFS on the ODA. It uses ACFS for the cluster file =
system as well as the database files.

=20

Can a file system be mounted on both nodes, or just on one? Is this =
automatic?

Oakcli will take care of this for you.

=20

Given a complete backup (... which is a problem all of its own...), how =
does one restore a database?

Use RMAN or Enterprise Manager for this. There will be little difference =
from a standard RAC database in how you backup and restore a database.

=20

Don't use centralised wallets with TDE, otherwise problems will arise -- =
but what does that even mean?

This isn't specific to the ODA. There are a number of reasons to have =
local wallets in RAC -- one of the most important being that you can't =
have a local only autologin wallet if it is shared with multiple nodes.

=20

You will find little argument that the documentation for ODA is mediocre =
at best. This is why a number of training companies (including the one I =
teach for) have developed their own content for the ODA. I think your =
best course of action, though, is to get yourself a couple of excellent =
books.

Practical Oracle Database Appliance =
<http://www.amazon.com/Practical-Oracle-Database-Appliance-Curtis/dp/1430=
262656>=20

Oracle Database Appliance: A Hands-On Guide =
<http://www.amazon.com/Oracle-Database-Appliance-Hands--Guide/dp/00718274=
47>=20

=20

Seth Miller

=20

On Fri, Jan 29, 2016 at 10:42 PM, De DBA <dedba@tpg.com.au> wrote:

=20

I've just read through that documentation, as I will shortly get the =
responsibility for 2 ODA's. I would not classify the 3 software manuals =
and 2 hw manuals as good documentation. After reading all of it, I've =
got more questions than what I started out with...=20

The ODAs apparently are each set up as two stand-alone servers with =
shared storage. I understand that one needs to use oakcli to create =
databases and that this tool hides pretty much all functionality that we =
are used to through dbca etc. But what does it do exactly? How does one =
manage the OCFS? Can a file system be mounted on both nodes, or just on =
one? Is this automatic? Given a complete backup (... which is a problem =
all of its own...), how does one restore a database? Don't use =
centralised wallets with TDE, otherwise problems will arise -- but what =
does that even mean? Questions...=20

Pointers to more complete documentation/blogs/etc. regarding managing =
and patching the ODA are very welcome!

Cheers,
Tony=20

On 30/01/2016 6:38 am, Hans Forbrich wrote:

Yes, lack of documentation was a problem at one time.

That has significantly improved.  See =
http://docs.oracle.com/en/engineered-systems/

/Hans

On 29/01/2016 12:54 PM, Andrew Kerber wrote:

I have run into problem with a lack of good documentation on its use.=20

Sent from my iPad


On Jan 29, 2016, at 1:49 PM, <Jay.Miller@tdameritrade.com> =
<Jay.Miller@tdameritrade.com> wrote:

Hi

=20

We just attended an ODA presentation and it looks very promising as a =
solution for our non-prod testing environment as it would allow us to =
clone multiple instances of the gold copy test databases easily (without =
needing to coordinate with other departments as we do now) and apply =
patches for those environments quickly and easily as well.

=20

Any real life pros or cons that anyone has experienced with the =
appliance? We=E2=80=99d keep our production and performance testing =
environments off it at least for now.

=20

=20

Jay Miller

Sr. Oracle DBA

201.369.8355

=20

=20

=20

=20

=20

=20


------=_NextPart_001_0392_01D15DB8.BCB92170
Content-Type: text/html;
 charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40"><head><meta =
http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8"><meta =
name=3DGenerator content=3D"Microsoft Word 14 (filtered medium)"><!--[if =
!mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman","serif";
	color:black;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
	{mso-style-priority:99;
	mso-style-link:"Balloon Text Char";
	margin:0in;
	margin-bottom:.0001pt;
	font-size:8.0pt;
	font-family:"Tahoma","sans-serif";
	color:black;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
	{mso-style-priority:34;
	margin-top:0in;
	margin-right:0in;
	margin-bottom:0in;
	margin-left:.5in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman","serif";
	color:black;}
span.moz-smiley-s3
	{mso-style-name:moz-smiley-s3;}
span.hoenzb
	{mso-style-name:hoenzb;}
span.EmailStyle20
	{mso-style-type:personal;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
span.EmailStyle21
	{mso-style-type:personal;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
span.BalloonTextChar
	{mso-style-name:"Balloon Text Char";
	mso-style-priority:99;
	mso-style-link:"Balloon Text";
	font-family:"Tahoma","sans-serif";
	color:black;}
span.EmailStyle24
	{mso-style-type:personal-reply;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=3Dwhite =
lang=3DEN-US link=3Dblue vlink=3Dpurple><div class=3DWordSection1><p =
class=3DMsoNormal><span =
style=3D'font-size:14.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>Thanks Pete.<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:14.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:14.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>Wouldn=E2=80=99t it be great if there was some pointy-clicky MAP of =
features to license requirements. This is one time I think a Graphical =
User Interface (GUI) would wind hands down over a Command Line Interface =
(CLI).<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:14.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:14.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>In this metaphor the CLI is essentially reading the features and =
license documents from the bottom up. <o:p></o:p></span></p><p =
class=3DMsoNormal><span =
style=3D'font-size:14.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:14.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>The GUI could have a search box for a specific feature or command, =
flash up the appropriate bundle =E2=80=9Cbox=E2=80=9D and have links to =
the various license requirements to use the =
feature.<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:14.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:14.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>Reading the license matrix is time consuming and error prone (and the =
errors are difficult to test for as a user until a visit from license =
auditing!) Freeing that research time for learning to use the database =
better (which I find much more interesting) and avoiding unfortunate =
customer confrontations would be a wonderful advance! =
<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:14.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:14.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>Of course only Oracle could be the authoritative voice to create such =
a tool. (It might even =E2=80=9Chelp=E2=80=9D salesmen be =
accurate!)<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:14.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:14.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>mwf<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:14.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p>&nbsp;</o:p></span></p><div><div =
style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in =
0in 0in'><p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowt=
ext'>From:</span></b><span =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowt=
ext'> oracle-l-bounce@freelists.org =
[mailto:oracle-l-bounce@freelists.org] <b>On Behalf Of </b>Peter =
Sharman<br><b>Sent:</b> Tuesday, February 02, 2016 12:36 =
PM<br><b>To:</b> dedba@tpg.com.au; Seth Miller<br><b>Cc:</b> Oracle =
Discussion List<br><b>Subject:</b> RE: Anyone with experience with the =
Oracle Data Appliance/ODA?<o:p></o:p></span></p></div></div><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal><span =
lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>Snap Clone is part of the Cloud Management pack, which has the DBLM =
pack as a prerequisite.<o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p>&nbsp;</o:p></span></p><div><p class=3DMsoNormal><span =
lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'>Pete<o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'><img width=3D88 height=3D17 id=3D"_x0000_i1025" =
src=3D"cid:image001.jpg@01D15DB8.7543FA90" alt=3D"Oracle =
logo"><o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#666666=
'>Pete Sharman<br>Database Architect, DBaaS / DBLM<br>Enterprise Manager =
Product Suite<br>33 Benson Crescent CALWELL ACT 2905 =
AUSTRALIA<o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#666666=
'>Phone: <a href=3D"tel:+61262924095"><span =
style=3D'color:black'>+61262924095</span></a> | | Mobile: =
</span><u><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'>+61414443449</span></u><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'>&nbsp;<br></span><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#595959=
'>Email: <a href=3D"mailto:pete.sharman@oracle.com"><span =
style=3D'color:#0563C1'>pete.sharman@oracle.com</span></a>&nbsp; =
Twitter: @SharmanPete&nbsp; LinkedIn: </span><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#66696A;=
border:none windowtext =
1.0pt;padding:0in;background:white'>au.linkedin.com/in/</span><span =
lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333;=
border:none windowtext =
1.0pt;padding:0in;background:white'>petesharman</span><span lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><br></span><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333;=
border:none windowtext 1.0pt;padding:0in;background:white'>Website: =
petewhodidnottweet.com</span><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'><o:p></o:p></span></p><div class=3DMsoNormal align=3Dcenter =
style=3D'text-align:center'><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'><hr size=3D3 width=3D"100%" align=3Dcenter></span></div><p =
class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'>&quot;Controlling developers is like herding =
cats.&quot;<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#0070C0=
'>Kevin Loney, Oracle DBA Handbook<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'>&quot;Oh no, it's not, it's much harder than =
that!&quot;<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#0070C0=
'>Bruce Pihlamae, long term Oracle DBA<o:p></o:p></span></p><div =
class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><span =
lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'><hr size=3D3 width=3D"100%" align=3Dcenter></span></div></div><p =
class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p>&nbsp;</o:p></span></p><div><div =
style=3D'border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in =
0in 0in'><p class=3DMsoNormal><b><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:window=
text'>From:</span></b><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:window=
text'> De DBA [<a =
href=3D"mailto:dedba@tpg.com.au">mailto:dedba@tpg.com.au</a>] =
<br><b>Sent:</b> Tuesday, February 2, 2016 10:28 PM<br><b>To:</b> Peter =
Sharman &lt;<a =
href=3D"mailto:pete.sharman@oracle.com">pete.sharman@oracle.com</a>&gt;; =
Seth Miller &lt;<a =
href=3D"mailto:sethmiller.sm@gmail.com">sethmiller.sm@gmail.com</a>&gt;<b=
r><b>Cc:</b> Oracle Discussion List &lt;<a =
href=3D"mailto:oracle-l@freelists.org">oracle-l@freelists.org</a>&gt;<br>=
<b>Subject:</b> Re: Anyone with experience with the Oracle Data =
Appliance/ODA?<o:p></o:p></span></p></div></div><p =
class=3DMsoNormal><span lang=3DEN-AU><o:p>&nbsp;</o:p></span></p><p =
class=3DMsoNormal style=3D'margin-bottom:12.0pt'><span =
lang=3DEN-AU>Thanks Pete.<br><br>I've now seen the ODA. The database is =
version 11.2.0.4. The data files are stored in ASM disk groups, not on =
ACFS mounts. I am not sure if it is still possible to create snapshots =
with oakcli in this situation?<br><br>Is the snap clone functionality in =
EM/Cloud Control licensed with any optional pack? It sounds promising.. =
there is not much disk space left on the array, so a thin clone is =
preferable <span class=3Dmoz-smiley-s3>;-) =
</span><br><br>Cheers,<br>Tony<o:p></o:p></span></p><div><p =
class=3DMsoNormal><span lang=3DEN-AU>On 2/02/2016 12:45 pm, Peter =
Sharman wrote:<o:p></o:p></span></p></div><blockquote =
style=3D'margin-top:5.0pt;margin-bottom:5.0pt'><p =
class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>Tony</span><span lang=3DEN-AU><o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>&nbsp;</span><span lang=3DEN-AU><o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>I don=E2=80=99t think I saw anything about database versions in the =
thread, so there are a couple of other options you could use depending =
on the version:</span><span lang=3DEN-AU><o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>&nbsp;</span><span lang=3DEN-AU><o:p></o:p></span></p><p =
class=3DMsoListParagraph style=3D'text-indent:-.25in'><span lang=3DEN-AU =
style=3D'font-family:Symbol'>=C2=B7</span><span lang=3DEN-AU =
style=3D'font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
; </span><span lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>If the DB is 12c, there is snapshotting capability built into the =
database itself</span><span lang=3DEN-AU><o:p></o:p></span></p><p =
class=3DMsoListParagraph style=3D'text-indent:-.25in'><span lang=3DEN-AU =
style=3D'font-family:Symbol'>=C2=B7</span><span lang=3DEN-AU =
style=3D'font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
; </span><span lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>From DB 10g onwards you could look at using Enterprise =
Manager=E2=80=99s Snap Clone functionality which uses copy on write =
technology to build thin clones, optionally including masking as =
well.&nbsp; This may make it easier for you to do the snapshotting as =
its built into the product, which makes it less error prone than a =
manual snapshotting process.</span><span =
lang=3DEN-AU><o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>&nbsp;</span><span lang=3DEN-AU><o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>Let me know if you need any more details on that.</span><span =
lang=3DEN-AU><o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>&nbsp;</span><span lang=3DEN-AU><o:p></o:p></span></p><div><p =
class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'>Pete</span><span lang=3DEN-AU><o:p></o:p></span></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'><img border=3D0 width=3D88 height=3D17 id=3D"Picture_x0020_1" =
src=3D"cid:image001.jpg@01D15DB8.7543FA90" alt=3D"Oracle&#13;&#10;       =
         logo"></span><span lang=3DEN-AU><o:p></o:p></span></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#666666=
'>Pete Sharman<br>Database Architect, DBaaS / DBLM<br>Enterprise Manager =
Product Suite<br>33 Benson Crescent CALWELL ACT 2905 =
AUSTRALIA</span><span lang=3DEN-AU><o:p></o:p></span></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#666666=
'>Phone: <a href=3D"tel:+61262924095"><span =
style=3D'color:black'>+61262924095</span></a> | | Mobile: =
</span><u><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'>+61414443449</span></u><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'>&nbsp;<br></span><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#595959=
'>Email: <a href=3D"mailto:pete.sharman@oracle.com"><span =
style=3D'color:#0563C1'>pete.sharman@oracle.com</span></a>&nbsp; =
Twitter: @SharmanPete&nbsp; LinkedIn: </span><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#66696A;=
border:none windowtext =
1.0pt;padding:0in;background:white'>au.linkedin.com/in/</span><span =
lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333;=
border:none windowtext =
1.0pt;padding:0in;background:white'>petesharman</span><span lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><br></span><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif";color:#333333;=
border:none windowtext 1.0pt;padding:0in;background:white'>Website: =
petewhodidnottweet.com</span><span =
lang=3DEN-AU><o:p></o:p></span></p><div class=3DMsoNormal align=3Dcenter =
style=3D'text-align:center'><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'><hr size=3D3 width=3D"100%" align=3Dcenter></span></div><p =
class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'>&quot;Controlling developers is like herding cats.&quot;</span><span =
lang=3DEN-AU><o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#0070C0=
'>Kevin Loney, Oracle DBA Handbook</span><span =
lang=3DEN-AU><o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'>&nbsp;</span><span lang=3DEN-AU><o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'>&quot;Oh no, it's not, it's much harder than that!&quot;</span><span =
lang=3DEN-AU><o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#0070C0=
'>Bruce Pihlamae, long term Oracle DBA</span><span =
lang=3DEN-AU><o:p></o:p></span></p><div class=3DMsoNormal align=3Dcenter =
style=3D'text-align:center'><span lang=3DEN-AU =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#1F497D=
'><hr size=3D3 width=3D"100%" align=3Dcenter></span></div></div><p =
class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>&nbsp;</span><span lang=3DEN-AU><o:p></o:p></span></p><div><div =
style=3D'border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in =
0in 0in'><p class=3DMsoNormal><b><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:window=
text'>From:</span></b><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:window=
text'> De DBA [<a =
href=3D"mailto:dedba@tpg.com.au">mailto:dedba@tpg.com.au</a>] =
<br><b>Sent:</b> Monday, February 1, 2016 10:32 AM<br><b>To:</b> Seth =
Miller <a =
href=3D"mailto:sethmiller.sm@gmail.com">&lt;sethmiller.sm@gmail.com&gt;</=
a><br><b>Cc:</b> Oracle Discussion List <a =
href=3D"mailto:oracle-l@freelists.org">&lt;oracle-l@freelists.org&gt;</a>=
<br><b>Subject:</b> Re: Anyone with experience with the Oracle Data =
Appliance/ODA?</span><span =
lang=3DEN-AU><o:p></o:p></span></p></div></div><p =
class=3DMsoNormal><span lang=3DEN-AU>&nbsp;<o:p></o:p></span></p><p =
class=3DMsoNormal style=3D'margin-bottom:12.0pt'><span =
lang=3DEN-AU>Seth,<br><br>Thanks for that. I haven't got access to the =
systems yet, just reading up and preparing for the =
shock..<o:p></o:p></span></p><div><p class=3DMsoNormal><span =
lang=3DEN-AU style=3D'font-size:9.5pt;color:red'>You will not find OCFS =
on the ODA. It uses ACFS for the cluster file system as well as the =
database files.</span><span =
lang=3DEN-AU><o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p></div><p =
class=3DMsoNormal><span lang=3DEN-AU>Ah, yes, of course, it's on ASM... =
I understand that oakcli will create &amp; manage fs automatically, but =
I'm not going to have RAC. One node is supposed to be production, =
whereas the other node will run dev, test and UAT. I will need to =
refresh the dev &amp; test databases from production, and wonder whether =
I can create a snapshot, do the masking etc. and then mount the copy on =
the other node where it will then be used as the gold copy for the =
refreshes.<br><br></span><span lang=3DEN-AU =
style=3D'font-size:9.5pt'>get yourself a couple of excellent =
books.</span><span lang=3DEN-AU> <o:p></o:p></span></p><div><p =
class=3DMsoNormal><span lang=3DEN-AU style=3D'font-size:9.5pt'><a =
href=3D"http://www.amazon.com/Practical-Oracle-Database-Appliance-Curtis/=
dp/1430262656">Practical Oracle Database Appliance</a></span><span =
lang=3DEN-AU><o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
lang=3DEN-AU><a =
href=3D"http://www.amazon.com/Oracle-Database-Appliance-Hands--Guide/dp/0=
071827447">Oracle Database Appliance: A Hands-On =
Guide</a><o:p></o:p></span></p></div><p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'><span lang=3DEN-AU><br>I did look at the =
first one, which has some famous names amongst the authors. One of the =
reviews that I saw mentions that it is somewhat dated? Is it still =
worthwhile getting even if you work with the latest =
hard/software?<br><br>Cheers,<br>Tony<o:p></o:p></span></p><div><p =
class=3DMsoNormal><span lang=3DEN-AU>On 31/01/2016 2:45 pm, Seth Miller =
wrote:<o:p></o:p></span></p></div><blockquote =
style=3D'margin-top:5.0pt;margin-bottom:5.0pt'><div><p =
class=3DMsoNormal><span lang=3DEN-AU>Tony, <o:p></o:p></span></p><div><p =
class=3DMsoNormal><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span lang=3DEN-AU style=3D'font-size:9.5pt'>The ODAs =
apparently are each set up as two stand-alone servers with shared =
storage. I understand that one needs to use oakcli to create databases =
and that this tool hides pretty much all functionality that we are used =
to through dbca etc.</span><span =
lang=3DEN-AU><o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
lang=3DEN-AU style=3D'font-size:9.5pt;color:red'>Yes, oakcli is the =
magic behind ODA but it does not preclude you from using DBCA. If you =
need to create a database that does not fall into one of the oakcli =
templates, feel free to use DBCA or any other classic =
method.</span><span lang=3DEN-AU><o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span lang=3DEN-AU style=3D'font-size:9.5pt'>But what =
does it do exactly?</span><span =
lang=3DEN-AU><o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
lang=3DEN-AU style=3D'font-size:9.5pt;color:red'>Oakcli is nothing more =
than a bunch of very well written perl and shell scripts that wrap the =
classic tools included with the Oracle database software. They are easy =
to find and read if you really want to know what they are =
doing.</span><span lang=3DEN-AU><o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span lang=3DEN-AU style=3D'font-size:9.5pt'>How does =
one manage the OCFS?</span><span =
lang=3DEN-AU><o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
lang=3DEN-AU style=3D'font-size:9.5pt;color:red'>You will not find OCFS =
on the ODA. It uses ACFS for the cluster file system as well as the =
database files.</span><span =
lang=3DEN-AU><o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span lang=3DEN-AU style=3D'font-size:9.5pt'>Can a =
file system be mounted on both nodes, or just on one? Is this =
automatic?</span><span lang=3DEN-AU><o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span lang=3DEN-AU =
style=3D'font-size:9.5pt;color:red'>Oakcli will take care of this for =
you.</span><span lang=3DEN-AU><o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span lang=3DEN-AU style=3D'font-size:9.5pt'>Given a =
complete backup (... which is a problem all of its own...), how does one =
restore a database?</span><span =
lang=3DEN-AU><o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
lang=3DEN-AU style=3D'font-size:9.5pt;color:red'>Use RMAN or Enterprise =
Manager for this. There will be little difference from a standard RAC =
database in how you backup and restore a database.</span><span =
lang=3DEN-AU><o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span lang=3DEN-AU style=3D'font-size:9.5pt'>Don't use =
centralised wallets with TDE, otherwise problems will arise -- but what =
does that even mean?</span><span =
lang=3DEN-AU><o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
lang=3DEN-AU style=3D'font-size:9.5pt;color:red'>This isn't specific to =
the ODA. There are a number of reasons to have local wallets in RAC -- =
one of the most important being that you can't have a local only =
autologin wallet if it is shared with multiple nodes.</span><span =
lang=3DEN-AU><o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span lang=3DEN-AU style=3D'font-size:9.5pt'>You will =
find little argument that the documentation for ODA is mediocre at best. =
This is why a number of training companies (including the one I teach =
for) have developed their own content for the ODA. I think your best =
course of action, though, is to get yourself a couple of excellent =
books.</span><span lang=3DEN-AU><o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span lang=3DEN-AU style=3D'font-size:9.5pt'><a =
href=3D"http://www.amazon.com/Practical-Oracle-Database-Appliance-Curtis/=
dp/1430262656">Practical Oracle Database Appliance</a></span><span =
lang=3DEN-AU><o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
lang=3DEN-AU><a =
href=3D"http://www.amazon.com/Oracle-Database-Appliance-Hands--Guide/dp/0=
071827447">Oracle Database Appliance: A Hands-On =
Guide</a><o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span lang=3DEN-AU style=3D'font-size:9.5pt'>Seth =
Miller</span><span =
lang=3DEN-AU><o:p></o:p></span></p></div></div><div><p =
class=3DMsoNormal><span lang=3DEN-AU>&nbsp;<o:p></o:p></span></p><div><p =
class=3DMsoNormal><span lang=3DEN-AU>On Fri, Jan 29, 2016 at 10:42 PM, =
De DBA &lt;<a href=3D"mailto:dedba@tpg.com.au" =
target=3D"_blank">dedba@tpg.com.au</a>&gt; =
wrote:<o:p></o:p></span></p><blockquote =
style=3D'border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in =
6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5=
.0pt'><p class=3DMsoNormal><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p><div><p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'><span lang=3DEN-AU>I've just read through =
that documentation, as I will shortly get the responsibility for 2 =
ODA's. I would not classify the 3 software manuals and 2 hw manuals as =
good documentation. After reading all of it, I've got more questions =
than what I started out with... <br><br>The ODAs apparently are each set =
up as two stand-alone servers with shared storage. I understand that one =
needs to use oakcli to create databases and that this tool hides pretty =
much all functionality that we are used to through dbca etc. But what =
does it do exactly? How does one manage the OCFS? Can a file system be =
mounted on both nodes, or just on one? Is this automatic? Given a =
complete backup (... which is a problem all of its own...), how does one =
restore a database? Don't use centralised wallets with TDE, otherwise =
problems will arise -- but what does that even mean? Questions... =
<br><br>Pointers to more complete documentation/blogs/etc. regarding =
managing and patching the ODA are very welcome!<br><br>Cheers,<br>Tony =
<o:p></o:p></span></p><div><p class=3DMsoNormal><span lang=3DEN-AU>On =
30/01/2016 6:38 am, Hans Forbrich =
wrote:<o:p></o:p></span></p></div><blockquote =
style=3D'margin-top:5.0pt;margin-bottom:5.0pt'><div><p =
class=3DMsoNormal><span lang=3DEN-AU>Yes, lack of documentation was a =
problem at one time.<br><br>That has significantly improved.&nbsp; See =
<a href=3D"http://docs.oracle.com/en/engineered-systems/" =
target=3D"_blank">http://docs.oracle.com/en/engineered-systems/</a><br><b=
r>/Hans<br><br>On 29/01/2016 12:54 PM, Andrew Kerber =
wrote:<o:p></o:p></span></p></div><blockquote =
style=3D'margin-top:5.0pt;margin-bottom:5.0pt'><div><p =
class=3DMsoNormal><span lang=3DEN-AU>I have run into problem with a lack =
of good documentation on its use.&nbsp;<br><br>Sent from my =
iPad<o:p></o:p></span></p></div><div><p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'><span lang=3DEN-AU><br>On Jan 29, 2016, =
at 1:49 PM, &lt;<a href=3D"mailto:Jay.Miller@tdameritrade.com" =
target=3D"_blank">Jay.Miller@tdameritrade.com</a>&gt; &lt;<a =
href=3D"mailto:Jay.Miller@tdameritrade.com" =
target=3D"_blank">Jay.Miller@tdameritrade.com</a>&gt; =
wrote:<o:p></o:p></span></p></div><blockquote =
style=3D'margin-top:5.0pt;margin-bottom:5.0pt'><div><div><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU>Hi<o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU>We just attended an ODA presentation and it looks very =
promising as a solution for our non-prod testing environment as it would =
allow us to clone multiple instances of the gold copy test databases =
easily (without needing to coordinate with other departments as we do =
now) and apply patches for those environments quickly and easily as =
well.<o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU>Any real life pros or cons that anyone has experienced with =
the appliance? We=E2=80=99d keep our production and performance testing =
environments off it at least for now.<o:p></o:p></span></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU>Jay Miller<o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU>Sr. Oracle DBA<o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU>201.369.8355<o:p></o:p></span></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p></div></div></blockquote></block=
quote><p class=3DMsoNormal><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p></blockquote><p =
class=3DMsoNormal><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p></div></blockquote></div><p =
class=3DMsoNormal><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p></div></blockquote><p =
class=3DMsoNormal><span =
lang=3DEN-AU>&nbsp;<o:p></o:p></span></p></blockquote><p =
class=3DMsoNormal><span =
lang=3DEN-AU><o:p>&nbsp;</o:p></span></p></div></body></html>
------=_NextPart_001_0392_01D15DB8.BCB92170--

------=_NextPart_000_0391_01D15DB8.BCB92170
Content-Type: image/jpeg;
 name="image001.jpg"
Content-Transfer-Encoding: base64
Content-ID: <image001.jpg@01D15DB8.7543FA90>

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIf
IiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7
Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCAARAFgDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDp/D2n
ReMlu9S1ueWZ1uGiS1WQosCjpwO/vWhqPgvSbKwmurOW4sZ4UMiTrO3yEDPOTyKfqPhWK71CS600
3NjK/wDrZIJjGJD7j196qnwbM5UaheX17bg5aBrokN9R3rJRt01PYdZOXNGpyx/l/TsY1n5XiXVr
a51iCabGkiV44iQWIcjIA6561GH0e5ubb/hEYNQj1FbhQWO8Iq5+YPnjpXcW+kQQ+IV1GFDGq2Yg
VRwoUHOMVC+hp/wkK6nYF7SQjFwUOEm+q9z70chf1yF7K6VtFfT0aMzxVqI1C/i8Ox3i20JAfULj
ftEadkz6tVLTPEz6ZpGraX9pjvLrToWe0mDBvNi7E46le9b+m+HrKztr2G8t/tTXUxknaYBzL6fg
Kgu/DGlyz2sljYizkgfcXiQICpGCpHcH0p2lv1MoVaHL7Jq6X59+/l6FbSPB2lalpVtfX809/c3M
Ykedp25JGcDB4HtUWtaVZ6HcaBb2EbRI2pAtliS3ynqTTj4OkV3Om3V7Y2zMWWFLkhR9B2+lSXHh
KSbTIbae7u5LiO581JmuMsvGOvak1poi1VXtFJ1brXTtdP5aHXPwpI7DNeW2Tya89zfalouqaozT
MqiCULHCAfugZHPrXRJ4R1IOpbWNQKgjI+1nkflUl54TWe+ludNkurBpD+9MNwUWQ+uPX3pyvIjD
OlQuua7fXXT7tdfITw/otjIlwDoV7pgJXJuJsl8HOBycCitHQdDutLuJJLi9urneuAJpy4H4UU4r
Q5K9aftHyyv83+ptx9KcetFFWcz3I/X6U0ffWiikMl/5aD6Uh+830oooEOHemt0/GiiqBDu1R96K
KQRHpRRRSJe5/9k=

------=_NextPart_000_0391_01D15DB8.BCB92170--

--
http://www.freelists.org/webpage/oracle-l


