Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1130
  • Last Modified:

Error When Creating Oracle 11g EM

When running the following I get what happened below not sure what to do from here:

C:\Users\Joe>emca -config dbcontrol db -repos recreate

STARTED EMCA at Sep 25, 2014 10:14:16 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: GO
Database Control is already configured for the database GO
You have chosen to configure Database Control for managing the database GO
This will remove the existing configuration and the default settings and perform
 a fresh configuration
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Listener ORACLE_HOME [ D:\app\product\11.2.0\dbhome_1 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Password for SYSMAN user: Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ D:\app\product\11.2.0\dbhome_1

Local hostname ................ GOBASE.com
Listener ORACLE_HOME ................ D:\app\product\11.2.0\dbhome_1
Listener port number ................ 1521
Database SID ................ GO
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Sep 25, 2014 10:14:43 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at D:\app\cfgtoollogs\emca\go\emca_2014_09
_25_10_14_16.log.
Sep 25, 2014 10:14:43 AM oracle.sysman.emcp.DatabaseChecks performReposChecks
SEVERE: 'job_queue_processes' must be greater than or equal to 1.  Fix the error
(s) and run EM Configuration Assistant again in standalone mode.
Sep 25, 2014 10:14:43 AM oracle.sysman.emcp.EMConfig perform
SEVERE: 'job_queue_processes' must be greater than or equal to 1.  Fix the error
(s) and run EM Configuration Assistant again in standalone mode.
Refer to the log file at D:\app\cfgtoollogs\emca\gio\emca_2014_09_25_10_14_16.lo
g for more details.
Could not complete the configuration. Refer to the log file at D:\app\cfgtoollog
s\emca\gio\emca_2014_09_25_10_14_16.log for more details.
0
jjmekkattil
Asked:
jjmekkattil
  • 3
  • 3
1 Solution
 
slightwv (䄆 Netminder) Commented:
Set the spfile parameter job_queue_processes to a number > 1:

alter system set job_queue_processes=10 scope=spfile;

Then bounce the database.

I just used 10 as a nice round number.  Use whatever number you feel is necessary.  It is the number of concurrent database jobs that can run at once.
0
 
jjmekkattilAuthor Commented:
what exactly does changing it from 1 to 10 do?
0
 
slightwv (䄆 Netminder) Commented:
It allows more than one database job to run at the same time.

If you ever have a question about what a spfile parameter is or does, the online docs are an excellent resource:
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams112.htm#REFRN10077

JOB_QUEUE_PROCESSES specifies the maximum number of job slaves per instance that can be created for the execution of DBMS_JOB jobs and Oracle Scheduler (DBMS_SCHEDULER) jobs. DBMS_JOB and Oracle Scheduler share the same job coordinator and job slaves, and they are both controlled by the JOB_QUEUE_PROCESSES parameter.

If the value of JOB_QUEUE_PROCESSES is set to 0, then DBMS_JOB jobs and Oracle Scheduler jobs will not run on the instance.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
jjmekkattilAuthor Commented:
It seemed like it was going to work until I got the attached error
emca-2014-09-26-07-31-56.log
0
 
slightwv (䄆 Netminder) Commented:
Looks like a permission error of some type.

Make sure you are running the commands from an admin command prompt.
Make sure the user you are logged in as is a member of the ORA_DBA groups.

Maybe the previous attempts messed something up.
Try removing it before trying to recreate it:
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create

If all else fails, do a manual cleanup.  

It has been a long time since I had to do this but the steps below seem like what I had done in the past:
http://sandeepmohanty-san.blogspot.com/2011/03/configuring-em-db-console-11gr2.html
0
 
jjmekkattilAuthor Commented:
Looks like that took thanks for your help yet again!
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now