How it is running?
Any spesific advices?
EM64T looks interesting.

Thanks 

On Nov 9, 9:43=A0am, "Jack" <n...@INVALIDmail.com> wrote:
> How it is running?
> Any spesific advices?
> EM64T looks interesting.
>
> Thanks

What's Win2k8R2?  Windows 2000?  Maybe is there a windows 2008?

Sorry you lost me here ...

Best advice is to not run Oracle on windows and go for real unix/linux
systems.

On Tue, 09 Nov 2010 12:48:49 -0800, John Hurley wrote:

> On Nov 9, 9:43 am, "Jack" <n...@INVALIDmail.com> wrote:
>> How it is running?
>> Any spesific advices?
>> EM64T looks interesting.
>>
>> Thanks
> 
> What's Win2k8R2?  Windows 2000?  Maybe is there a windows 2008?
> 
> Sorry you lost me here ...
> 
> Best advice is to not run Oracle on windows and go for real unix/linux
> systems.

Does that mean that Windows is a some sort of a unix system, but not the 
real one? The OP asked a perfectly legitimate question. I felt an impulse 
to jovially respond with "don't", but was able to refrain from such a 
childish act. BTW, it will be interesting to see the "real systems" with
the write barriers in 2.6.32+:

http://lxr.free-electrons.com/source/Documentation/filesystems/ext4.txt
http://www.spinics.net/lists/xfs/msg00081.html

If nothing else, NTFS is a mature file system which can beat Ext3, Ext4  
ReiserFS and similar toys hands down when it comes to I/O performance.
NTFS has extents and defragmentation for years, Ext3 suffers a from 
fragmentation and slows down considerably if a multitude of small files, 
for instance with extensions like "*.trc", "*.aud" or "*.arch" are  
regularly written to and deleted from disk. Ext4, on the other hand, has 
extents to help deal with the problem, but no defragmenter:

http://ubuntuforums.org/showthread.php?t=1201298 (look at the reply by 
Nick Rhodes).

People who have created NTFS must be laughing to tears while looking at 
all of that. The mess is, of course, partially created by Linus Torvalds 
himself and his diatribe against O_DIRECT:

http://lkml.org/lkml/2007/1/10/233


As a matter of fact, Linux is in a sorry state these days. Buggy, having 
performance problems and having finally lost the battle for the hearts 
and minds: http://tinyurl.com/26tawax

I must say that running Oracle on top of Windows 7 is much less 
preposterous than it sounds. Windows, once again, rules supreme on the 
desktop, Oracle will likely mess up OpenOffice, the performance of 
Windows 7 server is not at all bad. I tested it myself and it beats down 
even a well tuned Red Hat 5.5 system on the same machine. It doesn't beat 
it down by much, but, to my surprise, the Windows 7 Server was the clear 
winner of our internal in-house test. It was a very lax setting, not a 
formal benchmark, so I cannot publish the results, but I must say that I 
was surprised by them. Windows 7 is a very solid animal, as well as NTFS, 
and our local SA was able to tune it quite well. The database was Oracle 
RDBMS 11.2.0.1 on both machines, with filesystemio_options was set to 
"setall" on both configurations, disks were SAN disks on an old HP MSA 
disk array which went out of support and is no longer used for production 
systems. The system has 2 quad-core AMD processor units and 16GB of RAM.
Linux was Red Hat 5.5 x86-64, with all the disks formatted as Ext3, while 
Windows was represented with 64-bit Windows 7 Server. Application was 
home grown. 


-- 
http://mgogala.byethost5.com

On Nov 10, 8:29=A0am, Mladen Gogala <n...@email.here.invalid> wrote:


> childish act. BTW, it will be interesting to see the "real systems" with
> the write barriers in 2.6.32+:
>
> http://lxr.free-electrons.com/source/Documentation/filesystems/ext4.txtht=
tp://www.spinics.net/lists/xfs/msg00081.html

