Oracle 10G Connectivity with Datastage

hiswapnadeep · Post by **hiswapnadeep** » Wed May 07, 2008 5:32 am

Hi All,

I had installed Oracle 10G database in my system. The install was successful. I also provided all required access to the user using the following codes:

GRANT select ON sys.gv_$instance TO public;
GRANT select ON sys.v_$cache TO public;
CREATE ROLE DSXE;
GRANT SELECT on sys.dba_extents to DSXE;
GRANT SELECT on sys.dba_data_files to DSXE;
GRANT SELECT on sys.dba_tab_partitions to DSXE;
GRANT SELECT on sys.dba_tab_subpartitions to DSXE;
GRANT SELECT on sys.dba_objects to DSXE;
GRANT SELECT on sys.all_part_indexes to DSXE;
GRANT SELECT on sys.all_part_tables to DSXE;
GRANT SELECT on sys.all_indexes to DSXE;
GRANT DSXE to <oracle userid>;

Next step was to link the Oracle database with the Datastage component. For that purpose, I am required to execute the following codes:

In Command prompt:

C:\Ascential\DataStage\PXEngine\install>sh
$ ORACLE_HOME="C:/oraclexe/app/oracle/product/10.2.0/server"
$ export ORACLE_HOME
$ APT_ORCHHOME="C:/Ascential/DataStage/PXEngine"
$ export APT_ORCHHOME
$ sh install.liborchoracle
Installing Oracle driver
Using C:/oraclexe/app/oracle/product/10.2.0/server as ORACLE_HOME
Installing driver for Oracle Version 10g
Oracle installation is complete.
$ exit

tnsname.ora

C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN

However, as I am in the Windows command prompt, I am confused whether I would be able to execute the UNIX script install.liborchoracle to install the Oracle Driver. Is there any alternative method for the linking?

Minhajuddin · Post by **Minhajuddin** » Wed May 07, 2008 10:50 am

You would be able to execute all these commands as MKS Toolkit is installed when you install parallel edition on Windows (DS 7.5x2 and DS 8.x). MKS Toolkit gives you the ability to run unix commands on the Windows server.

ray.wurlod · Post by **ray.wurlod** » Wed May 07, 2008 3:55 pm

Moderator: please move to server forum

The answers there will be different.

hiswapnadeep · Post by **hiswapnadeep** » Thu May 08, 2008 12:47 am

Hi,

MKS Toolkit is installed in my machine. Can you plz guide me how to execute the commands using the same.

Minhajuddin · Post by **Minhajuddin** » Thu May 08, 2008 10:25 am

Go to the command prompt and fire them away!

hiswapnadeep · Post by **hiswapnadeep** » Thu May 08, 2008 12:16 pm

I had tried to fire the commands using the command prompt... But everytime when i was trying to fire the sh command, its throwing the error that sh command not found... Moreover its also throwing the error for cat also... I have copied the sh.exe as well as other basic commands from the MKS toolkit folder...

lstsaur · Post by **lstsaur** » Thu May 08, 2008 12:22 pm

Are you using 7.5x2 EE?

hiswapnadeep · Post by **hiswapnadeep** » Thu May 08, 2008 1:29 pm

Yes I m using 7.5EE...

Minhajuddin · Post by **Minhajuddin** » Thu May 08, 2008 8:18 pm

Does your PATH environment variable point to the MKSToolkit bin?
if not, you should add it to the path.

And by the by, there is a difference between 7.5 and 7.5x2.

hiswapnadeep · Post by **hiswapnadeep** » Thu May 08, 2008 9:31 pm

Hi,

I am using 7.5X2 EE....

lstsaur · Post by **lstsaur** » Thu May 08, 2008 10:50 pm

Check your system variable, SHELL, make sure its value populated as
C:/PROGRA~1/MKSTOO~1/mksnt/sh.exe.

hiswapnadeep · Post by **hiswapnadeep** » Thu May 08, 2008 11:29 pm

Hi,

I have checked the system variable SHELL. Its value was as mentioned by you.

Some of the errors as shown are as under:

C:\Ascential\DataStage\PXEngine\install>sh.exe
$ ORACLE_HOME="C:/oraclexe/app/oracle/product/10.2.0/server"
$ export ORACLE_HOME
$ APT_ORCHHOME="C:/Ascential/DataStage/PXEngine"
$ export APT_ORCHHOME
$ sh install.liborchoracle
sh: not found
$ ./install.liborchoracle
Installing Oracle driver
cat: ./install.liborchoracle 262: not found
ls: not found
grep: not found
ls: not found
grep: not found
ls: not found
grep: not found
$