Re: Protocol Adapter Error (help decipher log)

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 - 11:28:44 CDT