Init (){ Ririn.toString(); }

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
- Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.- If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener.- Check for an event in the listener.log file.

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

Acid .O