枫树之技术人生

由于oracle的9i以后都支持XML数据库，所以缺省安装一般会安装一个叫XDB的XML数据库，它开启了以下几个端口：8080（HTTP），2100（FTP）等，因此在management中可以直接打开XML数据库，第一项就是配置，在里面可以直接修改这些缺省的端口地址，比用其它方式要方便很多。

SQL> call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),
  2  '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()',8081))
  3  /
SQL> commit;
 
Commit complete.
 
SQL>  exec dbms_xdb.cfg_refresh;

[oracle@test11 oracle]$ sqlplus /nolog
 
SQL*Plus: Release 9.2.0.4.0 - Production on Sat Aug 6 14:24:49 2005
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
SQL> connect / as sysdba;
Connected.
-- 把HTTP/WEBDAV端口从8080改到8081
SQL> call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),
  2  '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()',8081))
  3  /
 
Call completed.
-- 把FTP端口从2100改到2111
SQL>  call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),
  2  '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text()',2111))
  3  /
 
Call completed.
 
SQL> commit;
 
Commit complete.
 
SQL>  exec dbms_xdb.cfg_refresh;
 
PL/SQL procedure successfully completed.
-- 检查修改是否已经成功
SQL> select dbms_xdb.cfg_get from dual;
 
CFG_GET
--------------------------------------------------------------------------------
<xdbconfig xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd" xmlns:xsi="http://w
 
SQL>

[oracle@test11 oracle]$ netstat -ntlp 
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name  
tcp        0      0 0.0.0.0:32768           0.0.0.0:*               LISTEN      -                  
tcp        0      0 127.0.0.1:32769         0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:2401            0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:33730           0.0.0.0:*               LISTEN      14987/ora_d000_szdb
tcp        0      0 0.0.0.0:873             0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:110             0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:8081            0.0.0.0:*               LISTEN      2473/tnslsnr       
tcp        0      0 0.0.0.0:1521            0.0.0.0:*               LISTEN      2473/tnslsnr       
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:25              0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:2111            0.0.0.0:*               LISTEN      2473/tnslsnr       
tcp        0      0 :::11009                :::*                    LISTEN      -                  
tcp        0      0 ::ffff:127.0.0.1:4001   :::*                    LISTEN      -                  
tcp        0      0 ::ffff:127.0.0.1:4002   :::*                    LISTEN      -                  
tcp        0      0 :::9090                 :::*                    LISTEN      -                  
tcp        0      0 ::ffff:127.0.0.1:12005  :::*                    LISTEN      -                  
tcp        0      0 :::12009                :::*                    LISTEN      -                  
tcp        0      0 :::8080                 :::*                    LISTEN      -                  
tcp        0      0 :::80                   :::*                    LISTEN      -                  
tcp        0      0 :::22                   :::*                    LISTEN      -                  
tcp        0      0 ::ffff:127.0.0.1:11005  :::*                    LISTEN      -                  
[oracle@test11 oracle]$

以下网站上有很多电子类书籍

http://www..ava123.net

http://www.javafan.net

http://www.java.net

以下是关于oralce的

http://download.chinaitlab.com/special/oracleebook.htm

http://wadotey.bokee.com/

《样式表虑镜中文手册》苏昱（Rainer Su）

http://blog.blogchina.com/upload/2004-12-02/20041202152100837739.rar