di ORACLE_HOME/ network/admin/ biasanya ORACLE_HOME itu tmpat oracle diinstall misal C:\oracle\product\bla... nah misal saia ada di D:\oracle\ora11\Network\Admin ..
di folder trsbut ada tnsnames.ora nah buka deh pake notepad biasanya ada isi bgini : Nama_Alias = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Lokasi_server_IP_or_PCName )(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = Nama_Service_Database) ) ) nah k'lo bisa coba pake cmd -> dos C:\> tnsping Nama_Alias --> bwat cheeck koneksi C:\> sqlplus "sys/passw...@nama_alias as sysdba" -> test log-in gud luck then.... --- On Wed, 4/14/10, Anthony Kurniawan <[email protected]> wrote: From: Anthony Kurniawan <[email protected]> Subject: Re: [indo-oracle] ERROR - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor To: [email protected] Date: Wednesday, April 14, 2010, 8:08 AM Yup benar kata Pak Freddie, minta diiattach or copy-paste isi dari listener.ora n tnsnames.ora (by default terletak di ORACLE_HOME/ network/admin/ ) coba lihat melalui netManager, lalu coba lihat listening locations dan database services nya, apakah sudah mengarah ke target database yang tepat.. CMIIW.. "Gapailah cita-citamu setinggi langit karena jika kau meleset sekalipun, kau akan tetap berada diantara bintang-bintang" --- Pada Sen, 12/4/10, Freddie Tanuwijaya <synar_0...@yahoo. com> menulis: Dari: Freddie Tanuwijaya <synar_0...@yahoo. com> Judul: Re: [indo-oracle] ERROR - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Kepada: indo-oracle@ yahoogroups. com Tanggal: Senin, 12 April, 2010, 8:15 PM Bisa tolong disertkan listener.ora, tnsnames.ora nya juga ____________ _________ _________ __ From: Febry Ginanjar Koestiwandhana <febry_mj03@ yahoo. com> To: indo-oracle@ yahoogroups. com Sent: Sun, April 11, 2010 3:10:07 PM Subject: [indo-oracle] ERROR - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor dear Para Master Oracle saya benar2 Newbie di Oracle saya mau melakukan query di isql*plus, setelah masuk pada halaman login saya memasukkan username : sys Password : ****** connect identifier : orcl lalu muncul error ERROR - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor kira2 apa yang salah dan apa yang harus lakukan ya?? mohon bantuannya ya.. karena saya benar2 newbie nih di oracle NB : OS win xp SP2 , Oracle 10g Regards Febry [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Lebih aman saat online. Upgrade ke Internet Explorer 8 baru dan lebih cepat yang dioptimalkan untuk Yahoo! agar Anda merasa lebih aman. Gratis. Dapatkan IE8 di sini! http://downloads. yahoo.com/ id/internetexplo rer/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
