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/