Yegawds!  More madness...


> If nothing else, NTFS is a mature file system which can beat Ext3, Ext4 =
=A0
> ReiserFS and similar toys hands down when it comes to I/O performance.

Why on earth hasn't the Linux development community learned from full-
strength file systems such as xfs - and others - instead of
perpetually trying to re-invent the wheel?
"Not invented here" is rampant, in those circles!...


> People who have created NTFS must be laughing to tears while looking at
> all of that. The mess is, of course, partially created by Linus Torvalds
> himself and his diatribe against O_DIRECT:
>
> http://lkml.org/lkml/2007/1/10/233

Lovely.  He's an expert in data management and file system
architecture now, as well? The man must be a God, such is his
infallibility and endless knowledge about everything...

Of course dbs don't need to use anything else than the page cache!
Next mad idea?...


> As a matter of fact, Linux is in a sorry state these days. Buggy, having
> performance problems and having finally lost the battle for the hearts
> and minds:http://tinyurl.com/26tawax

Indeed. True for desktops. For servers, I still have my doubts and
hold hope high.

But fine tuning Linux/Oracle servers still involves a lot of
unnecessary "black arts", inadmissible this day and age.  Look at the
whole rigmarole with hugepages and the heaps of conflicting info out
there on why/how/when to use it, most of it against.

This, when IBM, Dijkstra and many others proved beyond any doubt why
it'd be needed once we got into 64-bit hardware and very large memory,
35 years ago!  It's got nothing to do with OSs and all to do with TLB
size and virtual memory translation.

Talk about no clue...  Indeed it is true that those who refuse to
learn from history are forever comdemned to endlessly repeat the same
mistakes.

Sure: it's easy to hire an "expert" to come in and fix things up.
Problem is: why should one be needed for something as basic?

Ah well: let's hope they don't learn the lesson too late.
Don't hold your breath...

"Mladen Gogala" <no@email.here.invalid> wrote in message 
news:pan.2010.11.09.21.29.40@email.here.invalid...

10+++

Thanks 

On Nov 9, 8:48=A0pm, John Hurley <hurleyjo...@yahoo.com> wrote:
>
> What's Win2k8R2? =A0Windows 2000? =A0Maybe is there a windows 2008?

Microsoft Windows 2008 Release 2.

> Sorry you lost me here ...
>
> Best advice is to not run Oracle on windows and go for real unix/linux
> systems.

Some of us dont' have any choice, sadly.  However, as much as I hate
to admit it, Windows 2008 64-bit does resemble a real O/S!

Mind you, why I still have to be warned "if you change a file name
extension, the file may become unusable" or why I need a cute animated
dog to help me "search" for files on a adult's operating system is
beyond me!

Possibly these things can be altered by changing system settings
somewhere, but surely an enterprise server's O/S should be set to
"adult" out of the box!

On Wed, 10 Nov 2010 03:37:55 -0800, gazzag wrote:

>  However, as much as I hate
> to admit it, Windows 2008 64-bit does resemble a real O/S!

Yes it does. Don't get me wrong, I am an old Unix/Linux hack who is used 
to working in Unix environment. I would love nothing better than to see 
Linux succeed. Unfortunately, there is a carnival of vanities, there are 
many commercial interests and there are many inhabitants of the lovely 
kingdom of Id that will probably see to it that Linux gets as messed up 
as Windows, if not even more. What the heck, Linux is open!



-- 
http://mgogala.byethost5.com

