Home » RDBMS Server » Enterprise Manager » OEM agent issue (Linux 2.6.18-92.1.13.el5)
OEM agent issue [message #528923] Thu, 27 October 2011 12:06 Go to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hi,

I'm new to OEM. When login i'm getting error : Details Failed to connect to database instance: ORA-28000: the account is locked (DBD ERROR: OCISessionBegin).

I have checked DBCONSOLE & AGENT are running properly. Please suggest.

litening:/opt/oracle/product/11.2.0/bin>export ORACLE_SID=infoddp
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_HOME=/opt/oracle/product/11.2.0
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_HOSTNAME=liteningv
litening:/opt/oracle/product/11.2.0/bin>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
http://liteningv:4300/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/product/11.2.0/liteningv_infoddp/sysman/log
litening:/opt/oracle/product/11.2.0/bin>emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 10.2.0.4.3
OMS Version       : 10.2.0.4.3
Protocol Version  : 10.2.0.4.3
Agent Home        : /opt/oracle/product/11.2.0/liteningv_infoddp
Agent binaries    : /opt/oracle/product/11.2.0
Agent Process ID  : 4566
Parent Process ID : 4557
Agent URL         : http://liteningv:4900/emd/main
Repository URL    : http://liteningv:4300/em/upload/
Started at        : 2011-10-25 06:03:08
Started by user   : oracle
Last Reload       : 2011-10-25 06:17:09
Last successful upload                       : 2011-10-27 13:01:21
Total Megabytes of XML files uploaded so far :    27.35
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    56.72%
Data channel upload directory                : /opt/oracle/product/11.2.0/liteningv_infoddp/sysman/recv
Last successful heartbeat to OMS             : 2011-10-27 13:01:32
---------------------------------------------------------------
Agent is Running and Ready
litening:/opt/oracle/product/11.2.0/bin>
Re: OEM agent issue [message #528929 is a reply to message #528923] Thu, 27 October 2011 12:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL> ALTER USER <USERNAME> ACCOUNT UNLOCK;
Re: OEM agent issue [message #528949 is a reply to message #528929] Thu, 27 October 2011 13:09 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Thanks for update BlackSwan. But all the mahor user are already in open status.

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
SYSMAN                         OPEN
DBSNMP                         OPEN
SYSTEM                         OPEN
SYS                            OPEN
Re: OEM agent issue [message #528954 is a reply to message #528949] Thu, 27 October 2011 13:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
28000, 00000, "the account is locked"
// *Cause:   The user has entered wrong password consequently for maximum
//           number of times specified by the user's profile parameter
//           FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account
// *Action:  Wait for PASSWORD_LOCK_TIME or contact DBA


with V11 passwords are CaseSenSitiVe!
Re: OEM agent issue [message #528956 is a reply to message #528954] Thu, 27 October 2011 14:05 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Thanks for update. I have checked FAILED_LOGIN_ATTEMPTS for default profile and it is already set to unlimited.

SQL> /

RESOURCE_NAME                    RESOURCE LIMIT
-------------------------------- -------- ----------------------------------------
COMPOSITE_LIMIT                  KERNEL   UNLIMITED
SESSIONS_PER_USER                KERNEL   UNLIMITED
CPU_PER_SESSION                  KERNEL   UNLIMITED
CPU_PER_CALL                     KERNEL   UNLIMITED
LOGICAL_READS_PER_SESSION        KERNEL   UNLIMITED
LOGICAL_READS_PER_CALL           KERNEL   UNLIMITED
IDLE_TIME                        KERNEL   UNLIMITED
CONNECT_TIME                     KERNEL   UNLIMITED
PRIVATE_SGA                      KERNEL   UNLIMITED
FAILED_LOGIN_ATTEMPTS            PASSWORD UNLIMITED
PASSWORD_LIFE_TIME               PASSWORD UNLIMITED

RESOURCE_NAME                    RESOURCE LIMIT
-------------------------------- -------- ----------------------------------------
PASSWORD_REUSE_TIME              PASSWORD UNLIMITED
PASSWORD_REUSE_MAX               PASSWORD UNLIMITED
PASSWORD_VERIFY_FUNCTION         PASSWORD NULL
PASSWORD_LOCK_TIME               PASSWORD 1
PASSWORD_GRACE_TIME              PASSWORD UNLIMITED
Re: OEM agent issue [message #528957 is a reply to message #528956] Thu, 27 October 2011 14:12 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

I would to add, although user DBSNMP is in open status, i don't know the password. So shall I go for change password for DBSNMP and later change password in OEM. What you suggest.

Thanks.
Re: OEM agent issue [message #529023 is a reply to message #528957] Fri, 28 October 2011 04:37 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Expert, any suggestions...???
Re: OEM agent issue [message #529067 is a reply to message #529023] Fri, 28 October 2011 09:46 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
which schema/username is throwing this error?

AUDIT both successful & unsuccessful logins.

can you replicate error using sqlplus?
Re: OEM agent issue [message #529094 is a reply to message #529067] Fri, 28 October 2011 12:15 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

non of the schema is throwing error. It is working correctly through sqlplus. Error is from OEM home page.

" Details Failed to connect to database instance: ORA-28000: the account is locked (DBD ERROR: OCISessionBegin)."
Re: OEM agent issue [message #531737 is a reply to message #529094] Thu, 17 November 2011 08:25 Go to previous messageGo to next message
daverich
Messages: 23
Registered: January 2010
Location: UK
Junior Member
If you can login to EM you should try to change the DBSNMP password from the
Targets-> DB Instance ->Configuration screen.


Can you login at all?
Re: OEM agent issue [message #531745 is a reply to message #531737] Thu, 17 November 2011 08:42 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>" Details Failed to connect to database instance: ORA-28000: the account is locked (DBD ERROR: OCISessionBegin)."


SQL> ALTER USER DBSNMP ACCOUNT UNLOCK;
Previous Topic: How to set Preferred Credentials for Host in OEM 11g
Next Topic: EM not connected
Goto Forum:
  


Current Time: Thu Mar 28 19:13:53 CDT 2024