EM dbconsole not started and giving NET HELPMSG 3547
Posted by Pavan DBA on May 18, 2010
Hi Friends, today i face some problem with EM dbconsole in one of my databases are here is the way how i resolved it
Database version : 10.2.0.4 standard edition
OS version : windows 2003 server with service pack 2
Problem : Sys admin performed firm upgrade on my database server and rebooted it. From that moment EM dbconsole is not working
1) i checked the status of dbconsole as follows
C:\Documents and Settings\oracms>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://cmsp-database.klpcph.local:5500/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running.
——————————————————————
Logs are generated in directory N:\oracle\product\10.2.0\db/cmsp-database.klpcph.local_KLPPROD01/sys
man/log
2) then i tried starting dbconsole and got following error
C:\Documents and Settings\oracms>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://cmsp-database.klpcph.local:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control …The OracleDBConsoleKLPPROD01 service is s
tarting…………………………………………………………………………………
……………………………………………………………………………………….
……………………
The OracleDBConsoleKLPPROD01 service could not be started.
A service specific error occurred: 1.
More help is available by typing NET HELPMSG 3547.
3) then i tried to find out what this message is
C:\Documents and Settings\oracms>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.
as you can see we cannot understand what is the exact problem here…
4) sometimes this problem may occur because SYSMAN and DBSNMP users got locked. so i checked their account status
C:\Documents and Settings\oracms>sqlplus “/ as sysdba”
SQL*Plus: Release 10.2.0.4.0 – Production on Tue May 18 08:26:24 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Release 10.2.0.4.0 – 64bit Production
SQL> select username,account_status from dba_users;
USERNAME ACCOUNT_STATUS
—————————— ——————————–
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SYSMAN OPEN
so from above, its clear that both the user accounts are open
5) then i checked if agent is running or not
C:\Documents and Settings\oracms>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
6) because agent is not running, i tried to start it
C:\Documents and Settings\oracms>emctl start agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
The service name is invalid.
More help is available by typing NET HELPMSG 2185.
as mentioned i tried to check what this message is…
C:\Documents and Settings\oracms>NET HELPMSG 2185
The service name is invalid.
EXPLANATION
You tried to start a service that is not configured on this system.
ACTION
Check the spelling of the service name or check the configuration information for the service using
the Services option from Server Manager.
7) restarting the server could be a solution, but we cannot do that if it is a production database. so i recreated repository
Do remember, recreating enterprise manager repository will not have any impact on database functionality
before recreating, take out the info like
Database hostname
Database SID
Listener port number
password for SYS user
password for DBSNMP user
password for SYSMAN user
also, it is important that DBSNMP and SYSMAN user’s account should be opened
use the following command to recreate repository
C:\Documents and Settings\oracms>emca -config dbcontrol db -repos recreate
STARTED EMCA at May 18, 2010 8:28:24 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: KLPSTAGE01
Database Control is already configured for the database KLPSTAGE01
You have chosen to configure Database Control for managing the database KLPSTAGE01
This will remove the existing configuration and the default settings and perform a fresh configurati
on
Do you wish to continue? [yes(Y)/no(N)]: y
Listener port number: 1521
Password for SYS user:
Password for DBSNMP 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 ……………. N:\oracle\product\10.2.0\db
Database hostname ……………. klpdbscph601.klpcph.local
Listener port number ……………. 1521
Database SID ……………. KLPSTAGE01
Email address for notifications ……………
Outgoing Mail (SMTP) server for notifications ……………
—————————————————————–
Do you wish to continue? [yes(Y)/no(N)]: y
this successfully created repository and started my dbconsole
8) so i am happy that my problem solved. but when i checked the EM dbconsole status….it gave me another shock
C:\Documents and Settings\oracms>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://klpdbscph601.klpcph.local:5500/em/console/aboutApplication
EM Daemon is not running.
——————————————————————
Logs are generated in directory N:\oracle\product\10.2.0\db/klpdbscph601.klpcph.local_KLPSTAGE01/sys
man/log
then i started looking at log and found following warning
May 18, 2010 8:33:00 AM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for klpdbscph601.klpcph.local
so finally, i reloaded listener and you know it started working… 🙂
C:\Documents and Settings\oracms>lsnrctl reload LISTENER_STAGE01
LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 – Production on 18-MAY-2010 08:37:26
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=klpdbscph601.klpcph.local)(PORT=1523)))
The command completed successfully
C:\Documents and Settings\oracms>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://klpdbscph601.klpcph.local:5500/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
Note : we are not using grid control, so this is only for 10g EM dbconsole problem. Don’t apply it for grid control and also test it before use
Pavan DBA's Blog 
windows7bugs said
Excellent Pavan. I had a nightmare with recent upgrade to 10.2.0.4 (legacy application, so no frowns please) & your post saved me from a hell. I have re-blogged your post. Thanks once again!
Pavan DBA said
Glad to hear that….
windows7bugs said
I’ve a question, while dropping and recreating the repository, I’ve read that the scheduled jobs designed using EM will get discarded. So, what should be a preventive approach in such cases? (Apparently we don’t schedule anything using EM at all in our environment). Just being curious!
Pavan DBA said
if any jobs are scheduled, it will run through dbms scheduler which is part of database and doesn’t have impact on EM. so it should not be a problem when we drop/recreate repository. can you provide the link where you read that? so that i can look into that.
windows7bugs said
Hello Pavan, I am not exactly sure about the link, however I believe it was from one of the document available with Oracle support. I’ve been going through hundreds of documents and lost the track of it. I’m sure I will able to get back to it. Please let me some time
windows7bugs said
Hello Pavan
I came across another issue after the upgrade. My upgrade was seamless other than the issues with EM. However after the upgrade I realized that the Windows Service for Oracle will not start automatically (even after auto start registry value is set TRUE). My consecutive attempts proved that the service starts once after I stop and start the service many times through services Microsoft console. I cross checked the registry, folder permissions on both target & new server instances to understand what is wrong. I can’t say it is not starting, yet I could say it starts once after stopping the service multiple times and starting. I tried to change the local system account with a member from the ora_dba group, still the result is same. My host is Windows 10. Any ideas?
Pavan DBA said
unfortunately, i don’t have much hands on windows OS. but from the explanation i can assume, it would be a compatibility issue which need to check with oracle support
windows7bugs said
Thanks Pavan, I got a workaround by upgrading to 10.2.0.5
10.2.0.4 breaks some permissions & much of the Microsoft APIs referred by the runtime were obsolete as early as 2006-7 period itself.
Anyway, the services are stopping and restarting after the upgrade to 10.2.0.5. Btw, this exercise is only for learning, hence I can avoid the Oracle support part. Thank you once again for the reply
Pavan DBA said
thanks very much for sharing this info which will be a learning for me and others as well.
Manoj Kumar said
C:\Documents and Settings\Administrator>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://amslorasrv:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control …The OracleDBConsoleor
cl service is starting………………………………………………….
…………………………………………………..
The OracleDBConsoleorcl service could not be started.
A service specific error occurred: 1.
More help is available by typing NET HELPMSG 3547.
C:\Documents and Settings\Administrator>
I am facing the same problem and recreate the dbconsole three time but still em not working
getting error A service specific error occurred: 1
while starting the emctl start dbconsole
Pavan DBA said
can you send me details steps and screenshots what u have done to mymailbox.21@gmail.com?
Ellareddy A said
Thx sir . Issue has resolved after recreating repository ( emca -config dbcontrol db -repos recreate)
beewee said
thank you..it works
Pavan DBA said
happy to hear that
Vimal said
Hi Pawan..When I start dbconsole the following happens….
Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
C:\Users\lap>set oracle_sid=studies
C:\Users\lap>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
C:\Users\lap>emctl start agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
These Windows services are started:
Apple Mobile Device
Application Experience
Background Intelligent Transfer Service
Base Filtering Engine
Bluetooth Service
Bluetooth Support Service
Bonjour Service
CamMonitor
CNG Key Isolation
COM+ Event System
Cryptographic Services
DCOM Server Process Launcher
Desktop Window Manager Session Manager
DHCP Client
Diagnostic Policy Service
Diagnostic System Host
Distributed Link Tracking Client
DNS Client
Extensible Authentication Protocol
Function Discovery Provider Host
Function Discovery Resource Publication
Group Policy Client
Human Interface Device Access
IKE and AuthIP IPsec Keying Modules
Intelr PROSet/Wireless Event Log
Intelr PROSet/Wireless Registry Service
IP Helper
IPsec Policy Agent
KtmRm for Distributed Transaction Coordinator
Microsoft Antimalware Service
Microsoft Network Inspection
Multimedia Class Scheduler
Network Connections
Network List Service
Network Location Awareness
Network Store Interface Service
NSUService
NVIDIA Display Driver Service
OracleMTSRecoveryService
OracleOraDb10g_home1ClrAgent
OracleOraDb10g_home1iSQL*Plus
OracleOraDb10g_home1TNSListener
OracleServiceSTUDIES
Plug and Play
Portable Device Enumerator Service
Print Spooler
Program Compatibility Assistant Service
ReadyBoost
Remote Access Connection Manager
Remote Procedure Call (RPC)
Secondary Logon
Secure Socket Tunneling Protocol Service
Security Accounts Manager
Security Center
Server
Shell Hardware Detection
Software Licensing
SQL Server (MSSMLBIZ)
SQL Server VSS Writer
SSDP Discovery
Superfetch
System Event Notification Service
Tablet PC Input Service
Task Scheduler
TCP/IP NetBIOS Helper
Telephony
Terminal Services
Themes
UPnP Device Host
User Profile Service
VAIO Content Folder Watcher
VAIO Entertainment Database Service
VAIO Entertainment UPnP Client Adapter
VAIO Event Service
WebClient
Windows Audio
Windows Audio Endpoint Builder
Windows Driver Foundation – User-mode Driver Framework
Windows Error Reporting Service
Windows Event Log
Windows Firewall
Windows Image Acquisition (WIA)
Windows Management Instrumentation
Windows Media Player Network Sharing Service
Windows Search
Windows Time
Windows Update
WinHTTP Web Proxy Auto-Discovery Service
WLAN AutoConfig
Workstation
XAudioService
The command completed successfully.
C:\Users\lap>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://Brindhavi-PC:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control …The OracleDBConsolest
udies service is starting……………………………………………….
……………………………………………………………………..
……………………………………………………………………..
……………………………………………………..
The OracleDBConsolestudies service could not be started.
A service specific error occurred: 1.
More help is available by typing NET HELPMSG 3547.
C:\Users\lap>sqlplus “/as sysdba”
SQL*Plus: Release 10.2.0.4.0 – Production on Sat Feb 18 18:36:57 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine
and Real Application Testing options
SQL> select username,account_status from dba_users;
USERNAME ACCOUNT_STATUS
—————————— ——————————–
OUTLN OPEN
MGMT_VIEW OPEN
LBACSYS OPEN
SYS OPEN
SYSTEM OPEN
MDSYS OPEN
ORDSYS OPEN
CTXSYS OPEN
ANONYMOUS OPEN
EXFSYS OPEN
DMSYS OPEN
USERNAME ACCOUNT_STATUS
—————————— ——————————–
DBSNMP OPEN
WMSYS OPEN
SYSMAN OPEN
XDB OPEN
ORDPLUGINS OPEN
SI_INFORMTN_SCHEMA OPEN
OLAPSYS OPEN
MDDATA OPEN
DIP OPEN
ORACLE_OCM OPEN
TSMSYS OPEN
USERNAME ACCOUNT_STATUS
—————————— ——————————–
ARUN OPEN
23 rows selected.
I get ‘The service specific error occured: 1’
Kindly help me Pavan…
Pavan Kumar said
Hi Vimal, did you followed all the steps that I specified in this article?
https://pavandba.com/2010/05/18/em-dbconsole-not-started-and-giving-net-helpmsg-3547/
if not please do that and get back to me if any issues
iNAM said
i have same problem but it could not work for me. While I am recreating repositary getting java errors
please can you advise.
Regards
iNAM
Pavan DBA said
please post the error messages so as to have a look and suggest
Adwoa said
Hi Pavan,
I’ve been thru your steps, however i’m stuck at
INFO: Dropping the EM repository. May take a while.
OS is Windows server 2008
oracle is 11gr2.
Please help.
Thanks!
Pavan Kumar said
Hi, please specify if you are getting any error. you can see the error info in the log file
Adwoa said
Pavan Kumar said
I can see two errors in the log file. one is invalid username/password and other is SYSMAN user already exists.
so, try to configure enterprise manager with DBCA or drop SYSMAN user and run manual commands. those commands itself will create SYSMAN user
Shehzad Ahmed said
i install oracle 10g on windows 7
but i face problem in starting of EM
and on this command “c:>emctl start dbconsole”
plz help me
Pavan Kumar said
Hi Ahmed, can you please let me know exact problem, error number and other details? also have you configured EM already? If need quick solution, plz chat with me on gtalk at mymailbox.21@gmail.com
Shehzad Ahmed said
Recently i started learning about oracle 10g
My operating system is windows 7
i install oracle 10g secsessfuly
but there is probelm in starting EM
and
problem in this command c:>emctl start dbconsole
plz help me
edgar said
Hi I have the same error with the console EM , a get the message
Is windows 2003 sp2
Db 10g with patch 10.2.0.4
2010-10-21 15:37:23 Thread-964 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-270,and testTZoffset for Etc/GMT-4:240 do not match
2010-10-21 15:37:24 Thread-964 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-270,and testTZoffset for Etc/GMT-4:240 do not match
2010-10-21 15:59:11 Thread-3616 WARN http: snmehl_connect: connect failed to (s01wdorc01:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2010-10-21 16:01:49 Thread-3960 WARN http: snmehl_connect: connect failed to (s01wdorc01:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2010-10-21 16:02:10 Thread-1504 WARN http: snmehl_connect: connect failed to (s01wdorc01:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
Pavan Kumar said
could you let me know what you did after you got NETHELP msg error? did you tried to recreate repository?
Anna Goulet said
Thanks Pavan. I was having the same 3547 message and these steps worked like a charm to get my dbconsole running again!
Pavan Kumar said
its glad to hear that Anna…thanks for commenting your views
Thomas Männer said
Thanks a lot for the detailed description. I had exactly the same issue with my private ora10g! The same procedure helped me getting my dbconsole running again.
Thanx again!!!
Pavan Kumar said
its gr8 to hear that such posts of mine is helpful….wishing to post more n more in future…thanks alot for commenting
Sunil Kumar said
hi Pavan,
thanks for this information. I have actually tried to recreate dbconsole and it is stopping at
INFO: Dropping the EM Repositery (this may take a while)…………..
and it’s not moving from that place.I even checked the log and shows nothing.
Please help me out in this!
Thanks
Sunil
Pavan Kumar said
Hi Sunil, can you provide the OS and DB versions?