Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Protocol Adapter Error (help decipher log)

Re: Protocol Adapter Error (help decipher log)

From: frank <fbortel_at_home.nl>
Date: Tue, 24 Oct 2000 20:46:41 GMT
Message-ID: <39F5ECFE.749F0C35@home.nl>

OK makes sense.
Does that connect then? It should according to the log. Maybe start tracing; add trace_level_client=8 (or 16) to sqlnet.ora and see what appears in sqlnet.trc

Mazur wrote:

> Well, I am guessing the client is considered java because I am using
> Oracle's Net Assistsnt while attempting to connect, which is written in
> java.....
>
> Rob
>
> frank wrote:
> >
> > Don't know - status = 0, which means the connection session was established.
> > The client is java, tho - is this meant to be?
> >
> > Mazur wrote:
> >
> > > I am having trouble logging into my Oracle db over my LAN.
> > > Oracle8i: 8.1.5 (brand new install)
> > > NT4 Server (sp6)
> > > NT4 Workstation Client (new Oracle Client install)
> > >
> > > The crazy thing is that when I look at the resulting log file (shown
> > > below), the log attempt from the server and from the client look alike,
> > > as if they both succeeded! I can log in when at the server, but the
> > > client fails with this error:
> > > ORA-12560: TNS: protocol adapter error
> > >
> > > ***THE DATABASE NAME IS MOBY
> > > ***Oracle is on NT box named rainserver_b
> > > ___________________________________
> > > ***RESULT IN MOBY.LOG AFTER SUCCESSFUL LOGIN FROM SERVER
> > > 21-OCT-00 20:03:38 *
> > > (CONNECT_DATA=(SERVICE_NAME=moby)(CID=(PROGRAM=D:\Oracle\Ora81\BIN\SQLPLUS.EXE)(HOST=RAINSERVER_B)(USER=Administrator)))
> > > * (ADDRESS=(PROTOCOL=tcp)(HOST=204.236.21.12)(PORT=1644)) * establish *
> > > moby * 0
> > >
> > > ***RESULT IN MOBY.LOG AFTER FAILED LOGIN FROM CLIENT
> > > 21-OCT-00 20:09:37 *
> > > (CONNECT_DATA=(SERVICE_NAME=moby)(CID=(PROGRAM=C:\Program
> > > Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=JESSICA)(USER=mazur))) *
> > > (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.10)(PORT=1099)) * establish *
> > > moby * 0
> > > ____________________________________
> > > On the client side, the name of the machine is "jessica" and I am logged
> > > into NT as "mazur", but I am specifying "scott" and "tiger" when trying
> > > to access the oracle instance on the server, just like I am when I logon
> > > on from the server itself. My client tnsnames.ora file names moby to be
> > > on
> > > host=rainserver_b
> > > port=1521
> > > protocol=TCP
> > > service_name=moby
> > >
> > > Does it seem to you like the server thinks the client logon was
> > > successful? I can run "tnsping moby" on server and get a successful
> > > result, and I can run "lsnrctl status moby" from the server and get all
> > > the good stats.
> > >
> > > BUT!, if I run "lsnrctl status" without specifying moby, I get a bunch
> > > of errors saying there is no listener, protocol adapter errors and
> > > target host or object doesn't exist. There is no other listener. Why
> > > am I getting this? Can anyone make sense of this?
> > >
> > > Thanks!
> > > Rob
Received on Tue Oct 24 2000 - 15:46:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US