ORA-12514
April 27, 2006
Semua berawal dr gw lupa everything abt my oracle db, include username, password ma service namenya
setelah nanya2 akhirnya di beri saran untuk sementara connect lewat command prompt sebagai sys as sysdba aja sperti ini :
C:\Documents and Settings\Ririn>sqlplus /nolog
hiks, sampe sini gw masi ga puas
gw penasaran sampe gw bisa ngakses ntu table employees
akhirnya gw nyoba connect make oracle sqlPlus
username gw isi sys as sysdba
trus gw mulai try n’ error ttg password
ah! bingo, akhirnya dpt jg ntu password
nah skrg masalahnya ganti ke host string
gw lupa nama host string gw
kt org2 yg gw tanya’in sie host string sama dgn nama service oracle yg ada di control panel
akhirnya gw nyoba nyari
di services gw, tertulis
OracleServiceACID
nah, gw nyoba masukin host string gw dgn ACID
waks, ternyata muncul error gni
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
nah, di bantu ma mas Daud ngutak ngatik semua yg berbau ttg listener (tnsnames.ora, listener.ora, listener.log) akhirnya bs jg connect sbg hr trus langsung nyoba select * from employees 
kt mbah google hasil dr searching error ORA-12514 adalah :
Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.
Action: - Wait a moment and try to connect a second time.- Check which services are currently known by the listener by executing: lsnrctl services
wuzzzz …. gt deh
so kesimpulan dr problem ini adalah, cek file tnsnames.ora anda, listener.ora, ma listener.log untuk mengecek configurasi anda dahulu kala (kalo file lognya ga kehapus loh ya )
oh ya, klo mo ngubah2 isi file tnsnames.ora ati2, soalnya kyknya case-sensitive deh 
sekian dulu
bsk UTS Database Developer, blm blajar …. waaaaaaaaaaaaaaaaaaaa
