dbTalk Databases Forums  

The penny hasn't dropped yet...

comp.databases.oracle.server comp.databases.oracle.server


Discuss The penny hasn't dropped yet... in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Noons
 
Posts: n/a

Default Re: The penny hasn't dropped yet... - 03-03-2010 , 04:41 PM






On Mar 4, 4:58*am, joel garry <joel-ga... (AT) home (DOT) com> wrote:


Quote:
I strongly agree with the sentiments in this thread. *But, here I have
to point out how common it is, to the point of being the mode, that
people won't supply the necessary information up front (right
Sybrand? :-) . *From that viewpoint, it merely becomes an issue of
Not really. If you look at the SR entry process, the basics of
information are all there: type of licence, release number and patch
level, OS/hardware. And the ability to load trace files and other
supporting evidence. As well as clear instructions asking if possible
to provide a simplified reproducible case. That's a heap more than
the usual Usenet "help" entry and has served well before, why would it
not be effective now?


Quote:
Where they cross the line is grabbing all information ever possibly
needed.
And not needed. That is the problem.


Quote:
*Think of this: *if you have everyone upload all their trace
files, you can mine that to create a decision support tool that can
automate much trace file analysis. *I'm sure you can name popular and
not-so-popular people who have done that. *So why not generalize
that?
I disagree. Support is not reducible to a mechanized, half-arsed
pseudo-AI tool cobbled together from past information. Each release
of Oracle has its own problems with new features - as well as a fair
share of others that are common with previous releases - most
unfortunately, but it's a fact! Any attempt to automate analysis of
SRs in such a climate is doomed to even more overhead, while still
needing specialist work. The notion that every SR can be analyzed
upfront by such a tool is doomed, like so many other prior attempts at
the same: nothing new here, it's not even a new idea. Tried before,
never worked, never will: software is not some immutable universe
definable by a static rule set.


Quote:
Well, what if that ORA-600 is hidden under several levels of
technology stack? *Way before you get there, you may indeed need to
follow the problem including over the network. *
Not at all. Ora-600 is an internal error in Oracle code. Period.
What causes it may be a simple command in sqlplus, or a very complex
chain of events starting with the fluttering of a butterfly's wings in
China. It still is an internal error in Oracle kernel code and needs
to be treated as such. Forget the rest: it's got nothing to do with
geography or entomology!


Quote:
I would think most
support calls are of the form "my program isn't working,"
Sure. And how/where is OCM going to help there?


Quote:
I'm sure
ora-600's are pretty scarce in the overall scheme of Oracle support.
I wish... I've hit 13 of them in the last year alone...


Quote:
there quick. *But if I'm getting a java virtual error, I'm just as
newbie as "my program isn't working" and I think an RDA is probably
appropriate. *OCM is just a proactive version of that, isn't it? *The
Network Is The Computer. *And OCM puts all your Oracle usernames into
a world readable file. *Sigh.
I don't have a problem with a tool that collects basic information
*about Oracle configuration*. Like hell I'm gonna let lose a tool in
my servers that collects information about the network itself, its
setup and most secure information. Read on about the arp command,
present in any pc although few know what it can do.
No way it's gonna happen. Period.

Reply With Quote
  #12  
Old   
Noons
 
Posts: n/a

Default Re: The penny hasn't dropped yet... - 03-03-2010 , 04:50 PM






On Mar 4, 5:23*am, John Hurley <johnbhur... (AT) sbcglobal (DOT) net> wrote:

Quote:
You do not need to run the Oracle Config Manager "live" you can run it
disconnected so that it gathers the config information required to get
an SR moving and then you can feed in the output.
John, please! I am *fully* aware of how OCM can be run: I installed
and examined it AGES ago. It is a viral tool. It has no place ANYWHERE
in a modern data centre. Period.

Quote:
Since you can gather the information disconnected you are free to look
at all this information before you ship it into Oracle.
I am not even remotely interested in wasting my time filtering what is
sent to Oracle: my employer doesn't pay me to do Oracle's work. Is
that clear?


