AQ Installing

Häkan Latva

unread,

Mar 6, 2006, 7:07:44 AM3/6/06

to

Hi all,

any refernces how to install AQ - is there any need to do anything to
listener..

All links appreciated...

rgds
HL

frank.va...@gmail.com

unread,

Mar 6, 2006, 8:46:14 AM3/6/06

to

Sigh... What version?

And no... no changes are required to the listener; why should it be?

DA Morgan

unread,

Mar 6, 2006, 12:28:11 PM3/6/06

to

What is required, depending on your version, is modification to the
PFILE/SPFILE. At a minimum:
aq_tm_processes=1
job_queue_processes=2

There is a complete AQ demo in Morgan's Library at www.psoug.org.

HTH
--
Daniel A. Morgan
http://www.psoug.org
damo...@x.washington.edu
(replace x with u to respond)

Häkan Latva

unread,

Mar 6, 2006, 11:40:14 PM3/6/06

to

> And no... no changes are required to the listener; why should it be?
>

Sigh - because I dont know if there would be - that is why asked

frank.va...@gmail.com

unread,

Mar 7, 2006, 4:32:12 AM3/7/06

to

Because a listener has *nothing* to do with Advanced Queuing.
Completely different subject. The question suggests you are quite new
to Oracle.

Häkan Latva

unread,

Mar 7, 2006, 5:52:14 AM3/7/06

to

<frank.va...@gmail.com> wrote in message
news:1141723932.3...@u72g2000cwu.googlegroups.com...

> Because a listener has *nothing* to do with Advanced Queuing.
> Completely different subject. The question suggests you are quite new
> to Oracle.
>

Sigh - thank you for answering nothing

Häkan Latva

unread,

Mar 7, 2006, 5:56:24 AM3/7/06

to

"DA Morgan" <damo...@psoug.org> wrote in message
news:11416660...@jetspin.drizzle.com...

Thanks Daniel,

this was a very useful post and tip...

Cannot say same fromother answers on this thread

HL

DA Morgan

unread,

Mar 7, 2006, 12:01:23 PM3/7/06

to

Don't abuse those trying to help you.

The obligation is your to go to http://tahiti.oracle.com and
read the concepts and architecture documents.

When you buy a car do you expect the dealer to teach you how
to drive?

We are the local car club ... not your driving instructor.

DA Morgan

unread,

Mar 7, 2006, 12:02:28 PM3/7/06

to

Be careful not to bite the hand that feeds you. We are here because
we want to share our knowledge. But you need to be gracious and
appreciate that no one is obligated to do so.

Best wishes with your project.

Häkan Latva

unread,

Mar 7, 2006, 11:12:38 PM3/7/06

to

>> The question suggests you are quite new Oracle.

Well, if answers are guality like this - I dont mind staying or asking
anything from this group - it basically means that beginners cannot ask
anything from this group - well, if that is what you're aiming at - I
promise not to disturb

Frank van Bortel

unread,

Mar 8, 2006, 3:11:16 PM3/8/06

to

Häkan Latva wrote:
> it basically means that beginners cannot ask
> anything from this group - well, if that is what you're aiming at - I
> promise not to disturb
>

Be my guest, stay away, and I am not sorry one bit to have
stepped on your adolescent toes.

It would have helped, if you started off with "I'm new
on this subject, so bear with me".
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

DA Morgan

unread,

Mar 8, 2006, 2:59:29 PM3/8/06

to

Not at all. But it is expected that people will try to help themselves.
So for example the following would be a good way to approach a question.
========================================================================
I have Oracle 10.2.0.1 running on RedHat Linux and I am trying to learn
AQ. I went to tahiti.oracle.com and found the following (provide link)
but when I try it it fails with an error message (ORA-01555 Snapshot
too old). Can someone please direct me to what this means and how to
resolve it.
========================================================================
What will get you a "please go away" response is something like this:

I am getting an error message when I try to run the create queue can
someone help me?