Pak Andes, berati sebelumnya setelah install oracle , environment Oracle nya belom di set atau gimana nih? seperti ORACLE_HOME, LD_LIBRARY_PATH,ORACLE_SID,etc ? Kalo belom yah sebenernya , masalah itu karena ORACLE_SID nya belum di set ketika ingin mengakses Sqlplus ( sqlplus / as sysdba). Terutama jika kita tidak setting ORACLE_SID nya di .profile user oracle.
.profile , tidak masalah kok kamu buat lagi sendiri yang penting perhatikan privileges dari file tersebut supaya bisa diakses paling tidak oleh user itu sendiri "oracle". cheers, Andrew ----- Original Message ---- From: Andes Febrian <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, 25 September 2008 12:09:47 Subject: Re: [indo-oracle] ERROR: ORA-01031: insufficient privileges on solaris 10 Ow begitu. thanks pak. btw, saya mau tanya niy, saya coba uninstall db trs re-create oracle user. kemudian ketika re-create user oracle, saya lihat di /home/oracle ga ada .profile, akhirnya saya buat file .profile kemudian di isi dgn setingan parameter oracle dari oracle sid, home, library path dan classpath. trs coba lagi install db, setelah selesai, error insuficient privileges ilang pak, cuma memang ketika login pada servernya langsung, bukan remote, muncul eror sqlplus not found, harus di set su - oracle dulu. yg saya tanyakan, tidak apakah membuat .profile sendiri ? On Wed, Sep 24, 2008 at 8:05 PM, Andrew E.K. <[EMAIL PROTECTED] com> wrote: > Aloo > > Iya, kebetulan patch number yang saya kasih itu untuk Solaris 10 Sparc - > Oracle 10g R2. Moga2 sama nih platformnya. Soalnya saya setiap abis install > oracle 10g R2 di Solaris 10 juga kena masalah ini pak :). Abis patch ini > langsung sembuh kok :) > > > cheers, > > Andrew > > ----- Original Message ---- > From: Andes Febrian <[EMAIL PROTECTED] com <pejantan4u% 40gmail.com> > > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > Sent: Wednesday, 24 September 2008 18:11:57 > Subject: Re: [indo-oracle] ERROR: ORA-01031: insufficient privileges on > solaris 10 > > Hi andrew, > > saya belum bisa buka metalink, dikarenakan bad koneksi. apakah patch ini > berlaku di Solaris 10 ? > > thanks > > On Wed, Sep 24, 2008 at 4:53 PM, Andrew E.K. <[EMAIL PROTECTED] com> wrote: > > > Hi Andes, > > > > Ini dikarenakan bugs di oracle 10g R2 saat instalasi di beberapa O/S . > Kamu > > bisa download patch nya di metalink : > > > > Patch Number 4516865 > > > > Description WRONG PERMISSIONS AFTER INSTALLATION IN OH AND SUBSEQUENT > > DIRECTORIES > > Product Oracle Database Family > > Semoga membantu :) > > > > cheers, > > > > Andrew > > > > > > ----- Original Message ---- > > From: Andes Febrian <pejantan4u@ gmail. com <pejantan4u% 40gmail.com> > > > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > > Sent: Wednesday, 24 September 2008 17:21:33 > > Subject: [indo-oracle] ERROR: ORA-01031: insufficient privileges on > solaris > > 10 > > > > Dear gurus, > > > > saya baru install oracle 10g R2 di Solaris 10, setelah selesai installasi > > mau masuk sqlplus, > > > > $sqlplus / as sysdba > > > > ERROR: ORA-01031: insufficient privileges > > > > muncul eror seperti di atas, knp ya masalahnya ? udah googling ga nemu2. > > thanks > > > > -- > > Cheers, > > ^_^ Andes ^_^ > > > > [Non-text portions of this message have been removed] > > > > New Email addresses available on Yahoo! > > Get the Email name you've always wanted on the new @ymail and > > @rocketmail. > > Hurry before someone else does! > > http://mail. promotions. yahoo.com/ newdomains/ sg/ > > > > [Non-text portions of this message have been removed] > > > > > > > > -- > Cheers, > ^_^ Andes ^_^ > > [Non-text portions of this message have been removed] > > Try cool new emoticons, skins, plus more space for friends. > Download Yahoo! Messenger Singapore now! > http://sg.messenger .yahoo.com > > [Non-text portions of this message have been removed] > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed] Get your preferred Email name! Now you can @ymail.com and @rocketmail.com http://mail.promotions.yahoo.com/newdomains/sg/ [Non-text portions of this message have been removed]