Quote:
As long as Oracle support makes up the rules about "necessary"
information ... well there's not much we can do if we need them to
work on an SR.
Guess what: we are the paying client of a service, we make the rules.
Basic law of business, as well as common law.
Oracle better not forget that...


Quote:
You can try going up the support foodchain without supplying it.
You bet. And I can also make my next support payment dependent on
Oracle changing their attitude.

Reply With Quote
  #13  
Old   
Noons
 
Posts: n/a

Default Re: The penny hasn't dropped yet... - 03-03-2010 , 05:06 PM



On Mar 4, 12:52*am, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:

Quote:
They're really pushing it hard! They want to be able to charge for
licenses automatically. The results are really beginning to show, on the
OUG meetings first. The NYOUG in the last October was a disaster, pure
marketing pitch, mostly by Oracle and a few satellites. None of my
colleagues was there, it was a loss of time. I will not attend the spring
meeting. I don't know of any DBA (v1.0, of course) who is not
Oh, the OUG has stopped being minimally relevant years ago. Once it
was opened to control by external parties to peddle their wares and
services instead of being run by users, the end of its usefulness was
obvious.
Only fools who thought it was a "great marketing avenue" kept showing
up: real users left years ago.
We formed a new dba one last year and it's been a success, with
relevant matters being discussed and frequent meetings. Much more
useful. Thank Pythian for that.
Of course Oracle hasn't even offered to help, although their folks
seem to be keen to show up and eat pizza at our expense...


Quote:
practices too. Selling the product and then charging for the ability to
tune it is morally dubious, to say the least. That is the primary reason
That one is such a customer relations disaster! I wonder who is the
genius that thought that one up and if he/she has been called to
explain the outcome.
But knowing how things work in big corporations, probably a VP by
now...


Quote:
license. Instead of a nice company that I was proud to recommend to my
management, Oracle became a corporate bully that I am trying to avoid at
all costs, whenever I can. Sic transit gloria mundi.
Ah well: not just you, I'm sure...

Reply With Quote
  #14  
Old   
joel garry
 
Posts: n/a

Default Re: The penny hasn't dropped yet... - 03-03-2010 , 07:41 PM



On Mar 3, 1:50*pm, Noons <wizofo... (AT) gmail (DOT) com> wrote:
Quote:
On Mar 4, 5:23*am, John Hurley <johnbhur... (AT) sbcglobal (DOT) net> wrote:
(Note for lurkers, I agree with pretty much everything Noons said
besides the following)

Quote:
Guess what: we are the paying client of a service, we make the rules.
Basic law of business, as well as common law.
Oracle better not forget that...
Not hardly. There are presumptions there of equal footing that just
don't apply. It seems apparent Oracle is well aware they can simply
wear down anyone who starts chest-thumping about lawsuits. They
_should_ treat us as though we make the rules, but google "fire your
customers" which is making the rounds again thanks to Seth Godin.
More realistically, there are just so many customers that a few
squeaks are a cost of doing business. Dropped penny? More like
http://www.youtube.com/watch?v=tAVYYe87b9w

Quote:
You can try going up the support foodchain without supplying it.

You bet. *And I can also make my next support payment dependent on
Oracle changing their attitude.
As Rocky would say to Bullwinkle "that trick never works." Bullwinkle
usually pulls out something like
http://1.bp.blogspot.com/_F3F2-KgbhT..._magic-hat.jpg

But I suppose it's a nice dream.

jg
--
@home.com is bogus.
The $29M Captcha challenge:
http://www.google.com/hostednews/ap/...KD30AD9E64CGG1

Reply With Quote
  #15  
Old   
John Hurley
 
Posts: n/a

Default Re: The penny hasn't dropped yet... - 03-04-2010 , 08:51 AM



On Mar 3, 4:50*pm, Noons <wizofo... (AT) gmail (DOT) com> wrote:

snip

