How to create a Oracle Queue?

[Feige]

Dear all,

I want to create a Queue to start oracle. system account is "system" while oracle account is "oracle".

Now Login as system account. I use
$SUBMIT/USER=oracle/QUEUE=ORACLE_AUTO ORA_AUTOSTART_YUSDB1.COM

ORA_AUTOSTART_YUSDB1.COM as follows:
$@ORAUSER YUSDB1
$SQLPLUS/NOLOG
CONNECT/AS SYSDBA
STARTUP
EXIT
$LSNRCTL START
$EXIT

I don't know how to create QUEUE,could you help me? or provide any sample? Thanks in advance

[Hoff · Accepted solution]

You'll certainly get pointers to the INITIALIZE command here, but I'd encourage you to learn this area in a bit more detail; between setting up the queue database and simply knowing how this stuff works will help you. (The specific answer here won't really help you...)

The basic steps for an OpenVMS batch queue are: Set up your queue database (if that's not already been done), and then set up your queue with INITIALIZE /QUEUE /BATCH, then set up your startup so the queue is started on boot.

That ORA_AUTOSTART_YUSDB1.COM stuff looks to be either Iracle or local stuff; not related to creating or starting a queue; that's what you want invoked either interactively or (with the SUBMIT command) via a batch queue.

The primary OpenVMS documentation is located here:

http://www.hp.com/go/openvms/doc

The INITIALIZE /QUEUE command:

http://h71000.www7.hp.com/doc/83FINAL/9996/9996pro_131.html#blue_119

The main descriptipon in the System Manager's Essentials Manual in the chapter _Managing the Queue Manager and Queue Database_ and here's the current manual:

http://h71000.www7.hp.com/doc/82FINAL/aa-pv5mj-tk/aa-pv5mj-tk.HTMl

Finding some startup-related queue-related discussions (and keywords that can be used in subsequent searches, and back in the documentation) on your local system using the SEARCH command:

$ search sys$startup:systartup_vms.template "queue" /window=9

[Feige]

Thanks! I will try.