使.profile在CDE中生效

HP-UX下安装Oracle,设置了oracle用户的.profile,但用Xmanager登录CDE时发现设置在.profile文件中的环境变量没有生效。

google "cde profile" 得到答案:

需要修改.dtprofile,加入DTSOURCEPROFILE=true

.dtprofile的注释里是这么解释的:

# # By default, the desktop does not read your standard $HOME/.profile
# # or $HOME/.login files. This can be changed by uncommenting the
# # DTSOURCEPROFILE variable assignment at the end of this file.

修改Oracle XMLDB的监听端口

Oracle XMLDB 占用了8080端口。

(Ref: http://www.red-database-security.com/..._default_ports.html)

解决办法:

  1. 修改XMLDB的端口设置
  2. 禁止XMLDB监听端口

(Ref: http://herosys.net/x/modules/wfsection/article.php?articleid=84)

修改方法:
$ sqlplus "/ as sysdba"

SQL> call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),
2 '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()', 8083));

Call completed.

SQL> call dbms_xdb.cfg_update(updateXML( dbms_xdb.cfg_get(),
2 '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text()' , 2111));

Call completed.

SQL> exec dbms_xdb.cfg_refresh;

PL/SQL procedure successfully completed.
(Ref: http://www.red-database-security.com/...-xmldb_port.html)