On Nov 10, 3:37=A0am, gazzag <gar...@jamms.org> wrote:
> On Nov 9, 8:48=A0pm, John Hurley <hurleyjo...@yahoo.com> wrote:
>
>
>
> > What's Win2k8R2? =A0Windows 2000? =A0Maybe is there a windows 2008?
>
> Microsoft Windows 2008 Release 2.
>
> > Sorry you lost me here ...
>
> > Best advice is to not run Oracle on windows and go for real unix/linux
> > systems.
>
> Some of us dont' have any choice, sadly. =A0However, as much as I hate
> to admit it, Windows 2008 64-bit does resemble a real O/S!
>
> Mind you, why I still have to be warned "if you change a file name
> extension, the file may become unusable" or why I need a cute animated
> dog to help me "search" for files on a adult's operating system is
> beyond me!
>
> Possibly these things can be altered by changing system settings
> somewhere, but surely an enterprise server's O/S should be set to
> "adult" out of the box!

Now I have images of doggies doing "adult" things in my head.

I must say, I came to the conclusion long ago linux was incompatible
with commercial interests - and certainly my personal desktop
interests - but didn't really know if it was just me being a dinosaur
and being wishful about all the effort being expended would be better
spent on real unix.  I feel validated with Mladen's "carnival of
vanities" post.

I still find my own biases seem out of step with reality anyways.  NT
was VMS redux, Xenix --> SCO was a Bill Gates production, Larry and
mysql... it's all wtf?

jg
--
@home.com is bogus.
If at first you don't succeed, feed 'em spam.
http://www.signonsandiego.com/news/2010/nov/09/navy-carrier-helps-stranded-=
cruise-ship-san-diego/
Maybe they should've airlifted in some street-taco vendors...

Joel:

# I must say, I came to the conclusion long ago linux was incompatible
with commercial interests - and certainly my personal desktop
interests - but didn't really know if it was just me being a dinosaur
and being wishful about all the effort being expended would be better
spent on real unix. =A0I feel validated with Mladen's "carnival of
vanities" post.

Ummm ... well around here lots of fairly big companies running lots of
database systems on linux.  Not too many problems in general with a
mix of preferences including RedHat and OEL being the most popular
platforms.

Just tons of people at Open World this year who have gone the fully
monty over to linux for their database servers.

After Larry paraded the penguins around on stage a couple of years
there is no going back.  You can find highlights from OOW this
year ... Larry talked for a long time about how Oracle will be
developing/maintaining/enhancing and supporting linux.

Was I somewhat skeptical this year going to OOW ( and after we have
moved to OEL ) after the Sun purchase.  You know it.  Did I come away
with any leftover nervousness ... not at all.

Nothing wrong with Solaris and from a long time back I used to do
admin work on it ( for the database and app servers ).

Neither linux or Solaris is going to be left behind by Oracle.

On Wed, 10 Nov 2010 12:24:47 -0800, John Hurley wrote:

> Ummm ... well around here lots of fairly big companies running lots of
> database systems on linux.  Not too many problems in general with a mix
> of preferences including RedHat and OEL being the most popular
> platforms.

Linux is cheaper. That is the reason. 

> 
> Just tons of people at Open World this year who have gone the fully
> monty over to linux for their database servers.

Fully Monty? 



-- 
http://mgogala.byethost5.com

"Mladen Gogala" <no@email.here.invalid> wrote in message 
news:pan.2010.11.10.16.52.37@email.here.invalid...
> On Wed, 10 Nov 2010 03:37:55 -0800, gazzag wrote:
>

After restart (Win7-64b =about 2k8R2:)  rdbms alerts "Beginning crash 
recovery"
I think it (OS) does not shutdown database, there was somewere
some bat-file when shutding down OP.
Or what could fix this? 

Jack:

# After restart (Win7-64b =3Dabout 2k8R2:) =A0rdbms alerts "Beginning
crash recovery"

.... I think it (OS) does not shutdown database, there was somewere
some bat-file when shutding down OP. Or what could fix this?

There should be a windows service installed that handles starting up
and shutting down a database.  In windows probably an auto start type
of thing.

I think it is a really really bad idea to automate starting a database
on a server reboot.  What if you were having some kind of storage
problem or hardware problem etc that is not yet diagnosed and/or fixed
completely.

