ããé¦å
ç¨ç³»ç»ç¨æ·ç»éï¼å¨ç³»ç»ç¨æ·ä¸æ¥çdbaç¨æ·ç¶æ
ããselect username,account_status from dba_users;
ããå
¶ä¸å¸¸ç¨çç¨æ·ç¶ææ:EXPIREDåLOCKED
ããå¦æsysmanç¶ææ¯è¿æï¼ä¿®æ¹å¯ç æ¹æ³ï¼
ãã1ãæ§è¡emctl stop dbconsole
ãã使ç¨ä¸é¢çå½ä»¤æ¥æ£æ¥æ¯å¦ç¼ºå¤±åæ¢äºï¼
ããemctl status dbconsole
ãã确认åæ¢ä»¥åå°±å¯ä»¥å¨sqlpulséæ¹å¯ç äº
ãã2ãæ§è¡ä¸é¢çå½ä»¤ä¿®æ¹sysmanå¯ç ï¼
ããSQL->alter user sysman identified by <ä½ è¦æ¹çå¯ç >;
ããä¸è¿é¦å
ä½ å¾ç¡®è®¤ä¸ä¸sysmanæ¯å¦è¢«éå®ï¼å°±æ¯æ§è¡
ããSQL->select username,account_status from dba_users;
ããçsysmançç¶æï¼å¦ææ¯LOCKEDï¼é£ä¹ä½ å
å¾è§£éï¼
ããSQL->alter user sysman account unlock;
ãã解éå®æååä¿®æ¹å¯ç ï¼æè
ä¿®æ¹åå解éé½è¡ï¼æ¥éª¤å¯ä»¥é¢ åï¼ä½æ¯ç»å¯¹ä¸è½å°ã
ããä¿®æ¹å®æå
ããSQL->connect sysman/å¯ç
ããå¦æè¿æ¥æåå°±å¯ä»¥è¿è¡ä¸ä¸æ¥äºã
ãã3ãä¿®æ¹emoms.properties
ããå¨è·¯å¾ ORACLE_HOME\[HOST]_[SID]\sysman\configä¸
ããæ¾å°æ件åç¼è¾ä»¥ä¸ä¸¤å¥ï¼
ããoracle.sysman.eml.mntr.emdRepPwd= [Your encrypted password]
ããoracle.sysman.eml.mntr.emdRepPwdEncrypted=True
ããæ¾å°åæ[Your encrypted password]æ¹æä½ è¿ä¸ªç¨æ·è¦æ¹çå¯ç ï¼ææï¼ï¼ç¶åæä¸é¢çTrueæ¹æFalse.
ãã4ãéæ°å¯å¨dbConsole
ããemctl start dbconsole
ããå¯å¨åä½ åå°emoms.propertieséçï¼æ¯ä¸æ¯å¯ç ç»ä½ å å¯äºï¼èä¸emdRepPwdEncryptedåæäºTrue!
ããå¦æç¨æ·dbsnmpä¹å¤±æçè¯ï¼åæ ·çåæ³ï¼å
åæ¢dbconsoleåagentç¶åå¨sqlpluséç¡®ä¿ä»çç¶ææ¯openï¼ä¿®æ¹å¯ç ï¼ç¶ååå»æ件ä¸æ¹ï¼ä¸è¿è¿æ¬¡æ件ä¸ä¸æ ·ï¼åæäºtargets.xml ï¼å®çè·¯å¾å¨
ããORACLE_HOME\[HOST]_[SID]\sysman\emd
ããä¿®æ¹ä»¥ä¸è¡ï¼
ãã<Property NAME="password" VALUE="<[Your encrypted password]>" ENCRYPTED="TRUE"/>
ããåæ ·æ<[Your encrypted password]>æ¹æä½ è¦æ¹çå¯ç ï¼æåé¢çTRUEæ¹æFALSEï¼ä¿åãéæ°å¯å¨dbconsole
温馨提示:答案为网友推荐,仅供参考