Re: [OT] Oracle memory leak debugging

[Damian Gallagher]

Well, we normally do this through an SR, as it generally requires the use of 
some internal technology which needs a support contract underpinning it. If you 
don't have a support contract/My Oracle Support account, contact me off list 
and I'll discuss what we can do. If you do, open an SR and let me know the SR 
number.

The trace you have is a SQL*NET trace, which traces the interactions over the 
network. It's as much use as a chocolate teapot for what you're looking for :-)

Cheers
Damian 

-Original Message-
From: Neale Ferguson [mailto:ne...@sinenomine.net] 
Sent: 29 May 2013 01:37
To: LINUX-390@vm.marist.edu
Subject: [OT] Oracle memory leak debugging

I am trying to determine why an Oracle app is using a lot of storage (and 
growing and growing). I am not sure if it¹s application related or not.
Initially I saw lots of OCIParamGet() calls with no corresponding
OCIDescriptorFree() calls. However, after correcting this there was no respite 
from memory consumption.

Looking at the memory contents as the app runs to see what's in the new areas 
allocated I see lots of "Alloc statemen" eye-catchers. Statement handles are 
being created OCIHandleAlloc() and freed via OCIHandleFree() without error.

This is Oracle 10g. Creating .sqlnet.ora with the following provides a lot of 
data but sheds no light:

trace_level_client=16
trace_file_client=cli
trace_directory_client=/tmp/oci
trace_unique_client=true
trace_timestamp_client=ON

I'd really like to find out why Oracle believes the area cannot be freed.

A similar app runs on Windows without a problem so I'd like some way of tracing 
all the OCI calls being made in both environments and compare them to see what 
magic incantation may be missing.

Neale

--
For LINUX-390 subscribe / signoff / archive access instructions, send email to 
lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Regina listserv

[Damian Gallagher]

regin...@lightlink.com

I'm subscribed, I'll see if I can work out how I did that :-)

Cheers
Damian

-Original Message-
From: Bauer, Bobby (NIH/CIT) [E] [mailto:baue...@mail.nih.gov] 
Sent: 18 July 2013 13:51
To: LINUX-390@vm.marist.edu
Subject: Regina listserv

We have a Rexx (Regina) requirement. Is there a Regina listserv? I haven't been 
able to find one. 

Bobby Bauer
Center for Information Technology
National Institutes of Health
Bethesda, MD 20892-5628
301-594-7474

 

--
For LINUX-390 subscribe / signoff / archive access instructions, send email to 
lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Regina listserv

[Damian Gallagher]

http://regina-rexx.sourceforge.net/index.html

Support
A mailing list exists for the announcement and discussion of Regina related 
matters. To subscribe to this mailing list, send an email message to the list 
server with the first line of the body of the message containing:
subscribe regina-l

With Regina on SourceForge, support resources for Regina. such as mailing 
lists, discussion forums, bug reporting and feature requests are available.
=
Cheers
Damian

-Original Message-
From: Bauer, Bobby (NIH/CIT) [E] [mailto:baue...@mail.nih.gov] 
Sent: 18 July 2013 13:51
To: LINUX-390@vm.marist.edu
Subject: Regina listserv

We have a Rexx (Regina) requirement. Is there a Regina listserv? I haven't been 
able to find one. 

Bobby Bauer
Center for Information Technology
National Institutes of Health
Bethesda, MD 20892-5628
301-594-7474

 

--
For LINUX-390 subscribe / signoff / archive access instructions, send email to 
lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Unable to logon to Linux under VM

[Damian Gallagher]

That's interesting. I'll take a look into this.
Damian

-Original Message-
From: Linux on 390 Port [mailto:linux-...@vm.marist.edu]on Behalf Of
Calvin Fisher
Sent: 23 June 2009 16:37
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Unable to logon to Linux under VM


I ran into this same problem when trying to logon to the VM console.
There is an error in the Oracle install doc.

Last week after my change I was unable to logon the
server on the console directly. I found that in February I was asked to
make this change

Add the following line to the /etc/pam.d/login file:

session required /lib/security/pam_limits.so
session required pamlimit.so

This caused the error that would not let me logon the console directly.
This web page http://www.dawnstar.id.au/.  explains that there is an error
in the Oracle install doc. I removed the line from the /etc/pam.d/login
file and I can now logon the console directly and apply maintenance.

Could that be your problem. You have to ssh into the server to remove the
line.
Calvin Fisher

MVMUA http://www2.marist.edu/~mvmua/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

Re: Oracle Client on SLES 10

[Damian Gallagher]

If you are only running the client, yes. However, you'll find it difficult to 
apply patches anywhere except the original system unless you also clone the 
Oracle inventory information - maybe that's the way you want it.

For the original install problem, I generally recommend you ignore the link 
error and apply the 10.2.0.4 patchset on top, rather than just 6007358.

cheers
Damian

-Original Message-
From: Linux on 390 Port [mailto:linux-...@vm.marist.edu]on Behalf Of
Marcy Cortes
Sent: 07 October 2009 05:05
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle Client on SLES 10


On a related note, anyone know if it is safe to just clone the Oracle binaries? 

Marcy 

"This message may contain confidential and/or privileged information. If you 
are not the addressee or authorized to receive this for the addressee, you must 
not use, copy, disclose, or take any action based on this message or any 
information herein. If you have received this message in error, please advise 
the sender immediately by reply e-mail and delete this message. Thank you for 
your cooperation."


-Original Message-
From: Cortes, Marcy D. 
Sent: Tuesday, October 06, 2009 8:43 PM
To: 'Linux on 390 Port'
Subject: RE: [LINUX-390] Oracle Client on SLES 10

No need, but thanks anyway.  An Oracle DBA here retrieved it for me.
All is well (although this is ugly - I won't be able to command line install 
this thing on the other 21 servers).


Marcy 

"This message may contain confidential and/or privileged information. If you 
are not the addressee or authorized to receive this for the addressee, you must 
not use, copy, disclose, or take any action based on this message or any 
information herein. If you have received this message in error, please advise 
the sender immediately by reply e-mail and delete this message. Thank you for 
your cooperation."

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

Re: Hugepages+oracle 10.0.2.0.4 in sles10SP2

[Damian Gallagher]

I can certainly state that it's most definitely available, as it's running for 
an awful lot of customers :-) I'll chase down that response - contact me off 
list with the precise details, please.

I'm currently investigating the status of this - the last time the docs were 
updated support for hugepages wasn't in the kernel - now that it is I'll get 
this revised.
Back soon
Damian


-Original Message-
From: Linux on 390 Port [mailto:linux-...@vm.marist.edu]on Behalf Of Szefler 
Jakub - Hurt TP
Sent: 27 November 2009 10:34
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Hugepages+oracle 10.0.2.0.4 in sles10SP2


Hi,