The last thing in the world you want to happen is several restarts in
a row where Oracle may be trying to recover things and may have dicey
and/or incomplete view of the environment.

My recommendation is to disable windows services ( and unix/linux
similar things ) that start up database automatically.  Take control
of those decisions!

On Nov 17, 6:39=A0am, "Jack" <n...@INVALIDmail.com> wrote:
> After restart (Win7-64b =3Dabout 2k8R2:) =A0rdbms alerts "Beginning crash
> recovery"
> I think it (OS) does not shutdown database, there was somewere
> some bat-file when shutding down OP.
> Or what could fix this?

Check your Services applet.  Start -> Run ->  Services.msc

There should be a service called "OracleService<instance_name>".  This
service is responsible for starting and stopping the Oracle instance.
As John Hurley suggested, I would ensure that this service is set to
"manual".

Then I would shut the database down, rename the current alert log and
reboot the server.  Check your Event Log after startup for any clues,
then start the Oracle service you set to manual above then re-examine
the alert log.

HTH
-g

On Nov 16, 10:39=A0pm, "Jack" <n...@INVALIDmail.com> wrote:
> "Mladen Gogala" <n...@email.here.invalid> wrote in message
>
> news:pan.2010.11.10.16.52.37@email.here.invalid...
>
> > On Wed, 10 Nov 2010 03:37:55 -0800, gazzag wrote:
>
> After restart (Win7-64b =3Dabout 2k8R2:) =A0rdbms alerts "Beginning crash
> recovery"
> I think it (OS) does not shutdown database, there was somewere
> some bat-file when shutding down OP.
> Or what could fix this?

See MOS Database Does Not Shutdown Cleanly When Oracle Service Is
Restarted [ID 437876.1]

There is a long-running dispute between how MS and Oracle handle this,
I don't know the Win7+modern Oracle aspects, if any.  I may be doing
such an installation at some unknowable point in the future, depending
on a vendor demo in another department, so I'd be interested in what
you find.

I have mixed feelings about auto restart, I've seen bigtime screwups
as John described, but since I'm on a system where I have complete
control, I autostart production, since the usual case is some one-time
thing once a year, while multi-restarts are either a place with bad
communications between departments with distributed control (like the
hardware maintainer comes in and pulls the plug, thinking everything
was ready), or a hardware issue so bad it means moving to another box
anyways.  Standbys are a good thing, YMMV.

jg
--
@home.com is bogus.
Those darn computer glitches! http://www.signonsandiego.com/news/2010/nov/1=
6/computer-glitches-stall-city-audit/

"joel garry" <joel-garry@home.com> kirjoitti 
viestiss�:a2db7bf2-8f52-4677-8c06-f3e14ca94dd2@w21g2000vby.googlegroups.com...
On Nov 16, 10:39 pm, "Jack" <n...@INVALIDmail.com> wrote:
> "Mladen Gogala" <n...@email.here.invalid> wrote in message
>
snip
> I'd be interested in what you find.
jg
--
@home.com is bogus.
Those darn computer glitches! 
http://www.signonsandiego.com/news/2010/nov/16/computer-glitches-stall-city-audit/
--------------------------------

Note, value of 0,05?

w2k3 OK.
w2k8x64 (x86) not matured, good try but not 100% valid. Better luck next 
time/next year.
Rigths to change opinion reserved :)
Lets see what tomorrow will show in servers/farms/clouds, hope to have good 
mood (by sailing/ambiguous term Hyv�ll� tuulella ).

Thanks -Jack-
just one a bit "angry bird "
http://musicwn.com/browse.php?artist=Mikko+Kuustonen&album=Hyv%C3%A4ll%C3%A4+tuulella
http://download.mtv3.fi/album/Mikko_Kuustonen/30_Unohtumatonta_Laulua/5C7A22D6-6B7B-4AB8-B998-DB29E075499E/