Hi,
coba anda ketik
c:> set oracle_sid=<SID_NAME>
c:>sqlplus /nolog
> Pastikan service dan instance sudah 'UP'
lalu coba lagi jalankan sqlplus nya dan koneksi nya ke
database.
Semoga membantu
salam,
Andrew E.K.
--- Muksin <[EMAIL PROTECTED]> wrote:
> thank's Mr. Ronald..., saran bapak sudah saya coba,
> saya cek memakai console command prompt dan saya cek
> juga status listenernya sudah OK/success, tetapi
> jika saya jalankan memakai console sql masih tetap
> tampil pesan
> ERROR : ORA-12560: TNS:protocol adapter error
> kenapa ya ?
> atau ada saran lain ? atau juga para Oracle mania
> yang lain ?
>
> NB : saya install ORACLE 9i dg Platform OS Windows
> Advance Server
>
>
> Thank's
> ----- Original Message -----
> From: Ronald Speirs
> To: Muksin
> Sent: Wednesday, May 25, 2005 12:29 PM
> Subject: Re: [indo-oracle] tanya koneksi
>
>
>
> $ oerr ora 12560
> 12560, 00000, "TNS:protocol adapter error"
> // *Cause: A generic protocol adapter error
> occurred.
> // *Action: Check addresses used for proper
> protocol specification. Before
> // reporting this error, look at the error stack
> and check for lower level
> // transport errors. For further details, turn on
> tracing and reexecute the
> // operation. Turn off tracing when the operation
> is complete.
>
> $ lsnrctl status
> $ lsnrctl stop
> $ lsnrctl start
>
> > mohon maaf sebelumnya ,saya pendatang baru dan
> masih awam tentang oracle,mo nanya :
> > saya sudah install db oracle, kemudian coba
> koneksi (dengan
> > Console)dengan user sys dan passwdnya, waktu
> awal - awal koneksi
> > dengan user sys bisa terkoneksi. kemudian saya
> shutdown database
> > tersebut.lalu saya coba koneksi lg dengan user
> sys dan passwdnya.
> > sekarang muncul pesan ERROR : ORA-12560:
> TNS:protocol adapter error
> > dan gak bisa koneksi,kenapa yaa ?
> > mohon solusi & pencerahannya kepada rekan-rekan
> ORACLE mania
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
>
>
>
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new Resources site
http://smallbusiness.yahoo.com/resources/
--
-----------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/