Re: dbms_aqadm.create_queue_table problems - running under windows

Randy Nichols wrote:

> 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

If you are running on Windows forget semaphores and kernel settings. From my experience I'd use oradim to drop and recreate the Windows services. Failing that ... go to metalink, do some research, and open an iTAR if all else fails.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)