Quote:
John, please! *I am *fully* aware of how OCM can be run: *I installed
and examined it AGES ago. It is a viral tool. It has no place ANYWHERE
in a modern data centre. Period.
Chill dude. Your posting here made it a little unclear to me at least
what you were aware of here.

You don't really have any choice about installing it ... it comes with
the software. New patchsets and maintenance that goes into the system
keeps updating it.

About the only choices that we have here is how we configure it ... if
we configure it ... and if we use it ... how we use it.

Quote:
Since you can gather the information disconnected you are free to look
at all this information before you ship it into Oracle.

I am not even remotely interested in wasting my time filtering what is
sent to Oracle: my employer doesn't pay me to do Oracle's work. Is
that clear?
If your employer pays you to support Oracle databases then anything
relevant to Oracle support probably comes under your discretion in
some regard. What you choose to do is obviously up to you.

Quote:
As long as Oracle support makes up the rules about "necessary"
information ... well there's not much we can do if we need them to
work on an SR.

Guess what: we are the paying client of a service, we make the rules.
Basic law of business, as well as common law.
Oracle better not forget that...
Maybe we don't speak the same language apparently.

I don't see anyone here arguing against the idea that we don't like
what has been forced on us.

Quote:
You can try going up the support foodchain without supplying it.

You bet. *And I can also make my next support payment dependent on
Oracle changing their attitude.
The unfortunate situation is that Oracle customers need a support
contract to be able to download patches/patchset updates/patchsets
along with new releases etc.

Reply With Quote
  #16  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: The penny hasn't dropped yet... - 03-04-2010 , 10:53 AM



On Thu, 04 Mar 2010 05:51:37 -0800, John Hurley wrote:

Quote:
You don't really have any choice about installing it ... it comes with
the software. New patchsets and maintenance that goes into the system
keeps updating it.
Actually, you do. I consistently refuse to give it my CSI.



--
http://mgogala.byethost5.com

Reply With Quote
  #17  
Old   
joel garry
 
Posts: n/a

Default Re: The penny hasn't dropped yet... - 03-04-2010 , 01:19 PM



On Mar 4, 7:53*am, Mladen Gogala <n... (AT) email (DOT) here.invalid> wrote:
Quote:
On Thu, 04 Mar 2010 05:51:37 -0800, John Hurley wrote:
You don't really have any choice about installing it ... it comes with
the software. *New patchsets and maintenance that goes into the system
keeps updating it.

Actually, you do. I consistently refuse to give it my CSI.

