DBD::Oracle failes make test on Remote DB Connect

[MikeL_4]

I am installing DBD::Oracle 1.16 in Perl 5.8.7 on a client server with remote Oracle database.
The make test failes some of it's test due to the connection to the Remote Oracle database.

Unable to connect to Oracle as test/test (ORA-06401: NET CMN: invalid driver designator (DBD ERROR: OCIServerAttach))
I installed the DBD::Oracle module on the server running the database itself without any problems.
The DBA gave me the following Oracle environment settings to use for remote DB:

export ORACLE_HOME=/opt/oracle/product/9.2.0.6.0 export ORACLE_SID=dummy
export TWO_TASK=T:dbsvr2:dummy
export TNS_ADMIN=/opt/oracle/admin/network export ORACLE_USERID=test/test
export PATH=$ORACLE_HOME/bin:$PATH
export SHLIB_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib export LD_PRELOAD=/usr/lib/libcl.2:/opt/oracle/product/9.2.0.6.0/lib/libwtc9.sl

Can anyone help me out on this ?
Thanks

[Mugilvannan · Accepted solution]

Try this and let us know the result
GO to OH
set oracle_home ,oracle_sid
Go to OH/bin and try to start listener lsnrctl start

Also dont forget to change host=last.oracle.com to host=x.x.x.x (your ip)


Thanks,
Mugil

[MikeL_4]

Oracle listener is already running on database server. I set HOST=IP of database server and still receive the same connection error on client server.

Unable to connect to Oracle as test/test (ORA-06401: NETCMN: invalid driver designator (DBD ERROR: OCIServerAttach))

[MikeL_4]

Was able to resolve 'make test' connection errors by changing oracle environments on:
ORACLE_SID, HOST, and TWO_TASK to:

export ORACLE_SID=
export HOST=dbsvr2
export TWO_TASK=dummy