We run an old release of DataStage (version 3.1.1r3) on an NT Server, with our Oracle database (Version 8.0.5) residing on a DEC Alpha. Our jobs start early in the morning.
Lately, weve been getting following errors on our initial jobs after theyve run a minute or two in the morning.
Oracle Error - OCI_INVALID_HANDLE
ORA-24324: service handle not initialized
ORA-12203: TNS:unable to connect to destination
Our DBA has found no problem on the DEC Alpha. Oddly enough, if we fire our jobs up after about 8:00am, they work fine. These jobs are a simple OCI8 stage to a Hashed stage, doing a simple load of a few columns from the Oracle tables to the NT Server.
Any ideas?
Thanks.
Sincerely,
Brad Vincent
Compuware
c/o The Detroit Medical Center
(313) 966-2176
OCI_INVALID_HANDLE
To prove anything to the DBAs you are going to have to use something like TNSPING or SQL*Plus to prove independently of DataStage that there is a problem connecting from the NT server to the Oracle database. Unfortunately, this probably means being there early one morning when the DataStage job crashes to then do these tests.
You could also try hunting down SQLNET.LOG on your NT server to see if it tells you anything more. Im not sure where you will find it as SQL*Net just creates it in the "current" directory, whatever that happens to be. Possibly the DataStage project directory.
It seems to me that this problem is somewhere in the Oracle layers (either on you server or the Dec Alpha) not in DataStage.
-----Original Message-----
From: Vincent, Brad [mailto:BVincent@dmc.org]
Sent: Saturday, 20 January 2001 2:19
To: DataStage Mailing List
Subject: OCI_INVALID_HANDLE
We run an old release of DataStage (version 3.1.1r3) on an NT Server, with our Oracle database (Version 8.0.5) residing on a DEC Alpha. Our jobs start early in the morning.
Lately, weve been getting following errors on our initial jobs after theyve run a minute or two in the morning.
Oracle Error - OCI_INVALID_HANDLE
ORA-24324: service handle not initialized
ORA-12203: TNS:unable to connect to destination
Our DBA has found no problem on the DEC Alpha. Oddly enough, if we fire our jobs up after about 8:00am, they work fine. These jobs are a simple OCI8 stage to a Hashed stage, doing a simple load of a few columns from the Oracle tables to the NT Server.
Any ideas?
Thanks.
Sincerely,
Brad Vincent
Compuware
c/o The Detroit Medical Center
(313) 966-2176
You could also try hunting down SQLNET.LOG on your NT server to see if it tells you anything more. Im not sure where you will find it as SQL*Net just creates it in the "current" directory, whatever that happens to be. Possibly the DataStage project directory.
It seems to me that this problem is somewhere in the Oracle layers (either on you server or the Dec Alpha) not in DataStage.
-----Original Message-----
From: Vincent, Brad [mailto:BVincent@dmc.org]
Sent: Saturday, 20 January 2001 2:19
To: DataStage Mailing List
Subject: OCI_INVALID_HANDLE
We run an old release of DataStage (version 3.1.1r3) on an NT Server, with our Oracle database (Version 8.0.5) residing on a DEC Alpha. Our jobs start early in the morning.
Lately, weve been getting following errors on our initial jobs after theyve run a minute or two in the morning.
Oracle Error - OCI_INVALID_HANDLE
ORA-24324: service handle not initialized
ORA-12203: TNS:unable to connect to destination
Our DBA has found no problem on the DEC Alpha. Oddly enough, if we fire our jobs up after about 8:00am, they work fine. These jobs are a simple OCI8 stage to a Hashed stage, doing a simple load of a few columns from the Oracle tables to the NT Server.
Any ideas?
Thanks.
Sincerely,
Brad Vincent
Compuware
c/o The Detroit Medical Center
(313) 966-2176