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 <[email protected]> To: [email protected] 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]
