saya sudah pastikan SID nya benar, dan di alert log ada error seperti ini "sculkget: failed to lock /u02/oracle/product/10.2//dbs/lk+ASM exclusive" kemudian saya coba hapus file lk+ASM ini. dan coba jalankan startup lagi tapi tetep error, bash-3.2$ echo $ORACLE_SID +ASM bash-3.2$ pwd /u02/oracle/product/10.2/dbs bash-3.2$ cd ../bin/ bash-3.2$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Jul 14 13:05:16 2009 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. Connected to an idle instance. SQL> shutdown abort ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 130023424 bytes Fixed Size 2071104 bytes Variable Size 102786496 bytes ASM Cache 25165824 bytes ORA-15000: command disallowed by current instance type di alert log terdapat error seperti ini : Tue Jul 14 13:05:25 2009 ORA-15000 signalled during: ALTER DATABASE MOUNT... klo misal saya deinstall oracle software, apakah asm instance nya hilang juga ? 2009/7/14 gugukerz <[email protected]> > > > pastiin SIDnya udah bener belum? > > kalo saya biasa liat SID di $ORACLE_BASE/admin > > disitu biasanya ada folder untuk tiap2 SID, lalu cek juga ASM instancenya > udah up lom? > > liat lognya deh... > > Pada 14 Juli 2009 11:51, Andes Febrian > <[email protected]<pejantan4u%40gmail.com>> > menulis: > > > > > > > > thanks atas respon nya, tadi udah coba, ini hasil nya : > > bash-3.2$ export ORACLE_SID=+ASM > > bash-3.2$ sqlplus / as sysdba > > > > SQL*Plus: Release 10.2.0.3.0 - Production on Tue Jul 14 11:50:07 2009 > > > > Copyright (c) 1982, 2006, Oracle. All Rights Reserved. > > > > Connected to an idle instance. > > > > SQL> > > > > FYI, pake AIX 5.3 > > > > ORACLE_SID nya pake +ASM1, kek gini jg hasilnya : > > bash-3.2$ export ORACLE_SID=+ASM1 > > bash-3.2$ sqlplus / as sysdba > > > > SQL*Plus: Release 10.2.0.3.0 - Production on Tue Jul 14 11:51:14 2009 > > > > Copyright (c) 1982, 2006, Oracle. All Rights Reserved. > > > > Connected to an idle instance. > > > > SQL> > > > > need help.. > > > > 2009/7/14 gugukerz > > <[email protected]<muhamad.irvansyah%40gmail.com> > <muhamad.irvansyah%40gmail.com> > > > > > > > > > > > > > > > > coba jawab... > > > > > > coba dari sqlplus tapi ubah dulu seting environtment yang ORACLE_SID > > > menjadi > > > SIDnya ASM > > > > > > biasanya +ASM. > > > > > > setelah itu coba drop diskgroup <diskgroupname>; > > > > > > salam > > > > > > Pada 14 Juli 2009 11:37, Andes Febrian > > > <[email protected]<pejantan4u%40gmail.com> > <pejantan4u%40gmail.com> > > <pejantan4u%40gmail.com>> > > > menulis: > > > > > > > > > > > > > > > > > > Dear gurus, > > > > > > > > bagaimana cara hapus disk group yang baru saja saya create/configure, > > > pada > > > > server yang hanya baru di install oracle software ? saya mau create > > ulang > > > > disk group nya, tapi hapus dulu yg baru saja di create. coba drop > > > > menggunakan sqlplus, ga bisa. menggunakan EM, database blm ada. hapus > > > dari > > > > dbca, ga ada tombol hapus asm disk group. ada yang bisa sharing > caranya > > ? > > > > THanks. > > > > > > > > Regards, > > > > ANdes > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > -- > > > silahkan kunjungi alamat berikut : > > > wwwdotirvandotcodotnr > > > irvandotsite90dotnet > > > cunk-krinkdotblogspotdotcom > > > cunkrink543dotmultiplydotcom > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > -- > > Cheers, > > ^_^ Andes ^_^ > > > > [Non-text portions of this message have been removed] > > > > > > > > -- > silahkan kunjungi alamat berikut : > wwwdotirvandotcodotnr > irvandotsite90dotnet > cunk-krinkdotblogspotdotcom > cunkrink543dotmultiplydotcom > > [Non-text portions of this message have been removed] > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
