Re: Help NET8 can`t connect to Oracle 7.3.3 DB

[Quoted] When you use Oracle8's sqlplus from C (on Solaris) to connect A, did you set env ORACLE_HOME to "/oracle/8.1.5"? What is ORACLE_SID at that time? DO you have different unix login names for oracle7.3.3 and oracle 8.1.5 on C?

In article <8u9bh4$l4v$1_at_nnrp1.deja.com>,   lev.o_at_sapiens.com wrote:
>
>
> Hello forum !
>
> I will try to provide all info you asked.
>
> Let me explain the case :
>
> 1. The instalation . We had 2 HPUX 10.20 host runningg Oracle 7.3.3
 (I will
> refernce it as A)
>
> We had AIX 2.4.1 host with ORACLE 8.1.5 ( refenced as B)
>
> We had Solaris 2.6 running Oracle 7.3.3 ( C) From this
 machine we can
> connect (run sqlplus for ex. ) to any of other Oracle installations -
> (Referenced as A and B )
>
> 2. Recently we have installed Oracle 8.15 to this Solaris machime
 (Refernced
> as C).
>
> Today this machne succesfully runs Oracle server and we can connect
 to it
> any time. To connect to other machines (A and B) of course we need
 properly
> configured tnsnames.ora file. So we just made copy of tnsnames file
 from
> Oracle 7.3.3 home. (Remember. it was proved good). I suppose
 the copy is
> good too, because when we run Oracle 7.3.3/bin/sqlplus under ORACLE8
> environment it connects to any other Oracle Server ( A and
 B).
>
> 3. My actions
>
> 3.1 Run Oracle 7.3.3/bin/sqlplus connect string _at_oradb_A with
 ORACLE_HOME -
> Oracle 8 - SUCCESS
>
> 3.2 Run original Oracle 8 sqlplus (the same connect string) --
 HANGS
> I`ve investigated listener log and trace files of computer A.
 It shows
> established connection from IP address of A
>
> Trace file also doesn`t show any unusual (errors, warnings).
>
> I even tryed truss to see where sqlplus hangs. I saw that
 it opens socket
> , receives file desciptor and performs connect (rc=0), then some
 read,
> write, send operations on tis socket. Then it starts read
 operation - and
> never returns.
>
> Here the truss output :
> so_socket(2, 2, 0, "", 1) = 9
> connect(9, 0xEFFF9EE4, 16) = 0
> getsockname(9, 0xEFFF9EE4, 0xEFFF9EF4) = 0
> fcntl(9, F_SETFD, 0x00000001) = 0
> write(9, "\0F4\0\001\0\0\001 601 ,".., 244) = 244
> read(9, "\0\b\0\0\v\0\0\0", 2064) = 8
> write(9, "\0F4\0\001\0\0\001 601 ,".., 244) = 244
> read(9, "\018\0\002\0\0\001 5\f01".., 2064) = 24
> write(9, "\08F\0\006\0\0\0\0\0DEAD".., 143) = 143
> read(9, "\07F\0\006\0\0\0\0\0DEAD".., 2064) = 127
>
> write(9, "\0 \0\006\0\0\0\0\00106".., 32) = 32
> read(9, "\0 '\0\006\0\0\0\0\00104".., 2064) = 39
> write(9, "0397\0\006\0\0\0\0\00201".., 919) = 919
> read(9, "0194\0\006\0\0\0\0\00201".., 2064) = 404
> send(9, " !", 1, 1) = 1
> write(9, "\0\v\0\0\f\0\0\001\002", 11) = 11
> read(9, "\0\v\0\0\f\0\0\001\002", 2064) = 11
> read(9, 0x000CCF66, 2064) (sleeping...)
>
> Here comes listener.log (computer A -Oracle 7)
>
> 06-NOV-00 20:18:08 *
> (CONNECT_DATA=(SID=test9)(GLOBAL_NAME=test9.newframe)(CID=(
> PROGRAM=)(HOST=buick)(USER=levo))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=194.194.247.95 )(PORT=33070)) *
 establish *
> test9 * 0
>
> Here is SQLPLUS output :
> buick:/nfc/home/levo> sqlplus levo/levo_at_oradb_A
>
> SQL*Plus: Release 8.1.5.0.0 - Production on Tue Nov 7 18:02:27 2000
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> Here is excert from TNSNAMES.ORA :
>
> oradb_A.newframe=
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.newframe)
> (PROTOCOL = TCP)
> (Host = 194.194.247.7)
> (Port = 1526)
> )
> )
> (CONNECT_DATA = (SID = test9)(GLOBAL_NAME = test9.newframe))
> )
>
> Here comes listener trace file : doing connect handshake... got
 NSPTCN packet
> (ADDRESS=(PROTOCOL=beq)(PROGRAM=oracle)(ENVS=)(ARGV0=oracletest9)
 (ARGS='(LOCA
> L=N
> O)')(SID_NAME=test9)(ORACLE_HOME=/oracle/7.3.3)
 (GLOBAL_NAME=test9.newframe)(E
> NVS
> ='ORACLE_HOME=/oracle/7.3.3,PATH=/oracle/7.3.3/bin/,TZ=EET-
 2Israel,ORACLE_SID
> =te st9,')) connecting... About to exec oracle: detaching from parent
 with
> additional fork result string is NTP0 1513 hdl[IR]=23, hdl[IW]=22
 doing
> connect handshake... NSE=0 connect handshake is complete no timer
 allocated
> closing transport
>
> SUMMARY
>
> 1. SQLPLUS binary from ORAcle 7 connects to A,B,C 2. TNSNAMES
 evidently
> good 3. SQLPLUS from ORACLE 8 HANGS but A`s listener shows
 connection