That's not good enough. It still keeps running and trying to call
home by default. Just 'cause it doesn't succeed doesn't mean you
don't have to actively configure it to turn it off. So have you
figured out all the things it is doing and all the resources it is
taking up? (That's the editorial ranting you, not you in particular).

From the readme:

------------------------------------ begin inclusion

Enabling/Disabling collection of IP and MAC addresses:
-----------------------------------------------------

With the 10.2.5.0.0 release of Oracle Configuration Manager, the user
now
has the ability to disable the collection of specific configuration
items. The
only two configuration items that can be disabled are the collection
of the
host IP address and the Network Interface MAC accress. By default,
these
configuration items are collected.

To disable their collection, add a property to the
collector.properties file
in $ORACLE_HOME/ccr/config.

Add the following line to disable the collection of the host IP
address:

ccr.metric.host.ecm_hw_nic.inet_address=false

Add the following line to disable the Network Interface MAC address
collection:

ccr.metric.host.ecm_hw_nic.mac_address=false

The metric(s) are re-enabled by removing the corresponding line from
the
collector.properties file.

------------------------------------ End inclusion

Did not giving the CSI prevent /oracle/app/oracle/product/10.2.0/db_1/
ccr/config/default/targets.xml from having your hostname? Have you
checked where ccr.endpoint points to in ccr.properties? (If I were a
bad guy, perhaps that's where I'd go to make your system give me your
information. If I knew how it worked). How about those funnily named
xml files in ccr/state?

find $ORACLE_HOME/ccr -exec grep -l db_users {} \; -exec ll {} \;

jg
--
@home.com is bogus.
Well, Oracle me to tears! http://weblogs.java.net/blog/2009/06...ill-oracle-you

Reply With Quote
  #18  
Old   
John Hurley
 
Posts: n/a

Default Re: The penny hasn't dropped yet... - 03-04-2010 , 07:47 PM



On Mar 4, 10:53*am, Mladen Gogala <n... (AT) email (DOT) here.invalid> wrote:

snip

Quote:
You don't really have any choice about installing it ... it comes with
the software. *New patchsets and maintenance that goes into the system
keeps updating it.

Actually, you do. I consistently refuse to give it my CSI.
Ummm that's the configuring part and using it part ... not the
installing part.

Reply With Quote
  #19  
Old   
Noons
 
Posts: n/a

Default Re: The penny hasn't dropped yet... - 03-04-2010 , 09:41 PM



On Mar 4, 11:41*am, joel garry <joel-ga... (AT) home (DOT) com> wrote:


Quote:
Not hardly. *There are presumptions there of equal footing that just
don't apply. *It seems apparent Oracle is well aware they can simply
wear down anyone who starts chest-thumping about lawsuits. *They
_should_ treat us as though we make the rules, but google "fire your
customers" which is making the rounds again thanks to Seth Godin.
Interesting concept. And one of the many reasons why we ghave a GFC
that everyone knows how to correct and yet no one has been able to
fix. Somewhere in all that there is an element of reality missing...

Quote:
More realistically, there are just so many customers that a few
squeaks are a cost of doing business. *Dropped penny? *More likehttp://www.youtube.com/watch?v=tAVYYe87b9w
Yeah, I know. But no matter how many companies Oracle buys to offset
the lack of growth in DB business, there will be soon a day where
reality will catch up.



Quote:
You bet. *And I can also make my next support payment dependent on
Oracle changing their attitude.

As Rocky would say to Bullwinkle "that trick never works." *Bullwinkle
usually pulls out something likehttp://1.bp.blogspot.com/_F3F2-KgbhTc/SWAl_9WnUxI/AAAAAAAAAvM/ESUslxK...
LOL!

Quote:
But I suppose it's a nice dream.
One that'll cost them a coupla hundred grand a year.
And that's just one customer...

Reply With Quote
  #20  
Old   
Noons
 
Posts: n/a

Default Re: The penny hasn't dropped yet... - 03-04-2010 , 09:52 PM



On Mar 5, 12:51*am, John Hurley <johnbhur... (AT) sbcglobal (DOT) net> wrote:

Quote:
Chill dude. *Your posting here made it a little unclear to me at least
what you were aware of here.
You are right: sorry. Chilled.


Quote:
You don't really have any choice about installing it ... it comes with
the software. *New patchsets and maintenance that goes into the system
keeps updating it.
Wanna bet?
$cd $ORACLE_HOME/ccr
ksh: /u01/app/oracle/product/10.2.0/db_1/ccr: not found.
$

qed.

Quote:
About the only choices that we have here is how we configure it ... if
we configure it ... and if we use it ... how we use it.
One of the reasons why I spent a few months looking into it.
Initially with the best of intentions, but as I learned more and more
of what it does, with the single intention of disabling it once and
for all.


Quote:
If your employer pays you to support Oracle databases then anything
relevant to Oracle support probably comes under your discretion in
some regard. *What you choose to do is obviously up to you.
Exactly. I chose to let Oracle support do their work, not me.
There is a marked difference between supporting a database that
happens to use Oracle software and supporting Oracle software: the two
are far from interchangeable.


Quote:
The unfortunate situation is that Oracle customers need a support
contract to be able to download patches/patchset updates/patchsets
along with new releases etc.
Oracle used to sell separate upgrade licensing and support licensing,
back in the pre-6 days.
Guess why they bundled both into a single licence?
I wonder if anyone ever tested the legality under common law of them
doing so...

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.