Please, HELP

ogmios · Post by **ogmios** » Fri Jul 23, 2004 3:43 am

From the computer on which you run DataStage server, execute "tnsping oracleid" as the user under which you run the datastage jobs.

Possible causes:
- general changes in the environment (no ORACLE_HOME defined anymore)
- wrong access rights on the oracle files
- something wrong with the Oracle server

Ogmios

kduke · Post by **kduke** » Fri Jul 23, 2004 4:05 am

ORACLE_HOME needs to be set in dsenv file in order for Oracle plugins to work. The Oracle client needs to working properly as well. If you cannot connect with sqlplus then DataStage cannot connect either.

rreyespe · Post by **rreyespe** » Fri Jul 23, 2004 4:08 am

The Oracle client work perfectly, I can connect with SqlPlus. But where is th dsenv file?

ogmios · Post by **ogmios** » Fri Jul 23, 2004 4:17 am

rreyespe wrote:The Oracle client work perfectly

You have to be able to use the Oracle client on the server WITH the userid you use to run your jobs. dsenv is somewhere in the `cat /.dshome`

Ogmios

ray.wurlod · Post by **ray.wurlod** » Fri Jul 23, 2004 4:33 am

Check, too, that the TNSNAMES.ORA file is in the expected location and readable.

rreyespe · Post by **rreyespe** » Fri Jul 23, 2004 4:58 am

the TNSNAMES is also in the correct place and readable

sandhya · Post by **sandhya** » Fri Jul 23, 2004 5:04 am

Is the service name available in your TNSNAMES

ray.wurlod · Post by **ray.wurlod** » Fri Jul 23, 2004 5:05 am

The dsenv file is a script executed by all DataStage processes, principally to set necessary environment variables. The file is in the DataStage engine directory which, at version 7.x, is defined using the DSHOME environment variable. The file /.dshome may also exist, depending whether or not you're running in impersonation mode: if it does, it contains the pathname of the DataStage engine directory.

rreyespe · Post by **rreyespe** » Fri Jul 23, 2004 5:17 am

Yes the service name is available

ray.wurlod · Post by **ray.wurlod** » Tue Jul 27, 2004 2:55 pm

Because dsenv is a shell script, order of execution is unimportant. Put the commands anywhere you want.
Bourne shell syntax is preferred (I've forgotten why).

Code: Select all

ORACLE_HOME=pathname ; export ORACLE_HOME

Don't forget that there are no spaces beside the "=" character when setting environment variables. (They're mandatory in uvodbc.config, isn't it great to have consistency?!)

leo_t_nice · Post by **leo_t_nice** » Wed Jul 28, 2004 3:34 am

Hi

dsenv is usually found in $DSHOME/../DSEngine

ray.wurlod · Post by **ray.wurlod** » Wed Jul 28, 2004 6:07 am

In Windows environment variables can be set in Control Panel > System > Environment.
They can also be set using DataStage Administrator, in the "user defined environment variables" section (on both platforms).

ariear · Post by **ariear** » Wed Jul 28, 2004 1:41 pm

If I remember correctly there's no DSENV on windows and you're on windows right ?
The ORACLE environment is all in the registry (even ORACLE_HOME)
I don't remember how 2 ORACLE clients can co-exist and function on the same client host . sometime the oracle client can be installed even on another remote host and the re-boot lost the connection or something like that

DSXchange

Please, HELP

Re: Please, HELP