EMCA the problem of DBSNMP users and Sysman users when creating EM

Source: Internet
Author: User
Tags manual

After the manual library is completed, the database defaults to the following accounts (ORACLE 11.2.0.4): Manual Library Step Reference: http://blog.csdn.net/q947817003/article/details/16337611
Sql> Show User
USER is "SYSTEM"
Sql> select Username,account_status from Dba_users;
USERNAME Account_status
------------------------------ --------------------------------
SYS OPEN
SYSTEM OPEN
Outln Expired & LOCKED
Appqossys Expired & LOCKED
Dbsnmp Expired & LOCKED
DIP Expired & LOCKED
ORACLE_OCM Expired & LOCKED
When you build a library manually, you do not have the Sysman user used to create EM, and the DBSNMP user is locked.
The following tests found that DBSNMP users were unlocked after they entered the EMCA interaction, while Sysman users needed to wait for EM to complete the creation before they were created in the database (such as not created in the database when the creation process went wrong).
A description of DBSNMP and Sysman:--from official documents

Dbsnmp DBSNMP default Password The account used by the Management Agent component for Oracle Enterprise Manager to monitor and manage the database
An account used by the management agent component of Oracle Enterprise Manager to monitor and manage databases
Sysman Change_on_install default Password The account used to perform Oracle Enterprise Manager database administration tasks. Note-SYS and SYSTEM can also perform these tasks.
Accounts are used to perform Oracle Enterprise Manager database management tasks. It is to be noted that SYS and system can perform these tasks as well.

The experimental steps are as follows:

1. The first time you use Emca-config Dbcontrol db-repos Create

Make sure the SYS user password is correct. Can be tested in this way through Sqlplus sys/oracle@bys3 as SYSDBA.
Enter any password for DBSNMP (i input is Oraclesys), prompt account lock, ignore this prompt and return, enter Sysman password (i input is oraclesys)--can be arbitrary.
Listener Oracle_home [/u01/app/oracle/product/11.2.0/dbhome_1]:
Password for SYS User:
Password for DBSNMP User:
Nov, 2013 5:02:22 PM oracle.sysman.emcp.util.GeneralUtil initsqlengineloacly
Warning:ora-28000:the account is locked
Password for Sysman User:
Now CTRL + C to drop this interaction, or continue to go on the line.

2. From other terminals or the current terminal CTRL + C after this interaction login database to view the user situation, as follows:---DBSNMP users have been automatically unlocked.

Sql> select Username,account_status from Dba_users;
USERNAME Account_status
------------------------------ --------------------------------
SYS OPEN
SYSTEM OPEN
Dbsnmp OPEN
Outln Expired & LOCKED
Appqossys Expired & LOCKED
DIP Expired & LOCKED
ORACLE_OCM Expired & LOCKED
#####################################################

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/storage/

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.