Terimakasih atas support nya semua.... saya jalanin Oracle di laptop (localhost) bukan di server. Karena saya masih belajar jadi hanya laptop di rumah saja.
Terakhir aku cobain install juga Oracle developer 6i, SQLplus 8.0 (di headernya SQL*Plus) yang berada pada menu Oracle for windows NT> SQL plus 8.0 dan bisa dibuka dengan password yang saya create. Apakah itu SQL Plus tersebut sudah mewakili/sama dengan SQL Plus yang ada di OraDb10g_home>Application Development>SQL Plus? Untuk Abang Renga : saya udah coba ada beberapa yang beda karena oracle saya di windows. Nanti saya posting...Saat ini saya belom sempat (ada kursus Inggris dulu). Thanks SH --- Pada Sen, 16/3/09, Renga Haka <[email protected]> menulis: Dari: Renga Haka <[email protected]> Topik: Re: [indo-oracle] Password SQL Plus Kepada: [email protected] Tanggal: Senin, 16 Maret, 2009, 12:46 PM Sering ngalamin begini, karena datafile corrupt. Tidak bisa di-open saat startup. Perbaikannya dengan recovery datafile. Dipastikan saja dulu Instance Oracle dan Listenernya sudah sesuai. Dari Command Prompt (DOS Prompt), jalankan: C:\ lsnrctl status Berikut tampilan di linux, tapi semestinya di windows juga tidak beda jauh. LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-MAR-2009 19:00:26 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL= TCP)(HOST= localhost. localdomain) (PORT=1521) )) STATUS of the LISTENER ------------ --------- --- Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 17-MAR-2009 18:59:21 Uptime 0 days 0 hr. 1 min. 5 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/oracle/ products/ 10.2.1/network/ admin/listener. ora Listener Log File /u01/oracle/ products/ 10.2.1/network/ log/listener. log Listening Endpoints Summary... (DESCRIPTION= (ADDRESS= (PROTOCOL= tcp)(HOST= localhost. localdomain) (PORT=1521) )) (DESCRIPTION= (ADDRESS= (PROTOCOL= ipc)(KEY= EXTPROC0) )) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc" , status UNKNOWN, has 1 handler(s) for this service... Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orcl_XPT" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully Mungkin bisa dicoba dulu, nanti pesannya diposting ke milist ini lagi.. Salam, Wajib militer di Indonesia? Temukan jawabannya di Yahoo! Answers! http://id.answers.yahoo.com [Non-text portions of this message have been removed]
