聽

瀛︿範鏁版嵁搴擄紝棣栧厛寰楀厛鐧婚檰鏁版嵁搴擄紝鐧婚檰闇€瑕佽处鍙峰惂锛?/p>

聽

閭ｆ垜浠氨鍏堜簡瑙racle瀵硅处鍙风殑绠＄悊浠ュ強瑙勫垯锛?/p>

聽

瀵逛互鍚庝竴浜涙秹鍙婂埌鏁版嵁搴撳畨鍏ㄣ€佺敤鎴锋潈闄愬彲浠ユ洿濂界殑澶勭悊銆?/p>

聽

聽

榛樿鐢ㄦ埛

Oracle瀹夎浼氳嚜鍔ㄧ殑鐢熸垚sys鐢ㄦ埛鍜宻ystem鐢ㄦ埛:

锛?锛?sys鐢ㄦ埛鏄秴绾х敤鎴凤紝鍏锋湁鏈€楂樻潈闄愶紝鍏锋湁sysdba瑙掕壊锛屾湁create database鐨勬潈闄愶紝璇ョ敤鎴烽粯璁ょ殑瀵嗙爜鏄痗hange_on_install

锛?锛?system鐢ㄦ埛鏄鐞嗘搷浣滃憳锛屾潈闄愪篃寰堝ぇ銆傚叿鏈塻ysoper瑙掕壊锛屾病鏈塩reate database鐨勬潈闄愶紝榛樿鐨勫瘑鐮佹槸manager

锛?锛?涓€鑸锛屽鏁版嵁搴撶淮鎶わ紝浣跨敤system鐢ㄦ埛鐧诲綍灏卞彲浠ユ媺 涔熷氨鏄sys鍜宻ystem杩欎袱涓敤鎴锋渶澶х殑鍖哄埆鏄湪浜庢湁娌℃湁create database鐨勬潈闄愩€?/p>

聽

鍒涘缓鐢ㄦ埛聽
姒傝堪锛氬湪oracle涓鍒涘缓涓€涓柊鐨勭敤鎴蜂娇鐢?/span>create user璇彞锛屼竴鑸槸鍏锋湁dba(鏁版嵁搴撶鐞嗗憳)鐨勬潈闄愭墠鑳戒娇鐢ㄣ€?/span>
create user 鐢ㄦ埛鍚?/span> identified by 瀵嗙爜; (oracle鏈変釜姣涚梾锛屽瘑鐮佸繀椤讳互瀛楁瘝寮€澶达紝濡傛灉浠ュ瓧姣嶅紑澶达紝瀹冧笉浼氬垱寤虹敤鎴?/span>)

聽

缁欑敤鎴蜂慨鏀瑰瘑鐮?/span>聽
姒傝堪锛氬鏋滅粰鑷繁淇敼瀵嗙爜鍙互鐩存帴浣跨敤
password 鐢ㄦ埛鍚?/span>
濡傛灉缁欏埆浜轰慨鏀瑰瘑鐮佸垯闇€瑕佸叿鏈?/span>dba鐨勬潈闄愶紝鎴栨槸鎷ユ湁alter user鐨勭郴缁熸潈闄?/span>
SQL> alter user 鐢ㄦ埛鍚?/span> identified by 鏂板瘑鐮?/span>
聽