OraFAQ Forum: Enterprise Manager

Home » RDBMS Server » Enterprise Manager » OEM agent issue (Linux 2.6.18-92.1.13.el5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OEM agent issue [message #528923]

Thu, 27 October 2011 12:06

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>

Report message to a moderator

Re: OEM agent issue [message #528929 is a reply to message #528923]

Thu, 27 October 2011 12:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> ALTER USER <USERNAME> ACCOUNT UNLOCK;

Report message to a moderator

Re: OEM agent issue [message #528949 is a reply to message #528929]

Thu, 27 October 2011 13:09

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

Report message to a moderator

Re: OEM agent issue [message #528954 is a reply to message #528949]

Thu, 27 October 2011 13:42

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!

Report message to a moderator

Re: OEM agent issue [message #528956 is a reply to message #528954]

Thu, 27 October 2011 14:05

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

Report message to a moderator

Re: OEM agent issue [message #528957 is a reply to message #528956]

Thu, 27 October 2011 14:12

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.

Report message to a moderator

Re: OEM agent issue [message #529023 is a reply to message #528957]

Fri, 28 October 2011 04:37

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Expert, any suggestions...???

Report message to a moderator

Re: OEM agent issue [message #529067 is a reply to message #529023]

Fri, 28 October 2011 09:46

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?

Report message to a moderator

Re: OEM agent issue [message #529094 is a reply to message #529067]

Fri, 28 October 2011 12:15

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)."

Report message to a moderator

Re: OEM agent issue [message #531737 is a reply to message #529094]

Thu, 17 November 2011 08:25

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?

Report message to a moderator

Re: OEM agent issue [message #531745 is a reply to message #531737]

Thu, 17 November 2011 08:42

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;

Report message to a moderator

Previous Topic:	How to set Preferred Credentials for Host in OEM 11g
Next Topic:	EM not connected

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 22:42:06 CST 2025