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