Home » RDBMS Server » Networking and Gateways » Transparent Gateway for DB2 - older version
Transparent Gateway for DB2 - older version [message #246152] Wed, 20 June 2007 02:10 Go to next message
frederic
Messages: 2
Registered: June 2007
Location: France - Normandie
Junior Member
Hey,
I've got an old application that runs under Oracle 8, and that use TGTW 4 to access DB2 on a iseries with os 530.
My problem is that i need to upgrade the os400 to 540 to get hardware new equipements working.
So i test this oracle/tgtw on another system with V5R4 and get no result except some strange error :
on SQL+ i get these msgs :
ORA-01017
ORA-02063

On the iseries, i got these in TRC file :

--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is "TRC(SERV733755)"
New trace level is 6
--- TRACE CONFIGURATION INFORMATION ENDS ---

--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source ORACLE/ORA(SQLNET)
Parameter source loaded successfully

-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TRACE_FILE_SERVER = SERV000000
TRACE_LEVEL_CLIENT = OFF
USE_DEDICATED_SERVER = OFF
TRACE_LEVEL_SERVER = ADMIN
AUTOMATIC_IPC = OFF
sqlnet.authentication_required = NO
native_names.use_native = OFF
--- PARAMETER SOURCE INFORMATION ENDS ---

--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "LOG(SQLNET)"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---

Hst is already an NVstring.
Not enabling dead connection detection.
listener bequeathed shadow coming to life...
connecting...
doing connect handshake...
ADR="(ADDRESS=(PROTOCOL=tcp)(DEV=1)(HOST=10.144.12.9)(PORT=1521))" bufl=256
(ADDRESS=(PROTOCOL=tcp)(DEV=1)(HOST=10.144.12.9)(PORT=1521))
port resolved to 1521
using host IP address: 10.144.12.9
opening transport...
transport is open
(ADDRESS=(PROTOCOL=tcp)(DEV=1)(HOST=10.144.12.9)(PORT=1521))
port resolved to 1521
using host IP address: 10.144.12.9
opening transport...
Validnode Table IN use; err 0x0
getting sockname
transport is open
global context check-in (to slot 0)complete
hoff=12587
REDIR="(ADDRESS=(PROTOCOL=tcp)(DEV=0)(HOST=10.144.12.9)(PORT=47781))"
opening transport...
getting sockname
waiting to accept a connection.
valid node check on incoming node 10.144.2.10
Accepted Entry: 10.144.2.10
transport is open
Reading parameter "sqlnet.authentication_required" from parameter file
Found value "FALSE"
Counting £ of items in "sqlnet.authentication_services" parameter
Parameter not found
Found 0 items
Using default value "all available adapters"
Reading parameter "SQLNET.ENCRYPTION_SERVER" from parameter file
Parameter not found
Using default value "ACCEPTED"
Counting £ of items in "SQLNET.ENCRYPTION_TYPES_SERVER" parameter
Parameter not found
Using default value "all available algorithms"
Reading parameter "SQLNET.CRYPTO_CHECKSUM_SERVER" from parameter file
Parameter not found
Using default value "ACCEPTED"
Counting £ of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER" parameter
Parameter not found
Using default value "all available algorithms"
global context check-in (to slot 1) complete
doing connect handshake...
247 bytes from transport
got NSPTCN packet
no timer allocated
closing transport
global context check-out (from slot 0) complete
sending NSPTAC packet
24 bytes to transport
connect handshake is complete
nsctxinf¬0|=0x9, ¬1|=0x0
NTOBROKEN not supported by transport
143 bytes from transport
133 bytes from NS buffer
117 bytes to NS buffer
127 bytes to transport
flushing transport
Secure Network Services is not available.
No broken-connection function available.
36 bytes from transport
39 bytes to transport
705 bytes from transport
398 bytes to transport
157 bytes from transport
86 bytes to transport
163 bytes from transport
86 bytes to transport
10 bytes from transport
disconnecting...
no timer allocated
closing transport
global context check-out (from slot 1) complete

And this :

--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is "TRC(SERV733913)"
New trace level is 6
--- TRACE CONFIGURATION INFORMATION ENDS ---

--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source ORACLE/ORA(SQLNET)
Parameter source loaded successfully

-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TRACE_FILE_SERVER = SERV000000
TRACE_LEVEL_CLIENT = OFF
USE_DEDICATED_SERVER = OFF
TRACE_LEVEL_SERVER = ADMIN
AUTOMATIC_IPC = OFF
sqlnet.authentication_required = NO
native_names.use_native = OFF
--- PARAMETER SOURCE INFORMATION ENDS ---
--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "LOG(SQLNET)"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---
Hst is already an NVstring.
Not enabling dead connection detection.
listener bequeathed shadow coming to life...
connecting...
-<ERROR>- error (NTINHERIT)
-<ERROR>- nsres: id=0, op=73, ns=12560, ns2=0; nt¬0|=0, nt¬1|=0, nt¬2|=0
-<ERROR>- error from nsinherit: failed...
-<ERROR>- nr err code: 0
-<ERROR>- ns main err code: 2560
-<ERROR>- ns (2) err code: 0
-<ERROR>- nt main err code: 0
-<ERROR>- nt (2) err code: 0
-<ERROR>- nt OS err code: 0
No broken-connection function available.
-<ERROR>- Couldn't connect, returning 12560

If some "Guru" could help me, or just tell me it's not possible, thanks.


FREDERIC.


ORACLE 8.0.4.0
Tranparent Gateway 4.0.1.1.5
OS400 OS 5.3 (with special PTF SI14206)
waiting Upgrade to 5.4
Re: Transparent Gateway for DB2 - older version [message #246591 is a reply to message #246152] Thu, 21 June 2007 07:20 Go to previous messageGo to next message
frederic
Messages: 2
Registered: June 2007
Location: France - Normandie
Junior Member
Ok, it seems complicated. But the question is :
Can i make Oracle Tranparent Gateway for DB2 4.0.1.1.5 work on OS400 V5R4 ?
Any clue ?
Re: Transparent Gateway for DB2 - older version [message #246711 is a reply to message #246591] Thu, 21 June 2007 11:50 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
check this not sure.

http://www.oracle.com/technology/products/gateways/tg4db2.htm
Previous Topic: cldnt find tnsnames.ora
Next Topic: Two listeners up
Goto Forum:
  


Current Time: Fri Mar 29 08:26:05 CDT 2024