签到成功

知道了

CNDBA社区CNDBA社区

设置 FTP / HTTP 访问 RAC ASM 磁盘组

2016-11-25 15:53 1649 0 原创 Oracle 11g
作者： dave
本文链接：http://www.cndba.cn/Dave/article/959

 

 

       XML Database （XDB）使我们能够使用FTP和HTML协议访问和管理ASM磁盘组中的文件，可以方便的浏览和移入和移出。

       Oracle9i 支持 XML 数据库， 8080 是 Oracle XDB （ XML 数据库） Http 服务的默认端口， Oracle XDB 的Ftp 服务，默认端口是 2100 。 这2个端口与Tomcat 的端口是冲突的，所以我们在设置的时候可以改成其他端口。如：HTTP:8888, FTP: 2222。

 

一. 查看端口信息

       在Oracle 10g默认情况下， 数据库FTP 和 HTTP的端口是关闭的。 这个我们可以通过如下两个函数来验证。

 

[oracle@racdb1 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Dec 5 11:15:06 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn / as sysdba;

Connected.

SQL> select instance_name from v$instance;

INSTANCE_NAME

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

orcl1

SQL> select dbms_xdb.getFTPPort from dual;

GETFTPPORT

----------

         0

SQL> select dbms_xdb.getHTTPPort from dual;

GETHTTPPORT

-----------

http://www.cndba.cn/Dave/article/959

          0

SQL>

 

 

二.  查看监听

先查看一下监听，等会修改之后好做个对比：

[oracle@racdb2 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 05-DEC-2010 11:17:13

 

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

 

http://www.cndba.cn/Dave/article/959

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

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

Alias                     LISTENER_RACDB2

Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date                05-DEC-2010 10:42:45

Uptime                    0 days 0 hr. 34 min. 27 sec

Trace Level               offhttp://www.cndba.cn/Dave/article/959

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener_racdb2.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.6.228)(PORT=1521)))

 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.6.226)(PORT=1521)))

-- 这里只有2个

Services Summary...

Service "+ASM" has 1 instance(s).

  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...

Service "+ASM_XPT" has 1 instance(s).

  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...http://www.cndba.cn/Dave/article/959

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "oltp" has 2 instance(s).

  Instance "orcl1", status READY, has 1 handler(s) for this service...

  Instance "orcl2", status READY, has 2 handler(s) for this service...

Service "orcl" has 2 instance(s).

http://www.cndba.cn/Dave/article/959

  Instance "orcl1", status READY, has 1 handler(s) for this service...

  Instance "orcl2", status READY, has 2 handler(s) for this service...

Service "orclXDB" has 2 instance(s).

  Instance "orcl1", status READY, has 1 handler(s) for this service...

  Instance "orcl2", status READY, has 1 handler(s) for this service...

Service "orcl_XPT" has 2 instance(s).

  Instance "orcl1", status READY, has 1 handler(s) for this service...

  Instance "orcl2", status READY, has 2 handler(s) for this service...

The command completed successfully

 

 

三. 配置FTP 和 HTTP 端口http://www.cndba.cn/Dave/article/959

SQL> execute dbms_xdb.sethttpport(8888);

PL/SQL procedure successfully completed.

SQL> execute dbms_xdb.setftpport(2222);

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL>

 

查看端口信息：

SQL> select dbms_xdb.getFTPPort from dual;

GETFTPPORT

----------

      2222

SQL> select dbms_xdb.getHTTPPort from dual;

 

GETHTTPPORT

-----------

       8888

 

四. 再次查看监听：

[oracle@racdb2 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 05-DEC-2010 12:08:23http://www.cndba.cn/Dave/article/959

 

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

 

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date                05-DEC-2010 11:31:30

Uptime                    0 days 0 hr. 36 min. 53 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...http://www.cndba.cn/Dave/article/959

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=racdb2)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=racdb2)(PORT=8888))(Presentation=HTTP)(Session=RAW))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=racdb2)(PORT=2222))(Presentation=FTP)(Session=RAW))

Services Summary...

Service "+ASM" has 1 instance(s).

  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...

Service "+ASM_XPT" has 1 instance(s).

  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...

Service "orcl" has 2 instance(s).

  Instance "orcl1", status READY, has 1 handler(s) for this service...

  Instance "orcl2", status READY, has 2 handler(s) for this service...

Service "orclXDB" has 2 instance(s).

  Instance "orcl1", status READY, has 1 handler(s) for this service...

  Instance "orcl2", status READY, has 1 handler(s) for this service...

Service "orcl_XPT" has 2 instance(s).

  Instance "orcl1", status READY, has 1 handler(s) for this service...

  Instance "orcl2", status READY, has 2 handler(s) for this service...

The command completed successfully

 

如果没有生效，可以重启数据库 或者监听

$ srvctl stop database -d orcl
$ srvctl start database -d orcl

 

 

五. 验证FTP 和 HTTP 访问ASM

 

5.1  FTP 访问

[root@racdb2 bin]# ftp racdb1 2222

Connected to racdb1.

220- racdb1

http://www.cndba.cn/Dave/article/959

Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.

220 racdb1 FTP Server (Oracle XML DB/Oracle Database) ready.

530  Please login with USER and PASS.

530  Please login with USER and PASS.

KERBEROS_V4 rejected as an authentication type

Name (racdb1:root): system   --数据库用户名

331 pass required for SYSTEM

Password:

230 SYSTEM logged in

Remote system type is Unix.

 

       连接成功。 注意这里用的登录名和密码是数据库的用户和密码。 并且是非sys用户。因为sys 的密码需要家 as sysdba. 这里没办法输入。

       登陆后在/sys/asm下可以找到ASM磁盘组信息。ftp的基本命令都可以使用。

 

Linux 终端访问 FTP 及 上传下载 文件

http://blog.csdn.net/tianlesoftware/archive/2010/08/18/5818990.aspx

 

 

5.2  HTTP 访问

      

 

登陆的用户名和密码也是数据库的。

http://www.cndba.cn/Dave/article/959

 

 

 

 

 

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

Blog： http://blog.csdn.net/tianlesoftware

网上资源： http://tianlesoftware.download.csdn.net

相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群：62697716(满); DBA2 群：62697977(满)

DBA3 群：62697850   DBA 超级群：63306533;    

聊天 群：40132017

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请

 

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle 11g

用户评论
* 以下用户言论只代表其个人观点，不代表CNDBA社区的观点或立场
dave

dave

关注

人的一生应该是这样度过的：当他回首往事的时候，他不会因为虚度年华而悔恨，也不会因为碌碌无为而羞耻；这样，在临死的时候，他就能够说：“我的整个生命和全部精力，都已经献给世界上最壮丽的事业....."

  • 2239
    原创
  • 3
    翻译
  • 547
    转载
  • 186
    评论
  • 访问：6645144次
  • 积分：4249
  • 等级：核心会员
  • 排名：第1名
精华文章

    达梦数据库运维实战

    Oracle 18c 必须掌握的新特性：管理与实战

    Oracle数据库问题解决方案和故障排除手册
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        友情链接： CNDBA社区 | openGauss | openEuler | openAnolis | 广告联系: database@ustc.edu
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