Re: dbms_aqadm.create_queue_table problems - running under windows

The following procedure seemed to solve the problem:

1. Install Oracle 9.2
2. Create database and Oracle Advanced queues.
3. Apply 9.2.0.3 upgrade patch.
4. Run "migrate" scripts to upgrade the database to patch level

It seems if we patch Oracle 9.2 to 9.2.0.3 before creating the database and queues, we get the error mentioned previously.

-Randy Nichols

"Randy Nichols" <randynichols_at_yahoo.com> wrote in message news:g_YXa.34990$Mc.2777375_at_newsread1.prod.itd.earthlink.net...
> I forgot to mention Oracle 9.2.0.3 is running under Windows 2003 on one
> server and Windows NT4 on another. Both exhibit same problem with
> dbms_aqadm.create_queue_table()
>
> -Randy Nichols
>
> "Randy Nichols" <randynichols_at_yahoo.com> wrote in message
> news:SMYXa.34979$Mc.2776301_at_newsread1.prod.itd.earthlink.net...
> > Would you elaborate some more on semaphore settings, or point me to a
> > reference?
> >
> > I've installed Oracle 9.2 as full as I can (Enterprise configuration)
and
> > applied the 9.2.0.3 patch.
> >
> > On every machine I've installed, I get the same problem when executing
the
> > dbms_aqadm.create_queue_table() proc.
> >
> > Is there any special feature needed for Oracle queues?
> >
> > -Randy
> >
> > "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> > news:sa00jv87gevfff8ffg2m96bh6mvducg8jm_at_4ax.com...
> > > On Tue, 05 Aug 2003 18:54:23 GMT, "Randy Nichols"
> > > <randynichols_at_yahoo.com> wrote:
> > >
> > > >Are you referring to the <oracle
> > > >home>/admin/<database>/bdump/alert_<database>.log and the udump/...
> > files?
> > > >
> > > >There was nothing meaningful I could see in the alert...log file, and
> the
> > > >udump/ files had none of today's date that would relate to my
> operations.
> > > >
> > > >-Randy
> > >
> > > He definitely is referring you to those files. However, in my
> > > experience 3113's never result in an user trace file.
> > > One is inclined to think you have problems with your semaphore
> > > settings. This is one of the most common causes for the 3113 problem
> > >
> > >
> > > Sybrand Bakker, Senior Oracle DBA
> > >
> > > To reply remove -verwijderdit from my e-mail address
> > >
> >
> >
> >
>
>
>
Received on Wed Aug 06 2003 - 18:17:56 CDT