Perl DBI and DBD::Oracle - Secrets of the Oracle Database - page 229

Additional Windows-specific directories were omitted from the preceding setting. Now it
should be possible to run perl.exe :
C:> perl -version
This is perl, v5.8.3 built for MSWin32-x86-multi-thread
Copyright 1987-2003, Larry Wall
Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.
Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'. If you have access to the
Internet, point your browser at http://www.perl.com/, the Perl Home Page.
If you intend to use other components of the Perl installation apart from the Perl inter-
preter itself, you need to add %ORACLE_HOME%\perl\5.8.3\bin to PATH . You may then use perldoc
to read the documentation library within the Perl installation or pod2html to generate HTML
documentation from POD (Plain Old Documentation) statements embedded in Perl source
(see perldoc perlpod ).
C:> set PATH=%ORACLE_HOME%\perl\5.8.3\bin\MSWin32-x86-multi-thread;%ORACLE_HOME%\ pe
rl\5.8.3\bin;%ORACLE_HOME%\bin;C:\WINDOWS\System32
C:> perldoc perltoc
NAME
perltoc - perl documentation table of contents
DESCRIPTION
This page provides a brief table of contents for the rest of the Perl
documentation set. It is meant to be scanned quickly or grepped through
to locate the proper section you're looking for.
BASIC DOCUMENTATION
perl - Practical Extraction and Report Language
…
As it turns out, PERL5LIB does not have to be set for Perl in a Windows ORACLE_HOME to work,
since perl.exe automatically searches the directory tree from which it is invoked. On Windows,
there is no separate environment variable for searching dynamic link libraries (DLLs)—the
Windows variant of shared libraries. PATH serves as the command search path as well as the DLL
search path. The ORACLE DLL required to connect to a DBMS instance is OCI.DLL . Since
perl58.dll , which is required to run perl.exe , is collocated with perl.exe in %ORACLE_HOME%
\perl\5.8.3\bin\MSWin32-x86-multi-thread , and OCI.DLL is in %ORACLE_HOME%\bin , you are all
set once PATH contains these two directories.
The OUI also adds the directory %ORACLE_HOME%\sysman\admin\scripts to the setting of
PERL5LIB in the Control Panel . This should be retained to avoid impairing Database Control or
Grid Control. Note that a Grid Control Management Agent installation also contains an installation