ããå®è£
å®æ°æ®åºå¾ä¹
ä¸ç¨å¸¸å¸¸ä¼å¿è®°å
¶å¯ç ï¼ç¢°å°è¿ç§æ
åµä¸è¦å¨ä¸å¨å°±éè£
æ°æ®åºï¼æå
¶ä¸æ¹æ³ä¿®æ¹å³å¯
ããå¿è®°sysï¼systemç¨æ·çå¯ç ï¼
ãã使ç¨ORAPWD.EXEå·¥å
·ä¿®æ¹å¯ç ï¼å¨å¼å§èåç¹å»âè¿è¡âï¼è¾å
¥âcmdâï¼æå¼å½ä»¤æ示çªå£ï¼è¾å
¥å¦ä¸å½ä»¤ï¼
ããorapwd file=d:\oracle\product\10.1.0\Db_2\database\pwdctcsys.ora password=123456
ããè¿ä¸ªå½ä»¤éæ°çæäºæ°æ®åºå¯ç æ件ãå¯ç æ件çä½ç½®å¨ORACLE_HOMEç®å½ä¸ç\databaseç®å½ä¸ãè¿ä¸ªå¯ç æ¯ä¿®æ¹sysç¨æ·çå¯ ç ã é¤äºsysåsystemå
¶å®ç¨æ·çå¯ç ä¸ä¼æ¹åã
ããå¿è®°systemç¨æ·çå¯ç ï¼
ããå¯ä»¥ç¨sysç¨æ·ç»å½ãç¶åç¨alter userå½ä»¤ä¿®æ¹å¯ç ãå¦ï¼
ããconn sys/pass_word as sysdba;
ããalter user system identified by newpass;
ããå¿è®°sysç¨æ·å¯ç ï¼
ããå¯ä»¥ç¨systemç¨æ·ç»å½ãç¶åç¨alert user å½ä»¤ä¿®æ¹å¯ç ï¼å¦ï¼
ããCONN SYSTEM/PASS_WORD;
ããALTER USER SYSTEM IDENTIFIED BY NEWPASS;
ããå¿è®°é¤sys/systemç¨æ·ä¹å¤çç¨æ·çç»å½å¯ç ã
ããç¨sysï¼æè
systemï¼ç»å½ãCONN SYS/PASS_WORD AS SYSDBA;
ãã使ç¨å¦ä¸è¯å¥ä¿®æ¹ç¨æ·çå¯ç ãALTER USER USER_NAME IDENTIFIED BY NEWPASS;主è¦å¯ç ä¸è½æ¯å
¨æ°åä¸ä¸è½ä»¥æ°åå¼å¤´ã
ãã(1)CONN SYS/PASS AS SYSDBA;//以DBAç身份ç»å½
温馨提示:答案为网友推荐,仅供参考