Hello om agus, Untuk problem pertama bisa lihat reply dari om Yoel Susanto.
Untuk problem lainnya, penjelasan yang saya dapat: --------- ORA-12518: TNS:listener could not hand off client connection Your server is probably running out of memory and need to swap memory to disk. One cause can be an Oracle process consuming too much memory. A possible workaround is to set following parameter in the listener.ora and restart the listener: DIRECT_HANDOFF_TTC_LISTENER=OFF Should you be working with Multi threaded server connections, you might need to increase the value of large_pool_size. --------- -- Best regards, Wadi Achmed --------------Original Message-------------- Monday, May 21, 2007, 11:15:36 AM, you wrote: terima kasih semuanya atas jawabannya di tnsname maupun di listener nya sudah semuanya mengacu ke server. waktu pertama juga saya pikir masalah di host name nya tetapi saya rubah semunya menggunakan ip address saja (biar aman). apa dari segi os nya ? saya menggunakan win2003 r2 sampai saat ini saya masih menggunakan solusi restart servernya dan juga pada saat running beberapa saat muncul error : ORA-12518 TNS-LISTENER could not hand off client connection solusi : restart servernya adakah solusi lainnya ? terima kasih, ags ----- Original Message ---- From: Wadi Achmed <[EMAIL PROTECTED]> To: agus purwanto <[email protected]> Sent: Monday, May 21, 2007 10:04:04 AM Subject: Re: [indo-oracle] Startup di 10g Hello Om Agus, Coba cek di listener.ora nya apakah host nya sama dengan nama server/komputer? Kalo di windows bisa dilihat di system properties, kalo *nix family bisa lihat di /etc/hosts, atau di solaris pakai command hostname di console nya. -- Best regards, Wadi Achmed ------------ --Original Message----- --------- Monday, May 21, 2007, 7:42:37 AM, you wrote: Salam, saya punya masalah waktu startup database 10g. pada waktu saya shutdown --> database shutdown sql> shutdown immediate; tetapi pada saat saya startup sql> startup; muncul error host ... doesn't exists itu error karena apa ya? pada saat saya pakai syntax tersebut di 9i tidak masalah, apakah ada settingngan lagi yg belum saya buat. terima kasih, ags __________________________________________________________Get the free Yahoo! toolbar and rest assured with the added security of spyware protection. http://new.toolbar.yahoo.com/toolbar/features/norton/index.php [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/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
