Sunday, September 11, 2011

Oracle Enterprise Manager 10.2.0.4 Unable to start

Hi All

we gonna talk about Bug in oracle 10.2.0.4 , 10.2.0.5 since its unable to start enterprise manager after run
"emctl start dbconsole"


CONFIG: Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://myhost:5501/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control
................................................ failed


This error appear because the SSL certification has been end .
But the question is what can i do ?


Forget Enterprise manager and start using command line

Not just kidding

What if we try to recreate it again ?

emca -config dbcontrol db -repos recreate


STARTED EMCA at Jan 11, 2011 4:11:01 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database unique name: catest
Database Control is already configured for the database catest
You have chosen to configure Database Control for managing the database catest

This will remove the existing configuration and the default settings and perform a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: Y
Listener port number: 1521
Cluster name: mycluster
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):

........

Jan 11, 2011 4:18:05 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jan 11, 2011 4:19:31 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jan 11, 2011 4:28:38 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control
Refer to the log file at /myhost/oracle/product/10.2.0/db_1/cfgtoollogs/emca/catest/emca_2011-01-11_
04-11-01-PM.log for more details.
Could not complete the configuration. Refer to the log file at /myhost/oracle/product/10.2.0/db_
1/cfgtoollogs/emca/catest/emca_2011-01-11_04-11-01-PM.log for more details.


So what can i do in this case ? i try to recreate what more i can do ?

./emctl status dbconsole

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
https://myhost:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running.


./emctl status agent

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent is Not Running



Refer to Oracle Metlink Doc [1222603.1]

we need to do the following :

1-
Ignore any errors and continue with the installation or upgrade. The database will be created without errors.

2- Apply Patch 8350262 to your Oracle Home installation using OPatch

To apply the patch :
A-change to Patch directory .
B-export ORACLE_SID = ORCL
C-export ORACLE_HOME= /u01/oracle/product/10.2.0/db_1/
D-$ORACLE_HOME/OPatch/Opatch apply


Invoking OPatch 10.2.0.4.2

Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.

Oracle Home : /myhost
Central Inventory : /scratch/pchebrol/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : /myhost/oui
Log file location : /myhost/cfgtoollogs/opatch/opatch2011-01-02_11-00-00AM.log

ApplySession applying interim patch '8350262' to OH '/myhost'

Running prerequisite checks...

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8350262' for restore. This might take a while...
Backing up files affected by the patch '8350262' for rollback. This might take a while...

Patching component oracle.sysman.agent.core, 10.2.0.4.0a...
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/RootCert.class"
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/SecConstants.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/util/RootCert.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/util/SecConstants.class"
ApplySession adding interim patch '8350262' to inventory

Verifying the update...
Inventory check OK: Patch ID 8350262 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8350262 are present in Oracle Home.

OPatch succeeded.


3-If you using linux you need to kill all dbconsole process by "KillDbconsole" you will find it in the same patch directory , if you are using windows no need to kill anything .

$ /killDBConsole
ORACLE_HOME=/myhost/db_1
ORACLE_SID=caem31
State directory = /myhost/db_1/staxd10_caem31
WatchDog PID = 802932
DBconsole PID = 577716
EMAgent PID = 512156
Killing WatchDog (pid=802932) ...
Successfully killed process 802932
Killing DBConsole (pid=577716) ...
Successfully killed process 577716
Killing EMAgent (pid=512156) ...
Successfully killed process 512156


4-This not optional steps you need to do it :