> established
>
> I hope I provide the full and accurated information and now I
 patiently
> expect to your advices.
>
> Regards,
> Lev
>
> In article <3a08199b.5343373_at_news.news-ituk.to>,
> See Message body for real address wrote:
> >
> > In addition to multiple postings ( and snotty comments) you failed
 to post the
> > important files:
> > tnsnames.ora ( from each client -usually in the
 [Oracle_Home]/Network-[May be
> > Net80 on some]/admin directory - the cØÀº Àº > cannot complete
 its task - please let the group know what error ( if any) you
> > get...
> >
> > If you could post your tnsnames.ora,sqlnet.ora and names.ora( if
 using Oracle
> > names) we could help more...
> >
> > lev.o_at_sapiens.com wrote:
> >
> > >
> > >
> > > Hello all !
> > >
> > >I have already seen similar thread, but my case is a little bit
 different -
> > >sqlplus just stucks
> > >
> > >I have 4 Unix hosts with Oracle :
> > >A - 2 with 7.3.3 (HP)
> > >B - AIX with 8.1.5
> > >C - Solaris with 8.15 and 7.3.3
> > >
> > >Host C, Solaris 8.1.5, in problem. It cannot connect to any of A
 (HP7.3.3)
> > >- sqlplus just hangs. But it connects to B.
> > >
> > >If I try C`s sqlplus 7.3.3 (giving the full path) - then it do
 connects to
> > >every.
> > >
> > >
> > >
> > >
> > >Of cource I looked in listener log and trace files - nothing
 strange.
> > >Have a look :
> > >
> > >06-NOV-00 20:18:35 *
> > >(CONNECT_DATA=(SID=test9)(GLOBAL_NAME=test9.newframe)(CID=
 (PROGRAM=)(HOST=bui
> > >ck)(USER=levo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=194.194.247.95)
 (PORT=33071))
> > >* establish * test9 * 0)
> > >
> > >
> > >ThanX for your future precious comments
> > >
> > >Lev.
> > >
> > >
> > >Sent via Deja.com http://www.deja.com/
> > >Before you buy.
> >
> > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 07 2000 - 19:59:35 CET