Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Resolve:. / check_oracle_health-- connect orcl-- mode connection-time error report

2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Error prompt

. / check_oracle_health-connect orcl-mode connection-time

CRITICAL-cannot connect to orcl. Install_driver (Oracle) failed: Can't locate DBD/Oracle.pm in @ INC (@ INC contains:. / usr/local/lib64/perl5 / usr/local/share/perl5 / usr/lib64/perl5/vendor_perl / usr/share/perl5/vendor_perl / usr/lib64/perl5/ usr/share/perl5) at (eval 18) line 3.

Perhaps the DBD::Oracle perl module hasn't been fully installed

Or perhaps the capitalisation of 'Oracle' isn't right.

Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge, mysql.

At. / check_oracle_health line 5891

Resolve install_driver oracle failed can't locate dbd/oracle.pm in @ inc

There are two ways. This can be cut off using the above method.

Cpan [1]: install DBD::Oracle may not be installed directly for the following reasons:

……

Running make install

Make had some problems, won't install

Could not read'/ root/.cpan/build/DBD-Oracle-1.74-Zrp_Am/META.yml'. Falling back to other methods to determine prerequisites

Failed during this command:

PYTHIAN/DBD-Oracle-1.74.tar.gz: writemakefile NO'/ usr/bin/perl Makefile.PL INSTALLDIRS=site' returned status 512

But the package has been downloaded, so you can check the download record.

Saving to: / root/.cpan/sources/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.74.tar.tmp27681

You can find the available / root/.cpan/sources/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.74.tar.gz with find

Then move the current directory: mv / root/.cpan/sources/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.74.tar.gz.. /

Tar xvzf DBD-Oracle-1.74.tar.gz pay attention to folder permissions

Make prompt after cd: make: * does not specify the target and cannot find the makefile. Stop it.

After querying, you need to compile first: here you compile with perl: perl Makefile.PL [.PL is the executable file of perl, which can be viewed by ll. For other installation methods, you can check the INSTALL file description in the decompression package]

Because it is related to the directory of oracle, that is, if the environment variable is loaded, $ORACLE_HOME can be obtained by echo.

[root@localhost DBD-Oracle-1.74] # export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1

[root@localhost DBD-Oracle-1.74] # echo $ORACLE_HOME

And then Make&&Make install

Then execute the check_oracle_health command under the su-oracle user to view the result

[oracle@localhost libexec] $. / check_oracle_health-connect orcl-mode connection-time-user *-password *

OK-0.08 seconds to connect as YOUGOU_CC | connection_time=0.0832;1;5

It shows that it has been successful!

If you report the following error, you can check the corresponding directory file.

1. CRITICAL-cannot connect to orcl. Install_driver (Oracle) failed: DBD::Oracle object version 1.20 does not match bootstrap parameter 1.74 at / usr/lib64/perl5/DynaLoader.pm line 239.

Compilation failed in require at (eval 18) line 3.

At. / check_oracle_health line 5891

May be the version of the installed DBD::Oracle module, take a look at the directory / usr/local/nagios/DBD-Oracle-1.74/blib/arch/auto/DBD/Oracle/Oracle.so file and the installation of the Oracle version of the Oracle.so is not the same, this and the program environment variables to see which one you use, preferably one, mine is DBD-Oracle.tar.gz, so the execution file must also be this 1.74 Oracle.so

Do not cp $ORACLE_HOME/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so

# echo $ORACLE_HOME/lib > > / etc/ld.so.conf

# ldconfig

Similar

Ldconfig: the file / home/oracle/app/product/11.2.0/dbhome_1/lib/libnmefdms.so.0 is empty and not checked.

……

Ldconfig: / home/oracle/app/product/11.2.0/dbhome_1/lib/libexpat.so.1 is not a symbolic link

It's usually OK to execute an order again.

OK-0.29 seconds to connect as YOUGOU_CC | connection_time=0.2922;1;5

Display successful

-

2. Time::HiRes object version 1.9726 does not match $Time::HiRes::XS_VERSION 1.9712 at / usr/lib64/perl5/DynaLoader.pm line 239.9.

Compilation failed in require at. / check_oracle_health line 4746.

BEGIN failed--compilation aborted at. / check_oracle_health line 4746.

An error like this is due to a problem with the version of the HiRes.pm module. Either reinstall or copy the file / root/.cpan/build/Time-HiRes-1.9726-euaQ_5/HiRes.pm overwritten directory / usr/local/lib64/perl5/Time/ downloaded from perl-MCPAN-s shell to solve it.

3. / check_oracle_health-connect orcl-mode tnsping

DynaLoader object version 1.10 does not match $DynaLoader::VERSION 1.08 at / usr/lib64/perl5/DynaLoader.pm line 93.

Compilation failed in require at / usr/local/lib64/perl5/Time/HiRes.pm line 7.

Compilation failed in require at. / check_oracle_health line 4746.

BEGIN failed--compilation aborted at. / check_oracle_health line 4746.

Indicates that the inconsistent version of the DynaLoader index requires version 1.10, which is currently 1.08. Download the corresponding version to solve the problem, or directly replace the DynaLoader.pm solution. Attach files or replace the directory / usr/lib64/perl5/DynaLoader.pm.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report