On the Linux Virtual Machine Installed Oracle client, you need to use perl to capture the data in the database, so you need to install perl DBI and DBD package, respectively, DBI-1.616 and DBD-Oracle-1.28. You must use root to install DBI and DBD. Before installation, make sure that. the root environment variable in bash_profile has been set to ORACLE_HOME (oracle client path), ORACLE_SID (name of the database to be connected), and LD_LIBRARY_PATH (lib path under oracle client). In addition, replace SERVICE_NAME in the db to be logged on in the configuration file tnsnames. ora of oracle in Linux with SID (which is different from the configuration in windows ).
Go to the DBI path:
Perl Makefile. PL
Make
Make test
Make install
Go to the DBD path:
Perl Makefile. PL
Make
Make test
Make install
There are some warnings during installation. Don't worry.
Add lib to ld. so. conf and take effect.
Echo (oracle client lib)>/etc/ld. so. conf (this setting file is the directory setting for the system to search for dynamic connected libraries, in this file, the address system will automatically go to these directories to find the desired dynamic library file when running the program .)
Ldconfig (used to update the database cache after modification, so that the path of the new database can be found in the cache) when using other databases, the environment variables should be consistent with the root.