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

Home -> Community -> Usenet -> c.d.o.server -> About SQL*Net

About SQL*Net

From: half-wit <half-wit_at_bigfoot.com>
Date: Fri, 24 Dec 1999 19:35:16 +0800
Message-ID: <38635A74.E24A9818@bigfoot.com>


Hello, merry christmas.
Can you help me?

I want connect Oracle server A (version 7.2.3 on HP 10.20 ) from Oracle server B ( version 8.0.3 on Solaris 5.6) use SQL*Net,
but when I type sqlplus scott/tiger_at_serb from Solaris, it display the fellow line and no respones no longer.

SQL*Plus: Release 8.0.3.0.0 - Production on Fri Dec 24 19:29:45 1999 (c) Copyright 1997 Oracle Corporation. All rights reserved.

the follow is the trace log on Oracel server A, it seem fine.



opening transport...
waiting to accept a connection.
valid node check on incoming node 192.168.100.73 Accepted Entry: 192.168.100.73
transport is open
global context check-in (to slot 3) complete doing connect handshake...
223 bytes from transport
got NSPTCN packet
command = establish
connecting...
About to exec oracle:
  environ[0] = "ORACLE_HOME=/home/oracle/app/oracle/product/v723"
  environ[1] = "PATH=/home/oracle/app/oracle/product/v723/bin/"
  environ[2] = "TZ=EAT-8"
  environ[3] = "ORACLE_SID=ora7"
  environ[4] = "NLS_LANG=AMERICAN_AMERICA.zhs16cgb231280"
  environ[5] = "HOME=/home/oracle"

detaching from parent with additional fork result string is NTP0 10148
added pid 10148
hdl[IR]=15, hdl[IW]=14
NT layer IPC connection has been established. doing connect handshake...
NSE=0
connect handshake is complete
no timer allocated
closing transport
global context check-out (from slot 3) complete

And when we connect Oracle B from Oracle A opposition, sqlplus work fine.

I am so foolished with it.
pls help me.

99-12-23 Received on Fri Dec 24 1999 - 05:35:16 CST

Original text of this message

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