This content has been marked as final. Show 24 replies
What is SYSMAN user's status ?
Locked or Not?
What is your oracle version? pls, 4 digit.
Is it dbcontrol or an enterprise manager? Is it on the same server where your oracle database is?
how to check the status for sysman? what is the default password of sysman?
SQL> select * from v$version 2 ; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod PL/SQL Release 10.1.0.2.0 - Production CORE 10.1.0.2.0 Production TNS for 32-bit Windows: Version 10.1.0.2.0 - Production NLSRTL Version 10.1.0.2.0 - Production
yes it is on the same server where my database is.
and i suppose http://regadminsrv.hct.org:5500/em to be the address use to open ENTERPRISE MANAGER.
if there is a difference , kindly guide me.
besides, when i try to close my dbconsole service from services.msc utility
it is not closed. there is a problem with it.
1) connect as sys
2) select username,account_status from dab_users where owner = 'SYSMAN'
Post the result.
The DB COntrol console process is unable to connect to the database it self from various reasons:
1. the listener is not started
2. the database is not registered with the given listener
3. the DB Console configuration is incorrect for some reason
4. Database is not opened or accessible for client connections.
Verify if the DB Console process is able to connect to the database with:
1. the listener is started and the database instance is registered: lsnrctl status <listener name>
2. The SYSMAN account is unlocked nd the password is not expired.
3. Open ORACLE_HOME/<hostname>_<SID>/sysman/log/emoms.trc for connection errors.
SQL> select username,account_status from dba_users where USERNAME = 'SYSMAN'; USERNAME ACCOUNT_STATUS ---------- -------------------------------- SYSMAN LOCKED(TIMED)
C:\Documents and Settings\Administrator> lsnrctl status LISTENER LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 02-ع╟╤╙ -2013 12 :29:19a$ى↕ Copyright (c) 1991, 2004, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ ction Start Date 02-ع╟╤╙ -2013 08:04:29 Uptime 0 days 4 hr. 24 min. 49 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File G:\oracle\product\10.1.0\db_1\network\admin\listener.o ra Listener Log File G:\oracle\product\10.1.0\db_1\network\log\listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.153.4.194)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=regadminsrv.hct.org)(PORT=8080))(Pre sentation=HTTP)(Session=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=regadminsrv.hct.org)(PORT=2100))(Pre sentation=FTP)(Session=RAW)) Services Summary... Service "ORCL" has 2 instance(s). Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service... Instance "orcl", status READY, has 5 handler(s) for this service... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "RAMAN" has 1 instance(s). Instance "RMAN", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
i am trying to locate the files you menioned.
SQL> alter user sysman account unlock; User altered.
Edited by: Maahjoor on 02-Mar-2013 00:31
Check now. Refresh your link. See if that works?
i referesh the link, but result is the same.
could we reconfigure the dbconsole?
3. Open ORACLE_HOME/<hostname>_<SID>/sysman/log/emoms.trc for connection errors.Show this logfile .
could we reconfigure the dbconsole?It's OK, But do you know SYSMAN's password?
You can configure but for that you need to know sysman and dbsnmp password
the logfile is very big, the last few lines are below
i dont know the sysman password, but i could alter it.
[HttpRequestHandler-1693320] ERROR eml.OMSHandshake getParameterFromDB.402 - ORA-28000: the account is locked 2013-03-02 13:05:17,397 [HttpRequestHandler-1693320] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://regadminsrv.hct.org:1830/emd/main)(ERROR = INTERNAL_ERROR)
i could alter the password sharma ji.
Account status was LOCK(TIMED) , and after you unlocked but now still ORA-28000: the account is locked.
Then, I think that SYSMAN password is difference between EM config and DB.
So, maybe, You will connect EM by reconfigration..
yes , i think some weeks before i alter the password.
you seemed correct.
but reconfiguration also failed.
i am unable to re-configure.