Dear a_r_i_a and Aris, Tampaknya masalahnya karena command-nya itu loh
Shutdown transactional --> menunggu dulu sampai semua proses/transaksi selesai (dan comman ini menolak semua koneksi/session baru yang mau join) Ya itu dia, makanya semua PID harus dikill dulu. Yah, resikonya lama menunggu :) Tapi, kalau dengan shutdown transactional kita gak perlu recover database lagi pas nanti startup -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of a_r_i_a Sent: 16 Agustus 2006 13:52 To: [email protected] Subject: RE: [indo-oracle] sun solaris hang Dear Aris, Dari pengalaman saya pada saat shutdown database memang lama sebab masih ada user yang login. Jika saya shutdown database biasanya saya melakukan #ps -lef | grep lgwr. Jika ada proses dengan keterangan (LOCAL-NO) saya kill. 8 S oracle8i 1699 1 0 50 20 ? 79545 ? 10:38:43 ? 0:00 oracledbsgcpro (LOCAL=NO) 8 S oracle8i 1607 1 0 50 20 ? 80163 ? 10:18:26 ? 0:05 oracledbsgcpro (LOCAL=NO) Jika saya sudah kill process shutdown tidak lama. Saya juga pernah melakukan process startup pada saat process shutdown yang lama tadi, muncul pesan lagi process shutdown tapi tidak sampai hang seperti Mas. Jadi paling engga' kalo mau shutdown liat user dulu masih login atau tidak. Regards, Aria -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of aris munawar Sent: Monday, August 14, 2006 2:34 PM To: [email protected] Cc: 'aris' Subject: SPAM-LOW: [indo-oracle] sun solaris hang Halo oraclers, Saya mencoba membackup oracle dngan coldbackup pada sun solaris, Saya shutdown transactional...prosesnya lama sekali..akhirnya saya memutuskan untuk mnegcopy files oracle ke tempat lain. Setelah itu Saya mencoba melakukan startup ... tapi pesannya proses shutdown masih berlangsung spt itulah. Lalu os hang dengan pesan the space full, no swap spaces to grow stac pid 561. saya coba telnet juga gak bisa, dengan hipertelnet juga gak bisa dgn error message yang sama. Akhirnya saya reset manual pada powernya Mungkin ada yang tahu masalah seperti ini. Rgds, Aris -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links ========================================================= This e-mail, including any attachment is confidential and may be privileged. Use or disclosure of it by anyone other than an intended adressee is strictly prohibited. If you are not an intended addressee, please notify the sender by telephone or e-mail and delete the e-mail and any attachment from your system. PT Excelcomindo Pratama Tbk. ("the " Company") does not accept any liability in respect of communication made by its employee which is contrary to the company policy or outside the scope of the employment of the individual concerned. The employee responsible will be personally liable for any damages or other liability arising. ========================================================= -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
