Terimakasih atas kiriman attachmentnya Pak.. Regard's
IH --- On Thu, 12/18/08, eko suprijantono <[email protected]> wrote: From: eko suprijantono <[email protected]> Subject: Re: [indo-oracle] Needed help : ORA-12514 To: [email protected] Date: Thursday, December 18, 2008, 3:08 AM coba pelajari attachment nya y... mudah2an relevance... kalo tidak... mungkin bisa minta tolong yg lain ... ____________ _________ _________ __ From: Izzudin Hanafie <izzudin...@yahoo. com> To: indo-oracle@ yahoogroups. com Sent: Thursday, December 18, 2008 2:09:23 PM Subject: Re: [indo-oracle] Needed help : ORA-12514 Pak Eko, Saya sudah coba tambahkan di listener.ora lalu saya restart, tetapi listenernya tidak mau naik...hiks. .hiks. Mohon saran dan bantuannya.. :(( Regard's IH --- On Thu, 12/18/08, eko suprijantono <ekosuprijantono@ yahoo.com> wrote: From: eko suprijantono <ekosuprijantono@ yahoo.com> Subject: Re: [indo-oracle] Needed help : ORA-12514 To: indo-oracle@ yahoogroups. com Date: Thursday, December 18, 2008, 1:18 AM Tidak perlu mati ... u/ nambahinnya ... tapi setelah diubah biar ada dampaknya .. listener hrs direstart ... restart listenernya di command com aja .. biar kita bisa liat servicenya udh tersedia atau belum... ____________ _________ _________ __ From: Izzudin Hanafie <izzudin_aq@ yahoo. com> To: indo-oracle@ yahoogroups. com Sent: Thursday, December 18, 2008 1:10:28 PM Subject: Re: [indo-oracle] Needed help : ORA-12514 Mas Eko, Bila ingin menambahkan baris : (SID_DESC = (GLOBAL_DBNAME = teststdby) (ORACLE_HOME = D:\oracle\product\ 10.2.0\db_ 1) (SID_NAME = teststdby) ) ) di listener.ora- nya, apakah database harus dalam kondisi offline ?. Ataukah bila online tidak masalah sama sekali. Mohon infonya, Regards IH --- On Wed, 12/17/08, eko suprijantono <ekosuprijantono@ yahoo.com> wrote: From: eko suprijantono <ekosuprijantono@ yahoo.com> Subject: Re: [indo-oracle] Needed help : ORA-12514 To: indo-oracle@ yahoogroups. com Date: Wednesday, December 17, 2008, 11:50 PM Pengalaman saya pastikan di file listener.ora ada panggil servicenya database yg dibuat dalam hal ini db service sy saya teststdby SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\product\ 10.2.0\db_ 1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = teststdby) (ORACLE_HOME = D:\oracle\product\ 10.2.0\db_ 1) (SID_NAME = teststdby) ) ) LISTENER = (DESCRIPTION_ LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = servertest)( PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) ) Mudah2an sesuai... ____________ _________ _________ __ From: Izzudin Hanafie <izzudin_aq@ yahoo. com> To: indo-oracle@ yahoogroups. com Sent: Thursday, December 18, 2008 11:40:41 AM Subject: [indo-oracle] Needed help : ORA-12514 Dear master's, Adakah yang pernah mengalami error : ORA-12514:TNS: listener does not currently know of service requested in connect descriptor. Kejadiannya ketika selesai mengupdate patch Windows 2003 Server pada malam hari (semalem), lalu tiba-tiba pagi ini service Oracle database selalu mati, walaupun sudah distart lagi tetapi beberapa saat akan mati kembali. Mohon bantuannya, Regards IH [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] [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] [Non-text portions of this message have been removed]
