Re: Help NET8 can`t connect to Oracle 7.3.3 DB
Date: Tue, 07 Nov 2000 16:44:22 GMT
Message-ID: <8u9bh4$l4v$1_at_nnrp1.deja.com>
[Quoted] Hello forum !
I will try to provide all info you asked.
Let me explain the case :
- The instalation . We had 2 HPUX 10.20 host runningg Oracle 7.3.3 (I will refernce it as A)
[Quoted] We had AIX 2.4.1 host with ORACLE 8.1.5 ( refenced as B)
[Quoted] [Quoted] We had Solaris 2.6 running Oracle 7.3.3 ( C) From this machine we can
[Quoted] [Quoted] connect (run sqlplus for ex. ) to any of other Oracle installations -
(Referenced as A and B )
[Quoted] 2. Recently we have installed Oracle 8.15 to this Solaris machime (Refernced as C).
[Quoted] [Quoted] Today this machne succesfully runs Oracle server and we can connect to it [Quoted] [Quoted] any time. To connect to other machines (A and B) of course we need properly [Quoted] configured tnsnames.ora file. So we just made copy of tnsnames file from [Quoted] Oracle 7.3.3 home. (Remember. it was proved good). I suppose the copy is [Quoted] good too, because when we run Oracle 7.3.3/bin/sqlplus under ORACLE8 [Quoted] [Quoted] environment it connects to any other Oracle Server ( A and B).
[Quoted] 3. My actions
[Quoted] [Quoted] 3.1 Run Oracle 7.3.3/bin/sqlplus connect string _at_oradb_A with ORACLE_HOME - [Quoted] Oracle 8 - SUCCESS
[Quoted] [Quoted] 3.2 Run original Oracle 8 sqlplus (the same connect string) -- HANGS [Quoted] [Quoted] I`ve investigated listener log and trace files of computer A. It shows [Quoted] established connection from IP address of A
[Quoted] [Quoted] 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 [Quoted] , receives file desciptor and performs connect (rc=0), then some read, [Quoted] write, send operations on tis socket. Then it starts read operation - and [Quoted] never returns.
[Quoted] Here the truss output :
[Quoted] 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 :
[Quoted] [Quoted] buick:/nfc/home/levo> sqlplus levo/levo_at_oradb_A
[Quoted] 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
[Quoted] (ADDRESS=(PROTOCOL=beq)(PROGRAM=oracle)(ENVS=)(ARGV0=oracletest9)(ARGS='(LOCA
L=N
[Quoted] O)')(SID_NAME=test9)(ORACLE_HOME=/oracle/7.3.3)(GLOBAL_NAME=test9.newframe)(E
NVS
[Quoted] [Quoted] ='ORACLE_HOME=/oracle/7.3.3,PATH=/oracle/7.3.3/bin/,TZ=EET-2Israel,ORACLE_SID
[Quoted] =te st9,')) connecting... About to exec oracle: detaching from parent with
[Quoted] additional fork result string is NTP0 1513 hdl[IR]=23, hdl[IW]=22 doing
[Quoted] connect handshake... NSE=0 connect handshake is complete no timer allocated
[Quoted] closing transport
SUMMARY
-
[Quoted]
- SQLPLUS binary from ORAcle 7 connects to A,B,C 2. TNSNAMES evidently [Quoted] [Quoted] good 3. SQLPLUS from ORACLE 8 HANGS but A`s listener shows connection established
[Quoted] [Quoted] I hope I provide the full and accurated information and now I patiently [Quoted] expect to your advices.
Regards,
Lev
[Quoted] [Quoted] 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 [Quoted] > important files: [Quoted] [Quoted] > tnsnames.ora ( from each client -usually in the [Oracle_Home]/Network-[May be [Quoted] > Net80 on some]/admin directory - the cØÀº Àº > cannot complete its task - please let the group know what error ( if any) you > get... > [Quoted] [Quoted] > If you could post your tnsnames.ora,sqlnet.ora and names.ora( if using Oracle [Quoted] > 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 - [Quoted] > >sqlplus just stucks > > [Quoted] [Quoted] > >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) [Quoted] > >- 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. > > > > > > > > [Quoted] > >Of cource I looked in listener log and trace files - nothing strange. [Quoted] > >Have a look : > > [Quoted] > >06-NOV-00 20:18:35 * > >(CONNECT_DATA=(SID=test9)(GLOBAL_NAME=test9.newframe)(CID=(PROGRAM=)(HOST=bui [Quoted] > >ck)(USER=levo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=194.194.247.95)(PORT=33071)) [Quoted] > >* 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.
Received on Tue Nov 07 2000 - 17:44:22 CET