Oracle cannot unlock all EM-related accounts

Source: Internet
Author: User
It can be confirmed that it is a windows command line problem. Errors like this are generally not encountered in linux. When executing cmd, the system automatically runs a command,

It can be confirmed that it is a windows command line problem. Errors like this are generally not encountered in linux. When executing cmd, the system automatically runs a command,

When Oracle creates EM, an error is returned:

Configuration: Failed to unlock mgmt_view account
22:47:03 oracle. sysman. emcp. EMReposConfig invoke

Severe: cannot unlock all EM-related accounts

22:47:03 oracle. sysman. emcp. EMConfig perform
Severe: cannot unlock all EM-related accounts
For more information, see log files in D: \ oracle \ export toollogs \ emca \ orcl \ emca_2013_04_29_22_43_32.log.

22:47:03 oracle. sysman. emcp. EMConfig perform
Configuration: Stack Trace:
Oracle. sysman. emcp. exception. EMConfigException: cannot unlock all EM-related accounts
At oracle. sysman. emcp. EMReposConfig. invoke (EMReposConfig. java: 349)
At oracle. sysman. emcp. EMReposConfig. invoke (EMReposConfig. java: 158)
At oracle. sysman. emcp. EMConfig. perform (EMConfig. java: 253)
At oracle. sysman. emcp. EMConfigAssistant. invokeEMCA (EMConfigAssistant. java: 590)
At oracle. sysman. emcp. EMConfigAssistant. Configure mconfiguration (EMConfigAssistant. java: 1453)
At oracle. sysman. emcp. EMConfigAssistant. statusMain (EMConfigAssistant. java: 574)
At oracle. sysman. emcp. EMConfigAssistant. main (EMConfigAssistant. java: 522)
22:47:03 oracle. sysman. emcp. EMConfig restoreOuiLoc
Configuration: Restoring oracle. installer. oui_loc to D: \ oracle \ product \ 11.2.0 \ dbhome_1 \ oui

View the log file because the following statement is executed and an error is reported:

22:47:03 oracle. sysman. emcp. util. PlatformInterface executeCommand
Configuration: Run CMD/c d: \ oracle \ product \ 11.2.0 \ dbhome_1 \ sysman \ admin \ scripts \ emca \ emcaDbUtil. bat "D: \ oracle \ product \ 11.2.0 \ dbhome_1 \ sysman \ admin \ scripts; D: \ oracle \ product \ 11.2.0 \ dbhome_1 \ bin;" D: /oracle/product/11.2.0/dbhome_1/perl/bin \ perl.exe D: \ oracle \ product \ 11.2.0 \ dbhome_1 \ sysman \ admin \ scripts \ emca \ emcaDbUtil. pl D: \ oracle \ product \ 11.2.0 \ dbhome_1 "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = PC201303231245) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl.kew.0.com) "sys sysdba declare repos_pwd varchar2 (30); view_user varchar2 (30 ); view_user_pwd varchar2 (30); view_user_acc_status varchar2 (30); begin repos_pwd: = ?; Sysman. mgmt_view_priv.get_view_user (view_user); select account_status into view_user_acc_status from sys. dba_users where upper (username) = upper (view_user); IF view_user_acc_status like '% LOCKED % 'then execute immediate 'alter user' | view_user | 'account unlock'; end if; IF view_user_acc_status like '% EXPIRED %' THEN sysman. mgmt_view_priv.set_view_user_creds (repos_pwd); sysman. trim (view_user, view_user_pwd); execute immediate 'alter user' | view_user | 'identified by '| view_user_pwd | ''; end if; end; orcl 1 SYSMAN_PWD Error

However, it is strange that such an error does not occur when you pull it out separately. Let's look at the log and find that another error is reported before the preceding statement is executed:

22:47:03 oracle. sysman. emcp. util. PlatformInterface executeCommand
Configuration :'? 'It is neither an internal or external command nor a program that can be run
Or batch files.

It can be seen that this is the error message displayed at the cmd command prompt in windows. It is estimated that an error occurred while calling the internal command. Check the error message displayed at the first line of the window when cmd is started:

It can be confirmed that it is a windows command line problem. Errors like this are generally not encountered in linux. When executing cmd, the system automatically runs a command ,, but this command does not exist, so an error is returned. You just need to leave the automatic operation blank:

Reg add "HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Command Processor"/v "AutoRun"/d ""/f

Re-execute the operation, and the above error will no longer appear.

The preceding statement adds a registry key. The meanings of each parameter are as follows:

/V: AutoRun

/D: Data to be allocated

/F: Do not force rewrite existing data

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.