Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Error When Creating Oracle 11g EM

Posted on 2014-09-25
6
Medium Priority
?
1,015 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

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 2000 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup

705 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