æ¹æ³/æ¥éª¤
1
ç¨CRT以å®è£
oracleæ°æ®åºçç¨æ·è¿æ¥oracleæ°æ®åºæå¨æå¡å¨ã ï¼ä»¥æå¡å¨ä¸ºlinux 为ä¾ï¼
2
è¾å
¥å½ä»¤: sqlplus /nolog ,è¿å
¥oracleæ§å¶å°ï¼å¹¶è¾å
¥ conn /as sysdba;以DBAè§è²è¿å
¥ã
3
è¿æ¥æååï¼è¾å
¥âselect username from dba_usersâæ¥çç¨æ·å表ã
4
è¥ä¿®æ¹æä¸ä¸ªç¨æ·å¯ç ï¼ ä¿®æ¹ç¨æ·å£ä»¤ æ ¼å¼ä¸ºï¼
alter user ç¨æ·å identified by æ°å¯ç ï¼
以 apps 为ä¾ï¼å¯ç ä¿®æ¹ä¸º 123456. å¯è¾å
¥
alter user apps identified by 123456;
5
è¿æ ·å°±ä¿®æ¹æåäºã
http://jingyan.baidu.com/article/9f63fb91b786d5c8400f0eec.html