Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Qspace deletion

Nagaraj RanganathMar 7 2019 — edited Mar 12 2019

I seem to have messed up in the way I cleaned up a Qspace.

Now, neither can I remove the device (using command dsdl) nor can I re-create the deleted Qspace.

My lidl command shows

> lidl

Universal device index 0:

        name: <The complete queue path>

        start: 0

        size: 400

        free space map: 1 entry used 47 available

> dsdl 0

Are you sure? [y, n] y

Q_CAT:1147: ERROR: Cannot destroy device 0 on <the complete queue path>

It doesn't let me create the QSPACE (nor open)

> qspacecreate

Queue space name: MY_QSPACE

IPC Key for queue space: 8005

Size of queue space in disk pages: 350

Number of queues in queue space: 2

Number of concurrent transactions in queue space: 10

Number of concurrent processes in queue space: 10

Number of messages in queue space: 50

Error queue name: errque

Initialize extents (y, n [default=n]): y

Blocking factor [default=16]:

Q_CAT:1428: ERROR: Queue space creation - failed to create table MY_QSPACE.00, size 348 on config <the complete queue path>

Q_CAT:1295: ERROR: Queue space creation failed

Not sure what's holding the cleanup ( so that it lets me re-create).

Comments
Post Details
Added on Mar 7 2019
6 comments
525 views