./emctl secure dbconsole -reset

Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://myhost:5501/em/console/aboutApplication
Enter Enterprise Manager Root Password :
DBCONSOLE already stopped... Done.
Agent is already stopped... Done.
Securing dbconsole... Started.
Checking Repository... Done.
Checking Em Key... Done.
Checking Repository for an existing Enterprise Manager Root Key...
WARNING! An Enterprise Manager Root Key already exists in
the Repository. This operation will replace your Enterprise
Manager Root Key.
All existing Agents that use HTTPS will need to be
reconfigured if you proceed. Do you wish to continue and
overwrite your Root Key
(Y/N) ?
Y
Are you sure ? Reset of the Enterprise Manager Root Key
will mean that you will need to reconfigure each Agent
that is associated with this OMS before they will be
able to upload any data to it. Monitoring of Targets
associated with these Agents will be unavailable until
after they are reconfigured.
(Y/N) ?
Y
Generating Enterprise Manager Root Key (this takes a minute)... Done.Fetching Root Certificate from
the Repository... Done.
Updating HTTPS port in emoms.properties file... Done.
Generating Java Keystore... Done.
Securing OMS ... Done.
Generating Oracle Wallet Password for Agent.... Done.
Generating wallet for Agent ... Done.
Copying the wallet for agent use... Done.
Storing agent key in repository... Done.
Storing agent key for agent ... Done.
Configuring Agent...
Configuring Agent for HTTPS in DBCONSOLE mode... Done.
EMD_URL set in /myhost/myhost/sysman/config/emd.properties
Done.
Configuring Key store.. Done.
Securing dbconsole... Sucessful.


Sometimes reset secure its not enough the same error will be appear , I know its lot of steps but i told you use command line Ok Ok what i can do just recreate enterprise manager again :

emca -config dbcontrol db -repos recreate

Ok are you sure its working ??!!

emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://localhost:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
——————————————————————
Logs are generated in directory N:\oracle\product\10.2.0\db/klpdbscph601.klpcph.local_KLPSTAGE01/sys
man/log


Thank you all
hope this topic will be useful .





