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

Lepus Monitoring oracle11g

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

Software environment:

Python2.6 + xampp + oracle 11g + cx_Oracle-5.1.2 included with RHEL6.4 x86 + system

[root@save ~] # cat .bash _ profile

Export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib/usr/lib64:/usr/lib/local/lib

Export LD_LIBRARY_PATH

Export PATH

Description: there is already an Oracle 11g database on the server.

Environment variable configuration ORACLE_HOME can use the existing Oracle environment and library files

There is no need to install the following client software (of course, the server does not have an Oracle environment to install the following software packages)

Oracle-instantclient11.2-basic

Oracle-instantclient11.2-devel

Oracle-instantclient11.2-sqlplus

Load library files

[root@save cx_Oracle-5.1.2] # cat / etc/ld.so.conf

Include ld.so.conf.d/*.conf

/ usr/lib64

/ usr/lib64/python2.6/site-packages-cx_Oracle generated library files in this directory

/ u01/app/oracle/product/11.2.0/dbhome_1/lib-Oracle environment library files are in this directory

/ usr/local/mysql5.6/lib

[root@save cx_Oracle-5.1.

Install cx_Oracle

[root@save cx_Oracle-5.1.2] # python setup.py build

[root@save cx_Oracle-5.1.2] # python setup.py install

Test the Oracle driver

[root@save python] # python test_driver_oracle.py

Oracle python drivier is ok!

[root@save python] #

Landing on the Sky Rabbit Monitoring platform

Enter the configuration center and add new configuration to Oracle.

Configure IP username, password, and data source

Description:

For the data source configuration, one of the functions of the oralce environment we configured earlier is to parse our data source.

Fill in guilai for the data source I configured above.

[oracle@save admin] $pwd

/ u01/app/oracle/product/11.2.0/dbhome_1/network/admin

[oracle@save admin] $cat tnsnames.ora

Guilai=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = xxx.xxx.xxx.xxx) (PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ycw)

)

)

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