Solved

Error When Creating Oracle 11g EM

Posted on 2014-09-25
6
995 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40344067
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
ID: 40344073
what exactly does changing it from 1 to 10 do?
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40344077
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

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

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 40345873
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
ID: 40346120
Looks like that took thanks for your help yet again!
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

636 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