Not able to import the table metadata from Oracle Database

[Xpert]

Hi all,

I'm not able to import the table metadata from oracle 10.2.0.2 database. As it showing the below error message.

"Unable to initialize plug-in:"

Could somebody help me out.

[PradeepPandey]

Hi all,

I'm not able to import the table metadata from oracle 10.2.0.2 database. As it showing the below error message.

"Unable to initialize plug-in:"

Could somebody help me out.

Plese try using "Share metadata when importing from Connectors" or ODBC option

[ray.wurlod]

Did you bother to search the forums for this exact error message? I'm sure it's been posted many times before.

[sambarand]

I am also getting the same error message while trying to import table definations through Import->Table Definations->Plug-in Meta Data definations. But we are able to import table definations through Import->Table Definations->ODBC Table Definations.

I searched the forum for this error message but I found none.

We have updated the dsenv file and added the informations required by Oracle.

Also we are getting the error message
'C Stage PlugIn function "Get" required' when we are trying to run the job using Oracle OCI stage.

Please note that we are using Datastage version 7.5.1 server job and Oracle version is Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production.

[chulett]

Make sure you're using the 32bit Oracle libraries unless you are certain that DataStage is also 64bit on your platform.

[sambarand]

Thanks for your reply.

Our Datastage is 32 bit, so in the LIBPATH we have put ${ORACLE_HOME}/lib32 before ${ORACLE_HOME}/lib, but still getting the same error.

anthing more needs to be configured, to import table definations using Import->Plug-in metadata option?

[chulett]

Just the normal stuff in dsenv is what is needed, as documented in the pdf manuals. So, can you use any of the Oracle stages in a job, like the OCI stage in a Server job or is that not working as well?