Thanks a lot.. :D
Best Regards,
Andes
Yoel <[EMAIL PROTECTED]> wrote: yup, betul.
Good luck :)
On 8/3/06, Ryant Febrian <[EMAIL PROTECTED]> wrote:
>
> walah salah ya..
> Ow.. jd distributed_transaction itu static parameter. dan klo ga ada di
> init.ora file, berarti harus di tambahkan.
> Maaf pak yoel, berarti seperti ini klo di tambahkan di init.ora dan
> dirubah ya ?
>
> init.ora
>
> distributed_transactions = 60 (sebelumnya value ditempat saya 50)
>
> lalu database di restart kan? makasih, maaf merepotkan dan saya yg agak
> lemot. :D
>
>
> Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com>> wrote:
> distributed_transactions ada lah static parameter.
>
> jadi harus dirubah di init.ora dan di restart
>
> On 8/3/06, Ryant Febrian <[EMAIL PROTECTED] <pejantan_4u%40yahoo.com>>
> wrote:
> >
> > Ok. Makasih atas tutorial singkatnya tp padat dan bermakna :)
> > saya ulang ya, hehehehe.. jd klo saya rubah parameter dengan
> > ALTER SYSTEM SET distributed_transactions = 60; maka database tidak
> perlu
> > di restart. Ok, makasih banyak atas bantuannya.
> >
> > Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com> <yoel.ade%40gmail.com>>
> wrote: hhmmmm...
>
> >
> > V$ adalah dynamic performance view, it is not meant to be updated.
> > rubah oracle parameter itu menggunakan
> > 1. 'ALTER SYSTEM SET <parameter name> = <value>' (untuk dynamic
> parameter)
> > 2. Ubah di Init.ora file (untuk static & dynamic parameter)
> >
> > Untuk static parameter harus di restart databasenya, supaya membaca
> > parameter yang baru.
> >
> > On 8/2/06, Ryant Febrian <[EMAIL
> > PROTECTED]<pejantan_4u%40yahoo.com><pejantan_4u%
> 40yahoo.com>>
>
> > wrote:
> > >
> > > Maaf tanya lg.. hehehehe, masih lemot nie
> > > bila di tempat saya setelah di show parameter
> > >
> > >
> > > NAME TYPE VALUE
> > > ------------------------------------ -------
> > > ------------------------------
> > > distributed_transactions integer 50
> > >
> > > bila saya rubah parameternya, berarti saya update table v$parameter
> set
> > > value = 60 where name distributed_transactions;
> > > harus kah saya restart lg databasenya atau cukup di commit aja? lalu
> > kira2
> > > berpengaruh ga ya nantinya?
> > >
> > > sekali lagi saya ucapkan terima kasih atas bantuannya :)
> > >
> > > Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com> <yoel.ade%40gmail.com>
> <yoel.ade%40gmail.com>>
>
> > wrote: Ini saya coba pake
> >
> > > Oracle 8.1.7
> > >
> > >
> > > SQL> nect / as sysdba
> > > Connected.
> > > SQL> show parameter distributed_transactions
> > >
> > > NAME TYPE VALUE
> > > ------------------------------------ -------
> > > ------------------------------
> > > distributed_transactions integer 500
> > > SQL>
> > >
> > > kalo misalnya tidak ada di init file ya tinggal di tambahkan saja.
> > >
> > > Mengenai nilainya berapa, saya kurang tau.
> > > karena tidak pernah pakai. Mungkin bisa di coba dinaikan sedikit2.
> > > tidak bisa lebih dari parameter transactions
> > >
> > > Thanks
> > >
> > > On 8/1/06, Ryant Febrian <[EMAIL PROTECTED]<pejantan_4u%40yahoo.com>
> <pejantan_4u%40yahoo.com><pejantan_4u%
>
> > 40yahoo.com>>
> > > wrote:
> > > >
> > > > Maaf saya masih belum paham, tentang distributed_transactions
> > parameter
> > > > di init.ora file, krn setalah saya cari2 tidak ada
> > > > distributed_transactions. Apakah ada nama lain dr parameter tersebut
> > yg
> > > di
> > > > rubah? klo di rubah, misal, sampai batas berapakah saya harus
> > > merubahnya?
> > > >
> > > > Terima kasih
> > > >
> > > > Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com> <
> yoel.ade%40gmail.com> <yoel.ade%40gmail.com>
> > <yoel.ade%40gmail.com>>
> >
> > > wrote: di init.ora file.
> > >
> > > >
> > > >
> > > > On 8/1/06, Ryant Febrian <[EMAIL PROTECTED]<pejantan_4u%40yahoo.com>
> <pejantan_4u%40yahoo.com>
> > <pejantan_4u%40yahoo.com><pejantan_4u%
>
> >
> > > 40yahoo.com>>
> > > > wrote:
> > > > >
> > > > > Saya menggunakan oracle versi 8.1.6 OS SunOS.
> > > > > klo distributed_transactions parameter itu saya tinggal alter aja
> > > > > menggunakan user sys as sysdba atau di rubah di file init.ora??
> > > > >
> > > > > Terima Kasih
> > > > >
> > > > > Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com> <
> yoel.ade%40gmail.com> <
> > yoel.ade%40gmail.com> <yoel.ade%40gmail.com>
> > > <yoel.ade%40gmail.com>>
> > >
> > > > wrote: ada
> > > >
> > > > > DISTRIBUTED_TRANSACTIONS parameter,
> > > > >
> > > > > tapi obsolete untuk Oracle 9i R2 ke atas.
> > > > >
> > > > > Anda pake version brapa? OSnya apa
> > > > >
> > > > > On 8/1/06, Ryant Febrian <[EMAIL PROTECTED]<pejantan_4u%40yahoo.com>
> <pejantan_4u%40yahoo.com>
> > <pejantan_4u%40yahoo.com>
> > > <pejantan_4u%40yahoo.com><pejantan_4u%
> >
> > >
> > > > 40yahoo.com>>
> > > > > wrote:
> > > > > >
> > > > > > iya, akhirnya saya restart aja mesinnya dan databasenya otomatis
> > > mati
> > > > > > dan saya nyalain lagi. tp adakah solusi selain itu?? adakah cara
> > > > supaya
> > > > > > distributed transactions nya di perbesar? bila ada apanya yg
> harus
> > > > saya
> > > > > > ubah? Mohon bantuannya. :D
> > > > > >
> > > > > > Terima Kasih
> > > > > >
> > > > > > Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com> <
> yoel.ade%40gmail.com> <
> > yoel.ade%40gmail.com> <
> > > yoel.ade%40gmail.com> <yoel.ade%40gmail.com>
> > > > <yoel.ade%40gmail.com>>
> > > >
> > > > > wrote: taken from oracle
> > > > >
> > > > > > documentation
> > > > > >
> > > > > >
> > > > > > ORA-02042: too many distributed transactions Cause: the
> > distributed
> > > > > > transaction table was full because too many distributed
> > transactions
> > > > > were
> > > > > > active.
> > > > > > Action: Run fewer transactions. If you are sure you don't have
> too
> > > > many
> > > > > > concurrent distributed transactions, this indicates an internal
> > > error
> > > > > and
> > > > > > support should be notified. Instance shutdown/restart would be a
> > > > > > work-around.
> > > > > >
> > > > > > On 8/1/06, Ryant Febrian <[EMAIL
> > > > > > PROTECTED]<pejantan_4u%40yahoo.com>
> <pejantan_4u%40yahoo.com>
> > <pejantan_4u%40yahoo.com>
> > > <pejantan_4u%40yahoo.com>
> > > > <pejantan_4u%40yahoo.com><pejantan_4u%
> > >
> > > >
> > > > > 40yahoo.com>>
> > > > >
> > > > > > wrote:
> > > > > > >
> > > > > > > Hi rekan2 semua..
> > > > > > >
> > > > > > > Saya mendapatkan eror seperti dibawah ini :
> > > > > > >
> > > > > > > ORA-02042: too many distributed transactions
> > > > > > >
> > > > > > > Apa yg harus saya lakukan supaya tidak terjadi eror seperti
> ini
> > > lg?
> > > > > > apakah
> > > > > > > ini ada hubungan dgn file init.ora ? atau adakah yg harus saya
> > > rubah
> > > > ?
> > > > > > > Dan untuk yg connect catalog, net service itu seperti
> > > > > > > localhost.localdomain kan??
> > > > > > >
> > > > > > > Terima kasih
> > > > > > >
> > > > > > >
> > > > > > > ---------------------------------
> > > > > > > Groups are talking. We´re listening. Check out the handy
> > > > changes
> > > > > > to
> > > > > > > Yahoo! Groups.
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > ---------------------------------
> > > > > > Yahoo! Music Unlimited - Access over 1 million songs.Try it
> free.
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > __________________________________________________
> > > > > Do You Yahoo!?
> > > > > Tired of spam? Yahoo! Mail has the best spam protection around
> > > > > http://mail.yahoo.com
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > ---------------------------------
> > > > Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great
> > > rates
> > > > starting at 1�/min.
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------
> > > Do you Yahoo!?
> > > Get on board. You're invited to try the new Yahoo! Mail Beta.
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > See the all-new, redesigned Yahoo.com. Check it out.
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> ---------------------------------
> Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+
> countries) for 2�/min or less.
>
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates
starting at 1¢/min.
[Non-text portions of this message have been removed]
--
-----------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/
