Re: Help NET8 can`t connect to Oracle 7.3.3 DB
Date: Wed, 08 Nov 2000 10:54:41 GMT
Message-ID: <8ubbdg$a17$1_at_nnrp1.deja.com>
Hello !
[Quoted] I`ll try to clarify environment issues :
- Oracle environment As I said, I have run sqlplus from version Oracle7.3.3 in ORACLE 8 environment, it means that ORACLE_HOME and PATH both poins to ORACLE 8
2 Oacle as Unix user
We do not have different login for Orale7 and Oracle8, I think it is irrelevant because I`m talkink about client
I`d done my expirements with my user login (not as oracle) - and I saw in truss output file that the shell and library search path is indeed Oracle8.
I `ve also seen that sqlpus from Oracle 8 uses libclintsh.so and libskgxp8.so libraries, but Oracle7/sqlplus - neither of them.
Regards, and thank you for reply.
Lev
In article <8u9jeh$t2t$1_at_nnrp1.deja.com>,
gmei_at_my-deja.com wrote:
> 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.2 ° à¯
> > 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.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Nov 08 2000 - 11:54:41 CET