Dear Pak Taufik, Comment : ORA-12154: TNS:could not resolve the connect identifier specified
Disebabkan : sebuah koneksi ke database dibutuhkan yg menggunakan koneksitas "identifier", dimana koneksitas "identifier" tsb gagal berhubungan dgn "descriptor" yg menggunakan satu servis nama konfigurasi. Contoh : Jika misalnya koneksitas "identifier" yg di gunakan di sini adalah "net service name" kemudian "net service name" ini tdk berhasil di temukan di dalam "repository" atau "repository" tdk dapat ditemukan. Penyelesaian : 1. cari file yg bernama : TNSNAMES.ORA temukan isi konten seperti ini : connectstring= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = hostname or IP Address of the target computer) (PORT = 1521) ) ) (CONNECT_DATA = (SID = sidname of your database) ) ) trus coba ketik sintax ini di sqlplus sbb: eg. connect scott/[EMAIL PROTECTED] 2. Cari file yg bernama : sqlnet.ora pastikan isi kontent di dalam sqlnet.ora sbb : names.directory_path = (TNSNAMES) nah, skrg coba test ping di dos prompt. eg. c:\> tnsping connectstring ketika ada respons maka anda sudah berhasil masuk ke database. Hope this will solve your problem. Cheers, Jimmy Sinaga On 7/27/05, Teguh <[EMAIL PROTECTED]> wrote: > > Rekan-rekan oraclemania... > Saya baru belajar Oracle saat ini. Dan saat saya mau coba masuk ke TOAD > (Dengan measukan User name dan passwordnya) muncul comment : ORA:12154:TNS > Could not resolve service name. Bagaimana Solusinya...Mohon pencerahnnya. > > Thanks sebelumnya.. > Teguh > > > [Non-text portions of this message have been removed] > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.blogspot.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > > > [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
