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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Help NET8 can`t connect to Oracle 7.3.3 DB

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

From: <lev.o_at_sapiens.com>
Date: Tue, 07 Nov 2000 16:44:22 GMT
Message-ID: <8u9bh4$l4v$1@nnrp1.deja.com>

 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 @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. Received on Tue Nov 07 2000 - 10:44:22 CST

Original text of this message

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