oracle查询追加,在Cloudera Hue中，添加Oracle数据查询-CSDN博客

整个流程分几部分

安装Oracle

下载Oracle

安装Oracle

设置自启动服务

启动服务

Hue中连接Oracle

在Hue中添加服务

重启服务

下载Oracle

http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html

登陆oracle下载oracle-xe-11.2.0-1.0.x86_64.rpm.zip

[shell]

#解压安装包

unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip

#安装

cd Disk1 && rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm

#配置数据库，根据需要设置端口、用户名和密码

/etc/init.d/oracle-xe configure

#启动服务

service oracle-xe start

#/etc/init.d/oracle-xe start

#停止服务，手工停止命令

service oracle-xe stop

#/etc/init.d/oracle-xe stop

#设置自启动

sudo chkconfig oracle-xe on

#添加环境变量

source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh

echo "source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh" >> ~/.bash_profile

#连接数据库，默认用户名为system

sqlplus

[/shell]

数据库查询测试

[sql]

[cloudera@quickstart ~]$ sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Fri Oct 17 20:49:01 2014

Enter user-name: system

Enter password:

Connected to:

Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> show user;

USER is "SYSTEM"

SQL> select * from all_users;

USERNAME USER_ID CREATED

------------------------------ ---------- ------------------

XS$NULL 2147483638 28-AUG-11

APEX_040000 47 28-AUG-11

APEX_PUBLIC_USER 45 28-AUG-11

FLOWS_FILES 44 28-AUG-11

HR 43 28-AUG-11

MDSYS 42 28-AUG-11

ANONYMOUS 35 28-AUG-11

XDB 34 28-AUG-11

CTXSYS 32 28-AUG-11

OUTLN9 28-AUG-11

SYSTEM5 28-AUG-11

USERNAME USER_ID CREATED

------------------------------ ---------- ------------------

SYS0 28-AUG-11

12 rows selected.

SQL>

[/sql]

详细流程参见：http://mutap.wordpress.com/2012/04/22/install-oracle-11g-xe-release-2-in-oracle-linux-6/

在Hue中添加Oracle的rdbms连接，配置文件如下

添加以下配置文件

[plain]

[[databases]]

[[mysql]]

nice_name="shuhai's mac"

name=

engine=mysql

host=10.0.2.2

port=3306

user=root

password=password

[[oracle]]

nice_name="cloudera's oracle"

name=

engine=oracle

host=127.0.0.1

port=1521

user=system

password=password

[/plain]

[shell]

sudo vim /etc/hue/conf.empty/hue.ini

sudo service hue restart

[/shell]

如果出现系统错误，如`Error loading cx_Oracle module: No module named cx_Oracle`，需要使用`pip install cx_Oracle`