kenji-sama 0 Report post Posted August 31, 2008 slm sjhtra..aku ada install oracle9i..masa installation takda hal tapi bila dah slesai install,aku nak connect sbgi sysdba tp takleh connect n ada msj, "ORA-01031: insufficient privileges"...aku dah try bnyak kali n pelbagai cara tp sama gak...aku tak tau apa prblm dia sbb aku bru2 gak bljr oracle ni...ssapa yg ada pngalaman yg 'lbh kurang' tolong explain ckit apa prblm dia...tq.. Quote Share this post Link to post Share on other sites
fatah 0 Report post Posted September 2, 2008 (edited) Biasanya saya pakai: 1. akaun 'sys', atau 2. terminal/command prompt pada oracle user loginuntuk dapatkan privilege sysdba seperti contoh:# export ORACLE_SID=<SID> (jika unix)# set ORACLE_SID=<SID> (jika windows)# sqlplus /nologSQL> conn / as sysdba (#2)atauSQL> conn sys/sql as sysdba (#1) Edited September 2, 2008 by fatah Quote Share this post Link to post Share on other sites
kenji-sama 0 Report post Posted September 3, 2008 thnx bro..tp sy kurg paham la..ble xplain ckit cmne nak buat tu..# set ORACLE_SID=<SID> Quote Share this post Link to post Share on other sites
fatah 0 Report post Posted September 4, 2008 Tanda < dan > adalah diwajibkan isi. SID adalah Oracle System IDSila rujuk http://www.orafaq.com/wiki/ORACLE_SID Quote Share this post Link to post Share on other sites