DSXchange

Bala,
I had an Oracle Server Installed prior to DS installation. But it throwed the error that the user needs access to sys.dba_extents table. I did not know the sys password. So I reinstalled Oracle. I used the Oracle -package installer. This time had the user all access needed. Here it showed me the same error- that you were getting. What I did was -
I ran REGEDIT and deleted the entried of the Old oracle installation. Then, all the jobs that select data from oracle are running fine. I am using Oracle Enterprise stage.
But for jobs that load into Oracle using the same Oracle Enterprise stage, it is throwing the error reg. sql loader. It says not able to find " //./pippe/****** (some number)" and giving two log files in the scratch folder .
can we help each other.

Others are always welcome to give us their piece of advise.

Hi Bala,

You first check the value of APT_ORCHHOME variable defined at the project level. Please make sure it points to the pxengine folder. If it is correct, what you can do is, copy that value and instead of using APT_ORCHHOME/bin in PATH, u try with the actual value and check it.

bala_135 wrote:...
APT_ORCHHOME\bin ;C:\Oracle\Ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\PROGRA~1\MKSTOO~1\bin;C:\PROGRA~1\MKSTOO~1\bin\X11;C:\PROGRA~1\MKSTOO~1\mksnt;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;;C:\Ascential\ODBC
...

The text in red looks wrong, it needs to contain the path to your APT_ORCHHOME and not the fixed string.

There are several tables that DataStage needs to connect with in order to work.

sys.gv_$instance
sys.v_$cache to public
sys.dba_extents
sys.dba_data_files
sys.dba_tab_partitions
sys.dba_tab_subpartitions
sys.dba_objects
sys.all_part_indexes
sys.all_part_tables
sys.all_indexes

Your DBA should be able to give you the proper select permissions without having to reinstall.