I have official answer from oracle that oracle database not available for
zlinux :(. 


Jakub Szefler
Administrator Mainframe

Pion Operacji IT Grupy TP/Departament Infrastruktury
Wydział Infrastruktury Informatycznej
Dział Platform Serwerowych i Pamięci Masowych

ul. Goplańska 25, 91-463 Łódź
tel.0 42 655 32 29
fax.0 42 655 42 22
Telekomunikacja Polska <>
Telekomunikacja Polska Spółka Akcyjna z siedzibą i adresem w Warszawie
(00-105) przy ulicy Twardej 18, 
wpisana do Rejestru Przedsiębiorców prowadzonego przez Sąd Rejonowy dla
m.st.Warszawy 
XII Wydział Gospodarczy Krajowego Rejestru Sądowego pod numerem 010681; 
REGON 012100784, NIP 526-02-50-995; 
z pokrytym w całości kapitałem zakładowym wynoszącym 4 106 319 723 zł
__
Treść tej wiadomości zawiera informacje przeznaczone tylko dla adresata.
Jeżeli nie jesteście Państwo jej adresatem, bądź otrzymaliście ją przez
pomyłkę, prosimy o powiadomienie o tym nadawcy oraz trwałe jej usunięcie.


-Original Message-
From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of Gerald
Schaefer
Sent: Tuesday, November 17, 2009 2:54 PM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Hugepages+oracle 10.0.2.0.4 in sles10SP2

Hi,

I am not aware of any specific studies, but the page table sharing benefit
was explained in some detail in a z/Journal article: 
http://zjournal.tcipubs.com/issues/zJ.DEC-JAN09.pdf
(p. 24, Linux on System z Kernel News)

Mit freundlichem Gruß / Kind regards,

Gerald Schäfer

Linux on System z Development
IBM Systems &Technology Group, Systems Software Development / SW Linux für
zSeries Entwicklung

---
IBM Deutschland
Schoenaicher Str. 220
71032 Boeblingen
Phone: +49-7031-16-2275
Fax: +49-7031-16-3456
E-Mail: geral...@de.ibm.com

---
IBM Deutschland Research & Development GmbH / Vorsitzender des
Aufsichtsrats: Martin Jetter
Geschäftsführung: Dirk Wittkopp
Sitz der Gesellschaft: Böblingen / Registergericht: Amtsgericht Stuttgart,
HRB 243294


Linux on 390 Port  wrote on 11/17/2009 02:41:52
PM:

> From:
> 
> Richard Gasiorowski 
> 
> To:
> 
> LINUX-390@VM.MARIST.EDU
> 
> Date:
> 
> 11/17/2009 02:42 PM
> 
> Subject:
> 
> Re: Hugepages+oracle 10.0.2.0.4 in sles10SP2
> 
> Gerald,
> 
> Good stuff - has IBM published any studies or can you provide? 
> 
> 
> Richard (Gaz) Gasiorowski
> Global System z Linux Virutalization and Mainframce Services Product 
> Manager Americas RPE Portfolio Platform Services CSC 3170 Fairview 
> Park Dr., Falls Church, VA 22042
> 845-889-8533|Work|845-392-7889 Cell|rgasi...@csc.com|www.csc.com
> 
> 
> 
> 
> This is a PRIVATE message. If you are not the intended recipient, please 

> delete without copying and kindly advise us by e-mail of the mistake in 
> delivery. 
> NOTE: Regardless of content, this e-mail shall not operate to bind CSC 
to 
> any order or other contract unless pursuant to explicit written 
agreement 
> or government initiative expressly permitting the use of e-mail for such 

> purpose.
> 
> 
> 
> From:
> Gerald Schaefer 
> To:
> LINUX-390@VM.MARIST.EDU
> Date:
> 11/17/2009 08:36 AM
> Subject:
> Re: Hugepages+oracle 10.0.2.0.4 in sles10SP2
> 
> 
> 
> Hi,
> 
> you should see a large benefit in page table memory consumption with 
> applications
> that use lots of processes on shared (hugepage) memory mappings. IIRC, 
> Oracle
> should also benefit from this.
> 
> You will save 2 MB of page table memory per 1 GB of shared memory 
mapping, 
> 
> per
> process. This will scale with the size of the memory mapping and the 
> number of
> processes, up to the point that you can save more memory used for page 
> tables
> than you were actually sharing between the processes. For example, with 
> 1000
> processes sharing 1 GB of (hugepage) memory, you will save 2 GB of 
memory 
> that
> would otherwise be used for page tables w/o hugepages.
> 
> Mit freundlichem Gruß / Kind regards,
> 
> Gerald Schäfer
> 
> Linux on System z Development
> IBM Systems &Technology Group, Systems Software Development / SW Linux 
für 
> 
> zSeries Entwicklung
> 

Re: Oracle on s390x, patches release same time as x86 ?

[Damian Gallagher]

Lets clarify a little.
Individual patches (for a specific bug), if not already available, are released 
according to the severity and technical/business justification of the customer 
issue - so that's an ad-hoc process. 

We now collect important patches together into a Patch Set Update, released 
quarterly. This also includes the  Critical Patch Update, which on s390x we 
don't release separately after examination of customer downloads. The PSU are 
available on s390x pretty much simultaneously with all other platforms - they 
may be a day or 2 out, but we aim for simultaneous release - the January 2010 
is due any day now.

Patchsets do have delay, depending on the complexity of the underlying changes. 
With the introduction of the PSU, this is far less critical than it used to be, 
as the quarterly PSU takes care of issues related to stability.

Cheers
Damian

-Original Message-
From: Agblad Tore [mailto:tore.agb...@volvo.com] 
Sent: 15 January 2010 09:08
To: LINUX-390@vm.marist.edu
Subject: Oracle on s390x, patches release same time as x86 ?

I have heard s390x is not tier 1 platform so patches is released later than for 
tier 1 (x86?)
Someone knows how this works ?
If a timedelay, how long time ??

I'm waiting for a response from Oracle as well.

Cordialement / Vriendelijke Groeten / Best Regards / Med Vänliga Hälsningar
  Tore Agblad

   Volvo Information Technology
   Infrastructure Mainframe Design & Development
   SE-405 08, Gothenburg  Sweden
   E-mail: tore.agb...@volvo.com

   http://www.volvo.com/volvoit/global/en-gb/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

Re: A Question on Sizing z/VM Linux Guests

[Damian Gallagher]

Berry,

I'd be interested in seeing a 60 minute statspack or AWR/ADDM from one of these 
instances at peak hour - we generally recommend direct and asynch IO, which 
bypasses the cache. The reports will tell you what Oracle thinks it needs based 
on throughput, which you can compare to what z/VM and Linux is using. Contact 
me off list in the first place, as attachments don't survive well.

Cheers
Damian 

-Original Message-
From: van Sleeuwen, Berry [mailto:berry.vansleeu...@atosorigin.com] 
Sent: 04 February 2010 14:32
To: LINUX-390@vm.marist.edu
Subject: Re: A Question on Sizing z/VM Linux Guests

We have some oracle guests that have been set to 1G. And they actually need 
only 300M. The rest is occupied in cache (between 650 and 710M).
I'd like to decrease the machines but it is quite hard to convince the oracle 
group that the machines do not need the memory. Instead, they even want to 
increase to 2G because the books tell them to. While the documents suggest the 
oracle will benefit from the increased memory, in reality VM will page more and 
the effect is an overall decrease in performance for all guests.

I would suggest to keep the guest as small as possible. Also try to limit SGA 
and such.

Berry. 

-Original Message-
From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of
RPN01
Sent: donderdag 4 februari 2010 14:17
To: LINUX-390@VM.MARIST.EDU
Subject: Re: A Question on Sizing z/VM Linux Guests

If you're using IBM style DASD as your disk storage, you'll want to size the 
linux image's memory considerably smaller than what is suggested for an Intel 
processor.

The first reason is that you have several levels of cache before the data even 
gets to the linux image. These layers (controller, z/VM,
mdcache) will cut the time to retrieve the data, and caching it in linux as 
well really won't make anything any faster.

The second reason is that larger images cause more paging on z/VM's part.
The Intel memory suggestion is based on real memory, always available.
Since this is virtual memory, your "in-memory cache" may actually be on disk 
anyway, causing a paging read when it is needed. You can actually slow down the 
response in an image by making its memory larger, because it will spend much 
more time paging.

Finding the right size is a little more tricky. You want to start at some 
reasonable value (1G, 2G...), and then cut the image's memory over time until 
you notice it just begin to swap. Some people will allow it to do this minimal 
swapping, while others will increase the image size enough so that it doesn't 
swap at all. It just depends on which expert you choose to listen to.

At this point, you'll have an image that supports the application running, but 
doesn't have enough memory to devote a large amount to caching its disk, which 
is exactly where you want to be. You may actually be surprised at how little 
memory this really is.

--
Robert P. Nix  Mayo Foundation.~.
RO-OE-5-55 200 First Street SW/V\
507-284-0844   Rochester, MN 55905   /( )\
-^^-^^
"In theory, theory and practice are the same, but  in practice, theory and 
practice are different."



On 2/4/10 7:00 AM, "Carson, Brad"  wrote:

> We have a project that is being setup to run on RHEL under z/VM.  The 
> sizing parameters for the guests (Oracle DB, and WebLogic) are being 
> sent to us based on intel platform sizing.  How do some of you handle 
> the sizing conversion from Intel to IFL's?  Are there some rules of
thumb, we should know about?
>
> Our environment:
>
> IBM z10-BC (QA and Dev) and z10-EC (Prod) running z/VM 5.4 and RHEL
5.3.
>
>
> Thanks for any insight.
>
> /Brad (please ignore the company inserted HIPAA disclaimer)
>
> - This e-mail and any 
> attachments may contain CONFIDENTIAL information, including PROTECTED 
> HEALTH INFORMATION. If you are not the intended recipient, any use or 
> disclosure of this information is STRICTLY PROHIBITED; you are 
> requested to delete this e-mail and any attachments, notify the sender

> immediately, and notify the LabCorp Privacy Officer at
privacyoffi...@labcorp.com or call (877) 23-HIPAA.
>
> --
> For LINUX-390 subscribe / signoff / archive access instructions, send 
> email to lists...@vm.marist.edu with the message: INFO LINUX-390 or 
> visit http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions, send email to 
lists...@vm.marist.edu with the message: INFO LINUX-390 or visit 
http://www.marist.edu/htbin/wlvindex?LINUX-390


--
For LINUX-390 subscribe / signoff / archive access instructions, send email to 
lists...@vm.marist.edu with the message: INFO LIN

Re: A Question on Sizing z/VM Linux Guests

[Damian Gallagher]

Yep - I'd be interested to know which books if they are Oracle publications.

-Original Message-
From: Ron Wells [mailto:rwe...@agfinance.com] 
Sent: 04 February 2010 15:02
To: LINUX-390@vm.marist.edu
Subject: Re: A Question on Sizing z/VM Linux Guests

sounds familiar >> the book tells them to..




From:
"van Sleeuwen, Berry" 
To:
LINUX-390@VM.MARIST.EDU
Date:
02/04/2010 08:32 AM
Subject:
Re: A Question on Sizing z/VM Linux Guests
Sent by:
Linux on 390 Port 



We have some oracle guests that have been set to 1G. And they actually
need only 300M. The rest is occupied in cache (between 650 and 710M).
I'd like to decrease the machines but it is quite hard to convince the
oracle group that the machines do not need the memory. Instead, they
even want to increase to 2G because the books tell them to. While the
documents suggest the oracle will benefit from the increased memory, in
reality VM will page more and the effect is an overall decrease in
performance for all guests.

I would suggest to keep the guest as small as possible. Also try to
limit SGA and such.

Berry.

-Original Message-
From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of
RPN01
Sent: donderdag 4 februari 2010 14:17
To: LINUX-390@VM.MARIST.EDU
Subject: Re: A Question on Sizing z/VM Linux Guests

If you're using IBM style DASD as your disk storage, you'll want to size
the linux image's memory considerably smaller than what is suggested for
an Intel processor.

The first reason is that you have several levels of cache before the
data even gets to the linux image. These layers (controller, z/VM,
mdcache) will cut the time to retrieve the data, and caching it in linux
as well really won't make anything any faster.

The second reason is that larger images cause more paging on z/VM's
part.
The Intel memory suggestion is based on real memory, always available.
Since this is virtual memory, your "in-memory cache" may actually be on
disk anyway, causing a paging read when it is needed. You can actually
slow down the response in an image by making its memory larger, because
it will spend much more time paging.

Finding the right size is a little more tricky. You want to start at
some reasonable value (1G, 2G...), and then cut the image's memory over
time until you notice it just begin to swap. Some people will allow it
to do this minimal swapping, while others will increase the image size
enough so that it doesn't swap at all. It just depends on which expert
you choose to listen to.

At this point, you'll have an image that supports the application
running, but doesn't have enough memory to devote a large amount to
caching its disk, which is exactly where you want to be. You may
actually be surprised at how little memory this really is.

--
Robert P. Nix  Mayo Foundation.~.
RO-OE-5-55 200 First Street SW/V\
507-284-0844   Rochester, MN 55905   /( )\
-^^-^^
"In theory, theory and practice are the same, but  in practice, theory
and practice are different."



On 2/4/10 7:00 AM, "Carson, Brad"  wrote:

> We have a project that is being setup to run on RHEL under z/VM.  The
> sizing parameters for the guests (Oracle DB, and WebLogic) are being
> sent to us based on intel platform sizing.  How do some of you handle
> the sizing conversion from Intel to IFL's?  Are there some rules of
thumb, we should know about?
>
> Our environment:
>
> IBM z10-BC (QA and Dev) and z10-EC (Prod) running z/VM 5.4 and RHEL
5.3.
>
>
> Thanks for any insight.
>
> /Brad (please ignore the company inserted HIPAA disclaimer)
>
> - This e-mail and any
> attachments may contain CONFIDENTIAL information, including PROTECTED
> HEALTH INFORMATION. If you are not the intended recipient, any use or
> disclosure of this information is STRICTLY PROHIBITED; you are
> requested to delete this e-mail and any attachments, notify the sender

> immediately, and notify the LabCorp Privacy Officer at
privacyoffi...@labcorp.com or call (877) 23-HIPAA.
>
> --
> For LINUX-390 subscribe / signoff / archive access instructions, send
> email to lists...@vm.marist.edu with the message: INFO LINUX-390 or
> visit http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions, send
email to lists...@vm.marist.edu with the message: INFO LINUX-390 or
visit http://www.marist.edu/htbin/wlvindex?LINUX-390


--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or
visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
[attachment "disclaimer.txt" deleted by Ron Wells/AGFS/AGFin]

Re: Oracle 10.2.0 Install

[Damian Gallagher]

Those of you attending the Oracle on zSeries Special Interest Group at 
Collaborate10 ( www.zseriesoraclesig.org ) next week will hear more about the 
installation prereqs issue, and a 'solution' during one of my presentations. 
There'll be a My Oracle Support article after that.

For Suse Linux Enterprise 10, we have only certified the 10.2.0.4 patchset, so 
certainly you should apply that immediately, and I also recommend the latest 
Patch Set Update - April 2010 is now available.

Cheers
Damian
 

-Original Message-
From: Ray Waters [mailto:ray.wat...@opensolutions.com] 
Sent: 14 April 2010 19:33
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle 10.2.0 Install

Thanks!

-Original Message-
From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of Rogério 
Soares
Sent: Wednesday, April 14, 2010 12:46 PM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 10.2.0 Install

Ray, you can check also the redpaper 4465( Installing Oracle 10gR2 on Red
Hat®
Enterprise Linux on IBM System z)

on Suse linux, also have a yast package named: "orarun" that turn easy
install oracle, check it too.



if you wish i send it to you...

you will need some patchs from oracle before start installation too.. this
patch is also describe on this paper.


On Wed, Apr 14, 2010 at 12:11 PM, Ray Waters
wrote:

> Thanks will do,
>
> I was following the recommendations of the Release notes:
>
> 4.2 Oracle Universal Installer Operating System Prerequisite Checks
> If you are installing Oracle Database 10g on SUSE Linux Enterprise Server
> 10,
> then the current version of Oracle Universal Installer does not recognized
> these
> operating systems as supported operating systems and does not perform the
> installation.
> Workaround #1 (recommended): Run the Oracle Universal Installer using the
> ignoreSysPrereqs flag which causes the installer to skip the operating
> system
> check and continue with the installation:
> ./runinstaller -ignoreSysPrereqs
> As a side effect, the installer also skips other checks during the
> installation.
>
> Ray Waters
>
> -Original Message-
> From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of
> Mauro Souza
> Sent: Wednesday, April 14, 2010 10:05 AM
> To: LINUX-390@VM.MARIST.EDU
> Subject: Re: Oracle 10.2.0 Install
>
> Hi Ray!
>
> If you follow the Oracle Installation Manual, you will see a lot of
> pre-reqs
> (libgcc, libaio, motif, and so...). One of the prereqs is gcc, which will
> provide cc to you.
> You should install it without -ignoreSysPrereqs to see if there's missing
> libs, wrong parameters, and so. After solving whatever the installer
> complais about, run without checking prereqs to install it.
>
> Mauro
> http://mauro.limeiratem.com - registered Linux User: 294521
> Scripture is both history, and a love letter from God.
>
>
> On Wed, Apr 14, 2010 at 11:59 AM, Ray Waters
> wrote:
>
> > Listers,
> >
> > I am running  SUSE Linux Enterprise Server 10 SP2 (s390x) under z/VM 540
> > and am trying to install Oracle 10.2.0 Database.
> > uname -r
> > 2.6.16.60-0.21-default
> >
> > Since it should run under version 10, but the manual states the install
> > process only supports  up to version 9, I have to  ignore the prereqs:
> >
> > ./runInstaller -ignoreSysPrereqs
> >
> >
> > I get about 65% complete during the actual install and then I get an
> error.
> > I looked in the logs and it is complaining about a cc command.
> >
> > INFO: Start output from spawned process:
> > INFO: --
> > INFO:
> >
> > INFO: rm -f nnfgt.*
> >
> > INFO: (if [ "compile" = "compile" ] ; then \
> >  /home/oracle/oracle/product/10.2.0/db_1/bin/gennfgt > nnfgt.c ;\
> >  cc  -c nnfgt.c ;\
> >  rm -f /home/oracle/oracle/product/10.2.0/db_1/lib/nnfgt.o ;\
> >  mv nnfgt.o /home/oracle/oracle/product/10.2.0/db_1/lib/ ;\
> >  cc -m31 -c nnfgt.c ;\
> >  rm -f /home/oracle/oracle/product/10.2.0/db_1/lib32/nnfgt.o ;\
> >  mv nnfgt.o /home/oracle/oracle/product/10.2.0/db_1/lib32 ;\
> >  /usr/bin/ar rv
> > /home/oracle/oracle/product/10.2.0/db_1/lib32/libn10.a
> > /home/oracle/oracle/product/10.
> > INFO: 2.0/db_1/lib32/nnfgt.o ;\
> >
> > INFO:   /usr/bin/ar rv
> > /home/oracle/oracle/product/10.2.0/db_1/lib/libn10.a
> > /home/oracle/oracle/product/10.2.0/db_1/lib/nnfgt.o ; fi)
> >
> > INFO: /bin/sh: cc: command not found
> >
> > INFO: mv: cannot stat `nnfgt.o'
> > INFO: : No such file or directory
> >
> > INFO: /bin/sh: cc: command not found
> >
> >
> >
> > How do I get this "cc" command?
> >
> > Ray Waters
> > Senior Technical Support Analyst
> > Open Solutions Inc.
> > 3900 Essex Lane, Suite 400
> > Houston, TX  77027-5100
> >
> > Office 713-965-8451
> > Cell713-705-5403
> > Email ray.wat...@opensolutions.com
> >
> > www.bank.opensolutions.com
> > www.opensolutions.com
> >
>  > www.opensolutions.com>
> >
> > 
> > NOTICE:
> > This e-mail i

Re: Oracle 10.2.0 Install

[Damian Gallagher]

Announced yesterday at the SIG:

Now available for s390x  - Red Hat 5 and SLES 10 - an RPM to check that 
software prerequisites are met before Oracle software is installed. It doesn't 
contain or install any executable of itself, but the rpm install process will 
perform updates to software components if required, or install missing rpms, 
depending on the options chosen. We'll be maintaining this as the OS components 
change. Please refer to Note 1086769.1 for full details, and send me any 
feedback or problems.

Regards
Damian

-Original Message-----
From: Damian Gallagher 
Sent: 15 April 2010 00:14
To: Linux on 390 Port
Subject: RE: Oracle 10.2.0 Install

Those of you attending the Oracle on zSeries Special Interest Group at 
Collaborate10 ( www.zseriesoraclesig.org ) next week will hear more about the 
installation prereqs issue, and a 'solution' during one of my presentations. 
There'll be a My Oracle Support article after that.

For Suse Linux Enterprise 10, we have only certified the 10.2.0.4 patchset, so 
certainly you should apply that immediately, and I also recommend the latest 
Patch Set Update - April 2010 is now available.

Cheers
Damian
 

-Original Message-
From: Ray Waters [mailto:ray.wat...@opensolutions.com] 
Sent: 14 April 2010 19:33
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle 10.2.0 Install

Thanks!

-Original Message-
From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of Rogério 
Soares
Sent: Wednesday, April 14, 2010 12:46 PM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 10.2.0 Install

Ray, you can check also the redpaper 4465( Installing Oracle 10gR2 on Red
Hat®
Enterprise Linux on IBM System z)

on Suse linux, also have a yast package named: "orarun" that turn easy
install oracle, check it too.



if you wish i send it to you...

you will need some patchs from oracle before start installation too.. this
patch is also describe on this paper.


On Wed, Apr 14, 2010 at 12:11 PM, Ray Waters
wrote:

> Thanks will do,
>
> I was following the recommendations of the Release notes:
>
> 4.2 Oracle Universal Installer Operating System Prerequisite Checks
> If you are installing Oracle Database 10g on SUSE Linux Enterprise Server
> 10,
> then the current version of Oracle Universal Installer does not recognized
> these
> operating systems as supported operating systems and does not perform the
> installation.
> Workaround #1 (recommended): Run the Oracle Universal Installer using the
> ignoreSysPrereqs flag which causes the installer to skip the operating
> system
> check and continue with the installation:
> ./runinstaller -ignoreSysPrereqs
> As a side effect, the installer also skips other checks during the
> installation.
>
> Ray Waters
>
> -Original Message-
> From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of
> Mauro Souza
> Sent: Wednesday, April 14, 2010 10:05 AM
> To: LINUX-390@VM.MARIST.EDU
> Subject: Re: Oracle 10.2.0 Install
>
> Hi Ray!
>
> If you follow the Oracle Installation Manual, you will see a lot of
> pre-reqs
> (libgcc, libaio, motif, and so...). One of the prereqs is gcc, which will
> provide cc to you.
> You should install it without -ignoreSysPrereqs to see if there's missing
> libs, wrong parameters, and so. After solving whatever the installer
> complais about, run without checking prereqs to install it.
>
> Mauro
> http://mauro.limeiratem.com - registered Linux User: 294521
> Scripture is both history, and a love letter from God.
>
>
> On Wed, Apr 14, 2010 at 11:59 AM, Ray Waters
> wrote:
>
> > Listers,
> >
> > I am running  SUSE Linux Enterprise Server 10 SP2 (s390x) under z/VM 540
> > and am trying to install Oracle 10.2.0 Database.
> > uname -r
> > 2.6.16.60-0.21-default
> >
> > Since it should run under version 10, but the manual states the install
> > process only supports  up to version 9, I have to  ignore the prereqs:
> >
> > ./runInstaller -ignoreSysPrereqs
> >
> >
> > I get about 65% complete during the actual install and then I get an
> error.
> > I looked in the logs and it is complaining about a cc command.
> >
> > INFO: Start output from spawned process:
> > INFO: --
> > INFO:
> >
> > INFO: rm -f nnfgt.*
> >
> > INFO: (if [ "compile" = "compile" ] ; then \
> >  /home/oracle/oracle/product/10.2.0/db_1/bin/gennfgt > nnfgt.c ;\
> >  cc  -c nnfgt.c ;\
> >  rm -f /home/oracle/oracle/product/10.2.0/db_1/lib/nnfgt.o ;\
> >  mv nnfgt.o /home/oracle/oracle/product/10.2.0/db_1/lib/ ;\
> >  cc -m31 -c nnfgt.c ;\
> >  rm -f /home/oracle/oracle/product/10.2.0/db_1/lib32/nnfgt.o ;\
&g

Re: Oracle 10.2.0 Install

[Damian Gallagher]

Thanks Rob. Basically I have started by going for the 80-20 rule - as is this 
should eliminate most of the installation prereq issues I see here. Getting it 
into the Oracle installer is a little more difficult. We'll still be 
maintaining the notes which document the required packages - this rpm is a 
physical manifestation of them, and also acts as a 'truth test' for the notes.

Cheers
Damian   

-Original Message-
From: Rob van der Heij [mailto:rvdh...@gmail.com] 
Sent: 23 April 2010 08:44
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle 10.2.0 Install

On Fri, Apr 23, 2010 at 9:22 AM, Damian Gallagher
 wrote:
> Announced yesterday at the SIG:
>
> Now available for s390x  - Red Hat 5 and SLES 10 - an RPM to check that 
> software prerequisites are met before Oracle software is installed. It 
> doesn't contain or install any executable of itself, but the rpm install 
> process will perform updates to software components if required, or install 
> missing rpms, depending on the options chosen. We'll be maintaining this as 
> the OS components change. Please refer to Note 1086769.1 for full details, 
> and send me any feedback or problems.

Cute idea! Will certainly avoid some of the problems mentioned when
the dependency checks are there. It will also warn the customer when
he's about to remove or change required packages. All that the
installer (and maybe the startup routine) has to do is check for the
"oracle-prereqs" package to be installed.

You probably also need to document the actual packages that provide
those components, since the RPM messages give little help there. At
least with YaST such intelligence is hidden in some proprietary
catalog that will walk the chain of requirements. I understand Novell
also has a build service where they take your "oracle-prereqs" package
and integrate it with the product (so YaST can find all the required
packages). That would let the customer also install it (plus
dependencies) from YaST in one go.

I could also see some elegance in shipping a bootstrap for the
installation program or startup scripts with it. That has the
advantage that RPM identifies the pieces of the application that were
planted at various places in the file system (outside the
/opt/whatever directories). But you probably considered that already.
Some products actually invoke the installer from the post-install
script, but that is rather annoying (and beyond what the scripts are
allowed to do).

Rob

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

Re: Oracle 10.2.0 Install

[Damian Gallagher]

Oracle isn't an rpm install, and as such has little dependency checking inbuilt 
- it has relied on manual verification. This new package purely implements the 
dependencies, removing the manual work. There is no direct relationship between 
the Oracle installer and this package.

Cheers
Damian

-Original Message-
From: David Boyes [mailto:dbo...@sinenomine.net] 
Sent: 23 April 2010 16:07
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle 10.2.0 Install

> Now available for s390x  - Red Hat 5 and SLES 10 - an RPM to check that
> software prerequisites are met before Oracle software is installed. It
> doesn't contain or install any executable of itself, but the rpm
> install process will perform updates to software components if
> required, or install missing rpms, depending on the options chosen.
> We'll be maintaining this as the OS components change. Please refer to
> Note 1086769.1 for full details, and send me any feedback or problems.

So to get this straight: 

You're going to make the Oracle RPM install depend on this package, and you're 
going to correctly maintain the dependencies for the Oracle installation as 
dependencies of this magic placeholder package. Right? 

If so, cool. If not, seems like fixing the dependencies of the original Oracle 
package would be just as effective. 

-- db

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

Re: Oracle 10.2.0 Install

[Damian Gallagher]

Thanks Mauro, that's it. You've expressed the concept far more clearly than I 
did, obviously :-)

Cheers
Damian

-Original Message-
From: Mauro Souza [mailto:thoriu...@gmail.com] 
Sent: 23 April 2010 17:00
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle 10.2.0 Install

David,

I think the idea here is provide an "fake" rpm which depends on the same
dependencies as Oracle DB do. So, installing this
"oracledeps-fake-virtual-10.2.0.2.rpm" will install the dependencies, and
you will be able to install Oracle without having to check manually gcc,
libgcc, openmotif, libaio, etc...

And this is a good idea.

Mauro
http://mauro.limeiratem.com - registered Linux User: 294521
Scripture is both history, and a love letter from God.


On Fri, Apr 23, 2010 at 12:29 PM, David Boyes  wrote:

> > Oracle isn't an rpm install, and as such has little dependency checking
> > inbuilt - it has relied on manual verification. This new package purely
> > implements the dependencies, removing the manual work. There is no
> > direct relationship between the Oracle installer and this package.
>
> Mmf. Not so useful, then. I can see why you do it that way given the number
> of platforms you need to have this thing install on, but I'd really like to
> see you fix that. If there is a package management system on the platform,
> it'd be to your advantage to use it.
>
> Not something you or I can fix easily, but it'd be a really desirable thing
> for you guys to have as a requirement.
>
> -- db
>
> --
> For LINUX-390 subscribe / signoff / archive access instructions,
> send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or
> visit
> http://www.marist.edu/htbin/wlvindex?LINUX-390
>

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

Re: Oracle 10.2.0 Install

[Damian Gallagher]

Ray,

Please refer to Note 1086769.1 on My Oracle Support for full details (and the 
RPM), and send me any feedback or problems (offlist, ideally, as I don't want 
to clutter peoples inboxes :-) )

Cheers
Damian

-Original Message-
From: Ray Waters [mailto:ray.wat...@opensolutions.com] 
Sent: 23 April 2010 17:48
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle 10.2.0 Install

Now if I could just find this dependency RPM!

Ray

-Original Message-
From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of Damian 
Gallagher
Sent: Friday, April 23, 2010 11:34 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 10.2.0 Install

Thanks Mauro, that's it. You've expressed the concept far more clearly than I 
did, obviously :-)

Cheers
Damian

-Original Message-
From: Mauro Souza [mailto:thoriu...@gmail.com]
Sent: 23 April 2010 17:00
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle 10.2.0 Install

David,

I think the idea here is provide an "fake" rpm which depends on the same
dependencies as Oracle DB do. So, installing this
"oracledeps-fake-virtual-10.2.0.2.rpm" will install the dependencies, and
you will be able to install Oracle without having to check manually gcc,
libgcc, openmotif, libaio, etc...

And this is a good idea.

Mauro
http://mauro.limeiratem.com - registered Linux User: 294521
Scripture is both history, and a love letter from God.


On Fri, Apr 23, 2010 at 12:29 PM, David Boyes  wrote:

> > Oracle isn't an rpm install, and as such has little dependency checking
> > inbuilt - it has relied on manual verification. This new package purely
> > implements the dependencies, removing the manual work. There is no
> > direct relationship between the Oracle installer and this package.
>
> Mmf. Not so useful, then. I can see why you do it that way given the number
> of platforms you need to have this thing install on, but I'd really like to
> see you fix that. If there is a package management system on the platform,
> it'd be to your advantage to use it.
>
> Not something you or I can fix easily, but it'd be a really desirable thing
> for you guys to have as a requirement.
>
> -- db
>
> --
> For LINUX-390 subscribe / signoff / archive access instructions,
> send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or
> visit
> http://www.marist.edu/htbin/wlvindex?LINUX-390
>

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

NOTICE:
This e-mail is intended solely for the use of the individual to whom it is 
addressed and may contain information that is privileged, confidential or 
otherwise exempt from disclosure. If the reader of this e-mail is not the 
intended recipient or the employee or agent responsible for delivering the 
message to the intended recipient, you are hereby notified that any 
dissemination, distribution, or copying of this communication is strictly 
prohibited. If you have received this communication in error, please 
immediately notify us by replying to the original message at the listed email 
address. Thank You.

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

Re: Announcing Red Hat Enterprise Linux 6 beta

[Damian Gallagher]

As I am a little. I don't have specific dates (purely because I don't record 
them), but I have information that I haven't yet discarded about certification, 
let alone support, going back 12 months+ - Rodger is only one of many customers 
who've been working for some time on this distribution. 

If you have specific information where you were told it wasn't available in 
that timescale, please let me have that, and I'll try to find out what's up.

Cheers
Damian 

-Original Message-
From: Rodger Donaldson [mailto:rodg...@diaspora.gen.nz] 
Sent: 23 April 2010 22:30
To: LINUX-390@vm.marist.edu
Subject: Re: Announcing Red Hat Enterprise Linux 6 beta

On Fri, Apr 23, 2010 at 05:11:39PM -0400, CHAPLIN, JAMES (CTR) wrote:
> The big question will be after RHEL 6 goes GA, how long will it take
> Oracle to catch up and certify their DB on this platform for the z390x
> Architecture? It took to this year, that we are able to move our Oracle
> DBs to RHEL 5 servers.

This surprises me - Oracle have told us we're supported with Oracle 10
on RHEL 5 since we started building two years ago.

--
Rodger Donaldsonrodg...@diaspora.gen.nz

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

Re: The Linux on System z Toolchain in a Nutshell

[Damian Gallagher]

Did you register again for this later event and get the new URL - the one from 
the first event today is not the same

-Original Message-
From: Frank M. Ramaekers [mailto:framaek...@ailife.com] 
Sent: 04 May 2010 19:41
To: LINUX-390@vm.marist.edu
Subject: Re: The Linux on System z Toolchain in a Nutshell

Nope, still can't (either with IE or Firefox).

 
Frank M. Ramaekers Jr.
 
 

-Original Message-
From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of Billy 
Bingham
Sent: Tuesday, May 04, 2010 1:27 PM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: The Linux on System z Toolchain in a Nutshell

I was getting that and then I got all the way out of I.E. and got back in again 
and I got to the
meeting.


Billy

On 4 May 2010 at 13:23, Frank M. Ramaekers wrote:

> Still can't get in:
>
> The meeting has not yet stated.  You will be able to access the meeting once 
> the host arrives.  Please wait.
>
>
> Frank M. Ramaekers Jr.
>
>
> -Original Message-
> From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of Billy 
> Bingham
> Sent: Tuesday, May 04, 2010 8:28 AM
> To: LINUX-390@VM.MARIST.EDU
> Subject: Re: The Linux on System z Toolchain in a Nutshell
>
> I got the following email from the event coordinator:
>
>
> From: Darla Erdmann [mailto:darlaerdm...@us.ibm.com]
> Sent: Tue 5/4/2010 8:17 AM
> Cc: Julie Liesenfelt; Dick Kendrick
> Subject: TODAY'S EVENT IS CANCELED DUE TO ADOBE TECHNICAL DIFFUCULTIES
>
>
> Hi Everyone - Today's The Linux on System z Toolchain in a Nutshell has been 
> canceled due
> to technical difficulties.
>
> I apologize for any inconvenience this may have caused. Please contact Julie 
> Liesenfelt with
> any concerns
> (jul...@us.ibm.com).
>
> There is another event scheduled later today : ADOBE EVENT: The Linux on 
> System z
> Toolchain in a Nutshell
> Date: May 4, 2010
> Time: 2:00 pm ET / 1:00 pm CT / 18:00:00 UTC
> Duration: 1 HR
>
> Abstract: The System z tools package is the essential tool chain for Linux on 
> System z. It
> contains everything from the bootloader to dump related tools. This 1-hour 
> presentation will
> outline the major tools of this package and present them in a nutshell; 
> including the primary
> use cases; hints and real world examples providing a quick; authoritative 
> solutions to daily
> system administration challenges. Furthermore the latest additions and 
> extensions will be
> presented.
>
> URL:
> To register for this event, please go the following link:
> http://ibmstg.na3.acrobat.com/linuxsyszpme/event/registration.html
>
>
>
>
>
>
> The presentation can be found here:
> http://www.vm.ibm.com/education/lvc/lvc0504c.pdfjul...@us.ibm.com
>
>
>
>
>
> Thank you!
> **
> Darla (Erdmann) Schleusner
> Education Delivery Support - Project Manager
> STG Support Team
> Bldg 004-2/J101
> TL 553-0379 Outside 1-507-253-0379
>
> *LIFE IS 90/10 - 90% IS HOW YOU TAKE IT AND 10% IS WHAT YOU MAKE IT.*
>
>
> On 4 May 2010 at 15:09, Rob van der Heij wrote:
>
> > On Tue, May 4, 2010 at 2:58 PM, Billy Bingham
> >  wrote:
> > > Is anyone able to attend this webinar (?) I have that it starts today at 
> > > 08:00 CDT, but I get the
> > > following:
> > >
> > > This content is not available yet.
> > >
> > >
> > > You are getting this error message because:
> > >
> > >    * You were trying to access a course that is not open.
> > >    * You were trying to access a meeting that has not started.
> > >    * You were trying to access an event that has not started.
> >
> > Trying again briefly after 08:00 CDT, I got a black screen telling it
> > was "on hold" whatever that may mean... I guess that's how Nut's Hell
> > looks :-)
> >
> > Rob
> >
> > --
> > For LINUX-390 subscribe / signoff / archive access instructions,
> > send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or 
> > visit
> > http://www.marist.edu/htbin/wlvindex?LINUX-390
> >
>
>
>
> --
> For LINUX-390 subscribe / signoff / archive access instructions,
> send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
> http://www.marist.edu/htbin/wlvindex?LINUX-390
>
> _
> This message contains information which is privileged and confidential and is 
> solely for the use of the
> intended recipient. If you are not the intended recipient, be aware that any 
> review, disclosure,
> copying, distribution, or use of the contents of this message is strictly 
> prohibited. If you have
> received this in error, please destroy it immediately and notify us at 
> privacy...@ailife.com.
>
> --
> For LINUX-390 subscribe / signoff / archive access instructions,
> send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
> htt

Re: Problem to install red hat 5.3

[Damian Gallagher]

Your boot media is the kernel, initrd etc that you punch and then ipl from. 
These have to match the Red Hat update you are installing - for every update 
you need to load the boot files to VM so you can ipl from the new versions.

Cheers
Damian

-Original Message-
From: Antonio Silva [mailto:carlosantonio...@gmail.com] 
Sent: 22 May 2010 02:33
To: LINUX-390@vm.marist.edu
Subject: Problem to install red hat 5.3

I upload the .iso red hat 5.3 for z in a nfs repository (also a Linux on z).
At the start the installation process, i get the following message
"The Red Hat Enterprise Linux installation tree in that directory does not
seem to match your boot media"


Anyone know what happens.

Thanks.

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

Re: Oracle client problem on SLES 10

[Damian Gallagher]

The libstdc change was introduced with SLES 10 SP3, I believe. As well as that 
manual, I recommend some articles on My Oracle Support:
Ensure you have prerequisite rpms to install Oracle Database 10gR2 and 
AS10g(midtier) on Linux on IBM zSeries (Doc ID 1086769.1) - we're working on an 
SP3 compatible rpm at the moment. Just ignore the error message if you've 
checked the provides. 
And the more generalInstalling Oracle 10gR2 RDBMS on zLinux (s390x) (Doc ID 
782439.1)

For the specific problem, I haven't seen that in ages.  Did you 
install/reinstall the client or just upgrade the OS ? I'm wondering if you had 
silent link failure - you might want to check your install log.

Cheers
Damian

-Original Message-
From: Marcy Cortes [mailto:marcy.d.cor...@wellsfargo.com] 
Sent: 14 December 2010 19:53
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle client problem on SLES 10

That was our first thoughts and we have all the ones listed in here.
http://download.oracle.com/docs/cd/B19306_01/relnotes.102/b25399.pdf

compat-libstdc++ doesn't seem to exist anymore and now is likely covered by 
libstdc++33  - we think.



Marcy Cortes

Operating Systems Engineer, z/VM and Linux on System z
Enterprise Hosting Services, Mainframe/Midrange Services

Wells Fargo Bank | 201 Third Street | San Francisco, CA 94103
MAC A0187-050
Tel 415-477-6343 | Cell 415-517-0895

marcy.d.cor...@wellsfargo.com

This message may contain confidential and/or privileged information. If you are 
not the addressee or authorized to receive this for the addressee, you must not 
use, copy, disclose, or take any action based on this message or any 
information herein. If you have received this message in error, please advise 
the sender immediately by reply e-mail and delete this message. Thank you for 
your cooperation.


-Original Message-
From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of Leland 
Lucius
Sent: Tuesday, December 14, 2010 11:36 AM
To: LINUX-390@vm.marist.edu
Subject: Re: [LINUX-390] Oracle client problem on SLES 10

If the Oracle client loads libraries dynamically, then I'd try to find out
if you're missing any lib* packages that you may have installed on the SLES9
system.  I wonder if you might have some 32bit libs missing...

On Tue, Dec 14, 2010 at 12:12 PM, Marcy Cortes <
marcy.d.cor...@wellsfargo.com> wrote:

> We've been using the Oracle 10gr2 client on SLES 9 to talk to some
> distributed oracle DB server.
>
> We're trying to get it to work on sles 10.  It works except when security
> is enabled.
>
> We are getting
>
> oracle error (#12657), which says:
>
> Cause: The near side of the connection required the use of a
> service (either encryption or checksumming) when no
> algorithms for that service were installed.
>
> Action: Remove the "ON" requirement for that service.
>
>
> The following lines are in the Oracle sqlnet.ora file for our connection to
> the Oracle database, which I believe uses this checksumming & encryption
> settings...
>
> SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT= (MD5)
> SQLNET.CRYPTO_CHECKSUM_CLIENT= requested
> SQLNET.ENCRYPTION_TYPES_CLIENT= (DES, DES40)
> SQLNET.ENCRYPTION_CLIENT= required
>
> Commenting out these lines works, but we need to have them in there.
> Any idea why Oracle is complaining about not having the needed algorithms
> installed?
>
>
> Marcy Cortes
>
>
> This message may contain confidential and/or privileged information. If you
> are not the addressee or authorized to receive this for the addressee, you
> must not use, copy, disclose, or take any action based on this message or
> any information herein. If you have received this message in error, please
> advise the sender immediately by reply e-mail and delete this message. Thank
> you for your cooperation.
>
> --
> For LINUX-390 subscribe / signoff / archive access instructions,
> send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or
> visit
> http://www.marist.edu/htbin/wlvindex?LINUX-390
> --
> For more information on Linux on System z, visit
> http://wiki.linuxvm.org/
>

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, vis

Re: Linux preferences

[Damian Gallagher]

" The Oracle DBA indicates that Oracle is easier to implement under Red Hat" - 
I'm interested in what this means precisely, as we should be pretty similar in 
each environment - we only have the one code set and installer. If there are 
significant differences that people are finding (on Z) then I'm happy to look 
into it.

Cheers
Damian  

-Original Message-
From: Melancon, Ruddy [mailto:melanc...@dot.state.al.us] 
Sent: 21 December 2010 14:46
To: LINUX-390@vm.marist.edu
Subject: Linux preferences

I am getting started in the use of zVM and zLinux.  I have purchased a license 
for SLES and have also installed Red Hat under test for an Oracle database.  
Everything I have installed is currently under test.  We are looking at 
revamping what we have.  I would like to pose a few questions.

There is the prospect of Novell being purchased by Attachmate.  I understand 
that in the past SLES has been more responsive to the x390 platform.

If you were just starting out, would you use Red Hat instead of SLES??

Are there other more pressing reasons to choose one over the other??

The Oracle DBA indicates that Oracle is easier to implement under Red Hat.  How 
hard would it be to manage both distributions??

Ruddy A. Melancon
IT Systems Specialist, Senior
Alabama Department of Transportation
334-353-6323

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Linux preferences

[Damian Gallagher]

The link failure at 10.2.0.2 applies to both distros - we shipped the wrong 
stubs so it can't link cleanly - and the solution is to apply the 10.2.0.3 or 4 
patchset over the top, as the DBA noted, and is addressed in the article: 
Installing Oracle 10gR2 RDBMS on zLinux (s390x) (Doc ID 782439.1)

The manual verification is being addressed by the article and rpm in: Ensure 
you have prerequisite rpms to install Oracle Database 10gR2 and AS10g(midtier) 
on Linux on IBM zSeries (Doc ID 1086769.1)
We're working on a SLES10 SP3 compatible rpm at the moment - it's a work in 
progress.

For the datapump issue, I'm not aware of that issue, and I can't obviously see 
how that could be distro/platform dependant, unless there's something being 
lost in translation, endianness for example. If you want to drop me an SR 
reference offline (if you have one) I can take a look. If you didn't open an 
SR, and can reproduce it, please do open an SR as if it's supposed to be 
working, it should do so.

" then porting new databases to this platform will just be a more manual effort 
than on our existing platforms and on any other platform that I've used in the 
past, too." - just plain shouldn't be the case, and I'm very keen to eliminate 
issues which make the platform appear less attractive to the dbas and sysadmins 
who use it. Generally a user inside the Linux guest shouldn't notice any 
difference between platforms, but of course platform specific information 
should be available on demand.

In summary, I do think we are doing the same thing on each distro (success or 
failure :-) ), and again, I'm happy to review any comments anyone else has.   

Cheers
Damian

-Original Message-
From: Melancon, Ruddy [mailto:melanc...@dot.state.al.us] 
Sent: 29 December 2010 17:36
To: LINUX-390@vm.marist.edu
Subject: FW: Linux preferences

In response to the email...

" The Oracle DBA indicates that Oracle is easier to implement under Red Hat" - 
I'm interested in what this means precisely, as we should be pretty similar in 
each environment - we only have the one code set and installer. If there are 
significant differences that people are finding (on Z) then I'm happy to look 
into it.
  
I got the following response...

Part of the reason for my preference is "the Devil you know". I've managed 
servers with RHAS and RHEL for a number of years. Also, RHEL and RHAS use 
commands and configurations that are very close to Solaris which I also managed 
for many years. There are just differences in the way that SUSE works from RHEL 
and Solaris which are different than the systems that I know well. SUSE is one 
that I do not know well.

The problem that I found with Oracle on SUSE on ZVM is that Oracle did not have 
a clean install. The base version that was available for SUSE was Oracle 
10.2.0.2 and it did not install cleanly on SUSE on ZVM. I did not get a usable 
database until I installed the 10.2.0.4 upgrades. Also, there was a large 
amount of manual verification that I had to do because the installation could 
not properly verify the environment. Now, I'm not sure if this was because of 
SUSE or ZVM, but it is time consuming and frustrating, regardless.

The second problem occurred when I was trying to perform a datapump import 
using the parameter REMAP_TABLESPACE. This parameter allows me to do a full 
import of a database and create the tablespaces that do not exist in different 
locations from the database where the export was performed. Being able to use 
this functionality is a time saver for me because I do not manually have to 
create the tablespaces before the import is performed. Some of my database 
contain many tablespaces and creating them manually before an import is very 
time consuming. When I tried to use the REMAP_TABLESPACES parameter on the 
Oracle database that was created on the SUSE OS, it failed miserably. I tried 
for a day and a half to make it work, but it just did not. I've used this 
parameter and process on Windows, Solaris, and RHEL OS's with no problems and 
so I thought SUSE was the issue. However, after much thought it may just be the 
Z/OS platform that has this bug in the datapump. If it is the platform and not 
the OS, then it really does not matter which OS is used. If the platform is the 
issue, then porting new databases to this platform will just be a more manual 
effort than on our existing platforms and on any other platform that I've used 
in the past, too.

[Ruddy A. Melancon] 

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / sig

Re: Some information

[Damian Gallagher]

Hi Carlos,

I'm still not clear from the email thread why the customer needs RHEL 4 ,unless 
it's currently RHEL 4 on Intel, and they want to eliminate that - we really do 
prefer that a newer kernel is used, and also that 10.2.0.4 as a minimal Oracle 
level is used - 10.2.0.5 is also now available.

Cheers
Damian 

-Original Message-
From: Carlos A. Bodra [mailto:cbo...@terra.com.br] 
Sent: 11 January 2011 23:18
To: LINUX-390@vm.marist.edu
Subject: Re: Some information

 As I wrote in previous email, customer wants to do a Proof of Concept
for an
 application that runs with Oracle 10g2. This application is running
today in
 intel server with 02 QC chips. Customer wants to check performance
and
 portability. He is evaluating possibility to migrate from intel to
z10.
 On Ter 11/01/11 20:05 , Dave Jones d...@vsoft-software.com sent:
 Hi, Carlos.
 That configuration *should* work, but I can't guarantee that it
will. 
 Why is he customer insisting on RH 4.6instead of the newer (and
still 
 supported)RH 5.4?
 DJ
 On 1/11/2011 3:37 PM, Carlos Bodra - Pessoal wrote:
 > Hello.
 >
 > We have a brand new z10 with 02 IFL engines and 64GB memory. This
 > machine has z/vm 5.4 installed
 > and we need to conduct a Proof of Concept for a customer that
needs Red
 > Hat 4.6 since they have Oracle
 > 10Gr2.
 >
 > Will this version runs ok under z/vm 5.4, since it is and old one?
I´m
 > now downloading
 >
 >
 > Red Hat Enterprise Linux AS 4.6 (s390x)
 >
 > iso images.
 >

--
 For LINUX-390 subscribe / signoff / archive access instructions,
 send email to lists...@vm.marist.edu [1] with the message: INFO
LINUX-390 or visit
 http://www.marist.edu/htbin/wlvindex?LINUX-390 [2]

--
 For more information on Linux on System z, visit
 http://wiki.linuxvm.org/ [3]

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: PHP5 problem

[Damian Gallagher]

That looks like the Oracle Call Interface library - it comes with the Database 
or the Instant Client, and there's a bunch of configuration and path stuff to 
do to make sure it gets picked up. 

Searching for oci8.so or PHP+Oracle in a well known search engine provides a 
number of references that you can use to validate your current environment and 
check the configuration

Cheers
Damian
-Original Message-
From: leandro bianco [mailto:leandro.bia...@gmail.com] 
Sent: 17 January 2011 18:54
To: LINUX-390@vm.marist.edu
Subject: PHP5 problem

Unfortunately I inherited this environment from the previous sysadmin
and do not know much about the origin of the OCI module that I guess
it was compiled.
I wanted to know if it was possible to avoid compiling in order to
better preserve the environment for future updates or at least what
could be the way to make the environment easier to manage as much as
possible

Thank you for your attention
Leandro



Re: PHP5 problem

Mark Post
Fri, 14 Jan 2011 11:58:50 -0800

>>> On 1/14/2011 at 11:40 AM, leandro bianco  wrote:
> Hi all i have a problem with php5 on oci8 on
> zSeries  SUSE SLES10 SP3   kernel   2.6.16.60-0.74.7 .
> I need to use php with oci8.so.
> Upgading php at level 5.2.14 oci8 are not more loaded.
> Looking at apache error log i can see this error:
> PHP Warning:  PHP Startup: Unable to load dynamic library
> '/usr/lib64/php5/extensions/oci8.so' - /usr/lib64/php
> 5/extensions/oci8.so: undefined symbol: OnUpdateInt in Unknown on line 0

>>> Since we don't ship anything named oci8.so with SLES (or the SDK), I have to
>assume that you got the library from somewhere else, or built it yourself.  V
>Have you tried rebuilding it, or getting an updated copy?


>Mark Post



--
Keep in mind that we didn't develop GNU for the sake of having it be
used by businesses. We welcome businesses to use it, and everybody,
every user of computers should be free to study and change and
redistribute software, all the software they use, and that includes
businesses, if they're using computers. But we don't give any
particular priority to businesses.
- Richard Stallman

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: SUSE 11 SP 1, Oracle 10g Install - Network Config Assistant Fails

[Damian Gallagher]

" But I'd like to make sure I have a basically working installation before I 
start patching.  "

Don't. Apply the 10.2.0.4 patchset (since you have it ready) before you do 
anything else. Just do it :-)

Cheers
Damian

-Original Message-
From: David Stuart [mailto:david.stu...@ventura.org] 
Sent: 04 February 2011 21:15
To: LINUX-390@vm.marist.edu
Subject: Re: SUSE 11 SP 1, Oracle 10g Install - Network Config Assistant Fails

Mark, 

That will take an 'outage', as I'm running in an LPAR (yeah, I know!), and I 
may have to POR after adjusting memory for that LPAR.  I don't remember, right 
now. 


Dave 






Dave Stuart
Prin. Info. Systems Support Analyst
County of Ventura, CA
805-662-6731
david.stu...@ventura.org>>> "Mark Post"  2/4/2011 1:11 PM >>>
>>> On 2/4/2011 at 04:01 PM, David Stuart  wrote: 
> It's running with 1GB. 

Just to get through the install I would try more, say 1.5 or 2G.


Mark Post

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390 
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/ 

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Gotcha's

[Damian Gallagher]

Well, there shouldn't be any gotcha's, if the installation material and the 
articles on My Oracle Support are all up to date :-) The plan is, it should all 
work, if we say it should.

If it doesn't work, open a service request. If that doesn't work, ping me and 
I'll have a wee chat with the relevant peeps to make sure that it does. If you 
KNOW of gotchas, advertise them as you want, but my job will of course be to 
reduce their life expectancy as far as possible :-)

Cheers
Damian


-Original Message-
From: David Stuart [mailto:david.stu...@ventura.org] 
Sent: 15 February 2011 17:23
To: LINUX-390@vm.marist.edu
Subject: Re: Gotcha's

I would be interested, too, as I'm in the process of installing Oracle and 
trying to get all the management tools to run.  

Right now, the database is up and running, but some of the management tools 
won't start. 


Thanks, 
Dave 






Dave Stuart
Prin. Info. Systems Support Analyst
County of Ventura, CA
805-662-6731
david.stu...@ventura.org>>> "Davey, Clair"  2/15/2011 8:25 AM 
>>>
I would like to hear some of your 'gotcha's when running Oracle
databases on Linux on Zeries.  You can send them offline if you would
like.
 
The contents of this e-mail are confidential to the ordinary user of the e-mail 
address to which it was addressed and may also be privileged. If you are not 
the addressee of this e-mail you should not copy, forward, disclose or 
otherwise use it or any part of it in any form whatsoever. If you have received 
this e-mail in error, please notify us by telephone or e-mail the sender by 
replying to this message, and then delete this e-mail and other copies of it 
from your computer system. We reserve the right to monitor all e-mail 
communications through our network.

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390 
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/ 

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Oracle 11g on zLinux

[Damian Gallagher]

Oracle 11GR2 (11.2.0.2.0) is now available via Oracle Technology Network, in 
1QCY2011 as previously announced.
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

cheers
Damian

-Original Message-
From: Moeur Tim C [mailto:tim.mo...@srpnet.com] 
Sent: 19 November 2010 21:26
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle 11g on zLinux

I was provided this link in some of my correspondence with IBM on this
subject:

http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS4016
See page 2.

The Oracle document mentioned in the IBM doc confirms the intent to
provide support and availability 1Q2011.

Tim

-Original Message-
From: Linux on 390 Port [mailto:LINUX-390@VM.MARIST.EDU] On Behalf Of
Rodger Donaldson
Sent: Wednesday, November 17, 2010 10:47 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 11g on zLinux

On Tue, Nov 16, 2010 at 12:01:35PM -0700, Mark Post wrote:
>
> > I'm hunting for descriptive documents on
> > Oracle's site, but none are forthcoming.   I see on this forum that
> > question was asked 2 years ago, but has it changed in 2 years?
>
>  Not really.  Current estimates are Q1 2011.  But I've heard such
> estimates before, so I take that with a large chunk of salt.  I'm
> told that this time things will be different, but I'll believe that
> when I see the announcement.

Me too; Oracle folks I've dealt with lately have seemed way more
interested in shoehorning us onto OEL than supporting Oracle on
zLinux.

We've had the releases for 11g turn into cancellations (for the 11.1)
and subsequent delays (for 11.2).

--
Rodger Donaldsonrodg...@diaspora.gen.nz

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or
visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Oracle 11g on zLinux

[Damian Gallagher]

Yep, I agree. I'll see what can be done, but I'm not going to hold my breath 
for it :-) If that's the only nit, I'm quite relieved :-)

Cheers
Damian

-Original Message-
From: Mark Post [mailto:mp...@novell.com] 
Sent: 30 March 2011 16:31
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle 11g on zLinux

>>> On 3/30/2011 at 10:44 AM, Damian Gallagher  
>>> wrote:

> Oracle 11GR2 (11.2.0.2.0) is now available via Oracle Technology Network, in 
> 1QCY2011 as previously announced.
> http://www.oracle.com/technetwork/database/enterprise-edition/downloads/inde
> x.html
> 
> cheers

Damian,

Thank you very much for this alert.  I appreciate it.  Now for the nit-picking 
(sorry).

When you click on "See All" at the URL you gave, the page that comes up 
(http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112020-zlinux64-352074.html)
 has under "Directions" bullet # "4. Review the certification matrix for this 
product here."  If you click on the link, it sends you to a page that says:
Certification Information
Oracle customers can find all certification information on the My Oracle 
Support website.
with a hyperlink to https://support.oracle.com/.  Rather irritating.


Mark Post

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Oracle 11g on zLinux

[Damian Gallagher]

It's official. Certification on MOS is in catchup. Supported OS distros are 
detailed in the doc.

Point them at Getting Started - 11gR2 Grid Infrastructure,SI(Single Instance), 
ASM and DB (IBM: Linux on System z) (Doc ID 1306465.1)

If they open an SR I'll just tell them the same - if that makes it 'official' 
for them tell them to do so, and stick my name in a prominent position in the 
SR so it'll route to me.

Cheers
Damian

-Original Message-
From: Graves, Aaron [mailto:aaron.gra...@citi.com] 
Sent: 30 March 2011 19:04
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle 11g on zLinux

I'm told by my Oracle group that it is not available on the Oracle "eDelivery" 
site nor is it mentioned as supported on "MOS".  Is there an ETA for this that 
would make it "official"?


-Original Message-
From: Linux on 390 Port [mailto:LINUX-390@VM.MARIST.EDU] On Behalf Of Damian 
Gallagher
Sent: Wednesday, March 30, 2011 12:56 PM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Oracle 11g on zLinux

Yep, I agree. I'll see what can be done, but I'm not going to hold my breath 
for it :-) If that's the only nit, I'm quite relieved :-)

Cheers
Damian

-Original Message-
From: Mark Post [mailto:mp...@novell.com]
Sent: 30 March 2011 16:31
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle 11g on zLinux

>>> On 3/30/2011 at 10:44 AM, Damian Gallagher  
>>> wrote:

> Oracle 11GR2 (11.2.0.2.0) is now available via Oracle Technology Network, in
> 1QCY2011 as previously announced.
> http://www.oracle.com/technetwork/database/enterprise-edition/downloads/inde
> x.html
>
> cheers

Damian,

Thank you very much for this alert.  I appreciate it.  Now for the nit-picking 
(sorry).

When you click on "See All" at the URL you gave, the page that comes up 
(http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112020-zlinux64-352074.html)
 has under "Directions" bullet # "4. Review the certification matrix for this 
product here."  If you click on the link, it sends you to a page that says:
Certification Information
Oracle customers can find all certification information on the My Oracle 
Support website.
with a hyperlink to https://support.oracle.com/.  Rather irritating.


Mark Post

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Hugepages+oracle 10.0.2.0.4 in sles10SP2

[Damian Gallagher]

Hugepages are now supported, with Oracle 11.2.0.2.0 released yesterday

Cheers
Damian

-Original Message-
From: Linux on 390 Port [mailto:LINUX-390@VM.MARIST.EDU] On Behalf Of Szefler 
Jakub - Hurt TP
Sent: 27 November 2009 16:34
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Hugepages+oracle 10.0.2.0.4 in sles10SP2

You can't use it. I tried to configure hugepages with oracle but oracle
never saw hugepages.

After started oracle database we always got :

HugePages_Total:  1024
HugePages_Free:   1024
HugePages_Rsvd:  0
Hugepagesize: 2048 kB 

We recived notice from oracle support - 361323.1. You can see that for IBM
zSeries Based Linux s390 (for kernel 2.4 and for 2.6) hugepages N/A. Notice
describe oracle 9 but we got informations that is valid for oracle 10.2 too.




-Original Message-
From: Linux on 390 Port [mailto:LINUX-390@VM.MARIST.EDU] On Behalf Of Thomas
Kern
Sent: Friday, November 27, 2009 4:15 PM
To: LINUX-390@VM.MARIST.EDU
Subject: Re: Hugepages+oracle 10.0.2.0.4 in sles10SP2

Not for sale or not supported?

/Tom Kern

Szefler Jakub - Hurt TP wrote:
> Hi,
> 
> I have official answer from oracle that oracle database not available 
> for zlinux :(.
> 
> 
> Jakub Szefler
> Administrator Mainframe
> 
> Pion Operacji IT Grupy TP/Departament Infrastruktury Wydział 
> Infrastruktury Informatycznej Dział Platform Serwerowych i Pamięci 
> Masowych

--
For LINUX-390 subscribe / signoff / archive access instructions, send email
to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: z/Linux Oracle question

[Damian Gallagher]

I suggest 13GB for a basic sandbox/kick the tyres installation, the database 
size depends on the tests required.

5.5 GB Oracle Grid Infrastructure for a Grid Home for Cluster and ASM Home 
1.0 GB /tmp directory. 
4.6 GB database software. 
1.7 GB of disk space for a preconfigured database that uses file system storage 
(optional)

Cheers
Damian

-Original Message-
From: Patrick Spinler [mailto:spinler.patr...@mayo.edu] 
Sent: 24 May 2011 16:20
To: LINUX-390@vm.marist.edu
Subject: Re: z/Linux Oracle question

Oracle software on our intel oracle 11G r2 RAC cluster is about 4.5G
each for Oracle DB and the Grid/Clusterware installs.  Call it 10G all
together.

So another 20GB for some test databases doesn't sound completely out of
line.

-- Pat

On 5/24/11 10:14 AM, Hughes, Jim wrote:
> Our Oracle guy says he needs 30 gig to install the Oracle software and a
> test database.  Does this sound correct?  I have no facts regarding this
> subject.
>
> Regards,
>
> 
> Jim Hughes
> Consulting Systems Programmer
> Mainframe Technical Support Group
> Department of Information Technology
> State of New Hampshire
> 27 Hazen Drive
> Concord, NH 03301
> 603-271-5586Fax 603.271.1516
>
> Statement of Confidentiality: The contents of this message are
> confidential. Any unauthorized disclosure, reproduction, use or
> dissemination (either whole or in part) is prohibited. If you are not
> the intended recipient of this message, please notify the sender
> immediately and delete the message from your system.
>
> --
> For LINUX-390 subscribe / signoff / archive access instructions,
> send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
> http://www.marist.edu/htbin/wlvindex?LINUX-390
> --
> For more information on Linux on System z, visit
> http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Oracle 11G on zLinux

[Damian Gallagher]

I believe it's the Linux kernel overhead taking away from the 4GB you thought 
you had. You can get away with 2GB or so - less than that will certainly incur 
a lot of swapping. Just make sure all the other prereqs are there and then use 
the -ignoreSysprereqs flag on the installer - the amount you actually need 
depends on the features you install.

Moving forward, it's what you need at runtime, pretty much the same calculation 
you had before (SGA, PGA, Oracle kernel, Linux kernel, etc).
And, no, I don't want to get into the wider discussion of why that 4GB number 
is there :-)

Cheers
Damian

-Original Message-
From: RPN01 [mailto:nix.rob...@mayo.edu] 
Sent: 03 August 2011 16:26
To: LINUX-390@vm.marist.edu
Subject: Oracle 11G on zLinux

We¹re in the process of doing an Oracle 11g install for proof of concept,
and we¹ve run into the 4gig memory issue. We gave the machine 4g of memory,
but it came up with an actual value of 3.9255gig and failed. Why is 4gig not
4gig? And, how much memory actually has to be allocated to install? Does
that amount really have to be left in the image moving forward? How are
other sites configuring Oracle on zLinux?

-- 
Robert P. Nix  Mayo Foundation.~.
RO-OC-1-18 200 First Street SW/V\
507-284-0844   Rochester, MN 55905   /( )\
-^^-^^
"In theory, theory and practice are the same, but
 in practice, theory and practice are different."


--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Required packages on a zLinux server running Oracle vs "Put everything on"

[Damian Gallagher]

Oh, we can do better than that :-) On the assumption that you have a support 
contract, all you need is in this article:
Note 1086769.1 -Ensure you have prerequisite rpms to install Oracle Database 
and AS10g(midtier) on IBM: Linux on System z (s390x)

This provides an rpm which consists only of prereqs, thus ensuring you have the 
packages needed for the appropriate product. Run both sets, and you're good for 
E-Business Suite also.

It won't necessarily tell you what you have that's unnecessary, though.

Cheers
Damian 


-Original Message-
From: Mauro Souza [mailto:thoriu...@gmail.com] 
Sent: 16 December 2011 10:56
To: LINUX-390@vm.marist.edu
Subject: Re: Required packages on a zLinux server running Oracle vs "Put 
everything on"

There's a RedBook (http://www.redbooks.ibm.com/abstracts/sg247634.html) for
installing Oracle on System Z. It contains all the needed packages, so you
could install just those packages. Having a lot of superfluous packages can
slow your server down, use more memory and disk than it should, and create
room for vulnerabilities (for instance on that Apache installed by default
and never configured properly).

Mauro
http://mauro.limeiratem.com - registered Linux User: 294521
Scripture is both history, and a love letter from God.


On Fri, Dec 16, 2011 at 1:43 AM, Marcy Cortes  wrote:

> The argument for not having them there is that you are subject to far less
> security patching.
> Now, some organizations don't seem to care about that.  Some others care
> more than one can ever imagine.
>
>
> Marcy
>
> -Original Message-
> From: Linux on 390 Port [mailto:LINUX-390@vm.marist.edu] On Behalf Of
> CHAPLIN, JAMES (CTR)
> Sent: Thursday, December 15, 2011 3:20 PM
> To: LINUX-390@vm.marist.edu
> Subject: [LINUX-390] Required packages on a zLinux server running Oracle
> vs "Put everything on"
>
> I got into a discussion with a co-worker over packages that are
> installed on a zLinux oracle server. We are Running RHEL 5.7 at our
> site, and are using Oracle 10g (about to go to 11g). I noticed that our
> Oracle servers have an average of 1192 rpm packages installed and 91
> define system services compared to our other non-Oracle servers
> (application, java, MQ & Websphere) having only 450 - 480 installed rpm
> packages and 53 defined services.
>
>
>
> I am not an oracle expert. Can anyone point me to a list of required
> software packages to be installed to support Oracle 10g? If you have any
> suggestions or personal experiences with oracle and the zLinux base
> platform, your comments are welcome.
>
>
>
> Another statement was "It does not matter what we have installed, as
> long as Oracle is working", or don't touch unless it is broken. A sample
> of the over 600 packages are httpd (apache) and eklogin. Others like
> squid I believe is needed. I am just looking for a good baseline and
> argument to clean up these servers from unneeded software.
>
>
>
> James Chaplin
>
> Systems Programmer, MVS, zVM & zLinux
>
>
> --
> For LINUX-390 subscribe / signoff / archive access instructions,
> send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or
> visit
> http://www.marist.edu/htbin/wlvindex?LINUX-390
> --
> For more information on Linux on System z, visit
> http://wiki.linuxvm.org/
>
> --
> For LINUX-390 subscribe / signoff / archive access instructions,
> send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or
> visit
> http://www.marist.edu/htbin/wlvindex?LINUX-390
> --
> For more information on Linux on System z, visit
> http://wiki.linuxvm.org/
>

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Required packages on a zLinux server running Oracle vs "Put everything on"

[Damian Gallagher]

There is a difference between the installation requirements and the runtime, as 
is usual. Installation requires x , but runtime doesn't - and the docs state 
4GB as that's the amount needed to get a full install. If you're a min install, 
you might get away with 2GB without swapping to hard, but there we go. Once 
you've done the install, of course X isn't needed, but that will be for 
patching perhaps :-) 

Once you're into runtime, then YYMV -  it's your workload that generates the 
resource usage.

Cheers
Damian

 

-Original Message-
From: van Sleeuwen, Berry [mailto:berry.vansleeu...@atos.net] 
Sent: 16 December 2011 17:09
To: LINUX-390@vm.marist.edu
Subject: Re: Required packages on a zLinux server running Oracle vs "Put 
everything on"

I don't know if that would help too. Our Oracle "specialist" ran a script from 
Oracle to determine requirements and demanded that the requirements would be 
met otherwise he couldn't install Oracle. This is an SLES11 with Oracle 11. So 
now we have a guest with 4G memory, 2G /tmp and a lot of packages installed, 
including a full X-windows. Installing Oracle we had proved through measuring 
the system that he needed only 200M /tmp space and less than 1G memory. X is 
never being used. So even the Oracle scripts and books do not reflect the 
actual minimal requirements but still consider a stand-alone server running X. 
BTW, the server is now installed according to Oracle recommendations, running 
at over 55MIPS it is now a top5 machine in CPU consumption and 100% in Q3. No, 
the machine is not in use yet so this is the IDLE load.

Our SLES10 with Oracle 10 is a guest with a minimal installation, meaning the 
absolute minimum required to run a Linux guest and added a few packages such as 
sudo, sysstat etc. On top of that we've added: "cpp, gcc ,gcc-c++ , glibc-devel 
,libaio-devel ,libmudflap, libstdc++-devel, java-1_5_0-ibm-devel, expat-32bit, 
fontconfig-32bit ,freetype2-32bit, glibc-devel-32bit, openmotif, 
xorg-x11-libs-32bit, zlib-32bit". So this is the actual minimum requirement. 
Anything more is not required to install or run an Oracle. Also the guest runs 
2 oracle databases within 1G. Idle load at about 6MIPS and almost never in Q3. 
Conclusion, don't trust the requirements from Oracle, they are wrong. On the 
other hand, if you want to install using X then you indeed need a lot more than 
this.

Regards, Berry.

> -Original Message-
> From: Linux on 390 Port [mailto:LINUX-390@VM.MARIST.EDU] On Behalf Of
> Damian Gallagher
> Sent: vrijdag 16 december 2011 15:47
> To: LINUX-390@VM.MARIST.EDU
> Subject: Re: Required packages on a zLinux server running Oracle vs "Put
> everything on"
>
> Oh, we can do better than that :-) On the assumption that you have a
> support contract, all you need is in this article:
> Note 1086769.1 -Ensure you have prerequisite rpms to install Oracle
> Database and AS10g(midtier) on IBM: Linux on System z (s390x)
>
> This provides an rpm which consists only of prereqs, thus ensuring you have
> the packages needed for the appropriate product. Run both sets, and you're
> good for E-Business Suite also.
>
> It won't necessarily tell you what you have that's unnecessary, though.
>
> Cheers
> Damian
>
>
> -Original Message-
> From: Mauro Souza [mailto:thoriu...@gmail.com]
> Sent: 16 December 2011 10:56
> To: LINUX-390@vm.marist.edu
> Subject: Re: Required packages on a zLinux server running Oracle vs "Put
> everything on"
>
> There's a RedBook
> (http://www.redbooks.ibm.com/abstracts/sg247634.html) for installing
> Oracle on System Z. It contains all the needed packages, so you could install
> just those packages. Having a lot of superfluous packages can slow your
> server down, use more memory and disk than it should, and create room for
> vulnerabilities (for instance on that Apache installed by default and never
> configured properly).
>
> Mauro
> http://mauro.limeiratem.com - registered Linux User: 294521 Scripture is
> both history, and a love letter from God.
>
>
> On Fri, Dec 16, 2011 at 1:43 AM, Marcy Cortes
>  > wrote:
>
> > The argument for not having them there is that you are subject to far
> > less security patching.
> > Now, some organizations don't seem to care about that.  Some others
> > care more than one can ever imagine.
> >
> >
> > Marcy
> >
> > -Original Message-
> > From: Linux on 390 Port [mailto:LINUX-390@vm.marist.edu] On Behalf Of
> > CHAPLIN, JAMES (CTR)
> > Sent: Thursday, December 15, 2011 3:20 PM
> > To: LINUX-390@vm.marist.edu
> > Subject: [LINUX-390] Required packages on a zLinux server running
> > Oracle vs &quo

Re: Concurrent Oracle patch availability for System z along with distributed?

[Damian Gallagher]

I was tempted to delay release of this post until it's second birthday :-) My 
previous answer is below. The update since then is that:
a) 11.2 patchsets are full product releases, so there's a lot more to port and 
QA than before.
b) This applies to all platforms, not just s390x - x86 is ready first since 
that's where we develop the patchset, and all the other platforms are then 
ported. We could achieve concurrency by delaying x86, but what would be the 
point of that ? We have expended considerable effort to streamline our QA and 
delivery procedures in order to facilitate the turnround of patchsets. 
c) the major message is that patchsets are no longer critical for stability and 
problem avoidance, the PSU does that, and those are released concurrently, 
quarterly,  provided the patchset on which they are built is available. 
Individual patches that you need due to a problem are available on demand, 
according to the severity of the problem you are experiencing.  

Cheers
Damian

-Original Message-----
From: Damian Gallagher 
Sent: 15 January 2010 20:55
To: Linux on 390 Port
Subject: RE: Oracle on s390x, patches release same time as x86 ?

Lets clarify a little.
Individual patches (for a specific bug), if not already available, are released 
according to the severity and technical/business justification of the customer 
issue - so that's an ad-hoc process. 

We now collect important patches together into a Patch Set Update, released 
quarterly. This also includes the  Critical Patch Update, which on s390x we 
don't release separately after examination of customer downloads. The PSU are 
available on s390x pretty much simultaneously with all other platforms - they 
may be a day or 2 out, but we aim for simultaneous release - the January 2010 
is due any day now.

Patchsets do have delay, depending on the complexity of the underlying changes. 
With the introduction of the PSU, this is far less critical than it used to be, 
as the quarterly PSU takes care of issues related to stability.

Cheers
Damian

-Original Message-
From: Agblad Tore [mailto:tore.agb...@volvo.com] 
Sent: 15 January 2010 09:08
To: LINUX-390@vm.marist.edu
Subject: Oracle on s390x, patches release same time as x86 ?

I have heard s390x is not tier 1 platform so patches is released later than for 
tier 1 (x86?)
Someone knows how this works ?
If a timedelay, how long time ??

I'm waiting for a response from Oracle as well.

Cordialement / Vriendelijke Groeten / Best Regards / Med Vänliga Hälsningar
  Tore Agblad

   Volvo Information Technology
   Infrastructure Mainframe Design & Development
   SE-405 08, Gothenburg  Sweden
   E-mail: tore.agb...@volvo.com

   http://www.volvo.com/volvoit/global/en-gb/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Concurrent Oracle patch availability for System z along with distributed?

[Damian Gallagher]

Mike,

Do consider joining the Special Interest Group - more details here - 
http://zseriesoraclesig.org/index.php , or at least keeping an eye on the site. 
At their request, we have roughly quarterly information events, webinars or 
conferences, where Oracle Support, frequently together with IBM's technical 
staff, talk about real world issues involving Oracle on System Z. The recording 
of the last one is on that site, and this issue is one I frequently discuss to 
ensure that the information around patching is understood. There's a whole 
bunch more we talk about as well :-) We're looking to do another fairly soon.

Cheers
Damian
(I changed the subject to bring it back to this thread. Hope it does :-) )

-Original Message-
From: Mike Walter [mailto:mike.wal...@aonhewitt.com] 
Sent: 06 January 2012 16:20
To: LINUX-390@vm.marist.edu
Subject: Re: LINUX-390 Digest - 3 Jan 2012 to 4 Jan 2012 (#2012-4)

-Original Message-
Thank you, Damian.

A year ago, around the birthday of your aforementioned post, I was only 
following the list occasionally - from a jealous distance.  After submitting 
refreshed business cases to the 'right' senior leader last winter, now we're 
finally (after a decade of repeated rejections) conducting a real Oracle 
database server workload Proof of Concept on Linux for System z.  

I find searching this list for pertinent posts awkward at best, especially 
comparing this listserver to the IBMVM listserver's online search capability.  

I really appreciate the updated descriptions; they seem to remove 'delayed 
System z patches for Oracle' from the list of show-stoppers.

Mike Walter
Aon Corporation
The opinions expressed herein are mine alone, not my employer's.


--

Date:    Wed, 4 Jan 2012 05:13:44 -0800
From:Damian Gallagher 
Subject: Re: Concurrent Oracle patch availability for System z along with 
distributed?

I was tempted to delay release of this post until it's second birthday :-) =
My previous answer is below. The update since then is that:
a) 11.2 patchsets are full product releases, so there's a lot more to port =
and QA than before.
b) This applies to all platforms, not just s390x - x86 is ready first since=
 that's where we develop the patchset, and all the other platforms are then=
 ported. We could achieve concurrency by delaying x86, but what would be th=
e point of that ? We have expended considerable effort to streamline our QA=
 and delivery procedures in order to facilitate the turnround of patchsets.=
=20
c) the major message is that patchsets are no longer critical for stability=
 and problem avoidance, the PSU does that, and those are released concurren=
tly, quarterly,  provided the patchset on which they are built is available=
. Individual patches that you need due to a problem are available on demand=
, according to the severity of the problem you are experiencing. =20

Cheers
Damian

-Original Message-
From: Damian Gallagher=20
Sent: 15 January 2010 20:55
To: Linux on 390 Port
Subject: RE: Oracle on s390x, patches release same time as x86 ?

Lets clarify a little.
Individual patches (for a specific bug), if not already available, are rele=
ased according to the severity and technical/business justification of the =
customer issue - so that's an ad-hoc process.=20

We now collect important patches together into a Patch Set Update, released=
 quarterly. This also includes the  Critical Patch Update, which on s390x w=
e don't release separately after examination of customer downloads. The PSU=
 are available on s390x pretty much simultaneously with all other platforms=
 - they may be a day or 2 out, but we aim for simultaneous release - the Ja=
nuary 2010 is due any day now.

Patchsets do have delay, depending on the complexity of the underlying chan=
ges. With the introduction of the PSU, this is far less critical than it us=
ed to be, as the quarterly PSU takes care of issues related to stability.

Cheers
Damian

-Original Message-
From: Agblad Tore [mailto:tore.agb...@volvo.com]=20
Sent: 15 January 2010 09:08
To: LINUX-390@vm.marist.edu
Subject: Oracle on s390x, patches release same time as x86 ?

I have heard s390x is not tier 1 platform so patches is released later than=
 for tier 1 (x86?)
Someone knows how this works ?
If a timedelay, how long time ??

I'm waiting for a response from Oracle as well.

Cordialement / Vriendelijke Groeten / Best Regards / Med V=E4nliga H=E4lsni=
ngar
  Tore Agblad

   Volvo Information Technology
   Infrastructure Mainframe Design & Development
   SE-405 08, Gothenburg  Sweden
   E-mail: tore.agb...@volvo.com

   http://www.volvo.com/volvoit/global/en-gb/

--

--
For LINUX-390 subscribe / signoff / arch

Re: Oracle 10.2 and 11.2 on Sles10

[Damian Gallagher]

Yep, our My Oracle Support certification site covers that also , 
Thanks Dominic :-)

Cheers
Damian

-Original Message-
From: Dominic Coulombe [mailto:dominic.coulo...@gmail.com] 
Sent: 01 February 2012 14:47
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle 10.2 and 11.2 on Sles10

Hi,

According to this document, Oracle 10.2 is supported under RHEL5, SLES10
and SLES11 :
http://docs.oracle.com/cd/B19306_01/relnotes.102/b25399/toc.htm#CHDFHIEA

And for Oracle 11.2, here is the info I found : RHEL4.8, RHEL5.4, SLES10
SP3 and SLES11 SP1 :
http://docs.oracle.com/cd/E11882_01/install.112/e24327/toc.htm#CIHFICFD

Regards.


On Wed, Feb 1, 2012 at 09:26, Le Blanc, Frank  wrote:

> I have been searching for an Oracle matrix that shows Oracle Database and
> the Suse Linux kernel versions it supports. I was told that there is no
> common Sles10 kernel level that supports Oracle 10.2 and 11.2. I thought
> Sles10 SP3 would support both.
> Appreciate any information.
>
> Frank LeBlanc
> Senior Systems Administrator
> Information Services & Technology
> Boston University
> T (617)353-9368
> F (617)353-6171
> flebl...@bu.edu
> http://www.bu.edu/tech
>
> --
> For LINUX-390 subscribe / signoff / archive access instructions,
> send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or
> visit
> http://www.marist.edu/htbin/wlvindex?LINUX-390
> --
> For more information on Linux on System z, visit
> http://wiki.linuxvm.org/
>

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Oracle in virtual environments

[Damian Gallagher]

Thanks Mike and Malcolm for the assist. 
I am from Oracle, and I can quite categorically state that as far as zSeries 
and z/VM is concerned, that statement is utter rubbish :-) Our certification 
site and the compatibility matrices fully and officially declare that it's all 
good. Here's the RAC one, for example: 
http://www.oracle.com/technetwork/database/clustering/tech-generic-linux-new-086754.html

So:
Paragraph 1: "In a discussion with our Oracle group.." Untrue
Paragraph 2: " Even more so, Oracle 'must' be installed with HA" Untrue (but 
Oracle Restart is recommended)
Paragraph 3: " Can anyone confirm this statement" In the negative :-)

I do a webcast quarterly or so around Oracle on zSeries, next one is March 
15th, see http://zseriesoraclesig.org/ for joining details (when it gets 
updated), if you are a My Oracle Support user there'll be an email out. I'll 
put a direct link out on this list in this topic next week.

We're presenting at Share March 14th on this topic, and at Collaborate12 in Las 
Vegas in April (mee, heee hee !!) so by all means join us at any of these 
events. I can also be found at the UK GSE conference in the Autumn (fall), and 
at the UK Zlinux User Group (ZLUG) meetings. I'm more than happy to be collared 
and put to the Question :-)

I'm quite happy to have a call with you and/or your DBA team, mail me offline 
to discuss. This applies to anyone who's having this kind of misunderstanding, 
of course :-)


Cheers
Damian (who has a whole worldwide team supporting Oracle on z/VM on zSeries :-) 
)
  

-Original Message-
From: van Sleeuwen, Berry [mailto:berry.vansleeu...@atos.net] 
Sent: 22 February 2012 09:02
To: LINUX-390@vm.marist.edu
Subject: Oracle in virtual environments

Hi All,

In a discussion with our Oracle group they claim that there is no support for 
Oracle in virtual systems and that they therefore will not support on virtual 
systems too. So when a (performance) problem is found they first advise to 
migrate to a dedicated server, and increase resources, before they attempt to 
solve the problem. This is not (only) true for z but also for other virtual 
systems as well, we discovered this because of the advice to migrate off of 
cloud systems. So basically any 'cloud' service is not advised to run Oracle.

Even more so, Oracle 'must' be installed with HA , the server 'must' have 4G to 
install in the first place and even more to run the database. Obviously plenty 
of caching must be available on all levels (FS cache, SGA/PGA, shared segments 
etc) to 'improve' performance. Needless to say that this makes server 'virtual 
unfriendly' to say the least, impossible to run virtualized would be a better 
description.

Can anyone confirm this statement? Is it Oracle or is it the interpretation or 
our Oracle group? Is there a formal statement from Oracle itself?

(And Yes, we do run Oracle systems. And we do measure the best performance in 
systems that are as small as possible, ie don't run according to Oracle 
recommendations. So from our point of view the statement is not true but that 
doesn't help if there is no support on whatever level.)

Met vriendelijke groet/With kind regards/Mit freundlichen Grüßen, Berry van 
Sleeuwen Flight Forum 3000 5657 EW Eindhoven
* +31 (0)6 22564276
[Description: atos]  [Description: cid:325312309@02022011-28C8]






Dit bericht is vertrouwelijk en kan geheime informatie bevatten enkel bestemd 
voor de geadresseerde. Indien dit bericht niet voor u is bestemd, verzoeken wij 
u dit onmiddellijk aan ons te melden en het bericht te vernietigen. Aangezien 
de integriteit van het bericht niet veilig gesteld is middels verzending via 
internet, kan Atos Nederland B.V. niet aansprakelijk worden gehouden voor de 
inhoud daarvan. Hoewel wij ons inspannen een virusvrij netwerk te hanteren, 
geven wij geen enkele garantie dat dit bericht virusvrij is, noch aanvaarden 
wij enige aansprakelijkheid voor de mogelijke aanwezigheid van een virus in dit 
bericht. Op al onze rechtsverhoudingen, aanbiedingen en overeenkomsten 
waaronder Atos Nederland B.V. goederen en/of diensten levert zijn met 
uitsluiting van alle andere voorwaarden de Leveringsvoorwaarden van Atos 
Nederland B.V. van toepassing. Deze worden u op aanvraag direct kosteloos 
toegezonden.

This e-mail and the documents attached are confidential and intended solely for 
the addressee; it may also be privileged. If you receive this e-mail in error, 
please notify the sender immediately and destroy it. As its integrity cannot be 
secured on the Internet, the Atos Nederland B.V. group liability cannot be 
triggered for the message content. Although the sender endeavours to maintain a 
computer virus-free network, the sender does not warrant that this transmission 
is virus-free and will not be liable for any damages resulting from any virus 
transmitted. On all offers and agreements under which Atos Nederland B.V. 
supplies goods and/or services of whatever nature, 

Re: Oracle in virtual environments

[Damian Gallagher]

Well, it's important to understand what we mean by " long idle periods on the 
database engine " - in the case of Oracle, the majority of the user work is 
done by the user process, rather than a centralised engine, and that user 
process is typically only active 1-5% of the time in an OLTP system - leaving 
plenty of opportunity to manage the PGA.

I'll leave the discussion of swap rates to virtual disk to the VM experts here, 
but believe me, a properly configured system can sustain insane rates with no 
significant observable impact on overall system throughput (as far as the 
database can tell, anyway).  

My presentations last year in webcasts and IOUG were very much concerned with 
virtual memory management - and the same issue applies to real memory in a 
non-virtual environment. The larger the SGA, the larger the space allocated to 
page translation tables for the shared memory segment. The more processes you 
have, the more page tables. Having a large SGA and a large process count can 
cripple a system to the point where the memory shortage comes from page tables, 
not SGA and PGA itself - remember the page tables are fixed in memory. Some of 
these presentations are on the ZSeries SIG site I posted earlier, and I really 
do recommend you join and participate in the SIG if you are running Oracle on 
zSeries - it's not run by Oracle, but by customers, so it's well worth 
investigating (did I mention Veegaaas!!!) . 

I have worked on numerous migration projects, where we have taken the Win/*nix 
system with hundreds of GB of SGA, and run it on Linux on IBM zSeries with much 
less memory - my usual recommendation is to reduce by 90% to start with, and we 
generally get there or better - in common with this thread it takes a while to 
convince the DBAs :-). I have the numbers, AWR, throughput etc from a specific 
project in front of me, so this is no idle statement. Add hugepages to the mix, 
and it just gets better.

And thanks to James Barton for reminding me of the top level note on 
virtualisation everywhere: 
http://www.oracle.com/technetwork/database/virtualizationmatrix-172995.html
which kinda shows that we do support virtualisation :-) 
Cheers
Damian



 
-Original Message-
From: Bernd Oppolzer [mailto:bernd.oppol...@t-online.de] 
Sent: 22 February 2012 20:32
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle in virtual environments

I don't think that the situation you describe (long idle periods on the
database
engine) is a realistic one. Of course, if such situations happen, the
database
engine's pages have to be paged out by the paging subsystem.

But I had another situation in mind: normal continuous operation of the
database.
Now, how large should the DB system buffer be? Normally, the larger, the
better.
The DB engine can handle larger amounts of data in memory and the hit ratio
(= buffer pool usage) is better. Less disk access needed. But: if the DB
bufferpools
are too large (= larger than the available REAL memory frames, under normal
circumstances), the DB engine competes with other address spaces for those
real memory page frames, and paging activity starts on the DB bufferpool
pages.
So it is possible that the DB page needed by the DB engine was just
paged out
by the paging subsystem. The efforts of the DB engine and the paging
subsystem
to reduce disk accesses disturb each other.

This is the normal behaviour: when you enlarge the DB buffer pool, the
performance
first gets better, but at a certain point (when paging activity starts
due to real page
frame constraints), performance gets dramatically worse.

Knowing this, I believe that performance on a virtual DB system may also
degrade
significantly, if the virtualization implies paging activity on the
address space
of the database engine.

Kind regards

Bernd




Am 22.02.2012 20:26, schrieb Rob van der Heij:
> On Wed, Feb 22, 2012 at 7:09 PM, Bernd Oppolzer
>   wrote:
>
>> The database engine or process uses large memory buffers to
>> cache the (least recently used) database pages in REAL memory,
>> and database performance may degrade significantly, if there is
>> paging acitivity on the memory buffers of the database engine.
>> So the DB admins have to take care that the real storage on the
>> DB machine is large enough that there is no paging on the DB
>> buffers, and the DB buffers have to be defined only as large as the
>> available REAL memory (not the address space).
> I don't think anyone disagrees with your claim that a running DB
> system needs the code and data in memory to operate on it. But when
> the database utilization is only 5%, it only needs that 5% of the
> time. Not 100% of the time. This means that the paging subsystem has
> to page out the idle guest to make room for others, and page it back
> in when it becomes active. The challenge becomes a bit easier if the
> DBA reduces the peak memory requirements (smaller SGA and PGA target)
> even when that means a bit more overhead during peak times.
>
>> This

Re: Oracle in virtual environments

[Damian Gallagher]

Apologies, this hung up in my outbox for 2 weeks without me noticing. Hope some 
of you can make it.

-Original Message-
From: Damian Gallagher 
Sent: 14 March 2012 09:59
To: linux-390@vm.marist.edu
Subject: RE: Oracle in virtual environments

" I do a webcast quarterly or so around Oracle on zSeries, next one is March 
15th"
Sorry, 14th :-) 
http://www.zseriesoraclesig.org/webcasts.php for joining information  - that 
takes you to the My Oracle Support official link - do take time to explore the 
SIG site, though. Note that the SIG is a completely independent organisation 
from Oracle, I'm just plugging a useful organisation.

It's a joint 'cast with Dave Simpson of IBM, and it ties in neatly with Share, 
where there are also joint presentations (but not the same ones :-)) the next 
day.

If anyone can't get on via their MoS subscription, or via their DBA group/ Mos 
Admin (who should have had a direct notification via our email ), let me know 
privately and I'll see what I can do, but since it's a MoS webcast, I'm not 
sure what I can do.
Cheers
Damian

-Original Message-
From: Damian Gallagher [mailto:damian.gallag...@oracle.com] 
Sent: 22 February 2012 16:13
To: 'linux-390@vm.marist.edu'
Subject: RE: Oracle in virtual environments

Thanks Mike and Malcolm for the assist. 
I am from Oracle, and I can quite categorically state that as far as zSeries 
and z/VM is concerned, that statement is utter rubbish :-) Our certification 
site and the compatibility matrices fully and officially declare that it's all 
good. Here's the RAC one, for example: 
http://www.oracle.com/technetwork/database/clustering/tech-generic-linux-new-086754.html

So:
Paragraph 1: "In a discussion with our Oracle group.." Untrue
Paragraph 2: " Even more so, Oracle 'must' be installed with HA" Untrue (but 
Oracle Restart is recommended)
Paragraph 3: " Can anyone confirm this statement" In the negative :-)

I do a webcast quarterly or so around Oracle on zSeries, next one is March 
15th, see http://zseriesoraclesig.org/ for joining details (when it gets 
updated), if you are a My Oracle Support user there'll be an email out. I'll 
put a direct link out on this list in this topic next week.

We're presenting at Share March 14th on this topic, and at Collaborate12 in Las 
Vegas in April (mee, heee hee !!) so by all means join us at any of these 
events. I can also be found at the UK GSE conference in the Autumn (fall), and 
at the UK Zlinux User Group (ZLUG) meetings. I'm more than happy to be collared 
and put to the Question :-)

I'm quite happy to have a call with you and/or your DBA team, mail me offline 
to discuss. This applies to anyone who's having this kind of misunderstanding, 
of course :-)


Cheers
Damian (who has a whole worldwide team supporting Oracle on z/VM on zSeries :-) 
)
  

-Original Message-
From: van Sleeuwen, Berry [mailto:berry.vansleeu...@atos.net] 
Sent: 22 February 2012 09:02
To: LINUX-390@vm.marist.edu
Subject: Oracle in virtual environments

Hi All,

In a discussion with our Oracle group they claim that there is no support for 
Oracle in virtual systems and that they therefore will not support on virtual 
systems too. So when a (performance) problem is found they first advise to 
migrate to a dedicated server, and increase resources, before they attempt to 
solve the problem. This is not (only) true for z but also for other virtual 
systems as well, we discovered this because of the advice to migrate off of 
cloud systems. So basically any 'cloud' service is not advised to run Oracle.

Even more so, Oracle 'must' be installed with HA , the server 'must' have 4G to 
install in the first place and even more to run the database. Obviously plenty 
of caching must be available on all levels (FS cache, SGA/PGA, shared segments 
etc) to 'improve' performance. Needless to say that this makes server 'virtual 
unfriendly' to say the least, impossible to run virtualized would be a better 
description.

Can anyone confirm this statement? Is it Oracle or is it the interpretation or 
our Oracle group? Is there a formal statement from Oracle itself?

(And Yes, we do run Oracle systems. And we do measure the best performance in 
systems that are as small as possible, ie don't run according to Oracle 
recommendations. So from our point of view the statement is not true but that 
doesn't help if there is no support on whatever level.)

Met vriendelijke groet/With kind regards/Mit freundlichen Grüßen, Berry van 
Sleeuwen Flight Forum 3000 5657 EW Eindhoven
* +31 (0)6 22564276
[Description: atos]  [Description: cid:325312309@02022011-28C8]






Dit bericht is vertrouwelijk en kan geheime informatie bevatten enkel bestemd 
voor de geadresseerde. Indien dit bericht niet voor u is bestemd, verzoeken

Re: Oracle in virtual environments

[Damian Gallagher]

" I do a webcast quarterly or so around Oracle on zSeries, next one is March 
15th"
Sorry, 14th :-) 
http://www.zseriesoraclesig.org/webcasts.php for joining information  - that 
takes you to the My Oracle Support official link - do take time to explore the 
SIG site, though. Note that the SIG is a completely independent organisation 
from Oracle, I'm just plugging a useful organisation.

It's a joint 'cast with Dave Simpson of IBM, and it ties in neatly with Share, 
where there are also joint presentations (but not the same ones :-)) the next 
day.

If anyone can't get on via their MoS subscription, or via their DBA group/ Mos 
Admin (who should have had a direct notification via our email ), let me know 
privately and I'll see what I can do, but since it's a MoS webcast, I'm not 
sure what I can do.
Cheers
Damian

-Original Message-
From: Damian Gallagher [mailto:damian.gallag...@oracle.com] 
Sent: 22 February 2012 16:13
To: 'linux-390@vm.marist.edu'
Subject: RE: Oracle in virtual environments

Thanks Mike and Malcolm for the assist. 
I am from Oracle, and I can quite categorically state that as far as zSeries 
and z/VM is concerned, that statement is utter rubbish :-) Our certification 
site and the compatibility matrices fully and officially declare that it's all 
good. Here's the RAC one, for example: 
http://www.oracle.com/technetwork/database/clustering/tech-generic-linux-new-086754.html

So:
Paragraph 1: "In a discussion with our Oracle group.." Untrue
Paragraph 2: " Even more so, Oracle 'must' be installed with HA" Untrue (but 
Oracle Restart is recommended)
Paragraph 3: " Can anyone confirm this statement" In the negative :-)

I do a webcast quarterly or so around Oracle on zSeries, next one is March 
15th, see http://zseriesoraclesig.org/ for joining details (when it gets 
updated), if you are a My Oracle Support user there'll be an email out. I'll 
put a direct link out on this list in this topic next week.

We're presenting at Share March 14th on this topic, and at Collaborate12 in Las 
Vegas in April (mee, heee hee !!) so by all means join us at any of these 
events. I can also be found at the UK GSE conference in the Autumn (fall), and 
at the UK Zlinux User Group (ZLUG) meetings. I'm more than happy to be collared 
and put to the Question :-)

I'm quite happy to have a call with you and/or your DBA team, mail me offline 
to discuss. This applies to anyone who's having this kind of misunderstanding, 
of course :-)


Cheers
Damian (who has a whole worldwide team supporting Oracle on z/VM on zSeries :-) 
)
  

-Original Message-
From: van Sleeuwen, Berry [mailto:berry.vansleeu...@atos.net] 
Sent: 22 February 2012 09:02
To: LINUX-390@vm.marist.edu
Subject: Oracle in virtual environments

Hi All,

In a discussion with our Oracle group they claim that there is no support for 
Oracle in virtual systems and that they therefore will not support on virtual 
systems too. So when a (performance) problem is found they first advise to 
migrate to a dedicated server, and increase resources, before they attempt to 
solve the problem. This is not (only) true for z but also for other virtual 
systems as well, we discovered this because of the advice to migrate off of 
cloud systems. So basically any 'cloud' service is not advised to run Oracle.

Even more so, Oracle 'must' be installed with HA , the server 'must' have 4G to 
install in the first place and even more to run the database. Obviously plenty 
of caching must be available on all levels (FS cache, SGA/PGA, shared segments 
etc) to 'improve' performance. Needless to say that this makes server 'virtual 
unfriendly' to say the least, impossible to run virtualized would be a better 
description.

Can anyone confirm this statement? Is it Oracle or is it the interpretation or 
our Oracle group? Is there a formal statement from Oracle itself?

(And Yes, we do run Oracle systems. And we do measure the best performance in 
systems that are as small as possible, ie don't run according to Oracle 
recommendations. So from our point of view the statement is not true but that 
doesn't help if there is no support on whatever level.)

Met vriendelijke groet/With kind regards/Mit freundlichen Grüßen, Berry van 
Sleeuwen Flight Forum 3000 5657 EW Eindhoven
* +31 (0)6 22564276
[Description: atos]  [Description: cid:325312309@02022011-28C8]






Dit bericht is vertrouwelijk en kan geheime informatie bevatten enkel bestemd 
voor de geadresseerde. Indien dit bericht niet voor u is bestemd, verzoeken wij 
u dit onmiddellijk aan ons te melden en het bericht te vernietigen. Aangezien 
de integriteit van het bericht niet veilig gesteld is middels verzending via 
internet, kan Atos Nederland B.V. niet aansprakelijk worden gehouden voor de 
inhou

Re: Oracle 11 not dropping from Queue 3

[Damian Gallagher]

It's the new VKTM process, which has a very small wake up interval, keeping the 
process, and hence the guest active. Open an SR and I'll tell you how to work 
round it.

Cheers
Damian

-Original Message-
From: Walters, Gene P [mailto:gene.p.walt...@wv.gov] 
Sent: 06 September 2012 13:18
To: LINUX-390@vm.marist.edu
Subject: Oracle 11 not dropping from Queue 3

We recently upgraded two of our Linux/Oracle instances from Oracle Database 10 
to 11.  Since that upgrade, they don't ever seem to drop out of Q3 in VM.  Has 
anyone else experienced this and how can it be corrected?

Thanks


--
For LINUX-390 subscribe / signoff / archive access instructions, send email to 
lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Oracle 11 not dropping from Queue 3

[Damian Gallagher]

There's a webinar next week, where IBM (Dave Simpson, who wrote the white paper 
Dominic referenced), Oracle (me) and the zSeries Oracle SIG will be discussing 
this as one of the agenda items, details below

Cheers
Damian

Oracle, IBM and the zSeries Oracle SIG will be holding a Webcast on September 
11 th highlighting the latest information for Oracle Solutions and customer 
experiences on Linux running on IBM System z. 

This webcast is recommended for all customers involved with Oracle on this 
platform, including but not limited to, DBAs, developers and system 
administrators who are looking to get the most from their investment on System 
z. 

Please forward this invitation to all interested parties. 

About the SIG: 

The International zSeries Oracle Special Interest Group (SIG) is an 
organization of companies licensed for Oracle on Linux on System z and/or the 
z/OS operating systems on IBM System z hardware. 

There are no membership fees or obligations. 
Communications are done through mailings, emails and their website and annual 
user conference. 
For more information, please visit their website at  www.zSeriesOracleSIG.org

   Here are some highlights and instructions for attending the upcoming 
event: 

Topics will include: 

Latest news from IBM and Oracle on Linux on System z 
Top ten Oracle on Linux on System z technical hot topics 
The mission of the zSeries Oracle Special Interest Group (SIG) 
Setting future SIG communication plans, conferences and technical exchanges 
 

When: September 11, 2012 

Time: 9am PDT, 11am CDT, Noon EDT, 4pm GMT 

Please dial in 10 minutes prior to the call to provide registration information

Replay: One hour after the call is completed in consideration of other 
geographies and availability. 

 

Dial in information: 

Inside the United States: 1-866-803-2143 
Outside United States:  Please reference the table below 
Passcode: 

IBM Oracle zSeries SIG Update 
For security reasons, the passcode will be required to join the call. 
Presentation: 

Will be available for download 24 hours prior to the webcast at: 
 http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS4968 
Further information, including international dial in details, may be found 
here: http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS4968


-Original Message-
From: Walters, Gene P [mailto:gene.p.walt...@wv.gov] 
Sent: 06 September 2012 13:18
To: LINUX-390@vm.marist.edu
Subject: Oracle 11 not dropping from Queue 3

We recently upgraded two of our Linux/Oracle instances from Oracle Database 10 
to 11.  Since that upgrade, they don't ever seem to drop out of Q3 in VM.  Has 
anyone else experienced this and how can it be corrected?

Thanks


--
For LINUX-390 subscribe / signoff / archive access instructions, send email to 
lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Oracle 11 not dropping from Queue 3

[Damian Gallagher]

Just a note on why I need an SR. The workround isn't a secret, it's just that 
we have an enhancement request open to get this issue formally resolved, and 
every SR becomes a 'vote' on that enhancement, so the more distinct reports we 
have, the better. If you have this issue, open an SR, and ask for it to be 
directed to me. 

Cheers
Damian  

-Original Message-
From: Damian Gallagher [mailto:damian.gallag...@oracle.com] 
Sent: 06 September 2012 13:47
To: 'Linux on 390 Port'
Subject: RE: Oracle 11 not dropping from Queue 3

It's the new VKTM process, which has a very small wake up interval, keeping the 
process, and hence the guest active. Open an SR and I'll tell you how to work 
round it.

Cheers
Damian

-Original Message-
From: Walters, Gene P [mailto:gene.p.walt...@wv.gov] 
Sent: 06 September 2012 13:18
To: LINUX-390@vm.marist.edu
Subject: Oracle 11 not dropping from Queue 3

We recently upgraded two of our Linux/Oracle instances from Oracle Database 10 
to 11.  Since that upgrade, they don't ever seem to drop out of Q3 in VM.  Has 
anyone else experienced this and how can it be corrected?

Thanks


--
For LINUX-390 subscribe / signoff / archive access instructions, send email to 
lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Oracle compression

[Damian Gallagher]

Is this the OS level compression (tar, zip, etc) or an Oracle compression 
function ? 
What is the vendor's system ?
And if it's Oracle level, what exactly do you mean by " import an Oracle 
database template" ? That covers a lot of options, and we can go get a room to 
talk privately :-)

Cheers
Damian

-Original Message-
From: Melancon, Ruddy [mailto:melanc...@dot.state.al.us] 
Sent: 28 November 2012 17:29
To: LINUX-390@vm.marist.edu
Subject: Oracle compression

I have a user that is trying to import an Oracle database template to a vendor. 
 He is indicating that the compression in Linux on z and the vendor's system 
are different.  Has anyone run into this before?

I am running zVM 6.1 with SLES 11.1.  The Oracle is 10G I think.

Ruddy Melancon
Alabama Department of Transportation.




--
For LINUX-390 subscribe / signoff / archive access instructions, send email to 
lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Excel replacement for linux on z

[Damian Gallagher]

If it's anything like when I was an operator 
"Our operators run many excel vb macros for production on a windows pc." Means 
overtime calculations. Very very important..

Cheers
Damian

-Original Message-
From: Christian Langer [mailto:christian.lan...@zivit.de] 
Sent: 14 March 2013 09:08
To: LINUX-390@vm.marist.edu
Subject: Re: Excel replacement for linux on z

Excel is just not suited to be/to do something productive ;) Try to change to 
some real DB application with a webfrontend.
A LAMP stack comes to mind

Christian

Am 13.03.2013 20:37, schrieb Herczeg, Zoltan:
> Our operators run many excel vb macros for production on a windows pc. I 
> wanted to move this workload to a virtual linux machine on our ifl. Does 
> anyone have any suggestions for an excel replacement that will run on a linux 
> virtual machine under z/vm?
> 
> Thanks
> Zoltan
> 
> --
> For LINUX-390 subscribe / signoff / archive access instructions, send 
> email to lists...@vm.marist.edu with the message: INFO LINUX-390 or 
> visit
> http://www.marist.edu/htbin/wlvindex?LINUX-390
> --
> For more information on Linux on System z, visit 
> http://wiki.linuxvm.org/
> 

--
Zentrum für Informationsverarbeitung und Informationstechnik (ZIVIT)
   - Betriebliches Architekturmanagement -
 Dienstsitz Bonn, An der Küppe 2, 53225 Bonn
Telefon: +49-228/99-680-5199, Mobil: +49-172/2042527
Internet: http://www.zivit.de

--
For LINUX-390 subscribe / signoff / archive access instructions, send email to 
lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit http://wiki.linuxvm.org/

--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
--
For more information on Linux on System z, visit
http://wiki.linuxvm.org/

Re: Oracle replication from linux x86_64 to linux on z

[Damian Gallagher]

The full interoperability reference is here, which requires access to My Oracle 
Support:
Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data 
Guard Configuration [ID 413484.1]

Cheers
Damian


-Original Message-
From: Fernando Gieseler [mailto:fgiese...@gmail.com] 
Sent: 02 May 2013 13:37
To: LINUX-390@vm.marist.edu
Subject: Re: Oracle replication from linux x86_64 to linux on z

Mehdi,

A friend warned me about my (small) mistake. Actually only Linux on Power is 
compatible with Dataguard Physical Standby in zLinux as a primary database.

Of course, if we have a primary instance (in zLinux) and an standby instance(of 
Dataguard) with zLinux (with CBU's) is also supported, and I think most 
recommended.

Sorry again, and tks Sam!

Regards,

Fernando Gieseler


2013/4/30 Fernando Gieseler 

> Mehdi,
>
> For this propose, you can consider DataGuard solution, with System z 
> (as
> primary) and AIX Power (as bkp), I recommend Power to maintain the Big 
> Endian and Little Endian compatibility.
>
> I'm not sure if the Goldem Gate is the best way for a DR case, because 
> it not control the transaction commit (I think).
>
> But, anyway, is a good case to discuss!
>
> Regards,
>
> Fernando Gieseler
> Enviado pelo meu aparelho BlackBerryR
>
> -Original Message-
> From: Mehdi 
> Sender: Linux on 390 Port 
> Date: Tue, 30 Apr 2013 08:42:21
> To: 
> Reply-To: Linux on 390 Port 
> Subject: Re: Oracle replication from linux x86_64 to linux on z
>
> The best approach is standby, I mean we need a backup of DB's on Linux 
> z to be able to switch over when primary DB's (linux x86_64) fails...
>
>
> On 29 April 2013 20:14, Dodds, Jim  wrote:
>
> > Do you mean replicate or do you mean move or do you mean standby?
> >
> > Jim Dodds
> > Systems Programmer/DBA
> > Kentucky State University
> > 400 East Main Street
> > Frankfort, Ky 40601
> > 502 597 6114
> >
> >
> > -Original Message-
> > From: Linux on 390 Port [mailto:LINUX-390@VM.MARIST.EDU] On Behalf 
> > Of Robert J Brenneman
> > Sent: Monday, April 29, 2013 9:59 AM
> > To: LINUX-390@VM.MARIST.EDU
> > Subject: Re: Oracle replication from linux x86_64 to linux on z
> >
> > What do you mean by replicate?
> > a) Do you want to move the database entirely from x86_64 to s390x ? 
> > I suspect this can be done using Oracle's native dump and restore
> utilities.
> > b) Or do you want a hybrid HA cluster where some nodes are x86_64 
> > and others are s390x ? I do not believe this is possible.
> >
> > In either case, perhaps Damian the Oracle guy will respond with 
> > actual relevant experience. :)
> >
> >
> > On Mon, Apr 29, 2013 at 4:42 AM, Mehdi  wrote:
> >
> > > Hey Guys,
> > >
> > > Is there any best practice to replicate Oracle 10gR2 DB's from 
> > > linux
> > > x86_64 to Oracle on linux z? Is Golden Gate the right way? Any 
> > > experiences and ideas are welcome...
> > >
> > > Bests,
> > > Mehdi
> > >
> > > --
> > >  For LINUX-390 subscribe / signoff / archive access 
> > > instructions, send email to lists...@vm.marist.edu with the 
> > > message: INFO LINUX-390 or visit
> > > http://www.marist.edu/htbin/wlvindex?LINUX-390
> > > --
> > >  For more information on Linux on System z, visit 
> > > http://wiki.linuxvm.org/
> > >
> >
> >
> >
> > --
> > Jay Brenneman
> >
> > 
> > -- For LINUX-390 subscribe / signoff / archive access instructions, 
> > send email to lists...@vm.marist.edu with the message: INFO 
> > LINUX-390 or
> visit
> > http://www.marist.edu/htbin/wlvindex?LINUX-390
> > 
> > -- For more information on Linux on System z, visit
> http://wiki.linuxvm.org/
> >
> > 
> > -- For LINUX-390 subscribe / signoff / archive access instructions, 
> > send email to lists...@vm.marist.edu with the message: INFO 
> > LINUX-390 or visit
> > http://www.marist.edu/htbin/wlvindex?LINUX-390
> > 
> > -- For more information on Linux on System z, visit 
> > http://wiki.linuxvm.org/
> >
>
> --
> For LINUX-390 subscribe / signoff / archive access instructions, send 
> email to lists...@vm.marist.edu with the message: INFO LINUX-390 or 
> visit
> http://www.marist.edu/htbin/wlvindex?LINUX-390
> --
> For more information on Linux on System z, visit 
> http://wiki.linuxvm.org/
>

--
For LINUX-390 subscribe / signoff / archive access instructions, send email to 
lists...@vm.marist.edu with the message: INFO LINUX-390 or visit