In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.