Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_aqadm.create_queue_table problems - running under windows

Re: dbms_aqadm.create_queue_table problems - running under windows

From: Randy Nichols <randynichols_at_yahoo.com>
Date: Wed, 06 Aug 2003 01:38:20 GMT
Message-ID: <g_YXa.34990$Mc.2777375@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 Tue Aug 05 2003 - 20:38:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US