Unable to initialize plugin

bala_135 · Post by **bala_135** » Sat Jun 30, 2007 2:36 am

Hi All,

I am getting the Error.Unable to intialse plugin when i try to import metadata through DS manger(plugin metadata definitions)
Databse:-Oracle 10g
OS-Unix(hp)
DS:-7.5

My dsenv file looks like this.

ORACLE_HOME=/u00/app/oracle/product/10.2.0; export ORACLE_HOME
ORACLE_HOME=/u00/app/oracle/product/10.2.0; export ORACLE_HOME
ORACLE_SID=dwdev; export ORACLE_SID
ORASID=dwdev; export ORASID

SHLIB_PATH=$SHLIB_PATH:$DSHOME/lib:$APT_ORCHHOME/lib:$APT_ORCHHOME/osh_wrappers:
$ODBCINF:$ODBCINF/lib:$ORACLE_HOME:$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$ORACLE_H
OME/ctx/lib:$ORACLE_HOME/rdbms/lib32:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC
2.0:$DSHOME/java/jre/lib/PA_RISC2.0/hotspot:$DSHOME/java/jre/lib/PA_RISC/hotspot
:/usr/lib:/usr/local/lib:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/contrib/bin/X
11:/usr/lib/X11:/usr/contrib/lib/X11:/opt/aCC/lib:/opt/aCC/bin; export SHLIB_PAT
H
export SHLIB_PATH.

Kindly give me some inputs how to get this error rectified.

Regards,
Bala.

ray.wurlod · Post by **ray.wurlod** » Sat Jun 30, 2007 2:59 am

Through which plug-in stage are you attempting to import the table definition?

Try using the Orchestrate orchdbutil utility - it's more robust.

bala_135 · Post by **bala_135** » Sat Jun 30, 2007 3:03 am

Hi Ray,

My aim is to check whether the connectivity to Oracle 10g database is working fine.But i that step i am facing this problem.

Regards,
Bala

ray.wurlod · Post by **ray.wurlod** » Sat Jun 30, 2007 5:51 am

You need to have $ORACLE_HOME/lib32 ahead of $ORACLE_HOME/lib in SHLIB_PATH, because DataStage is a 32-bit application.

bala_135 · Post by **bala_135** » Mon Jul 02, 2007 6:41 am

Hi,

Thanks Ray for your help.It working fine now.We could import the metadata through Plugin as well as through Orchestrate schema definitions but not through ODBC..

My odbc.ini file for one Oracle user(user1) looks like this
[ODBC]
IANAAppCodePage=4
InstallDir=/home/dsadm/Ascential/DataStage/branded_odbc
Trace=1
TraceDll=/home/dsadm/Ascential/DataStage/branded_odbc/lib/odbctrac.sl
TraceFile=/home/dsadm/Ascential/DataStage/branded_odbc/odbctrace.out
UseCursorLib=0

[TEST]
Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMora20.sl
Description=DataDirect Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=UXJEDB05
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=user1
Password=user1
PortNumber=1521
ProcedureRetResults=0
SID=test1
UseCurrentSchema=1

The corresponding uvodbc.config file entry is as follows

#
[ODBC DATA SOURCES]

<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1

<TEST>
DBMSTYPE = ODBC.

When i try to import the metadata through the ODBC I am able to get the ODBC.ini in the DSN name but when i enter the username and password for the corresponding DSN it returns me the following Error

ERROR - ODBC License file (IVVM.LIC or DDVM.LIC) not found in branded_odbc Directory.

According to the error messgae i went into the branded_odbc directory and saw the file I could find the IVVM.LIC file in it.

Anything i am missing.Kindly provide me some inputs to proceed further.

Regards,
Bala.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 02, 2007 9:19 am

That is an ENTIRELY DIFFERENT QUESTION

Please start a new thread.

ODBC does not use the Oracle OCI.