Solved

Error When Creating Oracle 11g EM

Posted on 2014-09-25
6
893 Views
Last Modified: 2014-09-26
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
Comment
Question by:jjmekkattil
  • 3
  • 3
6 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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
 

Author Comment

by:jjmekkattil
Comment Utility
what exactly does changing it from 1 to 10 do?
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:jjmekkattil
Comment Utility
It seemed like it was going to work until I got the attached error
emca-2014-09-26-07-31-56.log
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
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
 

Author Comment

by:jjmekkattil
Comment Utility
Looks like that took thanks for your help yet again!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to take different types of Oracle backups using RMAN.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now