عند عمل start لل emC:\>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0
Copyright © 1996, 2004 Oracle Corporation. All rights reserved.
http://is2:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...The OracleDBConsolesh
ihab service is starting.............
The OracleDBConsoleshihab service could not be started.

A service specific error occurred: 2.

More help is available by typing NET HELPMSG 3547.


C:\>net helpmsg 3547

A service specific error occurred: ***.


EXPLANATION

A service-specific error occurred.

ACTION

Refer to the Help or documentation for that service to determine the problem.

عند محاول عمل emca تظهر هذه الرسالة
مع أنة تم عمل alter system set shared_pool_size=100m;
و alter system set job_queue_prodesses=3;

C:\>emca

STARTED EMCA at Thu Nov 08 10:57:49 GMT+03:00 2007
Enter the following information about the database to be configured
Listener port number: 1512
Database SID: shihab
Service name: shihab
Email address for notification:
Email gateway for notification:
Password for dbsnmp:
Password for sysman:
Password for sys:

-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ D:\oracle\product\10.1.0\Db_1
Enterprise Manager ORACLE_HOME ................ D:\oracle\product\10.1.0\Db_1

Database host name ................ AS-Server.shihab.biz
Listener port number ................ 1512
Database SID ................ shihab
Service name ................ shihab
Email address for notification ...............
Email gateway for notification ...............

-----------------------------------------------------------------
Do you wish to continue? [yes/no]: yes
DBConsole is already configured for the database shihab
Would you like to re-configure DBConsole for the specified database? [yes/no]: y
es
Make sure that DBConsole has been shutdown
When you are ready to continue, press <Enter>

08/11/2007 10:58:23 + oracle.sysman.emcp.EMConfig checkConfiguration
WARNING: 'shared_pool_size' must be greater than or equal to 80 MB.
08/11/2007 10:58:23 + oracle.sysman.emcp.EMConfig checkConfiguration
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.
Could not complete the configuration. Refer to the log file for details

C:\>emca -a

STARTED EMCA at Thu Nov 08 11:29:27 GMT+03:00 2007
Enter the following information about the database to be configured
Listener port number: 1521
Database SID: shihab
Service name: shihab
Email address for notification:
Email gateway for notification:
ASM ORACLE_HOME [ D:\oracle\product\10.1.0\Db_1 ]:
ASM SID [ +ASM ]:
ASM port [ 1521 ]:
ASM user role [ SYSDBA ]:
ASM user name [ SYS ]:
ASM user password:
Password for dbsnmp:
Password for sysman:
Password for sys:

-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ D:\oracle\product\10.1.0\Db_1
Enterprise Manager ORACLE_HOME ................ D:\oracle\product\10.1.0\Db_1

Database host name ................ AS-Server.shihab.biz
Listener port number ................ 1521
Database SID ................ shihab
Service name ................ shihab
Email address for notification ...............
Email gateway for notification ...............
ASM ORACLE_HOME ................ D:\oracle\product\10.1.0\Db_1
ASM SID ................ +ASM
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM user name ................ SYS

-----------------------------------------------------------------
Do you wish to continue? [yes/no]: yes
DBConsole is already configured for the database shihab
Would you like to re-configure DBConsole for the specified database? [yes/no]: y
es
Make sure that DBConsole has been shutdown
When you are ready to continue, press <Enter>

08/11/2007 11:32:44 + oracle.sysman.emcp.EMConfig checkConfiguration
WARNING: 'shared_pool_size' must be greater than or equal to 80 MB.
08/11/2007 11:32:44 + oracle.sysman.emcp.EMConfig checkConfiguration
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.
Could not complete the configuration. Refer to the log file for details

try to drop the repository and recreate it again
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create

جربت وفق الحل التالي و نجحت العملية

Part I. Removing OracleDBConsole[sID] Service
Go to Windows Services panel and verify that OracleDBConsole[sID] is there. If you fnd it in the list and it can NOT be deleted by emca -x [sID] command, you need to remove it manually.


Delete OracleDBConsole[sID] from the registry:

1. Go to Start -> Run -> type regedit.
2. Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleDBConsoleCISDB.
3. Delete OracleDBConsoleCISDB key (hit delete).



Part II. Removing Sysman Directories
In order to recreate Sysman Schema, you will need to remove old directories:

1. Navigate to %ORACLE_HOME%\DomainName_SID directory and remove it.
2. Navigate to %ORACLE_HOME%\oc4j\j2ee\OC4J_DBConsole_DomainName_SID directory and remove it.
3. Reboot the server.
4. Verify that OracleDBConsole[sID] is not listed in Windows Services.


Part III. Creating new Sysman Schema and OracleDBConsole[sID] Service.

In fact, OracleDBConsole[sID] Service is created automatically as part of creating Sysman Schema procedure:

1. Start Database Configuration Assistant.
2. Click Next on the Welcome screen.
3. Select Configure Database Options and click Next.
4. Next screen will display database name, click Next.
5. Select Eneterprise Manager Repository and click Next. This presumes that Sysman Schema has been previosly dropped. If not, read how to drop Sysman Schema.
6. Select your Server Mode (default is Dedicated) and click Finish. This process may take several minutes and it will create dropped directories and OracleDBConsole[sID] Service.