referensi, pengalaman dgn antivirus yg super duper sensitif. :D
2009/11/12 Kalam Harun <[email protected]>: > iya servernya pake windows server 2003 dan ada antivirusnya yg active... > klo boleh tau ada referencenya gak, bahwa file milik oracle tsb ke-lock sama > antivirusnya ... > > thanks, > > 2009/11/12 murdi santoso <[email protected]> > >> >> >> kalau boleh tau server itu pakai o/s window ya ... dan antivirus di server >> itu aktive ya.. >> coba antivirusnya dimatikan .. >> mudah-mudahan kalau tidak salah file milik oracle ke -lock karna antivirus >> tersebut. >> >> >> ----- Original Message ---- >> From: Kalam Harun <[email protected] <kalamharun%40gmail.com>> >> To: [email protected] <indo-oracle%40yahoogroups.com> >> Sent: Thu, November 12, 2009 10:27:26 AM >> Subject: Re: [indo-oracle] ORACLE instance terminated. Disconnection force >> >> kalau error yg muncul di client ketika akan connect adalah: >> ORA-01092: ORACLE instance terminated. Disconnection force >> >> utk hasil query dari v$resource_limit: >> RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION >> INITIAL_ALLOCATION LIMIT_VALUE >> processes 18 19 200 200 >> sessions 15 17 225 225 >> >> kalau saya lihat lognya spt ini: >> ... >> Errors in file E:\oracle\admin\samacc\bdump\samaccCKPT.TRC: >> ORA-00206: error in writing (block 3, # blocks 1) of controlfile >> ORA-00202: controlfile: 'E:\ORACLE\ORADATA\SAMACC\CONTROL02.CTL' >> ORA-27072: skgfdisp: I/O error >> OSD-04008: WriteFile() failure, unable to write to file >> O/S-Error: (OS 33) The process cannot access the file because another >> process has locked a portion of the file. >> CKPT: terminating instance due to error 221 >> Instance terminated by CKPT, pid = 3924 >> ... >> >> Demikian barangkali ada bisa membantu... >> Thanks >> >> 2009/11/12 murdi santoso <[email protected] <sandi_ui%40yahoo.com>> >> >> > >> > >> > hi, >> > >> > bisa dijelaskan message error ORA yg keluar ..? >> > bisa check data total process dan total session yg di set di parameter >> pada >> > saat kondisi load tinggi..? >> > cek nya bisa dari view v$resource_limit. >> > >> > BR, >> > MS >> > >> > ________________________________ >> > From: Kalam Harun <[email protected] >> > <kalamharun%40gmail.com><kalamharun% >> 40gmail.com>> >> > To: [email protected] >> > <indo-oracle%40yahoogroups.com><indo-oracle% >> 40yahoogroups.com> >> >> > Sent: Thu, November 12, 2009 9:27:48 AM >> > Subject: [indo-oracle] ORACLE instance terminated. Disconnection force >> > >> > >> > Hallo DBA expert, >> > >> > Beberapa kali saya mengalami kasus seperti subject di atas. Client tidak >> > bisa connect, pesannya persis sama. >> > Saat ini yng dilakukan adalah restart server tsb dan kembali normal. >> > >> > Kira-kira apa penyebabnya dan solusi seharusnya apa ? >> > Untuk informasi, oracle yg digunakan oracle 8.1.7 dengan Windows Server >> > 2003. User/aplikasi yg connect tidak banyak antara 3-10 pc. >> > >> > Terima kasih sebelumnya, >> > >> > Kalam >> > >> > [Non-text portions of this message have been removed] >> > >> > [Non-text portions of this message have been removed] >> > >> > >> > >> >> [Non-text portions of this message have been removed] >> >> ------------------------------------ >> >> >> -- >> -----------I.N.D.O - O.R.A.C.L.E--------------- >> Keluar: >> [email protected]<indo-oracle-unsubscribe%40yahoogroups.com> >> Website: http://indooracle.wordpress.com >> http://www.facebook.com/group.php?gid=51973053515 >> ----------------------------------------------- >> >> Bergabung dengan Indonesia Thin Client User Groups, >> Terminal Server, Citrix, New Moon Caneveral, di: >> http://indo-thin.blogspot.comYahoo! Groups Links >> >> >> > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [email protected] > Website: http://indooracle.wordpress.com > http://www.facebook.com/group.php?gid=51973053515 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.comYahoo! Groups Links > > > > -- thanks and regards ujang | oracle dba | mysql dba jakarta - indonesia
