Oracle 9i DBMS Packages

[Darren Etheridge_2]

We currently have Oracle 9i installed on our HP 9000 machine running HPUX 11.23. I need to install the DBMS pacakges (for job scheduling, per our vendor of the software we are using). How do I install the DBMS packages ? Any help would be GREATLY appreciated :)

Darren

[Horia Chirculescu · Accepted solution]

Hello,

The package (DBMS_JOB)is created when Oracle is installed. The installation script for this package is called dbmsjob.sql (this is called by catproc.sql which is run after database creation).

You must create the background process(es) for the job queue by setting an initialization parameter in init.ora.

job_queue_processes=...

Read the ORACLE docs about this parameter. I use to set up this parameter with the number of active processors/cores from the system.

Best regards,
Horia.