apakah baris2 di listener nya sudah bener pak ? klo sudah, coba listener nya di up dari service, jgn melalui cmd.
dan bila start database jg dari service jgn pake cmd. klo mo pake cmd, coba anda gunakan alias tns names nya ketika login ke oracle i.e : sqlplus sys/ora...@orcl as sysdba baru setelah itu start semoga membantu, 2008/12/18 Izzudin Hanafie <[email protected]> > 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 > <[email protected]<ekosuprijantono%40yahoo.com>> > wrote: > From: eko suprijantono <[email protected]<ekosuprijantono%40yahoo.com> > > > Subject: Re: [indo-oracle] Needed help : ORA-12514 > To: [email protected] <indo-oracle%40yahoogroups.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...@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] > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