16 comments:

  1. Hallo,
    A have question: what do exactly this Command?
    emca -config dbcontrol db
    Should i before something doing?

    ReplyDelete
    Replies
    1. emca ---> enterprise manager configuration assistants which used to rebuild the sysman repository that used by enterprise manager.

      Delete
  2. Thanks!!

    I search in internet why my OEM doesn't workand i sow, that i muss instalieren a Patch ID 8350262, and i did that:
    --------------------------------------------------------------------------------
    E:\oracle\product\10.2.0\db_1\OPatch>opatch lsinventory
    Invoking OPatch 10.2.0.4.2
    Oracle Interim Patch Installer version 10.2.0.4.2
    Copyright (c) 2007, Oracle Corporation. All rights reserved.
    Oracle Home : e:\oracle\product\10.2.0\db_1
    Central Inventory : C:\Program Files\Oracle\Inventory
    from : n/a
    OPatch version : 10.2.0.4.2
    OUI version : 10.2.0.4.0
    OUI location : e:\oracle\product\10.2.0\db_1\\oui
    Log file location : e:\oracle\product\10.2.0\db_1\cfgtoollogs\opatch\opatch2013-
    01-31_13-09-03PM.log

    Lsinventory Output file location : e:\oracle\product\10.2.0\db_1\cfgtoollogs\opa
    tch\lsinv\lsinventory2013-01-31_13-09-03PM.txt

    Installed Top-level Products (1):
    Oracle Database 10g 10.2.0.4.0
    There are 1 products installed in this Oracle Home.
    Interim patches (1) :
    Patch 8350262 : applied on Mon Jan 28 11:10:58 CET 2013
    Created on 14 Sep 2010, 04:59:44 hrs PST8PDT
    Bugs fixed: 8350262
    OPatch succeeded.
    --------------------------------------------------------------------------------

    But yesterday had same problem my DBconsole doesn't work and the error was:

    Starting Oracle Enterprise Manager 10g Database Control ................ failed

    Then i readed your Blog and i apply this command (recreate the configuration):

    emca -config dbcontrol db -repos recreate

    Without Error, and actually the just service work but when i look the Status it doesnt work and the Homepage (http://myhost.bo:1158/em/console/aboutApplication) doen't work too :( .

    ------------------------------------------------------------------
    E:\oracle\product\10.2.0\db_1\BIN>emctl start dbconsole
    Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
    Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
    http://myhost.bo:1158/em/console/aboutApplication
    Starting Oracle Enterprise Manager 10g Database Control ...The OracleDBConsoleor
    cl service is starting..........................................................
    ............................................
    The OracleDBConsoleorcl service was started successfully.
    ------------------------------------------------------------------
    E:\oracle\product\10.2.0\db_1\BIN>emctl status dbconsole
    Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
    Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
    http://myhost.bo:1158/em/console/aboutApplication
    Oracle Enterprise Manager 10g is not running.
    Logs are generated in directory E:\oracle\product\10.2.0\db_1/myhostorcl/sysman/log
    ------------------------------------------------------------------
    E:\oracle\product\10.2.0\db_1\BIN>emctl status agent
    Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
    Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
    Agent is Not Running
    ---------------------------------------------------------------

    In the Log emca_2013-01-31_01-21-24-PM say:

    SEVERE: Cannot start Database Control. The following ports are already in use: [EM agent port:3938].
    Refer to the log file at E:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2013-01-31_01-21-24-PM.log for more details.
    Jan 31, 2013 2:21:45 PM oracle.sysman.emcp.EMConfig perform
    CONFIG: Stack Trace:
    oracle.sysman.emcp.exception.EMConfigException: Cannot start Database Control. The following ports are already in use: [EM agent port:3938].
    at oracle.sysman.emcp.EMDBPostConfig.areDbcPortsFree(EMDBPostConfig.java:1760)

    How could i solve the problem? Could you help me pls ...

    ReplyDelete
  3. after running this patch you should you recreate enterprise manager again .

    ReplyDelete
  4. yes, after running this patch i alredy recreate OEM. then i started dbconsole und say :"The OracleDBConsoleorcl service was started successfully" but it is not running. :(

    E:\oracle\product\10.2.0\db_1\BIN>emctl start dbconsole
    Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
    Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
    http://myhost.bo:1158/em/console/aboutApplication
    Starting Oracle Enterprise Manager 10g Database Control ...The OracleDBConsoleor
    cl service is starting..........................................................
    ............................................
    The OracleDBConsoleorcl service was started successfully.
    ------------------------------------------------------------------
    E:\oracle\product\10.2.0\db_1\BIN>emctl status dbconsole
    Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
    Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
    http://myhost.bo:1158/em/console/aboutApplication
    Oracle Enterprise Manager 10g is not running.
    Logs are generated in directory E:\oracle\product\10.2.0\db_1/myhostorcl/sysman/log
    ------------------------------------------------------------------
    E:\oracle\product\10.2.0\db_1\BIN>emctl status agent
    Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
    Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
    Agent is Not Running



    And in the LOGS: emagent.trc say that:


    2013-02-04 07:19:29 Thread-3832 ERROR upload: Error in uploadXMLFiles.
    Trying again in 103.00 seconds.
    2013-02-04 07:19:29 Thread-4192 ERROR fetchlets.os:
    Process stdout =
    #
    # An unexpected error has been detected by HotSpot Virtual Machine:

    #
    # EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x00000000778a0895, pid=1548, tid=4720

    #
    # Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_11-b03 mixed mode)

    # Problematic frame:

    # C [ntdll.dll+0x50895]

    #
    # An error report file with more information is saved as hs_err_pid1548.log

    #
    # If you would like to submit a bug report, please visit:

    # http://java.sun.com/webapps/bugreport/crash.jsp

    #
    #
    # An unexpected error has been detected by HotSpot Virtual Machine:

    #
    # EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x00000000778a0895, pid=2452, tid=4548

    #
    # Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_11-b03 mixed mode)

    # Problematic frame:

    # C [ntdll.dll+0x50895]

    #
    # An error report file with more information is saved as hs_err_pid2452.log

    #
    # If you would like to submit a bug report, please visit:

    # http://java.sun.com/webapps/bugreport/crash.jsp

    #

    2013-02-04 07:19:29 Thread-4192 ERROR fetchlets.os: Process stderr = ECM: host configuration collection:
    Collection failed: exit value: 1.
    2013-02-04 07:19:30 Thread-5080 ERROR upload: Error in uploadXMLFiles.
    Trying again in 123.00 seconds.
    2013-02-04 07:19:33 Thread-4908 ERROR upload: Error in uploadXMLFiles.
    Trying again in 147.00 seconds.
    2013-02-04 07:19:33 Thread-4628 WARN
    http: snmehl_connect: connect failed to (myhost.de:1158):
    No connection could be made because the target machine actively refused it.
    (error = 10061)

    ReplyDelete
    Replies
    1. Did you check MOS :
      Problem: Error Displaying Host Configuration ECM: Collection failed: exit value: 1 [ID 362137.1]

      Delete
  5. Hallo Osama,
    Actually try, again recreate configuration, and could you see, i have Java error, maybe it is the Problem? what do you think?.Therefore i was in MOS and i am reading some Forum for example (An unexpected error has been detected by HotSpot Virtual Machine )... and i doesnt find the problem: Error Displaying Host Configuration ECM: Collection failed: exit value: 1 [ID 362137.1] .... tanks for your time, i really want to solve this problem ..

    E:\oracle\product\10.2.0\db_1\BIN>emca -config dbcontrol db -repos recreate

    STARTED EMCA at Feb 5, 2013 8:24:31 AM
    EM Configuration Assistant, Version 10.2.0.1.0 Production
    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Enter the following information:
    Database SID: orcl
    java.io.IOException: The handle is invalid
    at java.io.FileInputStream.close0(Native Method)
    at java.io.FileInputStream.close(FileInputStream.java:245)
    at sun.nio.cs.StreamDecoder$CharsetSD.implClose(StreamDecoder.java:505)
    at sun.nio.cs.StreamDecoder.close(StreamDecoder.java:198)
    at java.io.InputStreamReader.close(InputStreamReader.java:187)
    at java.io.BufferedReader.close(BufferedReader.java:502)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine$ErrorStreamReader.r
    un(SQLEngine.java:2406)
    at java.lang.Thread.run(Thread.java:595)
    Database Control is already configured for the database orcl
    You have chosen to configure Database Control for managing the database orcl
    This will remove the existing configuration and the default settings and perform
    a fresh configuration
    Do you wish to continue? [yes(Y)/no(N)]: Y

    ReplyDelete
  6. ...
    Feb 5, 2013 8:48:35 AM oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at E:\oracle\product\10.2.0\db_1\cfgtoollog
    s\emca\orcl\emca_2013-02-05_08-24-31-AM.log.
    Feb 5, 2013 8:48:43 AM oracle.sysman.emcp.util.PortManager isPortInUse
    WARNING: Specified port 5540 is already in use.
    Feb 5, 2013 8:48:43 AM oracle.sysman.emcp.util.PortManager isPortInUse
    WARNING: Specified port 5520 is already in use.
    Feb 5, 2013 8:48:43 AM oracle.sysman.emcp.util.PortManager isPortInUse
    WARNING: Specified port 1158 is already in use.
    Feb 5, 2013 8:48:43 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
    INFO: Stopping Database Control (this may take a while) ...
    Feb 5, 2013 8:48:46 AM oracle.sysman.emcp.EMReposConfig dropRepository
    INFO: Dropping the EM repository (this may take a while) ...
    Feb 5, 2013 8:49:24 AM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully dropped
    Feb 5, 2013 8:49:25 AM oracle.sysman.emcp.EMReposConfig createRepository
    INFO: Creating the EM repository (this may take a while) ...
    Feb 5, 2013 8:50:47 AM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully created
    java.io.IOException: The handle is invalid
    at java.io.FileInputStream.close0(Native Method)
    at java.io.FileInputStream.close(FileInputStream.java:245)
    at sun.nio.cs.StreamDecoder$CharsetSD.implClose(StreamDecoder.java:505)
    at sun.nio.cs.StreamDecoder.close(StreamDecoder.java:198)
    at java.io.InputStreamReader.close(InputStreamReader.java:187)
    at java.io.BufferedReader.close(BufferedReader.java:502)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine$ErrorStreamReader.r
    un(SQLEngine.java:2406)
    at java.lang.Thread.run(Thread.java:595)
    Feb 5, 2013 8:50:55 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
    INFO: Securing Database Control (this may take a while) ...
    Feb 5, 2013 8:51:07 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
    INFO: Database Control secured successfully.
    Feb 5, 2013 8:51:07 AM oracle.sysman.emcp.util.DBControlUtil startOMS
    INFO: Starting Database Control (this may take a while) ...
    Feb 5, 2013 8:57:27 AM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error starting Database Control
    Refer to the log file at E:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emc
    a_2013-02-05_08-24-31-AM.log for more details.
    java.io.IOException: The handle is invalid
    at java.io.FileInputStream.close0(Native Method)
    at java.io.FileInputStream.close(FileInputStream.java:245)
    at sun.nio.cs.StreamDecoder$CharsetSD.implClose(StreamDecoder.java:505)
    at sun.nio.cs.StreamDecoder.close(StreamDecoder.java:198)
    at java.io.InputStreamReader.close(InputStreamReader.java:187)
    at java.io.BufferedReader.close(BufferedReader.java:502)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine$ErrorStreamReader.r
    un(SQLEngine.java:2406)
    at java.lang.Thread.run(Thread.java:595)
    Could not complete the configuration. Refer to the log file at E:\oracle\product
    \10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2013-02-05_08-24-31-AM.log for more deta
    ils

    ReplyDelete
    Replies
    1. First did you check Or even read the logs which is clear WARNING: Specified port 1158 is already in use. and did you check this log
      Could not complete the configuration. Refer to the log file at E:\oracle\product
      \10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2013-02-05_08-24-31-AM.log for more deta

      Delete
  7. Hi,

    But the port 1158 is not in use, they (1158, 5520, 5540,3938 )are free or it is a Problem with my firewall? i use 3 DNS server... how can i ORACLE_HOSTNAME configure or where?
    Could u pls help me..

    Hier ist the Log emca_2013-02-05_08-24-31-AM.log :
    Feb 5, 2013 8:51:07 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
    INFO: Database Control secured successfully.
    Feb 5, 2013 8:51:07 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
    CONFIG: Securing Database Control completed successfully .
    Feb 5, 2013 8:51:07 AM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Feb 5, 2013 8:51:07 AM oracle.sysman.emcp.util.DBControlUtil startOMS
    INFO: Starting Database Control (this may take a while) ...
    Feb 5, 2013 8:51:07 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: cmdType: 0
    Feb 5, 2013 8:51:07 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Starting Windows service...OracleDBConsoleorcl
    Feb 5, 2013 8:51:07 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleorcl' to fully start
    Feb 5, 2013 8:51:17 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleorcl' to fully start
    CONFIG: Initialization failure for service during start
    Feb 5, 2013 8:57:27 AM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error starting Database Control
    Refer to the log file at E:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2013-02-05_08-24-31-AM.log for more details.
    Feb 5, 2013 8:57:27 AM oracle.sysman.emcp.EMConfig perform
    CONFIG: Stack Trace:
    oracle.sysman.emcp.exception.EMConfigException: Error starting Database Control
    at oracle.sysman.emcp.EMDBPostConfig.performConfiguration(EMDBPostConfig.java:646)
    at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:224)
    at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:193)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:184)
    at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486)
    at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142)
    at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470)
    at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419)

    ReplyDelete
    Replies
    1. Check with SA about firewall and 1158 Port if its opened and can be used , Also Did you set ORACLE_HOME, Oracle_SID , Oracle_UNIQUE seems you didn't do that.

      Delete
  8. mein firewall is off, and the variables set.

    ReplyDelete
  9. Nice post....!!!!!!!

    http://sankar-information-security.blogspot.com/

    ReplyDelete
  10. hello
    I have applied this patch and my db version is 10.2.0.4.0.when i tried './emctl secure dbconsole -reset' it gave the error "Fetching Root Certificate from the Repository... Failed. rc = 1" can you please guide me

    ReplyDelete
    Replies
    1. 1. SQL> alter user SYSMAN account lock;
      2. SQL> drop user SYSMAN cascade;
      3. SQL> alter user MGMT_VIEW account lock;
      4. SQL> drop user MGMT_VIEW cascade;
      5. $ emca -deconfig dbcontrol db -repos drop -cluster or emca -deconfig dbcontrol db
      6. $ emca -config dbcontrol db -repos create

      Delete