Solved

Error When Creating Oracle 11g EM

Posted on 2014-09-25
6
908 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)
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 76

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
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 explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
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.

863 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

26 Experts available now in Live!

Get 1:1 Help Now