快捷搜索:

使用Oracle9i数据库的九大注意事项(1) - Oracle9

Oracle数据库的9.2.0.1.0版本中的Oracle HTTP Server有如下变更:

一、关于Apache Jserv进程

Oracle HTTP Server支持的Apache Jserv进程的最大年夜数目已经从Apache宣布的缺省值最大年夜值25增添到最大年夜值128,这个值是弗成实时设置设置设备摆设摆设的。

二、JDK/JRE 认证

Oracle被认证应用JDK/JRE 1.3.1_01和JDK/JRE 1.2.2_07两者来建立和设置设置设备摆设摆设带有mod_jserv 模块的Java利用法度榜样。

在 9.2.0.1.0版本中,所有的Java类库(如BC4J、XDK)连同JDK 1.1.8_10被装载和编译。这些编译类被认证运行在Java JRE支持的版本中,并且他们必须没被从新编译。

三、模块mod_plsql 的需求

针对一个特定的后端数据库应用mod_plsql 模块,你必要手动安装Oracle PL/SQL Web 对象包(OWA PL/SQL packages)在特定的后端数据库上。OWA PL/SQL packages应安装在SYS数据库模式下,确保你只安装它一次。留意已经存在的Oracle Application Server(OAS)用户迁移到Oracle HTTP Server时,必须调换这些包的老版本。

在Oracle HTTP Server中应用PL/SQL网关的更多信息请查阅http://hostname.domain:port/pls/admin_/title.htm。

四、规复利用办事器的OWA包

当你安装新的mod_plsql OWA包时,它们被放在SYS数据库用户模式下,这会为利用办事器(Oracle Application Server)应用OAS PL/SQL cartridge组件带来问题,假如你碰到这些问题并且想继承应用OAS的PL/SQL cartridge组件,就必须从新建立一些同义词,使得这些同义词参照到OWA包。在源数据库上建立同义词的步骤如下:

1.SYS帐户在SQL*Plus中连接到数据库

2.在SQL*Plus中运行下列敕令,这将删除所有在Oracle HTTP Server安装进程中建立的OWA公合营义词。

drop public synonym OWA_CUSTOM;

drop public synonym OWA_GLOBAL;

drop public synonym OWA;

drop public synonym HTF;

drop public synonym HTP;

drop public synonym OWA_COOKIE;

drop public synonym OWA_IMAGE;

drop public synonym OWA_OPT_LOCK;

drop public synonym OWA_PATTERN;

drop public synonym OWA_SEC;

drop public synonym OWA_TEXT;

drop public synonym OWA_UTIL;

drop public synonym OWA_INIT;

drop public synonym OWA_CACHE;

drop public synonym WPG_DOCLOAD;

3.连接到OWA包的安装模式oas_public,确保该用户具有CREATE PUBLIC SYNONYM权限,假如没有,则须手动为此用户授此权限。

4.运行下列敕令。这将从新建立OWA公合营义词使其参照到Oracle Application Server 的OWA包。

create public synonym OWA_CUSTOM for OWA_CUSTOM;

create public synonym OWA_GLOBAL for OWA_CUSTOM;

create public synonym OWA for OWA;

create public synonym HTF for HTF;

create public synonym HTP for HTP;

create public synonym OWA_COOKIE for OWA_COOKIE;

create public synonym OWA_IMAGE for OWA_IMAGE;

create public synonym OWA_OPT_LOCK for OWA_OPT_LOCK;

create public synonym OWA_PATTERN for OWA_PATTERN;

create public synonym OWA_SEC for OWA_SEC;

create public synonym OWA_TEXT for OWA_TEXT;

create public synonym OWA_UTIL for OWA_UTIL;

create public synonym OWA_INIT for OWA_CUSTOM;

create public synonym OWA_CACHE for OWA_CACHE;

create public synonym WPG_DOCLOAD for WPG_DOCLOAD;

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = icache))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))

)

)

(DESCRIPTION =

(PROTOCOL_STACK =

(PRESENTATION = GIOP)

(SESSION = RAW)

)

(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 2481))

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = )

(PROGRAM = extproc)

)

(SID_DESC =

GLOBAL_DBNAME = icache)

(ORACLE_HOME = )

(SID_NAME = icache)

)

此中是你的谋略机的实际主机名,是你的Oracle主目录$ORACLE_HOME。

九、应用Oracle XSU的限定

在9.2.0.1.0版本中,Oracle XML SQL Utility (XSU)没有包孕setEncoding措施,为了下载XSU的支持编码功能的最新版本,请查阅http://otn.oracle.com/tech/xml/oracle_xsu/。

您可能还会对下面的文章感兴趣: