Skip Menu |

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 60881
Status: rejected
Priority: 0/
Queue: DBD-Oracle

People
Owner: Nobody in particular
Requestors: vkumar1 [...] metlife.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: DBD module install errors
Date: Mon, 30 Aug 2010 13:51:14 -0400
To: bug-DBD-Oracle [...] rt.cpan.org
From: vkumar1 [...] metlife.com
Hi, We are getting below mentioned error while running make command for PERL. The Oracle version installed on the machine is 11gR2 and I couldn't find the files it is trying to search under ORACLE_HOME. Can you help us with this issues? ERROR MESSAGE root - R9DEVT> perl Makefile.PL Using DBI 1.54 (for perl 5.008008 on aix-thread-multi-64all) installed in /usr/opt/perl5/lib64/site_perl/5.8.8/aix-thread-multi-64all/auto/DBI/ Configuring DBD::Oracle for perl 5.008008 on aix (aix-thread-multi-64all) Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /u00/app/oracle/product/11.2.0.1 DEFINE _SQLPLUS_RELEASE = "1102000100" (CHAR) Oracle version 11.2.0.1 (11.2) Unable to locate an oracle.mk, proc.mk or other suitable *.mk file in your Oracle installation. (I looked in /u00/app/oracle/product/11.2.0.1/rdbms/demo/demo_xe.mk /u00/app/oracle/product/11.2.0.1/rdbms/lib/oracle.mk /u00/app/oracle/product/11.2.0.1/rdbms/demo/oracle.mk /u00/app/oracle/product/11.2.0.1/rdbms/demo/demo_rdbms.mk /u00/app/oracle/product/11.2.0.1/precomp/demo/proc/proc.mk /u00/app/oracle/product/11.2.0.1/precomp/demo/proc/demo_proc.mk /u00/app/oracle/product/11.2.0.1/proc/lib/proc.mk /u00/app/oracle/product/11.2.0.1/proc16/lib/proc16.mk under /u00/app/oracle/product/11.2.0.1) The oracle.mk (or demo_rdbms.mk) file is part of the Oracle RDBMS product. The proc.mk (or demo_proc.mk) file is part of the Oracle Pro*C product. You need to build DBD::Oracle on a system which has one of these Oracle components installed. (Other *.mk files such as the env_*.mk files will not work.) Alternatively you can use Oracle Instant Client. In the unlikely event that a suitable *.mk file is installed somewhere non-standard you can specify where it is using the -m option: perl Makefile.PL -m /path/to/your.mk See README.clients.txt for more information and some alternatives. at Makefile.PL line 1072. Environment Details :- PERL Version :- 5.8.8 DBI Version :- 1.54 DBD Version :- 1.19 Operating System :- AIX 6.1 root - R9DEVT> env _=/usr/bin/env LANG=en_US WSM_WS_CMD="startsrc -s http4websm" LOGIN=root SSH_TTY=/dev/pts/5 PATH=/u00/app/oracle/product/11.2.0.1/bin:.:/usr/ccs/bin:/usr/bin:/usr/lbin:/etc:/usr/sbin:/usr/ucb://bin:/usr/bin/X11:/sbin:.:/sbin:/usr/sbin:/usr/ccs/bin:/usr/ucb:/etc:/usr/local/bin:/usr/openwin/bin:/usr/ucs/bin:/usr/vac/bin RES_RETRY=2 EXTENDED_HISTORY=ON ORACLE_BASE=/u00/app/oracle LC__FASTMSG=true EDITOR=vi LOGNAME=root RES_TIMEOUT=2 MAIL=/usr/spool/mail/root ORACLE_SID=R9DEVT LOCPATH=/usr/lib/nls/loc PS1=[$MACHINE:$PWD] $LOGNAME - $ORACLE_SID> WSM_DOC_DIR="/usr/websm/http/com.ibm.websm.http.server_1.0.0" USER=root AUTHSTATE=files ORACLE_ADMIN=/u00/app/oracle/admin ORACLE_TRACE=/u00/app/oracle/admin/R9DEVT/diag/rdbms/f9demo/R9DEVT/trace ORACLE_DIAG=/u00/app/oracle/diag/rdbms/ SHELL=/usr/bin/ksh ODMDIR=/etc/objrepos HISTSIZE=2048 TMOUT=0 ORATAB=/etc/oratab HOME=/ SSH_CONNECTION=10.9.186.72 44926 10.90.232.38 22 SSH_CLIENT=10.9.186.72 44926 22 TERM=xterm MAILMSG=[YOU HAVE NEW MAIL] ORACLE_HOME=/u00/app/oracle/product/11.2.0.1 PWD=/tmp/DBD-Oracle-1.19 TZ=EST5EDT ENV=//.kshrc WSM_CGI_DIR= A__z=! LOGNAME="*TMOUT NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat LD_LIBRARY_PATH=/u00/app/oracle/product/11.2.0.1/lib:/usr/lib:/usr/openwin/lib:/usr/dt/lib:/u00/app/oracle/product/11.2.0.1/lib:/u00/app/oracle/product/11.2.0.1/lib64:/usr/ccs/lib:/usr/ucb/lib: Thanks and Regards, Vipin Kumar MetLife ITG - Enterprise Infrastructure - PSAdmin team Work :- 732-893-4021 The information contained in this message may be CONFIDENTIAL and is for the intended addressee only. Any unauthorized use, dissemination of the information, or copying of this message is prohibited. If you are not the intended addressee, please notify the sender immediately and delete this message.
I will have to reject this one as it is a config/install issue and not a bug persay You best bet for support is to post this on dbi-users@perl.org http://www.nntp.perl.org/group/perl.dbi.users/ There is a large number of people who look at that list and they will help you much more. Here are some things that may be a problem 1) The required directory is Read Only for you. You will have to have execute permission on the *.mk files 2) You Oracle may not be fully installed 3) My best advice is to get the instant client and try to get that to work locally.
you might want to give this a read as well http://www.pythian.com/news/6087/dbdoracle-on-aix-5-1/